private void BindUserOrderStatistics()
{
UserOrderQuery userOrder = new UserOrderQuery();
userOrder.UserName = userName;
userOrder.ShipTo = shipTo;
userOrder.StartDate = dateStart;
userOrder.EndDate = dateEnd;
userOrder.OrderId = orderId;
userOrder.PageSize = pager.PageSize;
userOrder.PageIndex = pager.PageIndex;
userOrder.SortBy = grdUserOrderStatistics.SortOrderBy;
if (grdUserOrderStatistics.SortOrder.ToLower() == "desc")
{
userOrder.SortOrder = SortAction.Desc;
}
OrderStatisticsInfo userOrders = SubsiteSalesHelper.GetUserOrders(userOrder);
grdUserOrderStatistics.DataSource = userOrders.OrderTbl;
grdUserOrderStatistics.DataBind();
pager.TotalRecords = userOrders.TotalCount;
lblPageCount.Text = string.Format("当前页共计<span style=\"color:red;\">{0}</span>个 <span style=\"padding-left:10px;\">订单金额共计</span><span style=\"color:red;\">{1}</span>元 <span style=\"padding-left:10px;\">订单毛利润共计</span><span style=\"color:red;\">{2}</span>元 ", userOrders.OrderTbl.Rows.Count, Globals.FormatMoney(userOrders.TotalOfPage), Globals.FormatMoney(userOrders.ProfitsOfPage));
lblSearchCount.Text = string.Format("当前查询结果共计<span style=\"color:red;\">{0}</span>个 <span style=\"padding-left:10px;\">订单金额共计</span><span style=\"color:red;\">{1}</span>元 <span style=\"padding-left:10px;\">订单毛利润共计</span><span style=\"color:red;\">{2}</span>元 ", userOrders.TotalCount, Globals.FormatMoney(userOrders.TotalOfSearch), Globals.FormatMoney(userOrders.ProfitsOfSearch));
}
public OrderStatisticsInfo GetUserOrdersNoPage(OrderQuery userOrder)
{
OrderStatisticsInfo orderStatisticsInfo = new OrderStatisticsInfo();
DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_OrderStatisticsNoPage_Get");
this.database.AddInParameter(storedProcCommand, "sqlPopulate", DbType.String, SaleStatisticDao.BuildUserOrderQuery(userOrder));
this.database.AddOutParameter(storedProcCommand, "TotalUserOrders", DbType.Int32, 4);
using (IDataReader dataReader = this.database.ExecuteReader(storedProcCommand))
{
orderStatisticsInfo.OrderTbl = DataHelper.ConverDataReaderToDataTable(dataReader);
if (dataReader.NextResult())
{
dataReader.Read();
if (dataReader["OrderTotal"] != DBNull.Value)
{
orderStatisticsInfo.TotalOfSearch += (decimal)dataReader["OrderTotal"];
}
if (dataReader["Profits"] != DBNull.Value)
{
orderStatisticsInfo.ProfitsOfSearch += (decimal)dataReader["Profits"];
}
}
}
orderStatisticsInfo.TotalCount = (int)this.database.GetParameterValue(storedProcCommand, "TotaluserOrders");
return(orderStatisticsInfo);
}
private void BindUserOrderStatistics()
{
OrderStatisticsInfo userOrders = SalesHelper.GetUserOrders(new OrderQuery
{
UserName = this.userName,
ShipTo = this.shipTo,
StartDate = this.dateStart,
EndDate = this.dateEnd,
OrderId = this.orderId,
PageSize = this.pager.PageSize,
SiteId = this.siteId,
PageIndex = this.pager.PageIndex,
SortBy = "OrderDate",
SortOrder = SortAction.Desc,
SourceOrder = this.orderSource,
ProductName = this.productName,
SupplierId = this.supplierId
});
this.rp_orderStatistics.DataSource = userOrders.OrderTbl;
this.rp_orderStatistics.DataBind();
this.pager.TotalRecords = userOrders.TotalCount;
this.lblPageCount.Text = string.Format("当前页共计<span class=\"colorG\">{0}</span>个 <span style=\"padding-left:10px;\">订单金额共计</span><span class=\"colorG\">{1}</span>元 <span style=\"padding-left:10px;\">订单毛利润共计</span><span class=\"colorG\">{2}</span>元 ", userOrders.OrderTbl.Rows.Count, Globals.FormatMoney(userOrders.TotalOfPage), Globals.FormatMoney(userOrders.ProfitsOfPage));
this.lblSearchCount.Text = string.Format("当前查询结果共计<span class=\"colorG\">{0}</span>个 <span style=\"padding-left:10px;\">订单金额共计</span><span class=\"colorG\">{1}</span>元 <span style=\"padding-left:10px;\">订单毛利润共计</span><span class=\"colorG\">{2}</span>元 ", userOrders.TotalCount, Globals.FormatMoney(userOrders.TotalOfSearch), Globals.FormatMoney(userOrders.ProfitsOfSearch));
}
private void btnCreateReport_Click(object sender, EventArgs e)
{
UserOrderQuery userOrder = new UserOrderQuery();
userOrder.UserName = userName;
userOrder.ShipTo = shipTo;
userOrder.StartDate = dateStart;
userOrder.EndDate = dateEnd;
userOrder.OrderId = orderId;
userOrder.PageSize = pager.PageSize;
userOrder.PageIndex = pager.PageIndex;
userOrder.SortBy = grdUserOrderStatistics.SortOrderBy;
if (grdUserOrderStatistics.SortOrder.ToLower() == "desc")
{
userOrder.SortOrder = SortAction.Desc;
}
OrderStatisticsInfo userOrdersNoPage = SubsiteSalesHelper.GetUserOrdersNoPage(userOrder);
StringBuilder builder = new StringBuilder();
builder.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
builder.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;\">");
builder.AppendLine("<td>订单号</td>");
builder.AppendLine("<td>下单时间</td>");
builder.AppendLine("<td>总订单金额</td>");
builder.AppendLine("<td>用户名</td>");
builder.AppendLine("<td>收货人</td>");
builder.AppendLine("<td>利润</td>");
builder.AppendLine("</tr>");
foreach (DataRow row in userOrdersNoPage.OrderTbl.Rows)
{
builder.AppendLine("<tr>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat:@\">" + row["OrderId"].ToString() + "</td>");
builder.AppendLine("<td>" + row["OrderDate"].ToString() + "</td>");
builder.AppendLine("<td>" + row["Total"].ToString() + "</td>");
builder.AppendLine("<td>" + row["UserName"].ToString() + "</td>");
builder.AppendLine("<td>" + row["ShipTo"].ToString() + "</td>");
builder.AppendLine("<td>" + row["Profits"].ToString() + "</td>");
builder.AppendLine("</tr>");
}
builder.AppendLine("<tr>");
builder.AppendLine("<td>当前查询结果共计," + userOrdersNoPage.TotalCount + "</td>");
builder.AppendLine("<td>订单金额共计," + userOrdersNoPage.TotalOfSearch + "</td>");
builder.AppendLine("<td>订单毛利润共计," + userOrdersNoPage.ProfitsOfSearch + "</td>");
builder.AppendLine("<td></td>");
builder.AppendLine("</tr>");
builder.AppendLine("</table>");
Page.Response.Clear();
Page.Response.Buffer = false;
Page.Response.Charset = "utf-8";
Page.Response.AppendHeader("Content-Disposition", "attachment;filename=UserOrderStatistics.xls");
Page.Response.ContentEncoding = Encoding.GetEncoding("utf-8");
Page.Response.ContentType = "application/ms-excel";
Page.EnableViewState = false;
Page.Response.Write(builder.ToString());
Page.Response.End();
}
private void btnCreateReport_Click(object sender, EventArgs e)
{
UserOrderQuery query2 = new UserOrderQuery();
query2.UserName = userName;
query2.StartDate = dateStart;
query2.EndDate = dateEnd;
query2.PageIndex = pager.PageIndex;
query2.SortBy = grdPurchaseOrderStatistics.SortOrderBy;
UserOrderQuery order = query2;
if (grdPurchaseOrderStatistics.SortOrder.ToLower() == "desc")
{
order.SortOrder = SortAction.Desc;
}
OrderStatisticsInfo purchaseOrdersNoPage = DistributorHelper.GetPurchaseOrdersNoPage(order);
StringBuilder builder = new StringBuilder();
builder.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
builder.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;\">");
builder.AppendLine("<td>采购单号</td>");
builder.AppendLine("<td>订单号</td>");
builder.AppendLine("<td>下单时间</td>");
builder.AppendLine("<td>分销商名称</td>");
builder.AppendLine("<td>采购单金额</td>");
builder.AppendLine("<td>利润</td>");
builder.AppendLine("</tr>");
foreach (DataRow row in purchaseOrdersNoPage.OrderTbl.Rows)
{
builder.AppendLine("<tr>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat:@\">" + row["PurchaseOrderId"].ToString() + "</td>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat:@\">" + row["OrderId"].ToString() + "</td>");
builder.AppendLine("<td>" + row["PurchaseDate"].ToString() + "</td>");
builder.AppendLine("<td>" + row["Distributorname"].ToString() + "</td>");
builder.AppendLine("<td>" + row["PurchaseTotal"].ToString() + "</td>");
builder.AppendLine("<td>" + row["PurchaseProfit"].ToString() + "</td>");
builder.AppendLine("</tr>");
}
builder.AppendLine("<tr>");
builder.AppendLine("<td>当前查询结果共计," + purchaseOrdersNoPage.TotalCount + "</td>");
builder.AppendLine("<td>采购单金额共计," + purchaseOrdersNoPage.TotalOfSearch + "</td>");
builder.AppendLine("<td>采购单毛利润共计," + purchaseOrdersNoPage.ProfitsOfSearch + "</td>");
builder.AppendLine("<td></td>");
builder.AppendLine("</tr>");
builder.AppendLine("</table>");
Page.Response.Clear();
Page.Response.Buffer = false;
Page.Response.Charset = "UTF-8";
Page.Response.AppendHeader("Content-Disposition", "attachment;filename=PurchaseOrderStatistics.xls");
Page.Response.ContentEncoding = Encoding.UTF8;
Page.Response.ContentType = "application/ms-excel";
Page.EnableViewState = false;
Page.Response.Write(builder.ToString());
Page.Response.End();
}
private void btnCreateReport_Click(object sender, System.EventArgs e)
{
OrderQuery userOrder = new OrderQuery
{
UserName = this.userName,
ShipTo = this.shipTo,
StartDate = this.dateStart,
EndDate = this.dateEnd,
OrderId = this.orderId,
PageSize = this.pager.PageSize,
PageIndex = this.pager.PageIndex,
SortBy = "OrderDate",
SortOrder = SortAction.Desc
};
OrderStatisticsInfo userOrdersNoPage = SalesHelper.GetUserOrdersNoPage(userOrder);
System.Text.StringBuilder builder = new System.Text.StringBuilder();
builder.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
builder.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;\">");
builder.AppendLine("<td>订单号</td>");
builder.AppendLine("<td>下单时间</td>");
builder.AppendLine("<td>总订单金额</td>");
builder.AppendLine("<td>昵称</td>");
builder.AppendLine("<td>收货人</td>");
builder.AppendLine("<td>利润</td>");
builder.AppendLine("</tr>");
foreach (System.Data.DataRow row in userOrdersNoPage.OrderTbl.Rows)
{
builder.AppendLine("<tr>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat:@\">" + row["OrderId"].ToString() + "</td>");
builder.AppendLine("<td>" + row["OrderDate"].ToString() + "</td>");
builder.AppendLine("<td>" + row["Total"].ToString() + "</td>");
builder.AppendLine("<td>" + row["UserName"].ToString() + "</td>");
builder.AppendLine("<td>" + row["ShipTo"].ToString() + "</td>");
builder.AppendLine("<td>" + row["Profits"].ToString() + "</td>");
builder.AppendLine("</tr>");
}
builder.AppendLine("<tr>");
builder.AppendLine("<td>当前查询结果共计," + userOrdersNoPage.TotalCount + "</td>");
builder.AppendLine("<td>订单金额共计," + userOrdersNoPage.TotalOfSearch + "</td>");
builder.AppendLine("<td>订单毛利润共计," + userOrdersNoPage.ProfitsOfSearch + "</td>");
builder.AppendLine("<td></td>");
builder.AppendLine("</tr>");
builder.AppendLine("</table>");
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "GB2312";
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=UserOrderStatistics.xls");
this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
this.Page.Response.ContentType = "application/ms-excel";
this.Page.EnableViewState = false;
this.Page.Response.Write(builder.ToString());
this.Page.Response.End();
}
private void btnCreateReport_Click(object sender, System.EventArgs e)
{
OrderStatisticsInfo purchaseOrdersNoPage = DistributorHelper.GetPurchaseOrdersNoPage(new UserOrderQuery
{
UserName = this.userName,
StartDate = this.dateStart,
EndDate = this.dateEnd,
PageIndex = this.pager.PageIndex,
SortBy = "PurchaseDate",
SortOrder = SortAction.Desc
});
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
stringBuilder.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;\">");
stringBuilder.AppendLine("<td>采购单号</td>");
stringBuilder.AppendLine("<td>订单号</td>");
stringBuilder.AppendLine("<td>下单时间</td>");
stringBuilder.AppendLine("<td>分销商名称</td>");
stringBuilder.AppendLine("<td>采购单金额</td>");
stringBuilder.AppendLine("<td>利润</td>");
stringBuilder.AppendLine("</tr>");
foreach (System.Data.DataRow dataRow in purchaseOrdersNoPage.OrderTbl.Rows)
{
stringBuilder.AppendLine("<tr>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat:@\">" + dataRow["PurchaseOrderId"].ToString() + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat:@\">" + dataRow["OrderId"].ToString() + "</td>");
stringBuilder.AppendLine("<td>" + dataRow["PurchaseDate"].ToString() + "</td>");
stringBuilder.AppendLine("<td>" + dataRow["Distributorname"].ToString() + "</td>");
stringBuilder.AppendLine("<td>" + dataRow["PurchaseTotal"].ToString() + "</td>");
stringBuilder.AppendLine("<td>" + dataRow["PurchaseProfit"].ToString() + "</td>");
stringBuilder.AppendLine("</tr>");
}
stringBuilder.AppendLine("<tr>");
stringBuilder.AppendLine("<td>当前查询结果共计," + purchaseOrdersNoPage.TotalCount + "</td>");
stringBuilder.AppendLine("<td>采购单金额共计," + purchaseOrdersNoPage.TotalOfSearch + "</td>");
stringBuilder.AppendLine("<td>采购单毛利润共计," + purchaseOrdersNoPage.ProfitsOfSearch + "</td>");
stringBuilder.AppendLine("<td></td>");
stringBuilder.AppendLine("</tr>");
stringBuilder.AppendLine("</table>");
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "UTF-8";
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=PurchaseOrderStatistics.xls");
this.Page.Response.ContentEncoding = System.Text.Encoding.UTF8;
this.Page.Response.ContentType = "application/ms-excel";
this.Page.EnableViewState = false;
this.Page.Response.Write(stringBuilder.ToString());
this.Page.Response.End();
}
private void BindDistributorRanking()
{
SaleStatisticsQuery query = new SaleStatisticsQuery();
query.StartDate = this.dateStart;
query.EndDate = this.dateEnd;
query.PageSize = this.pager.PageSize;
query.PageIndex = this.pager.PageIndex;
query.SortBy = "SaleTotals";
query.SortOrder = SortAction.Desc;
int totalDistributors = 0;
OrderStatisticsInfo distributorStatistics = DistributorHelper.GetDistributorStatistics(query, out totalDistributors);
this.grdDistributorStatistics.DataSource = distributorStatistics.OrderTbl;
this.grdDistributorStatistics.DataBind();
this.lblTotal.Money = distributorStatistics.TotalOfSearch;
this.lblProfitTotal.Money = distributorStatistics.ProfitsOfSearch;
this.pager.TotalRecords = totalDistributors;
}
private void BindPurchaseOrderStatistics()
{
UserOrderQuery order = new UserOrderQuery();
order.UserName = this.userName;
order.StartDate = this.dateStart;
order.EndDate = this.dateEnd;
order.PageSize = 10;
order.PageIndex = this.pager.PageIndex;
order.SortBy = "PurchaseDate";
order.SortOrder = SortAction.Desc;
OrderStatisticsInfo purchaseOrders = DistributorHelper.GetPurchaseOrders(order);
this.grdPurchaseOrderStatistics.DataSource = purchaseOrders.OrderTbl;
this.grdPurchaseOrderStatistics.DataBind();
this.pager.TotalRecords = purchaseOrders.TotalCount;
this.lblPageCount.Text = string.Format("当前页共计<span class=\"colorG\">{0}</span>个 <span style=\"padding-left:10px;\">采购单金额共计</span><span class=\"colorG\">{1}</span>元 <span style=\"padding-left:10px;\">采购单毛利润共计</span><span class=\"colorG\">{2}</span>元 ", purchaseOrders.OrderTbl.Rows.Count, Globals.FormatMoney(purchaseOrders.TotalOfPage), Globals.FormatMoney(purchaseOrders.ProfitsOfPage));
this.lblSearchCount.Text = string.Format("当前查询结果共计<span class=\"colorG\">{0}</span>个 <span style=\"padding-left:10px;\">采购单金额共计</span><span class=\"colorG\">{1}</span>元 <span style=\"padding-left:10px;\">采购单毛利润共计</span><span class=\"colorG\">{2}</span>元 ", purchaseOrders.TotalCount, Globals.FormatMoney(purchaseOrders.TotalOfSearch), Globals.FormatMoney(purchaseOrders.ProfitsOfSearch));
}
public OrderStatisticsInfo GetUserOrders(OrderQuery userOrder)
{
OrderStatisticsInfo info = new OrderStatisticsInfo();
DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_OrderStatistics_Get");
this.database.AddInParameter(storedProcCommand, "PageIndex", DbType.Int32, userOrder.PageIndex);
this.database.AddInParameter(storedProcCommand, "PageSize", DbType.Int32, userOrder.PageSize);
this.database.AddInParameter(storedProcCommand, "IsCount", DbType.Boolean, userOrder.IsCount);
this.database.AddInParameter(storedProcCommand, "sqlPopulate", DbType.String, BuildUserOrderQuery(userOrder));
this.database.AddOutParameter(storedProcCommand, "TotalUserOrders", DbType.Int32, 4);
using (IDataReader reader = this.database.ExecuteReader(storedProcCommand))
{
info.OrderTbl = DataHelper.ConverDataReaderToDataTable(reader);
if (reader.NextResult())
{
reader.Read();
if (reader["OrderTotal"] != DBNull.Value)
{
info.TotalOfPage += (decimal)reader["OrderTotal"];
}
if (reader["Profits"] != DBNull.Value)
{
info.ProfitsOfPage += (decimal)reader["Profits"];
}
}
if (reader.NextResult())
{
reader.Read();
if (reader["OrderTotal"] != DBNull.Value)
{
info.TotalOfSearch += (decimal)reader["OrderTotal"];
}
if (reader["Profits"] != DBNull.Value)
{
info.ProfitsOfSearch += (decimal)reader["Profits"];
}
}
}
info.TotalCount = (int)this.database.GetParameterValue(storedProcCommand, "TotaluserOrders");
return(info);
}
private void btnCreateReport_Click(object sender, System.EventArgs e)
{
OrderStatisticsInfo distributorStatisticsNoPage = DistributorHelper.GetDistributorStatisticsNoPage(new SaleStatisticsQuery
{
StartDate = this.dateStart,
EndDate = this.dateEnd,
PageSize = this.pager.PageSize,
SortBy = "SaleTotals",
SortOrder = SortAction.Desc
});
System.Data.DataTable orderTbl = distributorStatisticsNoPage.OrderTbl;
string text = string.Empty;
text += "排行,分销商名称,交易量,交易金额,利润\r\n";
foreach (System.Data.DataRow dataRow in orderTbl.Rows)
{
if (System.Convert.ToDecimal(dataRow["SaleTotals"]) > 0m)
{
text += dataRow["IndexId"].ToString();
}
else
{
text = (text ?? "");
}
text = text + "," + dataRow["UserName"].ToString();
text = text + "," + dataRow["PurchaseOrderCount"].ToString();
text = text + "," + dataRow["SaleTotals"].ToString();
text = text + "," + dataRow["Profits"].ToString();
text += "\r\n";
}
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "GB2312";
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=DistributorRanking.CSV");
this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
this.Page.Response.ContentType = "application/octet-stream";
this.Page.EnableViewState = false;
this.Page.Response.Write(text);
this.Page.Response.End();
}
private void BindUserOrderStatistics()
{
UserOrderQuery userOrder = new UserOrderQuery();
userOrder.UserName = this.userName;
userOrder.ShipTo = this.shipTo;
userOrder.StartDate = this.dateStart;
userOrder.EndDate = this.dateEnd;
userOrder.OrderId = this.orderId;
userOrder.PageSize = this.pager.PageSize;
userOrder.PageIndex = this.pager.PageIndex;
userOrder.SortBy = "OrderDate";
userOrder.SortOrder = SortAction.Desc;
OrderStatisticsInfo userOrders = SalesHelper.GetUserOrders(userOrder);
this.rp_orderStatistics.DataSource = userOrders.OrderTbl;
this.rp_orderStatistics.DataBind();
this.pager.TotalRecords = userOrders.TotalCount;
this.lblPageCount.Text = string.Format("当前页共计<span class=\"colorG\">{0}</span>个 <span style=\"padding-left:10px;\">订单金额共计</span><span class=\"colorG\">{1}</span>元 <span style=\"padding-left:10px;\">订单毛利润共计</span><span class=\"colorG\">{2}</span>元 ", userOrders.OrderTbl.Rows.Count, Globals.FormatMoney(userOrders.TotalOfPage), Globals.FormatMoney(userOrders.ProfitsOfPage));
this.lblSearchCount.Text = string.Format("当前查询结果共计<span class=\"colorG\">{0}</span>个 <span style=\"padding-left:10px;\">订单金额共计</span><span class=\"colorG\">{1}</span>元 <span style=\"padding-left:10px;\">订单毛利润共计</span><span class=\"colorG\">{2}</span>元 ", userOrders.TotalCount, Globals.FormatMoney(userOrders.TotalOfSearch), Globals.FormatMoney(userOrders.ProfitsOfSearch));
}
public OrderStatisticsInfo GetUserOrders(OrderQuery userOrder)
{
OrderStatisticsInfo orderStatisticsInfo = new OrderStatisticsInfo();
DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_OrderStatistics_Get");
this.database.AddInParameter(storedProcCommand, "PageIndex", DbType.Int32, userOrder.PageIndex);
this.database.AddInParameter(storedProcCommand, "PageSize", DbType.Int32, userOrder.PageSize);
this.database.AddInParameter(storedProcCommand, "IsCount", DbType.Boolean, userOrder.IsCount);
this.database.AddInParameter(storedProcCommand, "sqlPopulate", DbType.String, SaleStatisticDao.BuildUserOrderQuery(userOrder));
this.database.AddOutParameter(storedProcCommand, "TotalUserOrders", DbType.Int32, 4);
DataTable dataTable = new DataTable();
dataTable.TableName = "orderxml";
dataTable.Columns.Add(new DataColumn("search"));
DataRow dataRow = dataTable.NewRow();
dataRow["search"] = string.Concat(new object[]
{
SaleStatisticDao.BuildOrdersQuery(userOrder),
"---",
userOrder.OrderId,
"---",
userOrder.EndDate,
"---",
userOrder.StartDate,
"---",
userOrder.ShipTo
});
dataTable.Rows.Add(dataRow);
dataTable.WriteXml(HttpContext.Current.Request.MapPath("/searchlog.xml"));
using (IDataReader dataReader = this.database.ExecuteReader(storedProcCommand))
{
orderStatisticsInfo.OrderTbl = DataHelper.ConverDataReaderToDataTable(dataReader);
if (dataReader.NextResult())
{
dataReader.Read();
if (dataReader["OrderTotal"] != DBNull.Value)
{
orderStatisticsInfo.TotalOfPage += (decimal)dataReader["OrderTotal"];
}
if (dataReader["Profits"] != DBNull.Value)
{
orderStatisticsInfo.ProfitsOfPage += (decimal)dataReader["Profits"];
}
}
if (dataReader.NextResult())
{
dataReader.Read();
if (dataReader["OrderTotal"] != DBNull.Value)
{
orderStatisticsInfo.TotalOfSearch += (decimal)dataReader["OrderTotal"];
}
if (dataReader["Profits"] != DBNull.Value)
{
orderStatisticsInfo.ProfitsOfSearch += (decimal)dataReader["Profits"];
}
}
}
orderStatisticsInfo.TotalCount = (int)this.database.GetParameterValue(storedProcCommand, "TotaluserOrders");
return(orderStatisticsInfo);
}
public OrderStatisticsInfo GetUserOrdersNoPage(OrderQuery userOrder)
{
OrderStatisticsInfo info = new OrderStatisticsInfo();
DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_OrderStatisticsNoPage_Get");
this.database.AddInParameter(storedProcCommand, "sqlPopulate", DbType.String, BuildUserOrderQuery(userOrder));
this.database.AddOutParameter(storedProcCommand, "TotalUserOrders", DbType.Int32, 4);
using (IDataReader reader = this.database.ExecuteReader(storedProcCommand))
{
info.OrderTbl = DataHelper.ConverDataReaderToDataTable(reader);
if (reader.NextResult())
{
reader.Read();
if (reader["OrderTotal"] != DBNull.Value)
{
info.TotalOfSearch += (decimal) reader["OrderTotal"];
}
if (reader["Profits"] != DBNull.Value)
{
info.ProfitsOfSearch += (decimal) reader["Profits"];
}
}
}
info.TotalCount = (int) this.database.GetParameterValue(storedProcCommand, "TotaluserOrders");
return info;
}
private string sender; //门店id
private void BindUserOrderStatistics()
{
OrderQuery userOrder = new OrderQuery
{
UserName = this.userName,
ShipTo = this.shipTo,
StartDate = this.dateStart,
EndDate = this.dateEnd,
OrderId = this.orderId,
PageSize = this.pager.PageSize,
PageIndex = this.pager.PageIndex,
SortBy = "OrderDate",
SortOrder = SortAction.Desc,
Sender = this.sender
};
OrderStatisticsInfo userOrders = SalesHelper.GetUserOrders(userOrder);
this.pager.TotalRecords = userOrders.TotalCount;
//爽爽挝啡需要将利润改为堂食客户和微信客户的区分
userOrders.OrderTbl.Columns.Add("guestType");//客户种类 堂食用户或者微信用户
if (Hidistro.ControlPanel.Config.CustomConfigHelper.Instance.AutoShipping)
{
this.ddlGuestType.Visible = true;
this.ddlGuestType.SelectedIndex = 0;
if (guestType == "堂食用户")
{
this.ddlGuestType.SelectedIndex = 1;
}
else if (guestType == "手机用户")
{
this.ddlGuestType.SelectedIndex = 2;
}
if (guestType != "全部")//对结果集进行过滤
{
foreach (DataRow row in userOrders.OrderTbl.Rows)
{
if (this.guestType == "堂食用户")
{
if (row["UserName"].ToString() != "[堂食用户]")
{
row.Delete();
}
}
else if (this.guestType == "手机用户")
{
if (row["UserName"].ToString() == "[堂食用户]")
{
row.Delete();
}
}
}
userOrders.OrderTbl.AcceptChanges();
this.pager.TotalRecords = userOrders.OrderTbl.Rows.Count;
}
ddlSender.SelectedValue = this.sender;
}
else
{
this.ddlGuestType.Visible = false;
this.ddlSender.Visible = false;
}
this.rp_orderStatistics.DataSource = userOrders.OrderTbl;
this.rp_orderStatistics.DataBind();
this.lblPageCount.Text = string.Format("当前页共计<span class=\"colorG\">{0}</span>个 <span style=\"padding-left:10px;\">订单金额共计</span><span class=\"colorG\">{1}</span>元 <span style=\"padding-left:10px;\">订单毛利润共计</span><span class=\"colorG\">{2}</span>元 ", userOrders.OrderTbl.Rows.Count, Globals.FormatMoney(userOrders.TotalOfPage), Globals.FormatMoney(userOrders.ProfitsOfPage));
this.lblSearchCount.Text = string.Format("当前查询结果共计<span class=\"colorG\">{0}</span>个 <span style=\"padding-left:10px;\">订单金额共计</span><span class=\"colorG\">{1}</span>元 <span style=\"padding-left:10px;\">订单毛利润共计</span><span class=\"colorG\">{2}</span>元 ", userOrders.TotalCount, Globals.FormatMoney(userOrders.TotalOfSearch), Globals.FormatMoney(userOrders.ProfitsOfSearch));
}
