public void PrepareCondition(MssqlCondition mssqlCondition, UserApplySearchInfo userApplySearch)
{
mssqlCondition.Add("[Number]", userApplySearch.Number, ConditionType.Like);
mssqlCondition.Add("[Status]", userApplySearch.Status, ConditionType.Equal);
mssqlCondition.Add("[ApplyDate]", userApplySearch.StartApplyDate, ConditionType.MoreOrEqual);
mssqlCondition.Add("[ApplyDate]", userApplySearch.EndApplyDate, ConditionType.LessOrEqual);
mssqlCondition.Add("[UserID]", userApplySearch.UserID, ConditionType.Equal);
mssqlCondition.Add("[UserName]", userApplySearch.UserName, ConditionType.Like);
}
public List<UserApplyInfo> SearchUserApplyList(UserApplySearchInfo userApplySearch)
{
MssqlCondition mssqlCondition = new MssqlCondition();
this.PrepareCondition(mssqlCondition, userApplySearch);
List<UserApplyInfo> userApplyList = new List<UserApplyInfo>();
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar) };
pt[0].Value = mssqlCondition.ToString();
using (SqlDataReader reader = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchUserApplyList", pt))
{
this.PrepareUserApplyModel(reader, userApplyList);
}
return userApplyList;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
base.CheckAdminPower("ReadUserApply", PowerCheckType.Single);
UserApplySearchInfo userApply = new UserApplySearchInfo();
userApply.Status = RequestHelper.GetQueryString <int>("Status");
userApply.Number = RequestHelper.GetQueryString <string>("Number");
userApply.StartApplyDate = RequestHelper.GetQueryString <DateTime>("StartApplyDate");
userApply.EndApplyDate = ShopCommon.SearchEndDate(RequestHelper.GetQueryString <DateTime>("EndApplyDate"));
userApply.UserName = RequestHelper.GetQueryString <string>("UserName");
this.Status.Text = userApply.Status.ToString();
this.Number.Text = userApply.Number;
this.StartApplyDate.Text = RequestHelper.GetQueryString <string>("StartApplyDate");
this.EndApplyDate.Text = RequestHelper.GetQueryString <string>("EndApplyDate");
this.UserName.Text = RequestHelper.GetQueryString <string>("UserName");
base.BindControl(UserApplyBLL.SearchUserApplyList(base.CurrentPage, base.PageSize, userApply, ref this.Count), this.RecordList, this.MyPager);
}
}
/// <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 = 20;
int count = 0;
switch (action)
{
case "Read":
UserApplySearchInfo userApplySearch = new UserApplySearchInfo();
userApplySearch.UserID = base.UserID;
userApplyList = UserApplyBLL.SearchUserApplyList(currentPage, pageSize, userApplySearch, ref count); 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;
break;
case "Add":
moneyLeft = UserBLL.ReadUserMore(base.UserID).MoneyLeft;
break;
case "AddUserApply":
AddUserApply();
break;
default:
break;
}
}
protected override void PageLoad()
{
base.PageLoad();
this.action = RequestHelper.GetQueryString <string>("Action");
int queryString = RequestHelper.GetQueryString <int>("Page");
if (queryString < 1)
{
queryString = 1;
}
int pageSize = 20;
int count = 0;
string action = this.action;
if (action != null)
{
if (!(action == "Read"))
{
if (action == "Add")
{
this.moneyLeft = UserBLL.ReadUserMore(base.UserID).MoneyLeft;
}
else if (action == "AddUserApply")
{
this.AddUserApply();
}
}
else
{
UserApplySearchInfo userApply = new UserApplySearchInfo();
userApply.UserID = base.UserID;
this.userApplyList = UserApplyBLL.SearchUserApplyList(queryString, pageSize, userApply, ref count);
this.ajaxPagerClass.CurrentPage = queryString;
this.ajaxPagerClass.PageSize = pageSize;
this.ajaxPagerClass.Count = count;
}
}
}
public List<UserApplyInfo> SearchUserApplyList(int currentPage, int pageSize, UserApplySearchInfo userApplySearch, ref int count)
{
List<UserApplyInfo> userApplyList = new List<UserApplyInfo>();
ShopMssqlPagerClass class2 = new ShopMssqlPagerClass();
class2.TableName = ShopMssqlHelper.TablePrefix + "UserApply";
class2.Fields = "[ID],[Number],[Money],[UserNote],[Status],[ApplyDate],[ApplyIP],[AdminNote],[UpdateDate],[UpdateAdminID],[UpdateAdminName],[UserID],[UserName]";
class2.CurrentPage = currentPage;
class2.PageSize = pageSize;
class2.OrderField = "[ID]";
class2.OrderType = OrderType.Desc;
this.PrepareCondition(class2.MssqlCondition, userApplySearch);
class2.Count = count;
count = class2.Count;
using (SqlDataReader reader = class2.ExecuteReader())
{
this.PrepareUserApplyModel(reader, userApplyList);
}
return userApplyList;
}
public static List <UserApplyInfo> SearchUserApplyList(int currentPage, int pageSize, UserApplySearchInfo userApply, ref int count)
{
return(dal.SearchUserApplyList(currentPage, pageSize, userApply, ref count));
}
public static List <UserApplyInfo> SearchUserApplyList(UserApplySearchInfo userApply)
{
return(dal.SearchUserApplyList(userApply));
}
