public void GetList(HttpContext context)
{
int num = 1;
int num2 = 10;
num = base.GetIntParam(context, "page", false).Value;
if (num < 1)
{
num = 1;
}
num2 = base.GetIntParam(context, "rows", false).Value;
if (num2 < 1)
{
num2 = 10;
}
CouponItemInfoQuery couponItemInfoQuery = new CouponItemInfoQuery();
couponItemInfoQuery.CouponId = base.GetIntParam(context, "CouponId", false).Value;
couponItemInfoQuery.OrderId = base.GetParameter(context, "OrderId", false);
couponItemInfoQuery.CouponStatus = base.GetIntParam(context, "CouponStatus", true);
couponItemInfoQuery.PageIndex = num;
couponItemInfoQuery.PageSize = num2;
DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(couponItemInfoQuery);
string s = base.SerializeObjectToJson(dataList);
context.Response.Write(s);
context.Response.End();
}
private DataGridViewModel <Dictionary <string, object> > GetDataList(CouponItemInfoQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
DbQueryResult couponsUseList = CouponHelper.GetCouponsUseList(query);
dataGridViewModel.rows = DataHelper.DataTableToDictionary(couponsUseList.Data);
dataGridViewModel.total = couponsUseList.TotalRecords;
}
return(dataGridViewModel);
}
public DbQueryResult GetCouponsList(CouponItemInfoQuery query, bool isCoupon = true)
{
StringBuilder stringBuilder = new StringBuilder();
if (isCoupon)
{
stringBuilder.AppendFormat(" CouponId > 0 ");
}
else
{
stringBuilder.AppendFormat(" RedEnvelopeId > 0 ");
}
if (query.CouponId.HasValue)
{
stringBuilder.AppendFormat(" AND CouponId = {0} ", query.CouponId.Value);
}
if (query.UserId.HasValue)
{
stringBuilder.AppendFormat(" AND UserId='{0}' ", query.UserId);
}
if (!string.IsNullOrEmpty(query.CounponName))
{
stringBuilder.AppendFormat(" AND CouponName LIKE '%{0}%' ", DataHelper.CleanSearchString(query.CounponName));
}
if (!string.IsNullOrEmpty(query.OrderId))
{
stringBuilder.AppendFormat(" AND OrderId='{0}' ", DataHelper.CleanSearchString(query.OrderId));
}
if (query.CouponStatus.HasValue)
{
if (query.CouponStatus == 1)
{
stringBuilder.Append(" AND UsedTime IS NULL AND ClosingTime >= GETDATE() ");
}
else if (query.CouponStatus == 2)
{
stringBuilder.Append(" AND UsedTime IS NOT NULL ");
}
else if (query.CouponStatus == 3)
{
stringBuilder.Append(" AND UsedTime IS NULL AND ClosingTime < GETDATE() ");
}
}
if (string.IsNullOrEmpty(query.SortBy))
{
query.SortBy = "ClosingTime";
query.SortOrder = SortAction.Asc;
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_CouponItems", "ClaimCode", stringBuilder.ToString(), "*"));
}
private void BindCoupons()
{
CouponItemInfoQuery couponItemInfoQuery = new CouponItemInfoQuery();
couponItemInfoQuery.PageIndex = this.pager.PageIndex;
couponItemInfoQuery.PageSize = this.pager.PageSize;
couponItemInfoQuery.UserId = HiContext.Current.UserId;
couponItemInfoQuery.CouponStatus = this.typeId + 1;
DbQueryResult weiXinRedEnvelopeList = CouponHelper.GetWeiXinRedEnvelopeList(couponItemInfoQuery);
this.rptMyCoupons.DataSource = weiXinRedEnvelopeList.Data;
this.rptMyCoupons.DataBind();
this.pager.TotalRecords = weiXinRedEnvelopeList.TotalRecords;
}
private void BindCoupons()
{
CouponItemInfoQuery couponItemInfoQuery = new CouponItemInfoQuery();
couponItemInfoQuery.PageIndex = this.pager.PageIndex;
couponItemInfoQuery.PageSize = this.pager.PageSize;
couponItemInfoQuery.UserId = HiContext.Current.UserId;
couponItemInfoQuery.CouponStatus = this.typeId + 1;
couponItemInfoQuery.SortBy = "GetDate";
couponItemInfoQuery.SortOrder = SortAction.Desc;
DbQueryResult couponsUseList = CouponHelper.GetCouponsUseList(couponItemInfoQuery);
this.rptMyCoupons.DataSource = couponsUseList.Data;
this.rptMyCoupons.DataBind();
this.pager.TotalRecords = couponsUseList.TotalRecords;
}
protected void BindCouponList()
{
CouponItemInfoQuery couponquery = new CouponItemInfoQuery();
couponquery.CounponName = this.couponName;
couponquery.OrderId = this.couponOrder;
couponquery.CouponStatus = this.couponstatus;
couponquery.PageIndex = this.pager.PageIndex;
couponquery.PageSize = this.pager.PageSize;
couponquery.SortBy = "GenerateTime";
couponquery.SortOrder = SortAction.Desc;
DbQueryResult couponsList = PromoteHelper.GetCouponsList(couponquery);
this.pager.TotalRecords = couponsList.TotalRecords;
this.grdCoupons.DataSource = couponsList.Data;
this.grdCoupons.DataBind();
}
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 DbQueryResult GetCouponsList(CouponItemInfoQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
if (query.CouponId.HasValue)
{
stringBuilder.AppendFormat("CouponId = {0}", query.CouponId.Value);
}
if (!string.IsNullOrEmpty(query.CounponName))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat("Name = '{0}'", query.CounponName);
}
if (!string.IsNullOrEmpty(query.UserName))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat("UserName='******'", DataHelper.CleanSearchString(query.UserName));
}
if (!string.IsNullOrEmpty(query.OrderId))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat("Orderid='{0}'", DataHelper.CleanSearchString(query.OrderId));
}
if (query.CouponStatus.HasValue)
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" CouponStatus={0} ", query.CouponStatus);
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_CouponInfo", "ClaimCode", stringBuilder.ToString(), "*"));
}
public static DbQueryResult GetCouponsList(CouponItemInfoQuery query)
{
return((new CouponDao()).GetCouponsList(query));
}
public static DbQueryResult GetCouponsList(CouponItemInfoQuery couponquery)
{
return(PromotionsProvider.Instance().GetCouponsList(couponquery));
}
public abstract DbQueryResult GetCouponsList(CouponItemInfoQuery componquery);
public static DbQueryResult GetWeiXinRedEnvelopeList(CouponItemInfoQuery couponquery)
{
return(new CouponDao().GetCouponsList(couponquery, false));
}
public static DbQueryResult GetCouponsUseList(CouponItemInfoQuery couponquery)
{
return(new CouponDao().GetCouponsList(couponquery, true));
}
public static DbQueryResult GetCouponsListToExport(CouponItemInfoQuery couponquery)
{
return(new CouponDao().GetCouponsListToExport(couponquery));
}
