MESProductionWeb/MES.Production.Service/ServiceImp/ComManage/ContentManage.cs

using Central.Control.Domain;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;

namespace MES.Production.Service.ServiceImp
{
    /// <summary>
    /// 大数据字段Service实现类
    /// add 作者： 季健国 QQ:181589805 by 2016-10-14
    /// </summary>
    public class ContentManage : RepositoryBase<COM_CONTENT>, IService.IContentManage
    {
        /// <summary>
        /// 更新Isdel属性
        /// </summary>
        public bool UpdateSql(string Id, string tablename)
        {
            try
            {
                string sql = "update COM_CONTENT set isdel=1 where FK_RELATIONID=@FK_RELATIONID and FK_TABLE=@FK_TABLE";
                SqlParameter[] para = {
                                   new SqlParameter("@FK_RELATIONID",Id),
                                   new SqlParameter("@FK_TABLE",tablename)
                                   };
                return this.ExecuteSqlCommand(sql, para).ToString() != "0";
            }
            catch (Exception e) 
            {
                throw e;
            }
        }
    }
}