123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172 |
- 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
- }
- }
|