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(), "*");
}
