public List <UserRechargeInfo> SearchList(int currentPage, int pageSize, UserRechargeSearchInfo searchInfo, ref int count) { using (var conn = new SqlConnection(connectString)) { ShopMssqlPagerClass pc = new ShopMssqlPagerClass(); pc.TableName = "UsrRecharge"; pc.Fields = "[Id], [Number], [Money], [PayKey], [PayName], [RechargeDate], [RechargeIP], [IsFinish], [UserId] "; pc.CurrentPage = currentPage; pc.PageSize = pageSize; pc.OrderField = "[Id]"; pc.OrderType = OrderType.Desc; pc.MssqlCondition = PrepareCondition(searchInfo); count = pc.Count; return(conn.Query <UserRechargeInfo>(pc).ToList()); } }
protected void Page_Load(object sender, EventArgs e) { if (!this.Page.IsPostBack) { base.CheckAdminPower("ReadUserRecharge", PowerCheckType.Single); UserRechargeSearchInfo userRecharge = new UserRechargeSearchInfo(); userRecharge.Number = RequestHelper.GetQueryString <string>("Number"); userRecharge.StartRechargeDate = RequestHelper.GetQueryString <DateTime>("StartRechargeDate"); userRecharge.EndRechargeDate = ShopCommon.SearchEndDate(RequestHelper.GetQueryString <DateTime>("EndRechargeDate")); userRecharge.IsFinish = RequestHelper.GetQueryString <int>("IsFinish"); userRecharge.UserName = RequestHelper.GetQueryString <string>("UserName"); this.Number.Text = userRecharge.Number; this.StartRechargeDate.Text = RequestHelper.GetQueryString <string>("StartRechargeDate"); this.EndRechargeDate.Text = RequestHelper.GetQueryString <string>("EndRechargeDate"); this.IsFinish.Text = RequestHelper.GetQueryString <string>("IsFinish"); this.UserName.Text = RequestHelper.GetQueryString <string>("UserName"); base.BindControl(UserRechargeBLL.SearchUserRechargeList(base.CurrentPage, base.PageSize, userRecharge, ref this.Count), this.RecordList, this.MyPager); } }
protected override void PageLoad() { base.PageLoad(); this.action = RequestHelper.GetQueryString <string>("Action"); string action = this.action; if (action != null) { if (!(action == "Read")) { if (action == "Add") { this.payPluginsList = PayPlugins.ReadRechargePayPluginsList(); this.moneyLeft = UserBLL.ReadUserMore(base.UserID).MoneyLeft; } else if (action == "AddUserRecharge") { this.AddUserRecharge(); } } else { int queryString = RequestHelper.GetQueryString <int>("Page"); if (queryString < 1) { queryString = 1; } int pageSize = 20; int count = 0; UserRechargeSearchInfo userRecharge = new UserRechargeSearchInfo(); userRecharge.UserID = base.UserID; this.userRechargeList = UserRechargeBLL.SearchUserRechargeList(queryString, pageSize, userRecharge, ref count); this.ajaxPagerClass.CurrentPage = queryString; this.ajaxPagerClass.PageSize = pageSize; this.ajaxPagerClass.Count = count; } } }
public List <UserRechargeInfo> SearchUserRechargeList(int currentPage, int pageSize, UserRechargeSearchInfo userRechargeSearch, ref int count) { List <UserRechargeInfo> userRechargeList = new List <UserRechargeInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "UserRecharge"; class2.Fields = "[ID],[Number],[Money],[PayKey],[PayName],[RechargeDate],[RechargeIP],[IsFinish],[UserID],[UserName]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, userRechargeSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareUserRechargeModel(reader, userRechargeList); } return(userRechargeList); }