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

namespace LYFZ.WeixinServiceDate.DAL
{
   public class DAL_CustomerInterfaces :BaseDataOperate
    {
       public DAL_CustomerInterfaces()
         {
             this.TableFieldNameString = "";
         }
   		     
	
		#region 属性和字段

       string _tableName = "tb_CustomerInterfaces";
        /// <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_CustomerInterfaces CurrentModel
        {
            get { return new Model.Model_CustomerInterfaces(); }
        }

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

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

        #region 更新数据
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Model.Model_CustomerInterfaces 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_CustomerInterfaces model, string filterFieldName = "ID", string operators = "=", string overlookFieldList = "ID")
            {
                return base.Update(model, filterFieldName, operators, overlookFieldList);
            }
        #endregion

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

         /// <summary>
         /// 得到一个对象实体
         /// </summary>
         /// <param name="row"></param>
         /// <returns></returns>
        public Model.Model_CustomerInterfaces DataRowToModel(DataRow row)
        {
            return DataRowToModelObject(row) as Model.Model_CustomerInterfaces;
        }
       #endregion
       /// <summary>
       /// 更新调用次数
       /// </summary>
       /// <param name="JMGDomainName"></param>
       /// <param name="_CallFrequency"></param>
       /// <returns></returns>
        public bool UpdateCustCallFrequency(string JMGDomainName,long _CallFrequency)
        {
            bool ret = false;
            string sql = "update [dbo].[tb_CustomerInterfaces] set [CallFrequency]=" + _CallFrequency.ToString() + " where [JMGDomainName]='" + JMGDomainName + "'";
            if (LYFZ.Helper.SQLHelper.ExecuteSql(sql)>0) {
                ret = true;
            }
            return ret;
        }

        public DataTable GetOfficialAccountList(string eid)
        {
            if (!String.IsNullOrEmpty(eid))
            {

                string sql = String.Format("  SELECT [dbo].[tb_CustomerInterfaces].[id] ,[Token],[AppID] ,[AppSecret],[OfficialAccount],[OfficialAccountName] ,[authorizer_appid],[AuthorizeStatus] FROM [dbo].[tb_CustomerInterfaces] left join [dbo].[tb_authorization_info] on [AppID]=[authorizer_appid] where [Token]='{0}'", eid);
                return LYFZ.Helper.SQLHelper.Query(sql).Tables[0];

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