/// <summary> /// 添加或修改特殊仪器参数 /// </summary> /// <param name="p_objEquipVo"></param> /// <param name="p_blnAdd"></param> /// <returns></returns> public long m_lngAddSpecialDevice(clsLIS_Equip_DB_ConfigVO p_objEquipVo, bool p_blnAdd) { long lngRes = 0; com.digitalwave.iCare.middletier.LIS.clsLisDeviceSvc objDeviceSvc = null; objDeviceSvc = (com.digitalwave.iCare.middletier.LIS.clsLisDeviceSvc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.LIS.clsLisDeviceSvc)); lngRes = objDeviceSvc.m_lngAddSpecialDevice(objPrincipal, p_objEquipVo, p_blnAdd); // objDeviceSvc.Dispose(); return(lngRes); }
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); }