//public long m_lngUpdateDeviceResult(clsDeviceReslutVO[] arrDeviceResult) //{ //} public long m_lngUpdateDeviceResult(clsDeviceReslutVO deviceResult) { long lngRes = 0; string sql = @" update t_opr_lis_result set RESULT_VCHR=?,DEVICE_CHECK_ITEM_NAME_VCHR=?,UNIT_VCHR=?,DEVICE_SAMPLEID_CHR=? where IDX_INT=? "; System.Data.IDataParameter[] updateParameters = clsPublicSvc.m_objConstructIDataParameterArr ( deviceResult.m_strResult, deviceResult.m_strDeviceCheckItemName, deviceResult.m_strUnit, deviceResult.m_strDeviceSampleID, deviceResult.m_strIdx ); clsHRPTableService objHRPSvc = new clsHRPTableService(); try { System.Data.IDataParameter[] objODPArr = updateParameters; long lngRecEff = -1; lngRes = objHRPSvc.lngExecuteParameterSQL(sql, ref lngRecEff, updateParameters); objHRPSvc.Dispose(); } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
private void ConstructVO(DataRow p_dtrSource, ref clsDeviceReslutVO p_objResult) { // IDX_INT,DEVICE_CHECK_ITEM_NAME_VCHR,DEVICE_SAMPLEID_CHR,DEVICEID_CHR,CHECK_DAT,PSTATUS_INT p_objResult.m_strIdx = p_dtrSource["IDX_INT"].ToString(); p_objResult.m_strResult = p_dtrSource["RESULT_VCHR"].ToString().Trim(); p_objResult.m_strDeviceCheckItemName = p_dtrSource["DEVICE_CHECK_ITEM_NAME_VCHR"].ToString().Trim(); p_objResult.m_strDeviceSampleID = p_dtrSource["DEVICE_SAMPLEID_CHR"].ToString().Trim(); p_objResult.m_strDeviceID = p_dtrSource["DEVICEID_CHR"].ToString().Trim(); p_objResult.m_strCheckDat = p_dtrSource["CHECK_DAT"].ToString().Trim(); }
/// <summary> /// 查询仪器酶标(360)做的最新检验结果 /// </summary> /// <returns></returns> public long m_lngFindSTGroupResult(out List <clsDeviceReslutVO> lstResult) { long lngRes = 0; lstResult = new List <clsDeviceReslutVO>(); string sql = @" SELECT IDX_INT,RESULT_VCHR,DEVICE_CHECK_ITEM_NAME_VCHR,DEVICE_SAMPLEID_CHR,DEVICEID_CHR,CHECK_DAT,PSTATUS_INT FROM t_opr_lis_result WHERE device_check_item_name_vchr = 'ST360' AND check_dat > SYSDATE - 5 order by check_dat DESC "; // string sql = @" // SELECT SAMPLE_ID_CHR,RESULT_VCHR,DEVICE_CHECK_ITEM_NAME_VCHR,MODIFY_DAT,CHECK_DAT,STATUS_INT // FROM t_opr_lis_check_result // WHERE STATUS_INT=1 and modify_dat >sysdate-1 and DEVICE_CHECK_ITEM_NAME_VCHR='ST360' // ORDER BY MODIFY_DAT // "; DataTable dtbResult = null; clsHRPTableService hrpService = new clsHRPTableService(); try { lngRes = hrpService.lngGetDataTableWithoutParameters(sql, ref dtbResult); if (dtbResult != null && dtbResult.Rows.Count > 0) { DateTime dtFirst = DateTime.MinValue; for (int i = 0; i < dtbResult.Rows.Count; i++) { clsDeviceReslutVO checkResult = new clsDeviceReslutVO(); ConstructVO(dtbResult.Rows[i], ref checkResult); if (i == 0) { dtFirst = DateTime.Parse(checkResult.m_strCheckDat); } DateTime temp = DateTime.Parse(checkResult.m_strCheckDat); // 是不是同一个结果的 bool isSampleBatch = dtFirst.Year == temp.Year && dtFirst.Month == temp.Month && dtFirst.Day == temp.Day && dtFirst.Hour == temp.Hour && Math.Abs(dtFirst.Minute - temp.Minute) < 2; if (isSampleBatch) { lstResult.Add(checkResult); } } } } catch (Exception ex) { new com.digitalwave.Utility.clsLogText().LogError(ex.Message); } return(lngRes); }
public long m_lngUpdateDeviceResult(clsDeviceReslutVO deviceResult) { long lngRes = 0; try { lngRes = m_objSvc.m_lngUpdateDeviceResult(deviceResult); } catch { lngRes = 0; } return(lngRes); }
public void m_mthSave() { if (m_objViewer.m_lsvResultUnite.Items.Count <= 0 || m_objResultLog == null) { return; } m_objDeviceResultArr = new clsDeviceReslutVO[m_objViewer.m_lsvResultUnite.Items.Count]; for (int i = 0; i < m_objViewer.m_lsvResultUnite.Items.Count; i++) { m_objDeviceResultArr[i] = new clsDeviceReslutVO(); clsDeviceReslutVO objTemp = (clsDeviceReslutVO)m_objViewer.m_lsvResultUnite.Items[i].Tag; m_objDeviceResultArr[i].m_strAbnormalFlag = objTemp.m_strAbnormalFlag; m_objDeviceResultArr[i].m_strCheckDat = m_objResultLog.m_strCheckDat; m_objDeviceResultArr[i].m_strDeviceCheckItemName = objTemp.m_strDeviceCheckItemName; m_objDeviceResultArr[i].m_strDeviceID = objTemp.m_strDeviceID; m_objDeviceResultArr[i].m_strDeviceSampleID = m_objResultLog.m_strDeviceSampleID; m_objDeviceResultArr[i].m_strMaxVal = objTemp.m_strMaxVal; m_objDeviceResultArr[i].m_strMinVal = objTemp.m_strMinVal; m_objDeviceResultArr[i].m_strPstatus = "1"; m_objDeviceResultArr[i].m_strRefRange = objTemp.m_strRefRange; m_objDeviceResultArr[i].m_strResult = objTemp.m_strResult; m_objDeviceResultArr[i].m_strUnit = objTemp.m_strUnit; } long lngRes = 0; lngRes = m_objManage.m_lngAddNewDeviceCheckResultArrANDLog(m_objDeviceResultArr, m_objResultLog); if (lngRes > 0 && !this.m_blnShowDialog) { m_objViewer.m_lsvSampleList.Items.Clear(); m_mthGetDeviceSampleListByCondition(m_objResultLog.m_strDeviceSampleID, m_objResultLog.m_strDeviceID, DateTime.Parse(m_objResultLog.m_strCheckDat).ToShortDateString()); for (int i = 0; i < m_objViewer.m_lsvSampleList.Items.Count; i++) { clsResultLogVO objTemp = (clsResultLogVO)m_objViewer.m_lsvSampleList.Items[i].Tag; if (objTemp.m_strUseFlag == "1") { m_objViewer.m_lsvSampleList.Items[i].Selected = true; } } m_mthSetToBaseSample(); } }
public void m_mthShowMessage(bool p_blnAdd, clsDeviceSampleDataKey p_objDSDKey, object[] p_objResultVOArr) { string strCommingDate; if (p_blnAdd) { ListViewItem lvi = new ListViewItem(p_objDSDKey.strDeviceName); lvi.SubItems.Add(p_objDSDKey.strDeviceSampleID); lvi.SubItems.Add(p_objDSDKey.strCheckDate); this.m_lsvList.Items.Add(lvi); lvi.Selected = true; lvi.Focused = true; lvi.EnsureVisible(); lvi.Tag = p_objDSDKey; strCommingDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); p_objDSDKey.strCommingDateTime = strCommingDate; } else { strCommingDate = p_objDSDKey.strCommingDateTime; } string strSeq; string strItemName; string strResult; string strFlag; string strRefrange; this.m_txtWindow.Clear(); m_txtWindow.AppendText("Device data comming in " + strCommingDate + " ......\r\n"); m_txtWindow.AppendText("Device Name: " + p_objDSDKey.strDeviceName + " Device Sample ID: " + p_objDSDKey.strDeviceSampleID + " CheckDate: " + p_objDSDKey.strCheckDate + "\r\n\r\n"); m_txtWindow.AppendText("Seq. ItemName Result Flag ReferanceRange\r\n"); m_txtWindow.AppendText("--------------------------------------------------------------------------\r\n"); for (int i = 0; i < p_objResultVOArr.Length; i++) //clsLIS_Device_Test_ResultVO[] { strSeq = i.ToString().PadRight(8); if (p_objResultVOArr[i] is clsLIS_Device_Test_ResultVO) { clsLIS_Device_Test_ResultVO objTestResult = (clsLIS_Device_Test_ResultVO)p_objResultVOArr[i]; strItemName = objTestResult.strDevice_Check_Item_Name; if (strItemName != null) { strItemName = strItemName.PadRight(20); } else { strItemName = " "; } if (objTestResult.strResult != null) { strResult = objTestResult.strResult.PadRight(12); } else { strResult = " "; } if (objTestResult.strAbnormal_Flag != null) { strFlag = objTestResult.strAbnormal_Flag.PadRight(8); } else { strFlag = " "; } strRefrange = objTestResult.strRefRange; } else { clsDeviceReslutVO objResult = (clsDeviceReslutVO)p_objResultVOArr[i]; strItemName = objResult.m_strDeviceCheckItemName; if (strItemName != null) { strItemName = strItemName.PadRight(20); } else { strItemName = " "; } if (objResult.m_strResult != null) { strResult = objResult.m_strResult.PadRight(12); } else { strResult = " "; } if (objResult.m_strAbnormalFlag != null) { strFlag = objResult.m_strAbnormalFlag.PadRight(8); } else { strFlag = " "; } strRefrange = objResult.m_strRefRange; } m_txtWindow.AppendText(strSeq); m_txtWindow.AppendText(strItemName); m_txtWindow.AppendText(strResult); m_txtWindow.AppendText(strFlag); m_txtWindow.AppendText(strRefrange + "\r\n"); } m_txtWindow.AppendText("--------------------------------------------------------------------------\r\n"); if ((!this.Visible) || (this.WindowState == FormWindowState.Minimized)) { // frmMessageNotify frm = new frmMessageNotify(); // frm.m_frmRealWindow = this; // frm.m_lblDevice.Text = p_objDSDKey.strDeviceName; // frm.m_lnkDeviceSample.Text = p_objDSDKey.strDeviceSampleID; // frm.TopMost = true; // frm.m_objKey = p_objDSDKey; // frm.Show(); } else { // this.Show(); this.Activate(); } }
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("数据确认成功!"); }