public string AddInstrumentCommunication(InstrumentCommunicationSetting CommunicationSetting)
{
//if (CommunicationSetting == null || string.IsNullOrEmpty(CommunicationSetting.ID))
//{
// throw new IDNullException("通讯设置ID不可为空！");
//}
string sqlCommandText = ModuleConfiguration.SQL_CMD_InsertInstrumentCommunicationSetting;
this.dmlOperable.ExeSql(sqlCommandText, new Dictionary <string, object>()
{
//{ "@ID", long.Parse(CommunicationSetting.ID)},
{ "@InstrumentID", CommunicationSetting.Instrument.ID },
{ "@Type", CommunicationSetting.CommunicationType },
{ "@IpAddress", CommunicationSetting.IpAddress },
{ "@PortNumber", CommunicationSetting.PortNumber },
{ "@SerialPortName", CommunicationSetting.SerialPortName },
{ "@SerialPortBaudRate", CommunicationSetting.SerialPortBaudRate },
{ "@BluetoothDeviceName", CommunicationSetting.BluetoothDeviceName },
{ "@BluetoothAddress", CommunicationSetting.BluetoothAddress },
{ "@BluetoothKey", CommunicationSetting.BluetoothKey },
{ "@Protocol", CommunicationSetting.Protocol },
{ "@AssemblyName", CommunicationSetting.AssemblyName },
{ "@AssemblyPath", CommunicationSetting.AssemblyFilePath },
{ "@ClassName", CommunicationSetting.ClassName },
{ "@Version", CommunicationSetting.Version },
});
return(GenerateInstrumentCommunicationSettingID(0)); //CommunicationSetting.ID;
}
public InstrumentCommunicationSetting SetInstrumentCommunication(string SettingID, InstrumentCommunicationSetting CommunicationSetting)
{
if (string.IsNullOrEmpty(SettingID))
{
throw new IDNullException("仪器设置ID不可为空！");
}
int intI = 0;
if (CommunicationSetting.CommunicationType == CommunicationTypeEnum.TcpIpOverEthernet)
{
intI = 3;
}
else if (CommunicationSetting.CommunicationType == CommunicationTypeEnum.SerialPort)
{
intI = 1;
}
else if (CommunicationSetting.CommunicationType == CommunicationTypeEnum.Bluetooth)
{
intI = 2;
}
// string sqlCommandText = "UPDATE InstrumentCommnunicationSettings SET " + "ics_Type = " + intI + ", " +
//"ics_IpAddress = '" + CommunicationSetting.IpAddress + "', " +
//"ics_PortNumber = " + CommunicationSetting.PortNumber + ", " +
//"ics_SerialPortName ='" + CommunicationSetting.SerialPortName + "', " +
//"ics_SerialPortBaudRate =" + CommunicationSetting.SerialPortBaudRate + ", " +
//"ics_BluetoothDeviceName = '" + CommunicationSetting.BluetoothDeviceName + "'," +
//"ics_BluetoothAddress = '" + CommunicationSetting.BluetoothAddress + "', " +
//"ics_BluetoothKey = '" + CommunicationSetting.BluetoothKey + "' WHERE InstrumentID = " + SettingID + "; ";
string sqlCommandText = ModuleConfiguration.SQL_CMD_UpdateInstrumentCommunicationSetting;
this.dmlOperable.ExeSql(sqlCommandText, new Dictionary <string, object>()
{
{ "@InstrumentID", CommunicationSetting.Instrument.ID },
{ "@Type", intI },
{ "@IpAddress", CommunicationSetting.IpAddress },
{ "@PortNumber", CommunicationSetting.PortNumber },
{ "@SerialPortName", CommunicationSetting.SerialPortName },
{ "@SerialPortBaudRate", CommunicationSetting.SerialPortBaudRate },
{ "@BluetoothDeviceName", CommunicationSetting.BluetoothDeviceName },
{ "@BluetoothAddress", CommunicationSetting.BluetoothAddress },
{ "@BluetoothKey", CommunicationSetting.BluetoothKey },
{ "@Protocol", CommunicationSetting.Protocol },
{ "@AssemblyName", CommunicationSetting.AssemblyName },
{ "@AssemblyPath", CommunicationSetting.AssemblyFilePath },
{ "@ClassName", CommunicationSetting.ClassName },
{ "@Version", CommunicationSetting.Version },
});
return(CommunicationSetting);
}
