public MssqlCondition PrepareCondition(CouponSearchInfo searchInfo) { MssqlCondition mssqlCondition = new MssqlCondition(); mssqlCondition.Add("[Name]", searchInfo.Name, ConditionType.Like); mssqlCondition.Add("[Id]", string.Join(",", searchInfo.InCouponIds), ConditionType.In); if (searchInfo.Type > 0) { mssqlCondition.Add("[Type]", searchInfo.Type, ConditionType.Equal); } if (searchInfo.CanUse == 1) { mssqlCondition.Add(" DATEDIFF(day,getdate(),[UseStartDate])<=0 and DATEDIFF(day,getdate(),[UseEndDate])>=0"); } //未开始 if (searchInfo.TimePeriod == 1) { mssqlCondition.Add(" DATEDIFF ( day , getdate(), [UseStartDate] )>0"); } //进行中 if (searchInfo.TimePeriod == 2) { mssqlCondition.Add(" DATEDIFF(day,getdate(),[UseStartDate])<=0 and DATEDIFF(day,getdate(),[UseEndDate])>=0"); } //已结束 if (searchInfo.TimePeriod == 3) { mssqlCondition.Add(" DATEDIFF(day,getdate(),[UseEndDate])<0"); } return(mssqlCondition); }
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 == "NotUse") && !(action == "HasUse")) { if ((action != "AddCoupon") && (action == "AddUserCoupon")) { this.AddUserCoupon(); } } else { UserCouponSearchInfo userCoupon = new UserCouponSearchInfo(); userCoupon.UserID = base.UserID; if (this.action == "NotUse") { userCoupon.IsUse = 0; } else { userCoupon.IsUse = 1; } this.userCouponList = UserCouponBLL.SearchUserCouponList(queryString, pageSize, userCoupon, ref count); this.ajaxPagerClass.CurrentPage = queryString; this.ajaxPagerClass.PageSize = pageSize; this.ajaxPagerClass.Count = count; string str = string.Empty; foreach (UserCouponInfo info2 in this.userCouponList) { if (str == string.Empty) { str = info2.CouponID.ToString(); } else { str = str + "," + info2.CouponID.ToString(); } } if (str != string.Empty) { CouponSearchInfo coupon = new CouponSearchInfo(); coupon.InCouponID = str; this.couponList = CouponBLL.SearchCouponList(coupon); } } } }
public List <CouponInfo> SearchCouponList(CouponSearchInfo couponSearch) { MssqlCondition mssqlCondition = new MssqlCondition(); this.PrepareCondition(mssqlCondition, couponSearch); List <CouponInfo> couponList = new List <CouponInfo>(); SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar) }; pt[0].Value = mssqlCondition.ToString(); using (SqlDataReader reader = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchCouponList", pt)) { this.PrepareCouponModel(reader, couponList); } return(couponList); }
public List <CouponInfo> SearchList(int currentPage, int pageSize, CouponSearchInfo searchInfo, ref int count) { using (var conn = new SqlConnection(connectString)) { ShopMssqlPagerClass pc = new ShopMssqlPagerClass(); pc.TableName = "Coupon"; pc.Fields = " * "; pc.CurrentPage = currentPage; pc.PageSize = pageSize; pc.OrderField = "[Id]"; pc.MssqlCondition = PrepareCondition(searchInfo); count = pc.Count; return(conn.Query <CouponInfo>(pc).ToList()); } }
public List <CouponInfo> SearchCouponList(int currentPage, int pageSize, CouponSearchInfo couponSearch, ref int count) { List <CouponInfo> couponList = new List <CouponInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "Coupon"; class2.Fields = "[ID],[Name],[Money],[UseMinAmount],[UseStartDate],[UseEndDate]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, couponSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareCouponModel(reader, couponList); } return(couponList); }
protected override void PageLoad() { base.PageLoad(); CheckAdminPower("ReadCoupon", PowerCheckType.Single); couponKind = RequestHelper.GetQueryString <int>("couponkind"); //开始状态:未开始、进行中、已结束。默认: 进行中 timePeriod = RequestHelper.GetQueryString <int>("timeperiod") > 0? RequestHelper.GetQueryString <int>("timeperiod"):2; CouponSearchInfo searchInfo = new CouponSearchInfo(); if (couponKind > 0) { searchInfo.Type = couponKind; } if (timePeriod > 0) { searchInfo.TimePeriod = timePeriod; } couponList = CouponBLL.SearchList(1, pageSize, searchInfo, ref Count); }
public List <CouponInfo> SearchList(CouponSearchInfo searchInfo) { using (var conn = new SqlConnection(connectString)) { string sql = "select * from Coupon where 1=1 "; var para = new DynamicParameters(); if (searchInfo.InCouponIds.Length > 0) { sql += " and Id in @ids"; para.Add("ids", searchInfo.InCouponIds); } if (!string.IsNullOrEmpty(searchInfo.Name)) { sql += " and Name like @name"; para.Add("name", "%" + searchInfo.Name + "%"); } return(conn.Query <CouponInfo>(sql, para).ToList()); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { CheckAdminPower("ReadCoupon", PowerCheckType.Single); couponKind = RequestHelper.GetQueryString <int>("couponkind"); //开始状态:未开始、进行中、已结束 timeperiod = RequestHelper.GetQueryString <int>("timeperiod") < 1?2: RequestHelper.GetQueryString <int>("timeperiod"); CouponSearchInfo searchInfo = new CouponSearchInfo(); if (couponKind > 0) { searchInfo.Type = couponKind; } if (timeperiod > 0) { searchInfo.TimePeriod = timeperiod; } List <CouponInfo> couponList = CouponBLL.SearchList(CurrentPage, PageSize, searchInfo, ref Count); BindControl(couponList, RecordList, MyPager); } }
protected override void PageLoad() { base.PageLoad(); type = RequestHelper.GetQueryString <string>("type"); int currentPage = RequestHelper.GetQueryString <int>("Page"); if (currentPage < 1) { currentPage = 1; } int pageSize = 10; int count = 0; UserCouponSearchInfo userCouponSearch = new UserCouponSearchInfo(); userCouponSearch.UserId = base.UserId; if (!string.IsNullOrEmpty(type)) { if (type == "1")//未使用 { userCouponSearch.IsUse = (int)BoolType.False; userCouponSearch.IsTimeOut = (int)BoolType.False; } else if (type == "2")//已使用 { userCouponSearch.IsUse = (int)BoolType.True; userCouponSearch.IsTimeOut = -1;//不限期限有没过期 } else//已过期 { userCouponSearch.IsUse = (int)BoolType.False; userCouponSearch.IsTimeOut = (int)BoolType.True; } } else //所有 { userCouponSearch.IsTimeOut = -1; } userCouponList = UserCouponBLL.SearchList(currentPage, pageSize, userCouponSearch, ref count); commonPagerClass.Init(currentPage, pageSize, count, !string.IsNullOrEmpty(isMobile)); string idList = string.Empty; foreach (UserCouponInfo userCoupon in userCouponList) { if (idList == string.Empty) { idList = userCoupon.CouponId.ToString(); } else { idList += "," + userCoupon.CouponId.ToString(); } } if (idList != string.Empty) { CouponSearchInfo couponSearch = new CouponSearchInfo(); couponSearch.InCouponIds = Array.ConvertAll <string, int>(idList.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), i => Convert.ToInt32(i)); couponList = CouponBLL.SearchList(couponSearch); } }
public void PrepareCondition(MssqlCondition mssqlCondition, CouponSearchInfo couponSearch) { mssqlCondition.Add("[Name]", couponSearch.Name, ConditionType.Like); mssqlCondition.Add("[ID]", couponSearch.InCouponID, ConditionType.In); }
public static List <CouponInfo> SearchList(int currentPage, int pageSize, CouponSearchInfo searchInfo, ref int count) { return(dal.SearchList(currentPage, pageSize, searchInfo, ref count)); }
public static List <CouponInfo> SearchList(CouponSearchInfo searchInfo) { return(dal.SearchList(searchInfo)); }
/// <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 "NotUse": case "HasUse": case "TimeOut": UserCouponSearchInfo userCouponSearch = new UserCouponSearchInfo(); userCouponSearch.UserId = base.UserId; if (action == "NotUse") { userCouponSearch.IsUse = (int)BoolType.False; userCouponSearch.IsTimeOut = (int)BoolType.False; } else if (action == "HasUse") { userCouponSearch.IsUse = (int)BoolType.True; userCouponSearch.IsTimeOut = -1; //不限期限有没过期 } else { userCouponSearch.IsUse = (int)BoolType.False; userCouponSearch.IsTimeOut = (int)BoolType.True; } userCouponList = UserCouponBLL.SearchList(currentPage, pageSize, userCouponSearch, 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; string idList = string.Empty; foreach (UserCouponInfo userCoupon in userCouponList) { if (idList == string.Empty) { idList = userCoupon.CouponId.ToString(); } else { idList += "," + userCoupon.CouponId.ToString(); } } if (idList != string.Empty) { CouponSearchInfo couponSearch = new CouponSearchInfo(); couponSearch.InCouponIds = Array.ConvertAll <string, int>(idList.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), i => Convert.ToInt32(i)); couponList = CouponBLL.SearchList(couponSearch); } break; case "AddCoupon": break; case "AddUserCoupon": AddUserCoupon(); break; default: break; } }
public static List <CouponInfo> SearchCouponList(CouponSearchInfo coupon) { return(dal.SearchCouponList(coupon)); }