/// <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));
}
