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