//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("数据确认成功！");
}
