Пример #1
0
        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);
            }
        }