public bool AddMixedLinkageConfigInfo(Model.LinkageConfigMixed linkageConfigMixed) { int intEffectiveRows = 0; try { //StringBuilder sbSQL = new StringBuilder("REPLACE INTO LinkageConfigMixed(ID,Code, ActionCoefficient,ActionType, TypeA, LoopNoA, DeviceCodeA ,BuildingNoA,ZoneNoA , LayerNoA , DeviceTypeCodeA,TypeB,LoopNoB,DeviceCodeB,BuildingNoB ,ZoneNoB , LayerNoB , DeviceTypeCodeB ,TypeC ,MachineNoC,LoopNoC ,DeviceCodeC ,BuildingNoC ,ZoneNoC , LayerNoC ,DeviceTypeCodeC ,controllerID)"); //sbSQL.Append(" VALUES("); //sbSQL.Append(linkageConfigMixed.ID + ",'"); //sbSQL.Append(linkageConfigMixed.Code + "','"); //sbSQL.Append(linkageConfigMixed.ActionCoefficient + "','"); //sbSQL.Append((int)linkageConfigMixed.ActionType + "','"); //sbSQL.Append((int)linkageConfigMixed.TypeA + "','"); //sbSQL.Append(linkageConfigMixed.LoopNoA + "','"); //sbSQL.Append(linkageConfigMixed.DeviceTypeCodeA + "','"); //sbSQL.Append(linkageConfigMixed.BuildingNoA + "','"); //sbSQL.Append(linkageConfigMixed.ZoneNoA + "','"); //sbSQL.Append(linkageConfigMixed.LayerNoA + "','"); //sbSQL.Append(linkageConfigMixed.DeviceTypeCodeA + "','"); //sbSQL.Append((int)linkageConfigMixed.TypeB + "','"); //sbSQL.Append(linkageConfigMixed.LoopNoB + "','"); //sbSQL.Append(linkageConfigMixed.DeviceCodeB + "','"); //sbSQL.Append(linkageConfigMixed.BuildingNoB + "','"); //sbSQL.Append(linkageConfigMixed.ZoneNoB + "','"); //sbSQL.Append(linkageConfigMixed.LayerNoB + "','"); //sbSQL.Append(linkageConfigMixed.DeviceTypeCodeB + "','"); //sbSQL.Append((int)linkageConfigMixed.TypeC + "','"); //sbSQL.Append(linkageConfigMixed.MachineNoC + "','"); //sbSQL.Append(linkageConfigMixed.LoopNoC + "','"); //sbSQL.Append(linkageConfigMixed.DeviceCodeC + "','"); //sbSQL.Append(linkageConfigMixed.BuildingNoC + "','"); //sbSQL.Append(linkageConfigMixed.ZoneNoC + "','"); //sbSQL.Append(linkageConfigMixed.LayerNoC + "','"); //sbSQL.Append(linkageConfigMixed.DeviceTypeCodeC + "',"); //sbSQL.Append(linkageConfigMixed.ControllerID + ");"); //intEffectiveRows = _databaseService.ExecuteBySql(sbSQL); intEffectiveRows = _dbFileVersionService.AddMixedLinkageConfigInfo(linkageConfigMixed); } catch { intEffectiveRows = 0; } if (intEffectiveRows > 0) { return(true); } else { return(false); } }
public bool Update(Model.LinkageConfigMixed linkageConfigMixed) { try { LinkageConfigMixed result = _controller.MixedConfig.Find( delegate(LinkageConfigMixed x) { return(x.ID == linkageConfigMixed.ID); } ); if (result != null) { result.Code = linkageConfigMixed.Code; result.Controller = linkageConfigMixed.Controller; result.ControllerID = linkageConfigMixed.ControllerID; result.ActionCoefficient = linkageConfigMixed.ActionCoefficient; result.ActionType = linkageConfigMixed.ActionType; //分类A result.TypeA = linkageConfigMixed.TypeA; //回路A //器件编号A [当分类为“地址”时,存储的"回路编号"] result.LoopNoA = linkageConfigMixed.LoopNoA; //器件编号A [当分类为“地址”时,存储的"器件编号"] result.DeviceCodeA = linkageConfigMixed.DeviceCodeA; result.CategoryA = linkageConfigMixed.CategoryA; //楼号A result.BuildingNoA = linkageConfigMixed.BuildingNoA; //区号A result.ZoneNoA = linkageConfigMixed.ZoneNoA; //层号A result.LayerNoA = linkageConfigMixed.LayerNoA; //器件类型A result.DeviceTypeCodeA = linkageConfigMixed.DeviceTypeCodeA; result.TypeB = linkageConfigMixed.TypeB; result.LoopNoB = linkageConfigMixed.LoopNoB; result.DeviceCodeB = linkageConfigMixed.DeviceCodeB; result.CategoryB = linkageConfigMixed.CategoryB; result.BuildingNoB = linkageConfigMixed.BuildingNoB; result.ZoneNoB = linkageConfigMixed.ZoneNoB; result.LayerNoB = linkageConfigMixed.LayerNoB; result.DeviceTypeCodeB = linkageConfigMixed.DeviceTypeCodeB; result.TypeC = linkageConfigMixed.TypeC; result.MachineNoC = linkageConfigMixed.MachineNoC; result.LoopNoC = linkageConfigMixed.LoopNoC; result.DeviceCodeC = linkageConfigMixed.DeviceCodeC; result.BuildingNoC = linkageConfigMixed.BuildingNoC; result.ZoneNoC = linkageConfigMixed.ZoneNoC; result.LayerNoC = linkageConfigMixed.LayerNoC; result.DeviceTypeCodeC = linkageConfigMixed.DeviceTypeCodeC; } else { _controller.MixedConfig.Add(linkageConfigMixed); DataRecordAlreadySet = true; if (linkageConfigMixed.ID > ProjectManager.GetInstance.MaxIDForMixedLinkageConfig) { ProjectManager.GetInstance.MaxIDForMixedLinkageConfig = linkageConfigMixed.ID; } else { ProjectManager.GetInstance.MaxIDForMixedLinkageConfig++; } } } catch { return(false); } return(true); }
public Model.LinkageConfigMixed GetMixedLinkageConfigInfo(Model.LinkageConfigMixed linkageConfigMixed) { throw new System.NotImplementedException(); }
public int UpdateMixedLinkageConfigInfo(Model.LinkageConfigMixed lstLinkageConfigMixed) { throw new System.NotImplementedException(); }