110,561
社区成员
发帖
与我相关
我的任务
分享
cmd->CommandType = CommandType::StoredProcedure;proc proc_sys_getLetChk --从管理系统下载检查信息
(
@chkDesc varchar(300),
@LetRoomID varchar(20),
@chkTypeID int,
@chkResult int,
@WorkerID varchar(20)
)
as
declare @iErrors int
set @iErrors = 0
if(not exists(select * from CheckItems where LetRoomID = @LetRoomID
and WorkerID = @WorkerID
and chkTypeID = @chkTypeID))
begin
insert into CheckItems(chkDesc,LetRoomID, chkTypeID,chkResult,WorkerID)
values(@chkDesc,@LetRoomID,@chkTypeID,@chkResult,@WorkerID)
set @iErrors = @iErrors + @@error
end
else
begin
update CheckItems
set chkResult = @chkResult,
chkDesc = @chkDesc
where LetRoomID = @LetRoomID
and WorkerID = @WorkerID
and chkTypeID = @chkTypeID
set @iErrors = @iErrors + @@error
end
if(0 != @iErrors)
begin
return -1
end
else
begin
return 0
end
DataColumn ^dcLetChkDesc = tbChk->Columns[L"rrsiicRemarks"], ^dcLetChkLetID = tbChk->Columns[L"rrsNum"],
^dcLetChkTypeID = tbChk->Columns[L"rrsiicID"], ^dcChkResult = tbChk->Columns[L"rrsiicResult"];
cmd->Parameters->Add(L"@chkDesc", SqlDbType::VarChar, 300);
cmd->Parameters->Add(L"@LetRoomID", SqlDbType::VarChar, 20);
cmd->Parameters->Add(L"@chkTypeID", SqlDbType::Int, 4);
cmd->Parameters->Add(L"@chkResult", SqlDbType::Int, 4);
cmd->Parameters->Add(L"@WorkerID", SqlDbType::VarChar, 20);
DateTime ^dtNow3 = DateTime::Now;
for each(DataRow^ dr in tbChk->Rows){
//DateTime ^dtNow3 = DateTime::Now;
if(dr->IsNull(dcLetChkDesc) || String::IsNullOrEmpty(dr[dcLetChkDesc]->ToString()->Trim()))
cmd->Parameters[0]->Value = DBNull::Value;
else
cmd->Parameters[0]->Value = dr[dcLetChkDesc]->ToString();
if(dr->IsNull(dcLetChkLetID) || String::IsNullOrEmpty(dr[dcLetChkLetID]->ToString()->Trim()))
cmd->Parameters[1]->Value = DBNull::Value;
else
cmd->Parameters[1]->Value = dr[dcLetChkLetID]->ToString();
if(dr->IsNull(dcLetChkTypeID))
cmd->Parameters[2]->Value = DBNull::Value;
else
cmd->Parameters[2]->Value = Convert::ToInt32(dr[dcLetChkTypeID]);
if(dr->IsNull(dcChkResult))
cmd->Parameters[3]->Value = DBNull::Value;
else
cmd->Parameters[3]->Value = Convert::ToInt32(dr[dcChkResult]);
cmd->Parameters[4]->Value = strWorkerID;
/*if(!m_dbAccess->RunProc(L"proc_sys_getLetChk", params1, sqlTran))
throw gcnew Exception();*/
cmd->ExecuteNonQuery();
//dtNowE = DateTime::Now;
//AddTest(strWorkerID, dtNow3, dtNowE, L"each", (int)RetEnum::RET_OK);
}
dtNowE = DateTime::Now;
AddTest(strWorkerID, dtNow3, dtNowE, L"DispatchTask1", (int)RetEnum::RET_OK);