public bool AddGeneralLinkageConfigInfo(Model.LinkageConfigGeneral linkageConfigGeneral) { int intEffectiveRows = 0; try { //StringBuilder sbSQL = new StringBuilder("REPLACE INTO LinkageConfigGeneral(ID,Code,ActionCoefficient,BuildingNoA,ZoneNoA, LayerNoA1 , LayerNoA2 , DeviceTypeCodeA ,TypeC,MachineNoC ,LoopNoC,DeviceCodeC ,BuildingNoC,ZoneNoC, LayerNoC ,DeviceTypeCodeC ,controllerID)"); //sbSQL.Append(" VALUES("); //sbSQL.Append(linkageConfigGeneral.ID + ",'"); //sbSQL.Append(linkageConfigGeneral.Code + "','"); //sbSQL.Append(linkageConfigGeneral.ActionCoefficient + "','"); //sbSQL.Append(linkageConfigGeneral.BuildingNoA + "','"); //sbSQL.Append(linkageConfigGeneral.ZoneNoA + "','"); //sbSQL.Append(linkageConfigGeneral.LayerNoA1 + "','"); //sbSQL.Append(linkageConfigGeneral.LayerNoA2 + "','"); //sbSQL.Append(linkageConfigGeneral.DeviceTypeCodeA + "','"); //sbSQL.Append((int)linkageConfigGeneral.TypeC + "','"); //sbSQL.Append(linkageConfigGeneral.MachineNoC + "','"); //sbSQL.Append(linkageConfigGeneral.LoopNoC + "','"); //sbSQL.Append(linkageConfigGeneral.DeviceCodeC + "','"); //sbSQL.Append(linkageConfigGeneral.BuildingNoC + "','"); //sbSQL.Append(linkageConfigGeneral.ZoneNoC + "','"); //sbSQL.Append(linkageConfigGeneral.LayerNoC + "','"); //sbSQL.Append(linkageConfigGeneral.DeviceTypeCodeC + "',"); //sbSQL.Append(linkageConfigGeneral.ControllerID + ");"); //intEffectiveRows = _databaseService.ExecuteBySql(sbSQL); intEffectiveRows = _dbFileVersionService.AddGeneralLinkageConfigInfo(linkageConfigGeneral); } catch { intEffectiveRows = 0; } if (intEffectiveRows > 0) { return(true); } else { return(false); } }
public int UpdateGeneralLinkageConfigInfo(Model.LinkageConfigGeneral lstLinkageConfigGeneral) { throw new System.NotImplementedException(); }
public Model.LinkageConfigGeneral GetGeneralLinkageConfigInfo(Model.LinkageConfigGeneral linkageConfigGeneral) { throw new System.NotImplementedException(); }