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