public bool AddStandardLinkageConfigInfo(Model.LinkageConfigStandard linkageConfigStandard) { int intEffectiveRows = 0; try { //StringBuilder sbSQL = new StringBuilder("REPLACE INTO LinkageConfigStandard(ID,Code,DeviceNo1,DeviceNo2 , DeviceNo3 , DeviceNo4, DeviceNo5,DeviceNo6,DeviceNo7,DeviceNo8,DeviceNo9,DeviceNo10, ActionCoefficient , LinkageNo1 ,LinkageNo2 ,LinkageNo3,controllerID) "); //sbSQL.Append("VALUES("); //sbSQL.Append(linkageConfigStandard.ID + ",'"); //sbSQL.Append(linkageConfigStandard.Code+"','"); //sbSQL.Append(linkageConfigStandard.DeviceNo1 + "','"); //sbSQL.Append(linkageConfigStandard.DeviceNo2 + "','"); //sbSQL.Append(linkageConfigStandard.DeviceNo3 + "','"); //sbSQL.Append(linkageConfigStandard.DeviceNo4 + "','"); //sbSQL.Append(linkageConfigStandard.DeviceNo5 + "','"); //sbSQL.Append(linkageConfigStandard.DeviceNo6 + "','"); //sbSQL.Append(linkageConfigStandard.DeviceNo7 + "','"); //sbSQL.Append(linkageConfigStandard.DeviceNo8 + "','"); //sbSQL.Append(linkageConfigStandard.DeviceNo9 + "','"); //sbSQL.Append(linkageConfigStandard.DeviceNo10 + "','"); //sbSQL.Append(linkageConfigStandard.ActionCoefficient + "','"); //sbSQL.Append(linkageConfigStandard.LinkageNo1 + "','"); //sbSQL.Append(linkageConfigStandard.LinkageNo2 + "','"); //sbSQL.Append(linkageConfigStandard.LinkageNo3 + "',"); //sbSQL.Append(linkageConfigStandard.ControllerID + ");"); //intEffectiveRows = _databaseService.ExecuteBySql(sbSQL); intEffectiveRows = _dbFileVersionService.AddStandardLinkageConfigInfo(linkageConfigStandard); } catch { intEffectiveRows = 0; } if (intEffectiveRows > 0) { return(true); } else { return(false); } }