public bool GetDevicesByLoopForControllerType8003(ref Model.LoopModel loop)
{
List <DeviceInfo8003> lstDeviceInfo8003 = new List <DeviceInfo8003>();
string strDeviceQuerySQL = "select bianhao,leixing,geli,lingmd,shuchu1,shuchu2,shuchu3,yanshi,xianggh,zjczbh,GbZone,didian from ";
strDeviceQuerySQL += loop.Code;
DataTable dtDevices = _databaseService.GetDataTableBySQL(new StringBuilder(strDeviceQuerySQL));
int dtDevicesRowsCount = dtDevices.Rows.Count;
for (int j = 0; j < dtDevicesRowsCount; j++) //器件信息
{
DeviceInfo8003 device = new DeviceInfo8003();
device.Code = dtDevices.Rows[j]["bianhao"].ToString();
Int16?intTypeCode = dtDevices.Rows[j]["leixing"].ToString().Substring(0, 3).ToNullable <Int16>();
device.TypeCode = (short)intTypeCode;
device.Disable = dtDevices.Rows[j]["geli"].ToString().ToNullable <bool>();
device.SensitiveLevel = dtDevices.Rows[j]["lingmd"].ToString().ToNullable <Int16>();
device.LinkageGroup1 = dtDevices.Rows[j]["shuchu1"].ToString();
device.LinkageGroup2 = dtDevices.Rows[j]["shuchu2"].ToString();
device.LinkageGroup3 = dtDevices.Rows[j]["shuchu3"].ToString();
device.DelayValue = dtDevices.Rows[j]["yanshi"].ToString().ToNullable <Int16>();
device.sdpKey = dtDevices.Rows[j]["xianggh"].ToString();
device.ZoneNo = dtDevices.Rows[j]["zjczbh"].ToString().ToNullable <Int16>();
device.BroadcastZone = dtDevices.Rows[j]["GbZone"].ToString();
device.Location = dtDevices.Rows[j]["didian"].ToString();
device.Loop = loop;
loop.SetDevice <DeviceInfo8003>(device);
lstDeviceInfo8003.Add(device);
}
return(true);
}
public Model.LoopModel GetDevicesByLoop(Model.LoopModel loop)
{
StringBuilder sbQuerySQL = new StringBuilder("select ID,Code,Disable,Feature,DelayValue,SensitiveLevel,LinkageGroup1,LinkageGroup2,LinkageGroup3,sdpKey,BroadcastZone,ZoneNo,Location,LoopID,TypeCode from DeviceInfo8003 where LoopID=" + loop.ID);
System.Data.DataTable dt = _databaseService.GetDataTableBySQL(sbQuerySQL);
for (int i = 0; i < dt.Rows.Count; i++)
{
Model.DeviceInfo8003 model = new Model.DeviceInfo8003();
model.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
model.Code = dt.Rows[i]["Code"].ToString();
model.Disable = (bool?)dt.Rows[i]["Disable"];
model.Feature = new Nullable <short>(Convert.ToInt16(dt.Rows[i]["Feature"]));
model.DelayValue = new Nullable <short>(Convert.ToInt16(dt.Rows[i]["DelayValue"]));
model.SensitiveLevel = new Nullable <short>(Convert.ToInt16(dt.Rows[i]["SensitiveLevel"]));
model.LinkageGroup1 = dt.Rows[i]["LinkageGroup1"].ToString();
model.LinkageGroup2 = dt.Rows[i]["LinkageGroup2"].ToString();
model.LinkageGroup3 = dt.Rows[i]["LinkageGroup3"].ToString();
model.sdpKey = Convert.ToInt32(dt.Rows[i]["sdpKey"]);
model.BroadcastZone = dt.Rows[i]["BroadcastZone"].ToString();
model.ZoneNo = new Nullable <short>(Convert.ToInt16(dt.Rows[i]["ZoneNo"]));
model.Location = dt.Rows[i]["Location"].ToString();
model.LoopID = Convert.ToInt32(dt.Rows[i]["LoopID"]);
model.TypeCode = Convert.ToInt16(dt.Rows[i]["TypeCode"]);
model.Loop = loop;
model.LoopID = loop.ID;
loop.SetDevice <DeviceInfo8003>(model);
}
return(loop);
}
public bool GetDevicesByLoopForControllerType8001(ref Model.LoopModel loop, Dictionary <string, string> dictDeviceMappingManualControlBoard)
{
List <DeviceInfo8001> lstDeviceInfo8001 = new List <DeviceInfo8001>();
string strDeviceQuerySQL = "select bianhao,leixing,geli,lingmd,shuchu1,shuchu2,shuchu3,yanshi,xianggh,panhao,jianhao,cleixing,GbZone,didian,louhao,quhao,cenghao,fangjianhao,sdpkey from ";
strDeviceQuerySQL += loop.Code;
DataTable dtDevices = _databaseService.GetDataTableBySQL(new StringBuilder(strDeviceQuerySQL));
int dtDevicesRowsCount = dtDevices.Rows.Count;
for (int j = 0; j < dtDevicesRowsCount; j++) //器件信息
{
DeviceInfo8001 device = new DeviceInfo8001();
device.Code = dtDevices.Rows[j]["bianhao"].ToString();
device.Disable = dtDevices.Rows[j]["geli"].ToString().ToNullable <bool>();
device.SensitiveLevel = dtDevices.Rows[j]["lingmd"].ToString().ToNullable <Int16>();
device.LinkageGroup1 = dtDevices.Rows[j]["shuchu1"].ToString();
device.LinkageGroup2 = dtDevices.Rows[j]["shuchu2"].ToString();
device.LinkageGroup3 = dtDevices.Rows[j]["shuchu3"].ToString();
device.DelayValue = dtDevices.Rows[j]["yanshi"].ToString().ToNullable <Int16>();
device.BoardNo = dtDevices.Rows[j]["xianggh"].ToString().ToNullable <Int16>();
device.SubBoardNo = dtDevices.Rows[j]["panhao"].ToString().ToNullable <Int16>();
device.KeyNo = dtDevices.Rows[j]["jianhao"].ToString().ToNullable <Int16>();
Int16?intTypeCode = dtDevices.Rows[j]["leixing"].ToString().Substring(0, 3).ToNullable <Int16>();
device.TypeCode = (short)intTypeCode;
device.BroadcastZone = dtDevices.Rows[j]["GbZone"].ToString();
device.Location = dtDevices.Rows[j]["didian"].ToString();
device.BuildingNo = dtDevices.Rows[j]["louhao"].ToString().ToNullable <Int16>();
device.ZoneNo = dtDevices.Rows[j]["quhao"].ToString().ToNullable <Int16>();
device.FloorNo = dtDevices.Rows[j]["cenghao"].ToString().ToNullable <Int16>();
device.RoomNo = dtDevices.Rows[j]["fangjianhao"].ToString().ToNullable <Int16>();
device.sdpKey = dtDevices.Rows[j]["sdpkey"].ToString();
device.Loop = loop;
if (dictDeviceMappingManualControlBoard != null)
{
if (dictDeviceMappingManualControlBoard.ContainsKey(device.Code)) //如果存在网络手动盘的信息定义，则设置MCBCode的值，建立与手动盘的关系
{
device.MCBCode = dictDeviceMappingManualControlBoard[device.Code];
}
}
//if(lstDeviceInfo8001.Count>0)
//{
// _deviceAddressLength = lstDeviceInfo8001[0].Code.Length;
//}
loop.SetDevice <DeviceInfo8001>(device);
lstDeviceInfo8001.Add(device);
}
return(true);
}
