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