private DataGridViewModel <Dictionary <string, object> > GetDataList(CountDownQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
DbQueryResult countDownList = PromoteHelper.GetCountDownList(query);
dataGridViewModel.rows = DataHelper.DataTableToDictionary(countDownList.Data);
dataGridViewModel.total = countDownList.TotalRecords;
foreach (Dictionary <string, object> row in dataGridViewModel.rows)
{
CountDownInfo countDownInfo = row.ToObject <CountDownInfo>();
int num = 0;
if (countDownInfo.StartDate > DateTime.Now)
{
num = 1;
}
else if (countDownInfo.EndDate < DateTime.Now)
{
num = 2;
}
row.Add("State", num);
}
}
return(dataGridViewModel);
}
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;
}
CountDownQuery countDownQuery = new CountDownQuery();
countDownQuery.ProductName = context.Request["ProductName"];
countDownQuery.State = base.GetIntParam(context, "State", false).Value;
countDownQuery.PageIndex = num;
countDownQuery.PageSize = num2;
countDownQuery.SortBy = "DisplaySequence";
countDownQuery.SortOrder = SortAction.Desc;
DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(countDownQuery);
string s = base.SerializeObjectToJson(dataList);
context.Response.Write(s);
context.Response.End();
}
public DbQueryResult GetCountDownList(CountDownQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" 1=1 ");
if (!string.IsNullOrEmpty(query.ProductName))
{
stringBuilder.AppendFormat(" AND ProductName Like '%{0}%'", DataHelper.CleanSearchString(query.ProductName));
}
switch (query.State)
{
case 0:
stringBuilder.Append(" AND getdate() BETWEEN StartDate AND Enddate");
break;
case 1:
stringBuilder.Append(" AND StartDate > getdate()");
break;
case 2:
stringBuilder.Append(" AND Enddate < getdate()");
break;
}
string selectFields = "*";
return(DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_CountDown", "CountDownId", stringBuilder.ToString(), selectFields));
}
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;
}
CountDownQuery countDownQuery = new CountDownQuery();
countDownQuery.CountDownId = base.GetIntParam(context, "CountDownId", false).Value;
countDownQuery.PageIndex = num;
countDownQuery.PageSize = num2;
if (!string.IsNullOrEmpty(context.Request.QueryString["StoreId"]))
{
countDownQuery.StoreId = base.GetIntParam(context, "StoreId", false).Value;
}
if (!string.IsNullOrEmpty(context.Request.QueryString["OrderStatus"]))
{
countDownQuery.OrderState = (OrderStatus)base.GetIntParam(context, "OrderStatus", false).Value;
}
DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(countDownQuery);
string s = base.SerializeObjectToJson(dataList);
context.Response.Write(s);
context.Response.End();
}
private DataGridViewModel <Dictionary <string, object> > GetDataList(CountDownQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
DbQueryResult countDownTotalList = PromoteHelper.GetCountDownTotalList(query);
dataGridViewModel.rows = DataHelper.DataTableToDictionary(countDownTotalList.Data);
dataGridViewModel.total = countDownTotalList.TotalRecords;
foreach (Dictionary <string, object> row in dataGridViewModel.rows)
{
row.Add("OrderStatusText", EnumDescription.GetEnumDescription((Enum)(object)(OrderStatus)row["OrderStatus"], 0));
}
}
return(dataGridViewModel);
}
public DbQueryResult GetCountDownTotalList(CountDownQuery query)
{
StringBuilder stringBuilder = new StringBuilder(" 1=1 ");
if (query.CountDownId > 0)
{
stringBuilder.AppendFormat(" AND CountDownBuyId={0}", query.CountDownId);
}
if (query.StoreId >= 0)
{
stringBuilder.AppendFormat(" AND o.StoreId={0}", query.StoreId);
}
if (query.OrderState != 0)
{
stringBuilder.AppendFormat(" AND o.OrderStatus={0}", (int)query.OrderState);
}
string selectFields = "o.*,s.StoreName,(SELECT top 1 quantity FROM Hishop_OrderItems WHERE OrderId =o.OrderId ) as Quantity";
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_Orders o inner join vw_Hishop_StoreForPromotion s on s.StoreId=o.storeId", "OrderId", stringBuilder.ToString(), selectFields));
}
public static DbQueryResult GetCountDownTotalList(CountDownQuery query)
{
return(new CountDownDao().GetCountDownTotalList(query));
}
