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;
return(_dbFileVersionService.GetDevicesByLoopForControllerType8003(loop));
}
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 bool AddDevice(Model.LoopModel loop)
{
try
{
List <DeviceInfo8003> lstDevices = loop.GetDevices <DeviceInfo8003>();
foreach (var device in lstDevices)
{
device.Loop.ID = loop.ID;
device.LoopID = loop.ID;
StringBuilder sbDeviceInfoSQL = new StringBuilder("REPLACE INTO DeviceInfo8003(");
sbDeviceInfoSQL.Append("ID,");
sbDeviceInfoSQL.Append("Code,");
sbDeviceInfoSQL.Append("Disable,");
sbDeviceInfoSQL.Append("Feature,");
sbDeviceInfoSQL.Append("DelayValue,");
sbDeviceInfoSQL.Append("SensitiveLevel,");
sbDeviceInfoSQL.Append("LinkageGroup1,");
sbDeviceInfoSQL.Append("LinkageGroup2,");
sbDeviceInfoSQL.Append("LinkageGroup3,");
sbDeviceInfoSQL.Append("sdpKey,");
sbDeviceInfoSQL.Append("BroadcastZone,");
sbDeviceInfoSQL.Append("ZoneNo,");
sbDeviceInfoSQL.Append("Location,");
sbDeviceInfoSQL.Append("LoopID,");
sbDeviceInfoSQL.Append("TypeCode)");
sbDeviceInfoSQL.Append(" VALUES(");
sbDeviceInfoSQL.Append(device.ID + ",'");
sbDeviceInfoSQL.Append(device.Code + "','");
sbDeviceInfoSQL.Append(device.Disable + "','");
sbDeviceInfoSQL.Append(device.Feature + "','");
sbDeviceInfoSQL.Append(device.DelayValue + "','");
sbDeviceInfoSQL.Append(device.SensitiveLevel + "','");
sbDeviceInfoSQL.Append(device.LinkageGroup1 + "','");
sbDeviceInfoSQL.Append(device.LinkageGroup2 + "','");
sbDeviceInfoSQL.Append(device.LinkageGroup3 + "','");
sbDeviceInfoSQL.Append(device.sdpKey + "','");
sbDeviceInfoSQL.Append(device.BroadcastZone + "','");
sbDeviceInfoSQL.Append(device.ZoneNo + "','");
sbDeviceInfoSQL.Append(device.Location + "','");
sbDeviceInfoSQL.Append(device.LoopID + "','");
sbDeviceInfoSQL.Append(device.TypeCode + "');");
_databaseService.ExecuteBySql(sbDeviceInfoSQL);
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
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);
}
public bool AddDevice(Model.LoopModel loop)
{
try
{
List <DeviceInfo8053> lstDevices = loop.GetDevices <DeviceInfo8053>();
foreach (var device in lstDevices)
{
device.Loop.ID = loop.ID;
device.LoopID = loop.ID;
_dbFileVersionService.AddDeviceForControllerType8053(device);
}
}
catch (Exception ex)
{
logger.Error(ex.Message, ex);
return(false);
}
return(true);
}
public List <Model.LoopModel> GetLoopsByController(Model.ControllerModel controller)
{
List <LoopModel> lstLoops = new List <LoopModel>();
StringBuilder sbQuerySQL = new StringBuilder("select ID,Code,Name,DeviceAmount from Loop where controllerID=" + controller.ID);
System.Data.DataTable dt = _databaseService.GetDataTableBySQL(sbQuerySQL);
for (int i = 0; i < dt.Rows.Count; i++)
{
Model.LoopModel model = new Model.LoopModel();
model.ID = Convert.ToInt16(dt.Rows[i]["id"]);
model.Code = dt.Rows[i]["Code"].ToString();
model.Name = dt.Rows[i]["Name"].ToString();
model.DeviceAmount = Convert.ToInt16(dt.Rows[i]["DeviceAmount"]);
model.Controller = controller;
model.ControllerID = controller.ID;
lstLoops.Add(model);
}
return(lstLoops);
}
public bool AddLoopInfo(Model.LoopModel loop)
{
try
{
StringBuilder sbLoopSQL;
//此处未显示加入ID,由SQLite自动生成
sbLoopSQL = new StringBuilder("Replace into Loop(ID,Code,Name,DeviceAmount,controllerID) values(");
sbLoopSQL.Append(loop.ID + ",'");
sbLoopSQL.Append(loop.Code + "','");
sbLoopSQL.Append(loop.Name + "',");
sbLoopSQL.Append(loop.DeviceAmount + ",");
sbLoopSQL.Append(loop.ControllerID + ");");
_databaseService.ExecuteBySql(sbLoopSQL);
}
catch
{
return(false);
}
return(true);
}
protected override void SetDownloadedDeviceInfoTotalAmountInCurrentLoop(Model.LoopModel loopModel)
{
DownloadedDeviceInfoTotalAmountInCurrentLoop = loopModel.GetDevices <DeviceInfo8021>().Count; //设置当前回路的器件总数2017-04-06
}
protected override bool ExistSameDeviceCode(Model.LoopModel loop)
{
throw new NotImplementedException();
}
public List <Model.LoopModel> CopyLoopInfo(Model.LoopModel loop)
{
throw new NotImplementedException();
}
public bool AddDeviceForControllerType8003(Model.LoopModel loop)
{
throw new System.NotImplementedException();
}
public int UpdateLoopInfo(Model.LoopModel loop)
{
throw new NotImplementedException();
}
public Model.LoopModel GetLoopInfo(Model.LoopModel loop)
{
throw new NotImplementedException();
}
public bool AddDevice(Model.LoopModel loop)
{
try
{
List <DeviceInfo8001> lstDevices = loop.GetDevices <DeviceInfo8001>();
foreach (var device in lstDevices)
{
device.Loop.ID = loop.ID;
device.LoopID = loop.ID;
//StringBuilder sbDeviceInfoSQL = new StringBuilder("REPLACE INTO DeviceInfo8001(");
//sbDeviceInfoSQL.Append("ID,");
//sbDeviceInfoSQL.Append("Code,");
//sbDeviceInfoSQL.Append("Disable,");
//sbDeviceInfoSQL.Append("Feature,");
//sbDeviceInfoSQL.Append("DelayValue,");
//sbDeviceInfoSQL.Append("SensitiveLevel,");
//sbDeviceInfoSQL.Append("BoardNo,");
//sbDeviceInfoSQL.Append("SubBoardNo,");
//sbDeviceInfoSQL.Append("KeyNo,");
//sbDeviceInfoSQL.Append("BroadcastZone,");
//sbDeviceInfoSQL.Append("LinkageGroup1,");
//sbDeviceInfoSQL.Append("LinkageGroup2,");
//sbDeviceInfoSQL.Append("LinkageGroup3,");
//sbDeviceInfoSQL.Append("BuildingNo,");
//sbDeviceInfoSQL.Append("ZoneNo,");
//sbDeviceInfoSQL.Append("FloorNo,");
//sbDeviceInfoSQL.Append("RoomNo,");
//sbDeviceInfoSQL.Append("Location,");
//sbDeviceInfoSQL.Append("SDPKey,");
//sbDeviceInfoSQL.Append("MCBID,");
//sbDeviceInfoSQL.Append("LoopID,");
//sbDeviceInfoSQL.Append("TypeCode) ");
//sbDeviceInfoSQL.Append(" VALUES(");
//sbDeviceInfoSQL.Append(device.ID + ",'");
//sbDeviceInfoSQL.Append(device.Code + "','");
//sbDeviceInfoSQL.Append(device.Disable + "','");
//sbDeviceInfoSQL.Append(device.Feature + "','");
//sbDeviceInfoSQL.Append(device.DelayValue + "','");
//sbDeviceInfoSQL.Append(device.SensitiveLevel + "','");
//sbDeviceInfoSQL.Append(device.BoardNo + "','");
//sbDeviceInfoSQL.Append(device.SubBoardNo + "','");
//sbDeviceInfoSQL.Append(device.KeyNo + "','");
//sbDeviceInfoSQL.Append(device.BroadcastZone + "','");
//sbDeviceInfoSQL.Append(device.LinkageGroup1 + "','");
//sbDeviceInfoSQL.Append(device.LinkageGroup2 + "','");
//sbDeviceInfoSQL.Append(device.LinkageGroup3 + "','");
//sbDeviceInfoSQL.Append(device.BuildingNo + "','");
//sbDeviceInfoSQL.Append(device.ZoneNo + "','");
//sbDeviceInfoSQL.Append(device.FloorNo + "','");
//sbDeviceInfoSQL.Append(device.RoomNo + "','");
//sbDeviceInfoSQL.Append(device.Location + "','");
//sbDeviceInfoSQL.Append(device.sdpKey + "','");
//sbDeviceInfoSQL.Append(device.MCBID + "','");
//sbDeviceInfoSQL.Append(device.LoopID + "','");
//sbDeviceInfoSQL.Append(device.TypeCode + "');");
//_databaseService.ExecuteBySql(sbDeviceInfoSQL);
_dbFileVersionService.AddDeviceForControllerType8001(device);
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}