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