public PageModel <ProductPreSaleInfo> GetPreSaleList(ProductPreSaleQuery preSaleQuery) { StringBuilder stringBuilder = new StringBuilder(); if (!string.IsNullOrEmpty(preSaleQuery.ProductName)) { stringBuilder.AppendFormat(" ProductName like '%{0}%'", DataHelper.CleanSearchString(preSaleQuery.ProductName)); } if (preSaleQuery.PreSaleStatus > 0) { if (stringBuilder.Length > 0) { stringBuilder.Append(" AND "); } if (preSaleQuery.PreSaleStatus.Value == 1) { stringBuilder.Append(" PreSaleEndDate >= getdate()"); } else if (preSaleQuery.PreSaleStatus.Value == 2) { stringBuilder.Append(" PreSaleEndDate <= getdate()"); } } return(DataHelper.PagingByRownumber <ProductPreSaleInfo>(preSaleQuery.PageIndex, preSaleQuery.PageSize, preSaleQuery.SortBy, preSaleQuery.SortOrder, preSaleQuery.IsCount, "(select A.*,B.ProductName from Hishop_ProductPreSale as A left join Hishop_Products as B ON A.ProductId=B.ProductId) as Hishop_ProductPreSale", "PreSaleId", stringBuilder.ToString(), "*")); }
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; } ProductPreSaleQuery productPreSaleQuery = new ProductPreSaleQuery(); productPreSaleQuery.ProductName = context.Request["ProductName"]; productPreSaleQuery.PreSaleStatus = base.GetIntParam(context, "PreSaleStatus", true); productPreSaleQuery.PageIndex = num; productPreSaleQuery.PageSize = num2; productPreSaleQuery.SortBy = "PreSaleId"; productPreSaleQuery.SortOrder = SortAction.Desc; DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(productPreSaleQuery); string s = base.SerializeObjectToJson(dataList); context.Response.Write(s); context.Response.End(); }
private DataGridViewModel <Dictionary <string, object> > GetDataList(ProductPreSaleQuery query) { DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >(); if (query != null) { PageModel <ProductPreSaleInfo> preSaleList = ProductPreSaleHelper.GetPreSaleList(query); dataGridViewModel.rows = new List <Dictionary <string, object> >(); dataGridViewModel.total = preSaleList.Total; foreach (ProductPreSaleInfo model in preSaleList.Models) { Dictionary <string, object> dictionary = model.ToDictionary(); dictionary.Add("IsPreSaleEnd", !this.IsPreSaleEnd(model.PreSaleEndDate)); dictionary.Add("IsPreSaleHasOrder", ProductPreSaleHelper.IsPreSaleHasOrder(model.PreSaleId)); dataGridViewModel.rows.Add(dictionary); } } return(dataGridViewModel); }
public static PageModel <ProductPreSaleInfo> GetPreSaleList(ProductPreSaleQuery preSaleQuery) { return(new PreSaleDao().GetPreSaleList(preSaleQuery)); }