protected void BindCouponList() { CouponItemInfoQuery query = new CouponItemInfoQuery { CounponName = this.couponName, OrderId = this.couponOrder, CouponStatus = this.couponstatus, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortBy = "GenerateTime", SortOrder = SortAction.Desc }; DbQueryResult couponsList = CouponHelper.GetCouponsList(query); this.pager.TotalRecords = couponsList.TotalRecords; this.grdCoupons.DataSource = couponsList.Data; this.grdCoupons.DataBind(); }
public static DbQueryResult GetCouponsList(CouponItemInfoQuery query) { return new CouponDao().GetCouponsList(query); }
public DbQueryResult GetCouponsList(CouponItemInfoQuery query) { StringBuilder builder = new StringBuilder(); if (query.CouponId.HasValue) { builder.AppendFormat("CouponId = {0}", query.CouponId.Value); } if (!string.IsNullOrEmpty(query.CounponName)) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat("Name = '{0}'", query.CounponName); } if (!string.IsNullOrEmpty(query.UserName)) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat("UserName='******'", DataHelper.CleanSearchString(query.UserName)); } if (!string.IsNullOrEmpty(query.OrderId)) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat("Orderid='{0}'", DataHelper.CleanSearchString(query.OrderId)); } if (query.CouponStatus.HasValue) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat(" CouponStatus={0} ", query.CouponStatus); } return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_CouponInfo", "ClaimCode", builder.ToString(), "*"); }