這是我的 VB.NET 代碼
Public Shared Function SearchRoboCallByDate(datefrom As String, dateto As String, customerNo As String, regNo As String, terminalNo As String) As DataSet
Dim conn As New SqlConnection
Dim cmd As New SqlCommand
Dim adapter As New SqlDataAdapter
Dim ds As New Data.DataSet
conn = New SqlConnection(ConfigurationManager.ConnectionStrings("SQLConnString").ConnectionString)
'conn.ConnectionString = ConfigurationManager.ConnectionStrings("SQLConnString").ConnectionString
adapter.SelectCommand = cmd
ds.DataSetName = "DataSet"
cmd.CommandText = "sp_getRoboAlarmDetailByDate"
cmd.CommandTimeout = 600
cmd.Connection = conn
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@datefrom", datefrom)
cmd.Parameters.AddWithValue("@dateto", dateto)
cmd.Parameters.AddWithValue("@customerNo", customerNo)
cmd.Parameters.AddWithValue("@regNo", regNo)
cmd.Parameters.AddWithValue("@TerminalNo", terminalNo)
Try
adapter.Fill(ds)
Catch ex As Exception
ds = Nothing
End Try
Return ds
End Function
下面是我的存盤程序
ALTER procedure sp_getRoboAlarmDetailByDate
@datefrom datetime = null ,
@dateto datetime = null ,
@customerNo as nvarchar(60) = null ,
@regNo as nvarchar(60) = null,
@TerminalNo as nvarchar(60) = null
as
begin
if(@regNo = '0')
BEGIN
set @regNo = null
end
if(@customerNo = '0')
BEGIN
set @customerNo = null
end
if(@TerminalNo = '0')
BEGIN
set @TerminalNo = null
end
select
ID = 0 ,
rda.RCLogID ,
rda.VehicleID ,
cv.RegistrationNo ,
rda.TerminalNo ,
rda.PollID ,
rda.PacketNo ,
rda.TableNo ,
rda.ServerID ,
rda.ServerName ,
rda.isCallSuccessful ,
rda.Remarks ,
rda.CreatedOn,
c.CustomerID ,
c.CustomerNo
from
RoboCalls_DefuseAlarms_Log rda
Left join CustomersVehicles cv on cv.VehicleId = rda.VehicleID
Left join Customers c on c.CustomerID = cv.CustomerId
where
rda.CreatedOn between @datefrom AND @dateto
and c.CustomerNo = ISNULL(@customerNo, c.CustomerNo)
and RegistrationNo = ISNULL(@regNo, cv.RegistrationNo)
and rda.TerminalNo = ISNULL(@TerminalNo, rda.TerminalNo)
end
當我選擇 from 和 to date 時，資料顯示在網格視圖中，但是當我選擇另一個引數時@customerNo，或者，@regNo資料網格顯示錯誤：
未找到資料
并且在 VB 代碼中沒有拋出例外。并通過為存盤程序提供靜態值，顯示在 sql server 中的資料，但從 VB.NET 代碼中提供引數，引數資料從網格中消失
誰能告訴我我在這里做錯了什么？
謝謝
uj5u.com熱心網友回復：
我剛剛嘗試了以下代碼
cmd.CommandText = "Exec sp_GetRoboCallAlarmNotChecked '" & dtStart & "' ,'" & dtEnd & "' , '" & customerNo & "' , '" & regNo & "' ,'" & terminalNo & "', '" & notSuccessCheck & "'"
我的作業完成了 謝謝
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/490446.html