public long m_lngInsert(clsST360CheckResultVO deviceResult)
{
long lngRes = 0;
try
{
lngRes = m_objSvc.m_lngInsert(deviceResult);
}
catch
{
lngRes = 0;
}
return(lngRes);
}
/// <summary>
/// 根据微孔板编号查询
/// </summary>
/// <param name="boardNo"></param>
/// <param name="arrCheckResult"></param>
/// <returns></returns>
public long m_lngFind(string boardNo, out clsST360CheckResultVO[] arrCheckResult)
{
long lngRes = 0;
arrCheckResult = null;
string sql = @"
select * from t_opr_lis_st360_result where boardno_vchr=?
";
DataTable dtbResult = null;
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService hrpService = new com.digitalwave.iCare.middletier.HRPService.clsHRPTableService();
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(boardNo);
try
{
lngRes = hrpService.lngGetDataTableWithParameters(sql, ref dtbResult, objODPArr);
if (dtbResult != null && dtbResult.Rows.Count > 0)
{
arrCheckResult = new clsST360CheckResultVO[dtbResult.Rows.Count];
for (int i = 0; i < dtbResult.Rows.Count; i++)
{
clsST360CheckResultVO checkResult = new clsST360CheckResultVO();
ConstructVO(dtbResult.Rows[i], ref checkResult);
arrCheckResult[i] = checkResult;
}
}
else
{
arrCheckResult = new clsST360CheckResultVO[0];
}
}
catch (Exception ex)
{
new com.digitalwave.Utility.clsLogText().LogError(ex.Message);
}
return(lngRes);
}
public long m_lngInsert(clsST360CheckResultVO m_objResult)
{
long lngRes = 0;
string sql = @"
INSERT INTO t_opr_lis_st360_result
(sampleid_int, sampletype_int, boardno_vchr, templateno_int,
check_item_id_int, check_item_name_vchr,
check_item_english_name_vchr, modify_dat, operator_dat,
device_send_dat, resultnum_vchr, resulttext_vchr, status_int,
deviceid_chr, operator_id_chr, summary_vchr,Positive_INT
)
VALUES (?, ?, ?, ?,
?, ?,
?, ?, ?,
?, ?, ?, ?,
?, ?, ?,?
)
";
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService hrpService = new com.digitalwave.iCare.middletier.HRPService.clsHRPTableService();
try
{
System.Data.IDataParameter[] objODPArr = GetInsertDataParameterArr(m_objResult);
long lngRecEff = -1;
//往表增加记录
lngRes = 0;
lngRes = hrpService.lngExecuteParameterSQL(sql, ref lngRecEff, objODPArr);
hrpService.Dispose();
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
private void ConstructVO(DataRow p_dtrSource, ref clsST360CheckResultVO p_objResult)
{
//DEVICEID_CHR
//SampleId_int
//SampleType_int
//BoardNo_VCHR
//TemplateNo_int
//CHECK_ITEM_ID_INT
//CHECK_ITEM_NAME_VCHR
//CHECK_ITEM_ENGLISH_NAME_VCHR
//MODIFY_DAT
//DEVICE_SEND_DAT
//OPERATOR_DAT
//ResultNum_VCHR
//ResultText_VCHR
//OPERATOR_ID_CHR
//Status_int
//Summary_VCHR
p_objResult.m_strDeviceId = p_dtrSource["DEVICEID_CHR"].ToString().Trim();
p_objResult.m_intSampleId = DBAssist.ToInt32(p_dtrSource["SampleId_int"]);
p_objResult.m_enmSampelType = GetSampleType(DBAssist.ToInt32(p_dtrSource["SampleType_int"]));
p_objResult.m_strBoardNo = p_dtrSource["BoardNo_VCHR"].ToString().Trim();
p_objResult.m_intTemplateNo = DBAssist.ToInt32(p_dtrSource["TemplateNo_int"]);
p_objResult.m_strItemName = p_dtrSource["CHECK_ITEM_NAME_VCHR"].ToString().Trim();
p_objResult.m_strItemEnglishName = p_dtrSource["CHECK_ITEM_ENGLISH_NAME_VCHR"].ToString().Trim();
p_objResult.m_dtModify = DBAssist.ToDateTime(p_dtrSource["MODIFY_DAT"]);
p_objResult.m_dtDeviceSend = DBAssist.ToDateTime(p_dtrSource["DEVICE_SEND_DAT"]);
p_objResult.m_dtOperator = DBAssist.ToDateTime(p_dtrSource["OPERATOR_DAT"]);
p_objResult.m_strResultNum = p_dtrSource["ResultNum_VCHR"].ToString().Trim();
p_objResult.m_strResultText = p_dtrSource["ResultText_VCHR"].ToString().Trim();
p_objResult.m_strOperatorId = p_dtrSource["OPERATOR_ID_CHR"].ToString().Trim();
p_objResult.m_blnStatus = DBAssist.ToInt32(p_dtrSource["Status_int"]) == 1 ? true : false;
p_objResult.m_strSummary = p_dtrSource["Summary_VCHR"].ToString().Trim();
p_objResult.m_IsPositive = DBAssist.ToInt32(p_dtrSource["Positive_INT"].ToString()) == 1 ? true : false;
}
private System.Data.IDataParameter[] GetInsertDataParameterArr(clsST360CheckResultVO m_objResult)
{
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr
(
m_objResult.m_intSampleId,
GetSampleType(m_objResult.m_enmSampelType),
m_objResult.m_strBoardNo,
m_objResult.m_intTemplateNo,
m_objResult.m_intItemId,
m_objResult.m_strItemName,
m_objResult.m_strItemEnglishName,
m_objResult.m_dtModify,
m_objResult.m_dtOperator,
m_objResult.m_dtDeviceSend,
m_objResult.m_strResultNum,
m_objResult.m_strResultText,
m_objResult.m_blnStatus ? 1 : 0,
m_objResult.m_strDeviceId,
m_objResult.m_strOperatorId,
m_objResult.m_strSummary,
m_objResult.m_IsPositive?1:0
);
return(objODPArr);
}
private void m_cmdSubmitData_Click(object sender, EventArgs e)
{
if (m_selectProject == null || m_selectProject.Name == string.Empty)
{
MessageBox.Show("请选择检验项目！");
return;
}
if (m_selectTemplate == null || m_selectTemplate.TemplateName == string.Empty)
{
MessageBox.Show("请选择模板！");
return;
}
if (m_lstCheckResults == null || m_lstCheckResults.Count == 0)
{
MessageBox.Show("没有酶标检验项目结果！");
return;
}
if (MessageBox.Show(string.Format("仪器传送时间是：{0} \n 检验项目名称是：{1} \n 确认后数据将不能更改！", m_lstCheckResults[0].m_strCheckDat, m_selectProject.Name), "是否确认", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
string boardNo = m_txtBoardNO.Text;
if (string.IsNullOrEmpty(boardNo))
{
MessageBox.Show("微孔板编号为空！");
return;
}
string[] arrBoardNo = null;
clsST360CheckResultSmp.s_object.m_lngFindBoardName(out arrBoardNo);
if (arrBoardNo == null)
{
return;
}
foreach (string strboardNo in arrBoardNo)
{
if (strboardNo.Trim() == boardNo.Trim())
{
MessageBox.Show("微孔板编号数据库中已存在！");
m_txtBoardNO.SelectAll();
return;
}
}
foreach (clsDeviceReslutVO checkResult in m_lstCheckResults)
{
foreach (clsSTBoardItem boardItem in m_lstBoard)
{
if (boardItem.BoardStyle.SampleStyle == enmSTSampleStyle.Common && checkResult.m_strDeviceSampleID == boardItem.Sequence.ToString())
{
checkResult.m_strUnit = checkResult.m_strResult;
checkResult.m_strDeviceSampleID = boardItem.BoardStyle.SampleStyleNo.ToString();
checkResult.m_strResult = boardItem.IsPositive ? "阳" : "阴";
checkResult.m_strDeviceCheckItemName = this.m_selectProject.EnglishName;
}
}
}
foreach (clsDeviceReslutVO deviceResult in m_lstCheckResults)
{
clsST360Smp.s_object.m_lngUpdateDeviceResult(deviceResult);
}
DateTime dt = DateTime.Now;
foreach (clsSTBoardItem boardItem in m_lstBoard)
{
clsDeviceReslutVO checkResult = FindDeviceReslut(boardItem);
if (checkResult == null)
{
continue;
}
clsST360CheckResultVO checkResultVO = new clsST360CheckResultVO();
checkResultVO.m_blnStatus = true;
checkResultVO.m_dtModify = dt;
checkResultVO.m_dtOperator = dt;
checkResultVO.m_enmSampelType = boardItem.BoardStyle.SampleStyle;
checkResultVO.m_intSampleId = boardItem.Sequence;
checkResultVO.m_intTemplateNo = boardItem.BoardStyle.SampleStyleNo;
checkResultVO.m_strBoardNo = boardNo;
checkResultVO.m_strDeviceId = checkResult.m_strDeviceID;
checkResultVO.m_strItemEnglishName = m_selectProject.EnglishName;
checkResultVO.m_strItemName = m_selectProject.Name;
checkResultVO.m_strOperatorId = this.LoginInfo.m_strEmpID;
checkResultVO.m_strResultNum = boardItem.DataNum;
checkResultVO.m_strResultText = boardItem.IsPositive ? "阳" : "阴";
clsST360CheckResultSmp.s_object.m_lngInsert(checkResultVO);
}
MessageBox.Show("数据确认成功！");
}