private void btnCreateReport_Click(object sender, System.EventArgs e) { ManagerHelper.CheckPrivilege(Privilege.ReconciOrdersDetailsExcel); string startDate = this.calendarStart.SelectedDate.ToString(); string EndSdate = this.calendarEnd.SelectedDate.ToString(); if (string.IsNullOrEmpty(startDate) || string.IsNullOrEmpty(EndSdate)) { this.ShowMsg("起止时间不能为空!", false); return; } System.TimeSpan ND = Convert.ToDateTime(EndSdate) - Convert.ToDateTime(startDate); double mday = ND.Days; if (mday > 31) { this.ShowMsg("查询起止时间不能大于31天!", false); return; } //获取搜索所有数据 PageIndex=0 为获取所有数据 DbQueryResult ExpressFeeDetails = MemberHelper.GetReconciliationExpressFeeDetails(new ReconciliationExpressFeeQuery { BeginTime = !this.dateStart.HasValue ? "" : this.dateStart.Value.ToString("yyyy-MM-dd HH:mm:ss"), EndTime = !this.dateEnd.HasValue ? "" : (this.dateEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59"), PageIndex = 0, PageSize = 0, Supplier = int.Parse(string.IsNullOrWhiteSpace(this.sysupperId) ? "0" : this.sysupperId) }); DataTable dtResult = (DataTable)ExpressFeeDetails.Data; if (dtResult == null || dtResult.Rows.Count == 0) { this.ShowMsg("没有数据!", false); return; } foreach (DataColumn cl in dtResult.Columns) { if (cl.ColumnName == "OrderId") { cl.ColumnName = "子订单编号"; } else if (cl.ColumnName == "SupplierName") { cl.ColumnName = "供应商"; } else if (cl.ColumnName == "SourceOrderId") { cl.ColumnName = "订单号"; } else if (cl.ColumnName == "TradingTime") { cl.ColumnName = "交易时间"; } else if (cl.ColumnName == "ExpressCompanyName") { cl.ColumnName = "快递公司"; } else if (cl.ColumnName == "ShipOrderNumber") { cl.ColumnName = "快递单号"; } else if (cl.ColumnName.ToLower().Trim() == "shippingdate") { cl.ColumnName = "发货时间"; } else if (cl.ColumnName.ToLower().Trim() == "adjustedfreight") { cl.ColumnName = "快递费用"; } } MemoryStream ms = NPOIExcelHelper.ExportToExcel(dtResult, "快递费用报表明细"); this.Page.Response.Clear(); this.Page.Response.Buffer = false; this.Page.Response.Charset = "GB2312"; //this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=ReconciliationOrdersDetailed.xlsx"); if (!(this.calendarStart.SelectedDate.HasValue && this.calendarEnd.SelectedDate.HasValue)) { this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=快递费用报表明细.xlsx"); } else { this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=快递费用报表明细_" + this.dateStart.Value.ToString("yyyyMMdd") + "-" + this.dateEnd.Value.ToString("yyyyMMdd") + ".xlsx"); } this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); this.Page.Response.ContentType = "application/octet-stream"; this.Page.EnableViewState = false; this.Page.Response.BinaryWrite(ms.ToArray()); ms.Dispose(); ms.Close(); EventLogs.WriteOperationLog(Privilege.ReconciOrdersDetailsExcel, string.Format(CultureInfo.InvariantCulture, "用户{0}生成对快递费用明细报告成功", new object[] { this.User.Identity.Name })); this.Page.Response.End(); }
private void btnCreateReport_Click(object sender, System.EventArgs e) { ManagerHelper.CheckPrivilege(Privilege.ReconciOrdersExcel); string startDate = this.calendarStart.SelectedDate.ToString(); string EndSdate = this.calendarEnd.SelectedDate.ToString(); if (string.IsNullOrEmpty(startDate) || string.IsNullOrEmpty(EndSdate)) { this.ShowMsg("起止时间不能为空!", false); return; } System.TimeSpan ND = Convert.ToDateTime(EndSdate) - Convert.ToDateTime(startDate); double mday = ND.Days; if (mday > 31) { this.ShowMsg("查询起止时间不能大于31天!", false); return; } DbQueryResult balanceDetailsNoPage = MemberHelper.ExportReconciliationOrders(new ReconciliationOrdersQuery { StartDate = this.dateStart, EndDate = this.dateEnd, SortBy = "TradingTime", SortOrder = SortAction.Desc, }); DataTable dtResult = (DataTable)balanceDetailsNoPage.Data; if (dtResult == null || dtResult.Rows.Count == 0) { this.ShowMsg("没有数据!", false); return; } MemoryStream ms = NPOIExcelHelper.ExportToExcel(dtResult, "对账单"); this.Page.Response.Clear(); this.Page.Response.Buffer = false; this.Page.Response.Charset = "GB2312"; //this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=ReconciliationOrders.xlsx"); if (!(this.calendarStart.SelectedDate.HasValue && this.calendarEnd.SelectedDate.HasValue)) { this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=对账订单报表.xlsx"); } else { this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=对账订单报表_" + this.dateStart.Value.ToString("yyyyMMdd") + "-" + this.dateEnd.Value.ToString("yyyyMMdd") + ".xlsx"); } this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); this.Page.Response.ContentType = "application/octet-stream"; this.Page.EnableViewState = false; this.Page.Response.BinaryWrite(ms.ToArray()); ms.Dispose(); ms.Close(); EventLogs.WriteOperationLog(Privilege.ReconciOrdersExcel, string.Format(CultureInfo.InvariantCulture, "用户{0}生成的对账订单报告成功", new object[] { this.User.Identity.Name })); this.Page.Response.End(); StringBuilder sbstr = new StringBuilder(); string orderid = string.Empty; string text = string.Empty; sbstr.Append("付款日期"); sbstr.Append(",订单号"); sbstr.Append(",实际金额"); sbstr.Append(",收款金额"); sbstr.Append(",退款金额"); sbstr.Append(",买家昵称"); sbstr.Append(",拍单时间"); sbstr.Append(",付款时间"); sbstr.Append(",商品总金额"); sbstr.Append(",订单金额"); sbstr.Append(",优惠金额"); sbstr.Append(",运费"); sbstr.Append(",税额"); sbstr.Append(",优惠券"); sbstr.Append(",现金劵"); sbstr.Append(",货到付款服务费"); sbstr.Append(",订单备注"); sbstr.Append(",买家留言"); sbstr.Append(",收货地址"); sbstr.Append(",收货人名称"); sbstr.Append(",收货国家"); sbstr.Append(",州/省"); sbstr.Append(",城市"); sbstr.Append(",区"); sbstr.Append(",邮编"); sbstr.Append(",联系电话"); sbstr.Append(",手机"); sbstr.Append(",买家选择物流"); sbstr.Append(",最晚发货时间"); sbstr.Append(",海外订单"); sbstr.Append(",是否货到付款"); sbstr.Append(",订单状态"); sbstr.Append(",发货快递单号"); sbstr.Append(",快递公司"); sbstr.Append(",货主Id"); sbstr.Append(",货主名称\r\n"); foreach (System.Data.DataRow dataRow in ((System.Data.DataTable)balanceDetailsNoPage.Data).Rows) { sbstr.Append(dataRow["TradingTime"]); sbstr.AppendFormat(",\"\t{0}\"", dataRow["OrderId"]); sbstr.AppendFormat(",{0}", dataRow["ActualAmount"]); sbstr.AppendFormat(",{0}", dataRow["TotalAmount"]); sbstr.AppendFormat(",{0}", dataRow["RefundAmount"]); sbstr.AppendFormat(",{0}", dataRow["RealName"]); sbstr.AppendFormat(",{0}", dataRow["OrderDate"]); sbstr.AppendFormat(",{0}", dataRow["PayDate"]); sbstr.AppendFormat(",{0}", dataRow["Amount"]); sbstr.AppendFormat(",{0}", dataRow["OrderTotal"]); sbstr.AppendFormat(",{0}", dataRow["DiscountAmount"]); sbstr.AppendFormat(",{0}", dataRow["AdjustedFreight"]); sbstr.AppendFormat(",{0}", dataRow["Tax"]); sbstr.AppendFormat(",{0}", dataRow["CouponValue"]); sbstr.AppendFormat(",{0}", dataRow["VoucherValue"]); sbstr.AppendFormat(",{0}", dataRow["PayCharge"]); sbstr.AppendFormat(",\"{0}\"", dataRow["ManagerRemark"]); sbstr.AppendFormat(",\"{0}\"", dataRow["Remark"]); sbstr.AppendFormat(",\"{0}\"", dataRow["Address"]); sbstr.AppendFormat(",\"{0}\"", dataRow["ShipTo"]); sbstr.AppendFormat(",\"{0}\"", dataRow["Country"]); sbstr.AppendFormat(",\"{0}\"", dataRow["Province"]); sbstr.AppendFormat(",\"{0}\"", dataRow["City"]); sbstr.AppendFormat(",\"{0}\"", dataRow["Area"]); sbstr.AppendFormat(",\"\t{0}\"", dataRow["ZipCode"]); sbstr.AppendFormat(",\"\t{0}\"", dataRow["TelPhone"]); sbstr.AppendFormat(",\"\t{0}\"", dataRow["CellPhone"]); sbstr.AppendFormat(",\"{0}\"", dataRow["ModeName"]); sbstr.AppendFormat(",\"{0}\"", dataRow["LatestDelivery"]); sbstr.AppendFormat(",\"{0}\"", dataRow["OverseasOrders"]); sbstr.AppendFormat(",\"{0}\"", dataRow["CashDelivery"]); sbstr.AppendFormat(",\"{0}\"", dataRow["OrderStatus"]); sbstr.AppendFormat(",\"\t{0}\"", dataRow["ShipOrderNumber"]); sbstr.AppendFormat(",\"{0}\"", dataRow["ExpressCompanyName"]); sbstr.AppendFormat(",{0}", dataRow["ownerId"]); sbstr.AppendFormat(",\"{0}\"", dataRow["ownername"]); sbstr.Append("\r\n"); } this.Page.Response.Clear(); this.Page.Response.Buffer = false; this.Page.Response.Charset = "GB2312"; //this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=ReconciliationOrders.csv"); if (!(this.calendarStart.SelectedDate.HasValue && this.calendarEnd.SelectedDate.HasValue)) { this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=对账订单报表.csv"); } else { this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=对账订单报表_" + this.dateStart.Value.ToString("yyyyMMdd") + "-" + this.dateEnd.Value.ToString("yyyyMMdd") + ".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(sbstr.ToString()); this.Page.Response.End(); }
private void btnCreateReport_Click(object sender, System.EventArgs e) { this.LoadParameters(); DbQueryResult countDownList = PromoteHelper.ExprtAdOrderInfoList(new GroupBuyQuery { OrderId = this.OrderId, starttime = this.StartTime.ToString(), endtime = this.EndTime.ToString(), keyword = this.KeyWord, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortBy = "Ordertime", SortOrder = SortAction.Desc }); DataTable dtResult = (DataTable)countDownList.Data; if (dtResult == null || dtResult.Rows.Count == 0) { this.ShowMsg("没有数据!", false); return; } foreach (DataColumn cl in dtResult.Columns) { switch (cl.ColumnName.ToLower()) { case "orderno": cl.ColumnName = "订单号"; break; case "ordertotal": cl.ColumnName = "订单总金额"; break; case "productname": cl.ColumnName = "商品名称"; break; case "barcode": cl.ColumnName = "商品条码"; break; case "sku": cl.ColumnName = "Sku编码"; break; case "itemadjustedprice": cl.ColumnName = "商品单价"; break; case "orderstatus": cl.ColumnName = "订单状态"; break; case "paymenttype": cl.ColumnName = "支付类型"; break; case "paymentstatus": cl.ColumnName = "付款状态"; break; case "ordertime": cl.ColumnName = "订单创建时间"; break; case "updatedate": cl.ColumnName = "订单修改时间"; break; } } MemoryStream ms = NPOIExcelHelper.ExportToExcel(dtResult, "广告订单"); this.Page.Response.Clear(); this.Page.Response.Buffer = false; this.Page.Response.Charset = "GB2312"; this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=广告订单.xlsx"); this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); this.Page.Response.ContentType = "application/octet-stream"; this.Page.EnableViewState = false; this.Page.Response.BinaryWrite(ms.ToArray()); ms.Dispose(); ms.Close(); EventLogs.WriteOperationLog(Privilege.ReconciOrdersDetailsExcel, string.Format(CultureInfo.InvariantCulture, "用户{0}广告订单导出明细成功", new object[] { this.User.Identity.Name })); this.Page.Response.End(); }
/// <summary> /// 导出活动商品信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnCreateReport_Click(object sender, System.EventArgs e) { DataTable dt = PromoteHelper.GetPromotionProducts(this.activityId); if (dt == null || dt.Rows.Count == 0) { this.ShowMsg("该活动下无商品!", false); return; } List <DataColumn> removeCl = new List <DataColumn>(); foreach (DataColumn cl in dt.Columns) { if (cl.ColumnName == "ProductId") { cl.ColumnName = "商品编号"; } else if (cl.ColumnName == "ProductName") { cl.ColumnName = "商品名称"; } else if (cl.ColumnName == "ProductCode") { cl.ColumnName = "商家编码"; } else if (cl.ColumnName == "Stock") { cl.ColumnName = "库存"; } else if (cl.ColumnName == "MarketPrice") { cl.ColumnName = "市场价"; } else if (cl.ColumnName == "SalePrice") { cl.ColumnName = "一口价"; } else if (cl.ColumnName == "SupplierId") { cl.ColumnName = "供应商编号"; } else if (cl.ColumnName == "SupplierName") { cl.ColumnName = "供应商名称"; } else { removeCl.Add(cl); } } if (removeCl.Count > 0) { foreach (DataColumn cl in removeCl) { dt.Columns.Remove(cl); } } MemoryStream ms = NPOIExcelHelper.ExportToExcel(dt, "对账单"); this.Page.Response.Clear(); this.Page.Response.Buffer = false; this.Page.Response.Charset = "GB2312"; this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=" + this.activityId + "_" + this.litPromotionName.Text + "促销活动商品.xlsx"); this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); this.Page.Response.ContentType = "application/octet-stream"; this.Page.EnableViewState = false; this.Page.Response.BinaryWrite(ms.ToArray()); ms.Dispose(); ms.Close(); this.Page.Response.End(); }
private void btnCreateReport_Click(object sender, System.EventArgs e) { if (this.calendarStartDate.SelectedDate.HasValue) { this.startDate = Convert.ToDateTime(this.calendarStartDate.SelectedDate.Value.ToString()); } if (this.calendarEndDate.SelectedDate.HasValue) { this.endDate = Convert.ToDateTime(this.calendarEndDate.SelectedDate.Value.ToString()); } if (this.dropType.SelectedValue.HasValue) { this.typeId = int.Parse(this.dropType.SelectedValue.ToString()); } if (this.ddlSupplier.SelectedValue.HasValue) { this.supplierId = int.Parse(this.ddlSupplier.SelectedValue.ToString()); } if (this.dropIsApproved.SelectedValue != "-1") { this.IsApproved = int.Parse(this.dropIsApproved.SelectedValue); } if (this.dropIsApprovedPrice.SelectedValue != "-1") { this.IsApprovedPrice = int.Parse(this.dropIsApprovedPrice.SelectedValue); } if (this.dropIsAllClassify.SelectedValue != "-1") { this.IsAllClassify = int.Parse(this.dropIsAllClassify.SelectedValue); } if (this.dropCategories.SelectedValue.HasValue) { this.categoryId = int.Parse(this.dropCategories.SelectedValue.ToString()); } if (this.ddlSupplier.SelectedValue.HasValue) { this.supplierId = int.Parse(this.ddlSupplier.SelectedValue.ToString()); } ProductQuery productQuery = new ProductQuery { Keywords = this.txtSearchText.Text, ProductCode = this.txtSKU.Text, BarCode = this.txt_BarCode.Text, CategoryId = categoryId, PageSize = 1000000, PageIndex = 1, SortOrder = SortAction.Desc, SortBy = "DisplaySequence", StartDate = this.startDate, BrandId = this.dropBrandList.SelectedValue.HasValue ? this.dropBrandList.SelectedValue : null, TagId = this.dropTagList.SelectedValue.HasValue ? this.dropTagList.SelectedValue : null, TypeId = this.typeId, SaleStatus = this.saleStatus, EndDate = this.endDate, ImportSourceId = this.ddlImportSourceType.SelectedValue.HasValue ? this.ddlImportSourceType.SelectedValue : null, IsApproved = this.IsApproved, IsApprovedPrice = this.IsApprovedPrice, IsAllClassify = this.IsAllClassify, SupplierId = this.supplierId }; if (this.categoryId.HasValue) { productQuery.MaiCategoryPath = CatalogHelper.GetCategory(this.categoryId.Value).Path; } Globals.EntityCoding(productQuery, true); DbQueryResult products = ProductHelper.GetProducts(productQuery, false); DataTable dtResult = (DataTable)products.Data; if (dtResult == null || dtResult.Rows.Count == 0) { this.ShowMsg("没有数据!", false); return; } foreach (DataColumn cl in dtResult.Columns) { switch (cl.ColumnName.ToLower()) { case "productname": cl.ColumnName = "商品名称"; break; case "barcode": cl.ColumnName = "商品条码"; break; case "productcode": cl.ColumnName = "商品编码"; break; case "stock": cl.ColumnName = "库存"; break; case "costprice": cl.ColumnName = "成本"; break; case "saleprice": cl.ColumnName = "商品价格"; break; case "salestatus": cl.ColumnName = "商品状态"; break; case "isapproved": cl.ColumnName = "审核状态"; break; case "isapprovedprice": cl.ColumnName = "审核价状态"; break; case "isallclassify": cl.ColumnName = "备案状态"; break; case "cnarea": cl.ColumnName = "原产地"; break; case "suppliername": cl.ColumnName = "供应商名称"; break; case "productid": cl.ColumnName = "商品ID"; break; } } //导出带图片 //Export(dtResult); MemoryStream ms = NPOIExcelHelper.ExportToExcel(dtResult, "供应商商品明细"); this.Page.Response.Clear(); this.Page.Response.Buffer = false; this.Page.Response.Charset = "GB2312"; this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=供应商商品明细.xlsx"); this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); this.Page.Response.ContentType = "application/octet-stream"; this.Page.EnableViewState = false; this.Page.Response.BinaryWrite(ms.ToArray()); ms.Dispose(); ms.Close(); EventLogs.WriteOperationLog(Privilege.ReconciOrdersDetailsExcel, string.Format(CultureInfo.InvariantCulture, "用户{0}生成供应商商品明细成功", new object[] { this.User.Identity.Name })); this.Page.Response.End(); }