public long lngGetInstrumentSerialSetting2(string strData_Acquisition_Computer_IP, out clsLIS_Equip_Base[] objConfig_List) { objConfig_List = null; long lngRes = 0; if (string.IsNullOrEmpty(strData_Acquisition_Computer_IP)) { return(lngRes); } clsHRPTableService objHRPServ = null; try { string strSQL = @"select d.deviceid_chr, m.device_model_desc_vchr, s.comno_chr, s.baulrate_chr, s.databit_chr, s.stopbit_chr, s.parity_chr, s.flowcontrol_chr, s.receivebuffer_chr, s.sendbuffer_chr, s.sendcommand_chr, s.sendcommandinternal_chr, s.dataanalysisdll_vchr, s.dataanalysisnamespace_vchr, d.devicename_vchr, d.dataacquisitioncomputerip_chr, d.device_code_chr from t_bse_lis_serialsetup s, t_bse_lis_device d, t_bse_lis_device_model m where d.device_model_id_chr = s.device_model_id_chr and d.device_model_id_chr = m.device_model_id_chr and d.end_date_dat is null and trim(d.dataacquisitioncomputerip_chr) = ?"; DataTable dtResult = null; objHRPServ = new clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPServ.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = strData_Acquisition_Computer_IP; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); //List<clsLIS_Equip_Base> lstEquip = new List<clsLIS_Equip_Base>(); List <clsLIS_Equip_Base> lstEquip = new List <clsLIS_Equip_Base>(); DataRow drTemp = null; if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { #region clsLIS_Equip_ConfigVO clsLIS_Equip_ConfigVO2 objTemp = null; for (int iRow = 0; iRow < dtResult.Rows.Count; iRow++) { drTemp = dtResult.Rows[iRow]; objTemp = new clsLIS_Equip_ConfigVO2(); if (drTemp["DEVICEID_CHR"] != System.DBNull.Value) { objTemp.strLIS_Instrument_ID = drTemp["DEVICEID_CHR"].ToString().Trim(); } if (drTemp["DEVICENAME_VCHR"] != System.DBNull.Value) { objTemp.strLIS_Instrument_Name = drTemp["DEVICENAME_VCHR"].ToString().Trim(); } if (drTemp["DEVICE_MODEL_DESC_VCHR"] != System.DBNull.Value) { objTemp.strLIS_Instrument_Model = drTemp["DEVICE_MODEL_DESC_VCHR"].ToString().Trim(); } if (drTemp["COMNO_CHR"] != System.DBNull.Value) { objTemp.strCOM_No = drTemp["COMNO_CHR"].ToString().Trim(); } if (drTemp["BAULRATE_CHR"] != System.DBNull.Value) { objTemp.strBaud_Rate = drTemp["BAULRATE_CHR"].ToString().Trim(); } if (drTemp["DATABIT_CHR"] != System.DBNull.Value) { objTemp.strData_Bit = drTemp["DATABIT_CHR"].ToString().Trim(); } if (drTemp["STOPBIT_CHR"] != System.DBNull.Value) { objTemp.strStop_Bit = drTemp["STOPBIT_CHR"].ToString().Trim(); } if (drTemp["PARITY_CHR"] != System.DBNull.Value) { objTemp.strParity = drTemp["PARITY_CHR"].ToString().Trim(); } if (drTemp["FLOWCONTROL_CHR"] != System.DBNull.Value) { objTemp.strFlow_Control = drTemp["FLOWCONTROL_CHR"].ToString().Trim(); } if (drTemp["RECEIVEBUFFER_CHR"] != System.DBNull.Value) { objTemp.strReceive_Buffer = drTemp["RECEIVEBUFFER_CHR"].ToString().Trim(); } if (drTemp["SENDBUFFER_CHR"] != System.DBNull.Value) { objTemp.strSend_Buffer = drTemp["SENDBUFFER_CHR"].ToString().Trim(); } if (drTemp["SENDCOMMAND_CHR"] != System.DBNull.Value) { objTemp.strSend_Command = drTemp["SENDCOMMAND_CHR"].ToString(); } if (drTemp["SENDCOMMANDINTERNAL_CHR"] != System.DBNull.Value) { objTemp.strSend_Command_Internal = drTemp["SENDCOMMANDINTERNAL_CHR"].ToString().Trim(); } if (drTemp["DATAANALYSISDLL_VCHR"] != System.DBNull.Value) { objTemp.strData_Analysis_DLL = drTemp["DATAANALYSISDLL_VCHR"].ToString().Trim(); } if (drTemp["DATAANALYSISNAMESPACE_VCHR"] != System.DBNull.Value) { objTemp.strData_Analysis_Namespace = drTemp["DATAANALYSISNAMESPACE_VCHR"].ToString().Trim(); } if (drTemp["DATAACQUISITIONCOMPUTERIP_CHR"] != System.DBNull.Value) { objTemp.strData_Acquisition_Computer_IP = drTemp["DATAACQUISITIONCOMPUTERIP_CHR"].ToString().Trim(); } objTemp.strLIS_Instrument_NO = drTemp["device_code_chr"].ToString().Trim(); lstEquip.Add(objTemp); } #endregion } strSQL = @"select a.device_model_id_chr, a.online_module_chr, a.online_dns_vchr, a.work_module_chr, a.work_auto_internal_vchr, a.pic_path_vchr, a.other_pram_vchr, a.dataanalysisdll_vchr, a.dataanalysisnamespace_vchr, b.deviceid_chr, b.devicename_vchr, b.device_code_chr, b.dataacquisitioncomputerip_chr, c.device_model_desc_vchr from t_bse_lis_interface_online a, t_bse_lis_device b, t_bse_lis_device_model c where a.device_model_id_chr = c.device_model_id_chr and b.device_model_id_chr = a.device_model_id_chr and b.end_date_dat is null and trim(b.dataacquisitioncomputerip_chr) = ?"; dtResult = null; objHRPServ.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = strData_Acquisition_Computer_IP; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { #region clsLIS_Equip_DB_ConfigVO clsLIS_Equip_DB_ConfigVO objTempDB = null; for (int idx = 0; idx < dtResult.Rows.Count; idx++) { drTemp = dtResult.Rows[idx]; objTempDB = new clsLIS_Equip_DB_ConfigVO(); objTempDB.strLIS_Instrument_Model = drTemp["device_model_desc_vchr"].ToString().Trim(); objTempDB.strONLINE_MODULE_CHR = drTemp["online_module_chr"].ToString().Trim(); objTempDB.strONLINE_DNS_VCHR = drTemp["online_dns_vchr"].ToString().Trim(); objTempDB.strWORK_MODULE_CHR = drTemp["work_module_chr"].ToString().Trim(); objTempDB.strWORK_AUTO_INTERNAL_VCHR = drTemp["work_auto_internal_vchr"].ToString().Trim(); objTempDB.strPIC_PATH_VCHR = drTemp["pic_path_vchr"].ToString().Trim(); objTempDB.strOTHER_PRAM_VCHR = drTemp["other_pram_vchr"].ToString().Trim(); objTempDB.strData_Analysis_DLL = drTemp["dataanalysisdll_vchr"].ToString().Trim(); objTempDB.strData_Analysis_Namespace = drTemp["dataanalysisnamespace_vchr"].ToString().Trim(); objTempDB.strLIS_Instrument_ID = drTemp["deviceid_chr"].ToString().Trim(); objTempDB.strLIS_Instrument_Name = drTemp["devicename_vchr"].ToString().Trim(); objTempDB.strLIS_Instrument_NO = drTemp["device_code_chr"].ToString().Trim(); objTempDB.strData_Acquisition_Computer_IP = drTemp["dataacquisitioncomputerip_chr"].ToString().Trim(); lstEquip.Add(objTempDB); } #endregion } objConfig_List = lstEquip.ToArray(); } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; strData_Acquisition_Computer_IP = null; } return(lngRes); }
/// <summary> /// 选择设备后将设备设定信息与窗体中的控件绑定 xing.chen添加注释 2012-01-19 李泳潮修改 /// </summary> /// <param name="frmLIS_Controller">frmLIS_Data_Acquisition_Controller对象</param> public void SelectInstrument(com.digitalwave.iCare.gui.LIS_Data_Acquisition_Controller.frmLIS_Data_Acquisition_Controller frmLIS_Controller) { clsLIS_Equip_ConfigVO2 objEquip_ConfigVO1 = frmLIS_Controller.m_cboInstrument.SelectedItem as clsLIS_Equip_ConfigVO2; if (objEquip_ConfigVO1 != null) { frmLIS_Controller.m_txtBaudRate.Text = objEquip_ConfigVO1.strBaud_Rate; frmLIS_Controller.m_txtComNum.Text = objEquip_ConfigVO1.strCOM_No; frmLIS_Controller.m_txtDataBit.Text = objEquip_ConfigVO1.strData_Bit; switch (objEquip_ConfigVO1.strFlow_Control) { case "0": frmLIS_Controller.m_txtFlowControl.Text = "None"; break; case "1": frmLIS_Controller.m_txtFlowControl.Text = "Software"; break; case "2": frmLIS_Controller.m_txtFlowControl.Text = "Hardware"; break; } switch (objEquip_ConfigVO1.strParity) { case "0": frmLIS_Controller.m_txtParity.Text = "None"; break; case "1": frmLIS_Controller.m_txtParity.Text = "Even"; break; case "2": frmLIS_Controller.m_txtParity.Text = "Odd"; break; case "3": frmLIS_Controller.m_txtParity.Text = "Mark"; break; case "4": frmLIS_Controller.m_txtParity.Text = "Space"; break; } frmLIS_Controller.m_txtReceiveBuffer.Text = objEquip_ConfigVO1.strReceive_Buffer; frmLIS_Controller.m_txtSendBuffer.Text = objEquip_ConfigVO1.strSend_Buffer; frmLIS_Controller.m_txtStopBit.Text = objEquip_ConfigVO1.strStop_Bit; //frmLIS_Controller.m_ctlRemark.Text = ""; } else { frmLIS_Controller.m_txtBaudRate.Text = ""; frmLIS_Controller.m_txtComNum.Text = ""; frmLIS_Controller.m_txtDataBit.Text = ""; frmLIS_Controller.m_txtFlowControl.Text = ""; frmLIS_Controller.m_txtParity.Text = ""; frmLIS_Controller.m_txtReceiveBuffer.Text = ""; frmLIS_Controller.m_txtSendBuffer.Text = ""; frmLIS_Controller.m_txtStopBit.Text = ""; } #region 修版本模式 2012-01-19 yongchao.li 修改 //com.digitalwave.iCare.ValueObject.clsLIS_Equip_ConfigVO objEquip_ConfigVO = (clsLIS_Equip_ConfigVO)frmLIS_Controller.m_cboInstrument.SelectedItem; //frmLIS_Controller.m_txtBaudRate.Text = objEquip_ConfigVO.strBaud_Rate; //frmLIS_Controller.m_txtComNum.Text = objEquip_ConfigVO.strCOM_No; //frmLIS_Controller.m_txtDataBit.Text = objEquip_ConfigVO.strData_Bit; //switch (objEquip_ConfigVO.strFlow_Control) //{ // case "0": // frmLIS_Controller.m_txtFlowControl.Text = "None"; // break; // case "1": // frmLIS_Controller.m_txtFlowControl.Text = "Software"; // break; // case "2": // frmLIS_Controller.m_txtFlowControl.Text = "Hardware"; // break; //} //switch (objEquip_ConfigVO.strParity) //{ // case "0": // frmLIS_Controller.m_txtParity.Text = "None"; // break; // case "1": // frmLIS_Controller.m_txtParity.Text = "Even"; // break; // case "2": // frmLIS_Controller.m_txtParity.Text = "Odd"; // break; // case "3": // frmLIS_Controller.m_txtParity.Text = "Mark"; // break; // case "4": // frmLIS_Controller.m_txtParity.Text = "Space"; // break; //} //frmLIS_Controller.m_txtReceiveBuffer.Text = objEquip_ConfigVO.strReceive_Buffer; //frmLIS_Controller.m_txtSendBuffer.Text = objEquip_ConfigVO.strSend_Buffer; //frmLIS_Controller.m_txtStopBit.Text = objEquip_ConfigVO.strStop_Bit; #endregion }