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; } GroupBuyQuery groupBuyQuery = new GroupBuyQuery(); groupBuyQuery.ProductName = context.Request["ProductName"]; groupBuyQuery.PageIndex = num; groupBuyQuery.PageSize = num2; groupBuyQuery.SortBy = "DisplaySequence"; groupBuyQuery.SortOrder = SortAction.Desc; DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(groupBuyQuery); string s = base.SerializeObjectToJson(dataList); context.Response.Write(s); context.Response.End(); }
public DbQueryResult GetCountDownList(GroupBuyQuery query) { StringBuilder builder = new StringBuilder(); if (!string.IsNullOrEmpty(query.ProductName)) { builder.AppendFormat("ProductName Like '%{0}%'", DataHelper.CleanSearchString(query.ProductName)); } string selectFields = "CountDownId,productId,ProductName,CountDownPrice,StartDate,EndDate,DisplaySequence,MaxCount "; return(DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_CountDown", "CountDownId", builder.ToString(), selectFields)); }
public DbQueryResult GetGroupBuyList(GroupBuyQuery query) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" 1=1"); if (!string.IsNullOrEmpty(query.ProductName)) { stringBuilder.AppendFormat(" AND ProductName Like '%{0}%'", DataHelper.CleanSearchString(query.ProductName)); } string selectFields = "GroupBuyId,ProductId,ProductName,MaxCount,NeedPrice,Status,OrderCount,ISNULL(ProdcutQuantity,0) AS ProdcutQuantity,StartDate,EndDate,DisplaySequence,SupplierId"; return(DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_GroupBuy", "GroupBuyId", stringBuilder.ToString(), selectFields)); }
/// <summary> /// 限时抢购活动管理 /// </summary> /// <param name="query"></param> /// <returns></returns> public DbQueryResult GetCountManagerDownList(GroupBuyQuery query) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" 1=1 "); if (!string.IsNullOrEmpty(query.Title)) { stringBuilder.AppendFormat("and Title Like '%{0}%'", DataHelper.CleanSearchString(query.Title)); } string selectFields = "CountDownCategoryId,Title,StartTime,EndTime,AdImageUrl,AdImageLinkUrl,DisplaySequence"; return(DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Ecshop_CountDownCategories", "CountDownCategoryId", stringBuilder.ToString(), selectFields)); }
private void BindCountDown() { GroupBuyQuery query = new GroupBuyQuery(); query.ProductName = productName; query.PageIndex = pager.PageIndex; query.PageSize = pager.PageSize; query.SortBy = "DisplaySequence"; query.SortOrder = SortAction.Desc; DbQueryResult countDownList = PromoteHelper.GetCountDownList(query); grdCountDownsList.DataSource = countDownList.Data; grdCountDownsList.DataBind(); pager.TotalRecords = countDownList.TotalRecords; pager1.TotalRecords = countDownList.TotalRecords; }
private void BindGroupBuy() { GroupBuyQuery query = new GroupBuyQuery(); query.ProductName = this.productName; query.PageIndex = this.pager.PageIndex; query.PageSize = this.pager.PageSize; query.SortBy = "DisplaySequence"; query.SortOrder = SortAction.Desc; DbQueryResult groupBuyList = PromoteHelper.GetGroupBuyList(query); this.grdGroupBuyList.DataSource = groupBuyList.Data; this.grdGroupBuyList.DataBind(); this.pager.TotalRecords = groupBuyList.TotalRecords; this.pager1.TotalRecords = groupBuyList.TotalRecords; }
private void BindCountDown() { GroupBuyQuery query = new GroupBuyQuery { ProductName = this.productName, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortBy = "DisplaySequence", SortOrder = SortAction.Desc }; DbQueryResult countDownList = PromoteHelper.GetCountDownList(query); this.grdCountDownsList.DataSource = countDownList.Data; this.grdCountDownsList.DataBind(); this.pager.TotalRecords = countDownList.TotalRecords; this.pager1.TotalRecords = countDownList.TotalRecords; }
public DbQueryResult GetCountDownList(GroupBuyQuery query) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" 1=1 "); if (!string.IsNullOrEmpty(query.ProductName)) { stringBuilder.AppendFormat("and ProductName Like '%{0}%'", DataHelper.CleanSearchString(query.ProductName)); } if (query.SupplierId.HasValue) { stringBuilder.AppendFormat("and SupplierId = {0}", query.SupplierId); } string selectFields = "CountDownId,productId,ProductName,CountDownPrice,StartDate,EndDate,DisplaySequence,MaxCount,PlanCount,SupplierId"; return(DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Ecshop_CountDown", "CountDownId", stringBuilder.ToString(), selectFields)); }
private void BindGroupBuy() { GroupBuyQuery query = new GroupBuyQuery { ProductName = this.productName, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortBy = "DisplaySequence", SortOrder = SortAction.Desc }; int num = 0; if (int.TryParse(base.Request.QueryString["state"], out num)) { query.State = num; } DbQueryResult groupBuyList = GroupBuyHelper.GetGroupBuyList(query); this.grdGroupBuyList.DataSource = groupBuyList.Data; this.grdGroupBuyList.DataBind(); this.pager.TotalRecords = groupBuyList.TotalRecords; this.pager1.TotalRecords = groupBuyList.TotalRecords; }
private DataGridViewModel <Dictionary <string, object> > GetDataList(GroupBuyQuery query) { DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >(); if (query != null) { DbQueryResult groupBuyList = PromoteHelper.GetGroupBuyList(query); dataGridViewModel.rows = DataHelper.DataTableToDictionary(groupBuyList.Data); dataGridViewModel.total = groupBuyList.TotalRecords; foreach (Dictionary <string, object> row in dataGridViewModel.rows) { GroupBuyInfo groupBuyInfo = row.ToObject <GroupBuyInfo>(); decimal currentPrice = PromoteHelper.GetCurrentPrice(groupBuyInfo.GroupBuyId); row.Add("CurrentPrice", currentPrice); row.Add("StatusText", groupBuyInfo.StatusText); row.Add("CanDelete", (groupBuyInfo.Status != GroupBuyStatus.UnderWay || !(groupBuyInfo.StartDate <= DateTime.Now) || !(groupBuyInfo.EndDate >= DateTime.Now)) && groupBuyInfo.Status != GroupBuyStatus.EndUntreated); } } return(dataGridViewModel); }
/// <summary> ///导出广告订单 /// </summary> /// <param name="query"></param> /// <returns></returns> public DbQueryResult ExprtAdOrderInfoList(GroupBuyQuery query) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" 1=1 "); if (!string.IsNullOrEmpty(query.OrderId)) { stringBuilder.AppendFormat("and OrderNo Like '%{0}%'", DataHelper.CleanSearchString(query.OrderId)); } if (!string.IsNullOrEmpty(query.starttime) && query.starttime != "0001/1/1 0:00:00") { stringBuilder.AppendFormat("and OrderTIme>='{0}'", DataHelper.CleanSearchString(query.starttime)); } if (!string.IsNullOrEmpty(query.endtime) && query.endtime != "0001/1/1 0:00:00") { stringBuilder.AppendFormat("and OrderTIme<'{0}'", DataHelper.CleanSearchString(query.endtime)); } if (!string.IsNullOrEmpty(query.keyword)) { stringBuilder.AppendFormat("and (OrderNo like '%{0}%' or ProductName like '%{0}%' or OrderStatus like '%{0}%' or PaymentType like '%{0}%' or paymentStatus like '%{0}%')", DataHelper.CleanSearchString(query.keyword)); } string sql = @"select OrderNo, OrderTotal, ProductName, BarCode, sku, ItemAdjustedPrice, OrderStatus, PaymentType, paymentStatus, OrderTIme, UpdateDate from vw_GetAdOrderList as a where " + stringBuilder.ToString(); DbCommand storedProcCommand = this.database.GetSqlStringCommand(sql); DbQueryResult rs = new DbQueryResult(); rs.Data = this.database.ExecuteDataSet(storedProcCommand).Tables[0]; return(rs); }
private void BindGroupBuy() { GroupBuyQuery query = new GroupBuyQuery { ProductName = this.productName, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortBy = "DisplaySequence", SortOrder = SortAction.Desc }; int num = 0; if (int.TryParse(base.Request.QueryString["state"], out num)) { query.State = num; } DbQueryResult groupBuyList = GroupBuyHelper.GetGroupBuyList(query); this.grdGroupBuyList.DataSource = groupBuyList.Data; this.grdGroupBuyList.DataBind(); this.pager.TotalRecords = groupBuyList.TotalRecords; this.pager1.TotalRecords = groupBuyList.TotalRecords; }
/// <summary> ///获取广告订单 /// </summary> /// <param name="query"></param> /// <returns></returns> public DbQueryResult GetAdOrderInfoList(GroupBuyQuery query) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" 1=1 "); if (!string.IsNullOrEmpty(query.OrderId)) { stringBuilder.AppendFormat("and OrderNo Like '%{0}%'", DataHelper.CleanSearchString(query.OrderId)); } if (!string.IsNullOrEmpty(query.starttime) && query.starttime != "0001/1/1 0:00:00") { stringBuilder.AppendFormat("and OrderTIme>='{0}'", DataHelper.CleanSearchString(query.starttime)); } if (!string.IsNullOrEmpty(query.endtime) && query.endtime != "0001/1/1 0:00:00") { stringBuilder.AppendFormat("and OrderTIme<'{0}'", DataHelper.CleanSearchString(query.endtime)); } if (!string.IsNullOrEmpty(query.keyword)) { stringBuilder.AppendFormat("and (OrderNo like '%{0}%' or ProductName like '%{0}%' or OrderStatus like '%{0}%' or PaymentType like '%{0}%' or paymentStatus like '%{0}%')", DataHelper.CleanSearchString(query.keyword)); } return(DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_GetAdOrderList", "OrderTIme", stringBuilder.ToString(), "*")); }
public abstract DbQueryResult GetGroupBuyList(GroupBuyQuery query);
public abstract DbQueryResult GetCountDownList(GroupBuyQuery query);
public abstract DbQueryResult GetCountDownList(GroupBuyQuery query);
public abstract DbQueryResult GetGroupBuyList(GroupBuyQuery query);
public static DbQueryResult GetGroupBuyList(GroupBuyQuery query) { return new GroupBuyDao().GetGroupBuyList(query); }
public DbQueryResult GetGroupBuyList(GroupBuyQuery query) { StringBuilder builder = new StringBuilder(); builder.Append(" 1=1"); if (query.State > 0) { builder.AppendFormat(" AND Status = {0} ", query.State); } if (!string.IsNullOrEmpty(query.ProductName)) { builder.AppendFormat(" AND ProductName Like '%{0}%' ", DataHelper.CleanSearchString(query.ProductName)); } string selectFields = "GroupBuyId,ProductId,ProductName,MaxCount,NeedPrice,Status,SoldCount,OrderCount,ISNULL(ProdcutQuantity,0) AS ProdcutQuantity,StartDate,EndDate,DisplaySequence"; return DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_GroupBuy", "GroupBuyId", builder.ToString(), selectFields); }
/// <summary> ///导出广告订单 /// </summary> /// <param name="query"></param> /// <returns></returns> public static DbQueryResult ExprtAdOrderInfoList(GroupBuyQuery query) { return(new CountDownDao().ExprtAdOrderInfoList(query)); }
public static DbQueryResult GetCountManagerDownList(GroupBuyQuery query) { return(new CountDownDao().GetCountManagerDownList(query)); }
public override DbQueryResult GetGroupBuyList(GroupBuyQuery query) { StringBuilder builder = new StringBuilder(); builder.AppendFormat(" DistributorUserId={0}", HiContext.Current.User.UserId); if (!string.IsNullOrEmpty(query.ProductName)) { builder.AppendFormat(" AND ProductName Like '%{0}%'", DataHelper.CleanSearchString(query.ProductName)); } string selectFields = "GroupBuyId,ProductId, ProductName,MaxCount,NeedPrice,Status,OrderCount,ISNULL(ProdcutQuantity,0) AS ProdcutQuantity,EndDate,DisplaySequence"; return DataHelper.PagingByTopnotin(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_distro_GroupBuy", "GroupBuyId", builder.ToString(), selectFields); }
public static DbQueryResult GetGroupBuyList(GroupBuyQuery query) { return(PromotionsProvider.Instance().GetGroupBuyList(query)); }
public static DbQueryResult GetCountDownList(GroupBuyQuery query) { return(SubsitePromotionsProvider.Instance().GetCountDownList(query)); }
public static DbQueryResult GetGroupBuyList(GroupBuyQuery query) { return(new GroupBuyDao().GetGroupBuyList(query)); }
public static DbQueryResult GetGroupBuyList(GroupBuyQuery query) { return SubsitePromotionsProvider.Instance().GetGroupBuyList(query); }