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