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