using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;

namespace LYFZ.WeixinServiceDate.DAL
{
    public class DAL_KeywordManagement : BaseDataOperate
    {
       public DAL_KeywordManagement()
        {
            this.TableFieldNameString = "";
        }


       #region 属性和字段

       string _tableName = "tb_KeywordManagement";
       /// <summary>
       /// 获取数据表名
       /// </summary>
       public override string TableName
       {
           get { return _tableName; }
           set { this._tableName = value; }
       }

       /// <summary>
       /// 获取当前新的数据表模型对象
       /// </summary>
       public override object ObjModel
       {
           get
           {
               return this.CurrentModel;
           }
       }
       /// <summary>
       /// 获取当前新的MOdel
       /// </summary>
       public Model.Model_KeywordManagement CurrentModel
       {
           get { return new Model.Model_KeywordManagement(); }
       }


       string _tableFieldNameString = "";
       /// <summary>
       /// 数据表字段名数组
       /// </summary>
       public override string TableFieldNameString
       {
           get { return this._tableFieldNameString; }

           set { this._tableFieldNameString = value; }
       }

       #endregion

       #region 检查记录
       //基类已经实现
       #endregion

       #region 增加数据
       /// <summary>
       /// 增加一条数据
       /// </summary>
       /// <param name="model">Model对象</param>
       /// <returns></returns>
       public bool Add(Model.Model_KeywordManagement model)
       {
           return base.Add(model);
       }
       /// <summary>
       /// 增加一条数据
       /// </summary>
       /// <param name="model">Model对象</param>
       /// <param name="overlookFieldList">忽略字段名列表 字段名之间用“,”号分隔</param>
       /// <returns></returns>
       public bool Add(Model.Model_KeywordManagement model, string overlookFieldList = "ID")
       {
           return base.Add(model, overlookFieldList);
       }
       #endregion

       #region 删除数据
       /// <summary>
       /// 删除数据
       /// </summary>
       /// <param name="model"></param>
       /// <returns></returns>
       public bool Delete(Model.Model_KeywordManagement model)
       {
           return base.Delete(model.ID);
       }
       #endregion

       #region 更新数据
       /// <summary>
       /// 根据模块代码 设置启用/禁用状态
       /// </summary>
       public bool SetFunctionCodeEnabled(string FunctionCode,int isEnabled)
       {
           if (LYFZ.Helper.SQLHelper.ExecuteSql("UPDATE tb_KeywordManagement set [isEnabled]=" + isEnabled.ToString() + " where FunctionCode='" + FunctionCode + "'") > 0)
           {
               return true;
           }
           else {
               return false;
           }
       }
       /// <summary>
       /// 根据关键字 设置启用/禁用状态
       /// </summary>
       public bool SetKeywordCodeEnabled(string Keyword, int isEnabled)
       {
           if (LYFZ.Helper.SQLHelper.ExecuteSql("UPDATE tb_KeywordManagement set [isEnabled]=" + isEnabled.ToString() + " where Keyword='" + Keyword + "'") > 0)
           {
               return true;
           }
           else
           {
               return false;
           }
       }
       /// <summary>
       /// 更新一条数据
       /// </summary>
       public bool Update(Model.Model_KeywordManagement model)
       {
           return base.Update(model);
       }

       /// <summary>
       /// 根据筛选字段和SQL筛选运算符号更新数据
       /// </summary>
       /// <param name="model">Model对象</param>
       /// <param name="filterFieldName">筛选字段名称</param>
       /// <param name="operators">SQL筛选运算符号</param>
       /// <param name="overlookFieldList">忽略字段名列表 字段名之间用“,”号分隔</param>
       /// <returns></returns>
       public bool Update(Model.Model_KeywordManagement model, string filterFieldName = "ID", string operators = "=", string overlookFieldList = "ID")
       {
           return base.Update(model, filterFieldName, operators, overlookFieldList);
       }
       #endregion

       #region 查询数据
       /// <summary>
       /// 得到一个对象实体
       /// </summary>
       public Model.Model_KeywordManagement GetModel(int ID)
       {
           return DataRowToModel(GetDataRow(ID));
       }


       /// <summary>
       /// 得到一个对象实体
       /// </summary>
       /// <param name="row"></param>
       /// <returns></returns>
       public Model.Model_KeywordManagement DataRowToModel(DataRow row)
       {
           return DataRowToModelObject(row) as Model.Model_KeywordManagement;
       }
       #endregion

        #region 数据分页
        //基类已实现相关方法
        #endregion
    }
}