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));
}
