public DbQueryResult GetCombinationBuy(CombinationBuyInfoQuery query) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" 1=1 "); if (!string.IsNullOrEmpty(query.ProductName)) { stringBuilder.AppendFormat(" AND CombinationId in (select CombinationId from Hishop_CombinationBuySKU as A left join Hishop_Products as B on A.ProductId=B.ProductId where B.ProductName like '%{0}%')", DataHelper.CleanSearchString(query.ProductName)); } DateTime dateTime; if (query.Status == 0) { StringBuilder stringBuilder2 = stringBuilder; dateTime = DateTime.Now; dateTime = dateTime.Date; stringBuilder2.AppendFormat(" AND StartDate > '{0}'", dateTime.ToString()); } else if (query.Status == 1) { StringBuilder stringBuilder3 = stringBuilder; dateTime = DateTime.Now; dateTime = dateTime.Date; stringBuilder3.AppendFormat(" AND StartDate <= '{0}' AND EndDate >= GetDate()", dateTime.ToString()); } else if (query.Status == 2) { stringBuilder.Append(" AND EndDate <= GetDate()"); } string table = "(Select A.CombinationId,A.MainProductId,A.OtherProductIds,A.StartDate,A.EndDate,B.ProductName,B.ThumbnailUrl40 FROM Hishop_CombinationBuy AS A LEFT JOIN Hishop_Products AS B ON A.MainProductId=B.ProductId) AS Hishop_CombinationBuy"; return(DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, table, "CombinationId", 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; } CombinationBuyInfoQuery combinationBuyInfoQuery = new CombinationBuyInfoQuery(); combinationBuyInfoQuery.ProductName = context.Request["ProductName"]; combinationBuyInfoQuery.Status = -1; int?intParam = base.GetIntParam(context, "Status", true); if (intParam.HasValue) { combinationBuyInfoQuery.Status = intParam.Value; } combinationBuyInfoQuery.PageIndex = num; combinationBuyInfoQuery.PageSize = num2; combinationBuyInfoQuery.SortBy = "CombinationId"; combinationBuyInfoQuery.SortOrder = SortAction.Desc; DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(combinationBuyInfoQuery); string s = base.SerializeObjectToJson(dataList); context.Response.Write(s); context.Response.End(); }
private DataGridViewModel <Dictionary <string, object> > GetDataList(CombinationBuyInfoQuery query) { DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >(); if (query != null) { DbQueryResult combinationBuyList = CombinationBuyHelper.GetCombinationBuyList(query); dataGridViewModel.rows = DataHelper.DataTableToDictionary(combinationBuyList.Data); dataGridViewModel.total = combinationBuyList.TotalRecords; foreach (Dictionary <string, object> row in dataGridViewModel.rows) { DataTable otherProductsImgs = CombinationBuyHelper.GetOtherProductsImgs(row["OtherProductIds"].ToString()); List <Dictionary <string, object> > value = DataHelper.DataTableToDictionary(otherProductsImgs); row.Add("OtherProductsImg", value); DateTime t = (DateTime)row["StartDate"]; DateTime t2 = (DateTime)row["EndDate"]; DateTime now = DateTime.Now; string value2 = ""; if (t > now) { value2 = "即将开始"; } else if (t <= now && now <= t2) { value2 = "正在进行"; } else if (now > t2) { value2 = "已结束"; } row.Add("StatusText", value2); row["ThumbnailUrl40"] = base.GetImageOrDefaultImage(row["ThumbnailUrl40"], base.CurrentSiteSetting.DefaultProductImage); List <Dictionary <string, object> > list = row["OtherProductsImg"] as List <Dictionary <string, object> >; foreach (Dictionary <string, object> item in list) { item["ThumbnailUrl40"] = base.GetImageOrDefaultImage(item["ThumbnailUrl40"], base.CurrentSiteSetting.DefaultProductImage); } } } return(dataGridViewModel); }
public static DbQueryResult GetCombinationBuyList(CombinationBuyInfoQuery query) { return(new CombinationBuyDao().GetCombinationBuy(query)); }