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
}
