/// <summary> /// 积分明细(区分收入、支出) /// </summary> /// <param name="currentPage"></param> /// <param name="pageSize"></param> /// <param name="accountType"></param> /// <param name="userId"></param> /// <param name="inCome">1-收入,0-支出</param> /// <param name="count"></param> /// <returns></returns> public List <UserAccountRecordInfo> ReadList(int currentPage, int pageSize, AccountRecordType accountType, int userId, int inCome, ref int count) { using (var conn = new SqlConnection(connectString)) { ShopMssqlPagerClass pc = new ShopMssqlPagerClass(); pc.TableName = "UsrAccountRecord"; pc.Fields = "[Id], [RecordType], [Money], [Point], [Date], [IP], [Note], [UserId], [UserName]"; pc.CurrentPage = currentPage; pc.PageSize = pageSize; pc.OrderField = "[Id]"; pc.OrderType = OrderType.Desc; if ((int)accountType > 0) { pc.MssqlCondition.Add("[RecordType]", (int)accountType, ConditionType.Equal); } if (userId > 0) { pc.MssqlCondition.Add("[UserId]", userId, ConditionType.Equal); } if (inCome > 0) {//查询收入 pc.MssqlCondition.Add("[Point]", 0, ConditionType.More); } else {//查询支出 pc.MssqlCondition.Add("[Point]", 0, ConditionType.Less); } count = pc.Count; return(conn.Query <UserAccountRecordInfo>(pc).ToList()); } }
/// <summary> /// 页面加载 /// </summary> protected override void PageLoad() { base.PageLoad(); action = RequestHelper.GetQueryString <string>("Action"); int currentPage = RequestHelper.GetQueryString <int>("Page"); if (currentPage < 1) { currentPage = 1; } int pageSize = 15; int count = 0; accountType = AccountRecordType.Point; if (action == "Money") { accountType = AccountRecordType.Money; } userAccountRecordList = UserAccountRecordBLL.ReadList(currentPage, pageSize, accountType, base.UserId, ref count); if (userAccountRecordList.Count > 0) { if (accountType == AccountRecordType.Money) { moneyLeft = UserAccountRecordBLL.ReadMoneyLeftBeforID(userAccountRecordList[0].Id, base.UserId); } else { pointLeft = UserAccountRecordBLL.ReadPointLeftBeforID(userAccountRecordList[0].Id, base.UserId); } } ajaxPagerClass.CurrentPage = currentPage; ajaxPagerClass.PageSize = pageSize; ajaxPagerClass.Count = count; ajaxPagerClass.FirstPage = "<<首页"; ajaxPagerClass.PreviewPage = "<<上一页"; ajaxPagerClass.NextPage = "下一页>>"; ajaxPagerClass.LastPage = "末页>>"; ajaxPagerClass.ListType = false; ajaxPagerClass.DisCount = false; ajaxPagerClass.PrenextType = true; }
/// <summary> /// 积分明细(区分收入、支出) /// </summary> /// <param name="currentPage"></param> /// <param name="pageSize"></param> /// <param name="accountType"></param> /// <param name="userId"></param> /// <param name="inCome">1-收入,0-支出</param> /// <param name="count"></param> /// <returns></returns> public static List <UserAccountRecordInfo> ReadList(int currentPage, int pageSize, AccountRecordType accountType, int userId, int inCome, ref int count) { return(dal.ReadList(currentPage, pageSize, accountType, userId, inCome, ref count)); }