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); } }