/// <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);
}
