public ActionResult ExpertRenderToExcel(AuthorDetailQuery query, string strDict)
{
try
{
IAuthorPlatformFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorPlatformFacadeService>();
query.JournalID = CurAuthor.JournalID;
query.GroupID = 3;
IList <AuthorDetailEntity> list = service.GetAuthorDetailList(query);
if (list == null || list.Count <= 0)
{
return(Content("没有数据不能导出，请先进行查询！"));
}
strDict = Server.UrlDecode(strDict);
JavaScriptSerializer s = new JavaScriptSerializer();
Dictionary <string, object> JsonData = (Dictionary <string, object>)s.DeserializeObject(strDict);
IDictionary <string, string> dict = ((object[])JsonData.First().Value).Select(p => (Dictionary <string, object>)p).ToDictionary(p => p["key"].ToString(), q => q["value"].ToString());
//获取学历[Education]数据字典显示名-dict2[list[i].Education].ToString()
ISiteConfigFacadeService service2 = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
DictValueQuery query2 = new DictValueQuery();
query2.JournalID = CurAuthor.JournalID;
query2.DictKey = "Education";
IDictionary <int, string> dict2 = service2.GetDictValueDcit(query2);
//获取职称[JobTitle]数据字典显示名-dict3[list[i].JobTitle].ToString()
DictValueQuery query3 = new DictValueQuery();
query3.JournalID = CurAuthor.JournalID;
query3.DictKey = "JobTitle";
IDictionary <int, string> dict3 = service2.GetDictValueDcit(query3);
//替换字段内容
if (dict != null && dict.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
if (list[i].AuthorModel.GroupID == 2)
{
list[i].ReserveField2 = "作者";
}
if (list[i].AuthorModel.Status == 1)
{
list[i].ReserveField3 = "正常";
}
else
{
list[i].ReserveField3 = "已停用";
}
list[i].ReserveField4 = dict2[list[i].Education].ToString();
list[i].ReserveField5 = dict3[list[i].JobTitle].ToString();
}
}
//开始导出Excel
RenderToExcel.ExportListToExcel <AuthorDetailEntity>(list, dict
, null
, "专家信息_导出" + DateTime.Now.ToString("yyyy-MM-dd"), false, "xls");
return(Content("导出成功！"));
}
catch (Exception ex)
{
LogProvider.Instance.Error("导出专家信息出现异常：" + ex.Message);
return(Content("导出专家信息异常！"));
}
}
public ActionResult FinanceOutAccountRenderToExcel(ContributionInfoQuery query, string strDict)
{
try
{
IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>();
query.JournalID = CurAuthor.JournalID;
query.IsReport = true;
IList <FinanceAccountEntity> list = service.GetFinanceAccountPageList(query).ItemList;
if (list == null || list.Count <= 0)
{
return(Content("没有数据不能导出，请先进行查询！"));
}
strDict = Server.UrlDecode(strDict);
JavaScriptSerializer s = new JavaScriptSerializer();
Dictionary <string, object> JsonData = (Dictionary <string, object>)s.DeserializeObject(strDict);
IDictionary <string, string> dict = ((object[])JsonData.First().Value).Select(p => (Dictionary <string, object>)p).ToDictionary(p => p["key"].ToString(), q => q["value"].ToString());
IList <FinanceAccountEntity> outList = list.Select(o => { o.LayoutFee = Math.Round(o.LayoutFee / 100 * query.Percent); return(o); }).ToList <FinanceAccountEntity>();
RenderToExcel.ExportListToExcel <FinanceAccountEntity>(list, dict
, null
, "出款_导出" + DateTime.Now.ToString("yyyy-MM-dd"), false, "xls");
return(Content("导出成功！"));
}
catch (Exception ex)
{
LogProvider.Instance.Error("导出入款登记与通知信息出现异常：" + ex.Message);
return(Content("导出入款登记与通知信息异常！"));
}
}
public ActionResult IssueSubscribeToExcel(IssueSubscribeQuery query, string strDict)
{
try
{
strDict = Server.UrlDecode(strDict);
JavaScriptSerializer s = new JavaScriptSerializer();
Dictionary <string, object> JsonData = (Dictionary <string, object>)s.DeserializeObject(strDict);
IDictionary <string, string> dict = ((object[])JsonData["dict"]).Select(p => (Dictionary <string, object>)p).ToDictionary(p => p["key"].ToString(), q => q["value"].ToString());
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve <IIssueFacadeService>();
query.JournalID = CurAuthor.JournalID;
IList <IssueSubscribeEntity> list = service.GetIssueSubscribeList(query);
if (list == null || list.Count <= 0)
{
return(Content("没有数据不能导出，请先进行查询！"));
}
RenderToExcel.ExportListToExcel <IssueSubscribeEntity>(list, dict
, null
, "期刊订阅信息_导出" + DateTime.Now.ToString("yyyy-MM-dd"), false, "xls");
return(Content("导出成功！"));
}
catch (Exception ex)
{
LogProvider.Instance.Error("导出期刊订阅信息出现异常：" + ex.Message);
return(Content("导出期刊订阅信息异常！"));
}
}
public JsonResult ExpertPayMoneyRenderToExcel(WorkloadQuery query, string strDict)
{
try
{
IAuthorFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorFacadeService>();
IAuthorPlatformFacadeService serviceAuthorPlatform = ServiceContainer.Instance.Container.Resolve <IAuthorPlatformFacadeService>();
query.JournalID = CurAuthor.JournalID;
query.GroupID = query.GroupID;
IList <WorkloadEntity> list = service.GetWorkloadList(query);
IList <AuthorDetailEntity> listDetail = serviceAuthorPlatform.GetAuthorDetailList(new AuthorDetailQuery()
{
GroupID = 3, JournalID = JournalID
});
list = (from author in list join authorDetail in listDetail on author.AuthorID equals authorDetail.AuthorID into JionauthorDetail from authorDetail in JionauthorDetail.DefaultIfEmpty() select new WorkloadEntity()
{
RealName = author.RealName, LoginName = author.LoginName, AlreadyCount = author.AlreadyCount, WaitCount = author.WaitCount, ZipCode = authorDetail.ZipCode, Address = authorDetail.Address
}).ToList <WorkloadEntity>();
if (list == null || list.Count <= 0)
{
return(Json(new { flag = "error", msg = "没有数据不能导出，请先进行查询！" }));
}
strDict = Server.UrlDecode(strDict);
JavaScriptSerializer s = new JavaScriptSerializer();
Dictionary <string, object> JsonData = (Dictionary <string, object>)s.DeserializeObject(strDict);
IDictionary <string, string> dict = ((object[])JsonData.First().Value).Select(p => (Dictionary <string, object>)p).ToDictionary(p => p["key"].ToString(), q => q["value"].ToString());
RenderToExcel.ExportListToExcel <WorkloadEntity>(list, dict
, null
, "专家审稿费信息_导出" + DateTime.Now.ToString("yyyy-MM-dd"), false, "xls");
return(Json(new { flag = "success" }));
}
catch (Exception ex)
{
LogProvider.Instance.Error("导出作者信息出现异常：" + ex.Message);
return(Json(new { flag = "error", msg = "导出作者信息异常！" }));
}
}
public ActionResult ContributionAccountToExcel(ContributionAccountQuery query, string strDict)
{
string msg = string.Empty;
try
{
IAuthorPlatformFacadeService service = ServiceContainer.Instance.Container.Resolve <IAuthorPlatformFacadeService>();
query.JournalID = CurAuthor.JournalID;
query.IsReport = true;
strDict = Server.UrlDecode(strDict);
JavaScriptSerializer s = new JavaScriptSerializer();
Dictionary <string, object> JsonData = (Dictionary <string, object>)s.DeserializeObject(strDict);
IDictionary <string, string> dict = ((object[])JsonData.First().Value).Select(p => (Dictionary <string, object>)p).ToDictionary(p => p["key"].ToString(), q => q["value"].ToString());
IList <ContributionAccountEntity> list = new List <ContributionAccountEntity>();
IList <FlowStatusEntity> listFs = new List <FlowStatusEntity>();
IList <FlowContribution> listFc = new List <FlowContribution>();
switch (query.Kind)
{
case 4:
msg = "按过程稿统计收稿量";
listFs = GetContributionProcessList();
break;
case 3:
msg = "按退稿统计收稿量";
listFc = GetContributionReturnList();
break;
case 2:
msg = "按作者统计收稿量";
var pager = service.GetContributionAccountListByAuhor(query);
if (pager != null)
{
list = pager.ItemList;
}
break;
case 1:
msg = "按基金统计收稿量";
list = service.GetContributionAccountListByFund(query);
break;
case 0:
msg = "按时间统计收稿量";
list = service.GetContributionAccountListByYear(query);
break;
}
if (query.Kind == 1 || query.Kind == 2 || query.Kind == 0)
{
if (list == null || list.Count <= 0)
{
return(Content("没有数据不能导出，请先进行查询！"));
}
RenderToExcel.ExportListToExcel <ContributionAccountEntity>(list, dict
, null
, msg + "_导出" + DateTime.Now.ToString("yyyy-MM-dd"), false, "xls");
}
else if (query.Kind == 3)
{
if (listFc == null || listFc.Count <= 0)
{
return(Content("没有数据不能导出，请先进行查询！"));
}
RenderToExcel.ExportListToExcel <FlowContribution>(listFc, dict
, null
, msg + "_导出" + DateTime.Now.ToString("yyyy-MM-dd"), false, "xls");
}
else if (query.Kind == 4)
{
if (listFs == null || listFs.Count <= 0)
{
return(Content("没有数据不能导出，请先进行查询！"));
}
RenderToExcel.ExportListToExcel <FlowStatusEntity>(listFs, dict
, null
, msg + "_导出" + DateTime.Now.ToString("yyyy-MM-dd"), false, "xls");
}
return(Content("导出成功！"));
}
catch (Exception ex)
{
LogProvider.Instance.Error("导出" + msg + "出现异常：" + ex.Message);
return(Content("导出" + msg + "异常！"));
}
}
private void button4_Click(object sender, RoutedEventArgs e)
{
if (VM.QuotasView != null && VM.QuotasView.Count > 0)
{
System.Windows.Forms.SaveFileDialog _sfd = new System.Windows.Forms.SaveFileDialog
{
Filter = "Excel 2003 Files|xls.*",
FilterIndex = 1,
RestoreDirectory = true,
FileName = "增值税发票开收票明细.xls"
};
if (_sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string _localFilePath = _sfd.FileName; //获得文件路径
//获取文件名，不带路径
string _fileNameExt = _localFilePath.Substring(_localFilePath.LastIndexOf("\\", StringComparison.Ordinal) + 1);
DataTable dt = new DataTable();
dt.Columns.Add("BusinessPartner");
dt.Columns.Add("QuotaNo");
dt.Columns.Add("Commodity");
dt.Columns.Add("Brand");
dt.Columns.Add("Quantity");
dt.Columns.Add("ActualQuantity");
dt.Columns.Add("Price");
dt.Columns.Add("InvoicedQty");
dt.Columns.Add("InvoicedStatus");
string BusinessPartner = Client.Properties.Resources.Customer;
string QuotaNo = Client.Properties.Resources.QuotaNo;
string Commodity = Client.Properties.Resources.Commodity;
string Brand = Client.Properties.Resources.Brand;
string Quantity = Client.Properties.Resources.Quantity;
string ActualQuantity = Client.Properties.Resources.ActualQuantity;
string Price = Client.Properties.Resources.Price;
string InvoicedQty = Client.View.Reports.ResReport.InvoicedQty;
string InvoicedStatus = Client.Properties.Resources.InvoicedStatus;
DataRow dr = dt.NewRow();
dr["BusinessPartner"] = BusinessPartner;
dr["QuotaNo"] = QuotaNo;
dr["Commodity"] = Commodity;
dr["Brand"] = Brand;
dr["Quantity"] = Quantity;
dr["ActualQuantity"] = ActualQuantity;
dr["Price"] = Price;
dr["InvoicedQty"] = InvoicedQty;
dr["InvoicedStatus"] = InvoicedStatus;
dt.Rows.Add(dr);
//VM.QuotasView.
foreach (Quota quota in VM.QuotasView)
{
dr = dt.NewRow();
dr["BusinessPartner"] = quota.Contract.BusinessPartner.ShortName;
dr["QuotaNo"] = quota.QuotaNo;
dr["Commodity"] = quota.Commodity == null ? "" : quota.Commodity.Name;
dr["Brand"] = quota.Brand == null ? "" : quota.Brand.Name;
dr["Quantity"] = quota.Quantity;
dr["ActualQuantity"] = quota.VerifiedQuantity;
dr["Price"] = quota.FinalPrice;
dr["InvoicedQty"] = quota.VATInvoicedQuantity;
VATStatusConverter vatStatusConverter = new VATStatusConverter();
dr["InvoicedStatus"] = vatStatusConverter.Convert(quota.VATStatus, null, null, null);
dt.Rows.Add(dr);
}
RenderToExcel excelHelper = new RenderToExcel();
excelHelper.DataTableToExcel(dt, _localFilePath);
}
}
}
//导出Excel
private void button2_Click_1(object sender, RoutedEventArgs e)
{
if (VM.Ledgers != null && VM.Ledgers.Count > 0)
{
SaveFileDialog _sfd = new SaveFileDialog
{
Filter = "Excel 2003 Files|xls.*",
FilterIndex = 1,
RestoreDirectory = true,
FileName = "现货台账.xls"
};
if (_sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string _localFilePath = _sfd.FileName; //获得文件路径
//获取文件名，不带路径
string _fileNameExt = _localFilePath.Substring(_localFilePath.LastIndexOf("\\", StringComparison.Ordinal) + 1);
DataTable dt = new DataTable();
dt.Columns.Add("pQuotaNo");
dt.Columns.Add("pQuotaDate");
dt.Columns.Add("pQuotaSupplier");
dt.Columns.Add("metalName");
dt.Columns.Add("pBrandName");
dt.Columns.Add("pQtyStr");
dt.Columns.Add("pVerifiedQty");
dt.Columns.Add("pSalesQty");
dt.Columns.Add("pPrice");
dt.Columns.Add("pCurrency");
dt.Columns.Add("pPay");
dt.Columns.Add("pPaid");
dt.Columns.Add("pReceived");
dt.Columns.Add("pSettle");
dt.Columns.Add("pSettleCurrency");
dt.Columns.Add("Split");
dt.Columns.Add("sQuotaNo");
dt.Columns.Add("sQuotaDate");
dt.Columns.Add("sQuotaBuyer");
dt.Columns.Add("sBrandName");
dt.Columns.Add("sQtyStr");
dt.Columns.Add("sVerifiedQty");
dt.Columns.Add("sPrice");
dt.Columns.Add("sCurrency");
dt.Columns.Add("sReceive");
dt.Columns.Add("sReceived");
dt.Columns.Add("sPaid");
dt.Columns.Add("sSettle");
dt.Columns.Add("sSettleCurrency");
dt.Columns.Add("profit");
string PurchaseQuotaNo = ResReport.PurchaseQuotaNo;
string PurchaseDate = ResReport.PurchaseDate;
string Supplier = Properties.Resources.Supplier;
string Commodity = Properties.Resources.Commodity;
string Brand = Properties.Resources.Brand;
string QuotaQuantity = Properties.Resources.QuotaQuantity;
string ActualQuantity = Properties.Resources.ActualQuantity;
string SalesQty = Properties.Resources.SalesQty;
string Price = Properties.Resources.Price;
string Currency = Properties.Resources.Currency;
string Payable = Properties.Resources.Payable;
string PaidAmount = Properties.Resources.PaidAmount;
string Received = ResReport.Received;
string Settlement = Properties.Resources.Settlement;
string SettleCurrency = Properties.Resources.SettleCurrency;
string Split = "";
string SalesQuotaNo = ResReport.SalesQuotaNo;
string SalesDate = ResReport.SalesDate;
string Buyer = Properties.Resources.Buyer;
string Receivable = Properties.Resources.Receivable;
string PhysicalGrossProfit = ResReport.PhysicalGrossProfit;
DataRow dr = dt.NewRow();
dr["pQuotaNo"] = PurchaseQuotaNo;
dr["pQuotaDate"] = PurchaseDate;
dr["pQuotaSupplier"] = Supplier;
dr["metalName"] = Commodity;
dr["pBrandName"] = Brand;
dr["pQtyStr"] = QuotaQuantity;
dr["pVerifiedQty"] = ActualQuantity;
dr["pSalesQty"] = SalesQty;
dr["pPrice"] = Price;
dr["pCurrency"] = Currency;
dr["pPay"] = Payable;
dr["pPaid"] = PaidAmount;
dr["pReceived"] = Received;
dr["pSettle"] = Settlement;
dr["pSettleCurrency"] = SettleCurrency;
dr["Split"] = Split;
dr["sQuotaNo"] = SalesQuotaNo;
dr["sQuotaDate"] = SalesDate;
dr["sQuotaBuyer"] = Buyer;
dr["sBrandName"] = Brand;
dr["sQtyStr"] = QuotaQuantity;
dr["sVerifiedQty"] = ActualQuantity;
dr["sPrice"] = Price;
dr["sCurrency"] = Currency;
dr["sReceive"] = Receivable;
dr["sReceived"] = Received;
dr["sPaid"] = PaidAmount;
dr["sSettle"] = Settlement;
dr["sSettleCurrency"] = SettleCurrency;
dr["profit"] = PhysicalGrossProfit;
dt.Rows.Add(dr);
foreach (var item in VM.Ledgers)
{
dr = dt.NewRow();
decimal temp = 0;
dr["pQuotaNo"] = item.PQuotaNo;
dr["pQuotaDate"] = item.PQuotaDate.HasValue ? Convert.ToDateTime(item.PQuotaDate).ToString("yyyy-MM-dd") : "";
dr["pQuotaSupplier"] = item.PQuotaSupplier;
dr["metalName"] = item.MetalName;
dr["pBrandName"] = item.PBrandName;
dr["pQtyStr"] = item.PQty;
dr["pVerifiedQty"] = item.PVerifiedQty.HasValue ? item.PVerifiedQty.Value.ToString(RoundRules.STR_QUANTITY) : "";
dr["pSalesQty"] = item.PSalesQty.HasValue ? item.PSalesQty.Value.ToString(RoundRules.STR_QUANTITY) : "";
dr["pPrice"] = Decimal.TryParse(item.PPrice, out temp) ? temp.ToString(RoundRules.STR_PRICE) : item.PPrice;
dr["pCurrency"] = item.PCurrency;
dr["pPay"] = item.PPay.HasValue ? item.PPay.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["pPaid"] = item.PPaid.HasValue ? item.PPaid.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["pReceived"] = item.PReceived.HasValue ? item.PReceived.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["pSettle"] = item.PSettle.HasValue ? item.PSettle.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["pSettleCurrency"] = item.PSettleCurrency;
dr["Split"] = "";
dr["sQuotaNo"] = item.SQuotaNo;
dr["sQuotaDate"] = item.SQuotaDate.HasValue ? Convert.ToDateTime(item.SQuotaDate).ToString("yyyy-MM-dd") : "";
dr["sQuotaBuyer"] = item.SQuotaBuyer;
dr["sBrandName"] = item.SBrandName;
dr["sQtyStr"] = item.SQty;
dr["sVerifiedQty"] = item.SVerifiedQty.HasValue ? item.SVerifiedQty.Value.ToString(RoundRules.STR_QUANTITY) : "";
dr["sPrice"] = Decimal.TryParse(item.SPrice, out temp) ? temp.ToString(RoundRules.STR_PRICE) : item.SPrice;
dr["sCurrency"] = item.SCurrency;
dr["sReceive"] = item.SReceive.HasValue ? item.SReceive.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["sReceived"] = item.SReceived.HasValue ? item.SReceived.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["sPaid"] = item.SPaid.HasValue ? item.SPaid.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["sSettle"] = item.SSettle.HasValue ? item.SSettle.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["sSettleCurrency"] = item.SSettleCurrency;
dr["profit"] = item.Profit.HasValue ? item.Profit.Value.ToString(RoundRules.STR_AMOUNT) : "";
dt.Rows.Add(dr);
}
RenderToExcel excelHelper = new RenderToExcel();
excelHelper.DataTableToExcel(dt, _localFilePath);
}
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
VM.LoadVATInvoiceRequestLinesAll();
if(VM.VATInvoiceRequestLinesAll != null && VM.VATInvoiceRequestLinesAll.Count > 0)
{
System.Windows.Forms.SaveFileDialog _sfd = new System.Windows.Forms.SaveFileDialog
{
Filter = "Excel 2003 Files|xls.*",
FilterIndex = 1,
RestoreDirectory = true
};
if (VM.IsNeedApproved)
{
_sfd.FileName = "审核通过的开票申请.xls";
}
else
{
_sfd.FileName = "增值税开票申请列表.xls";
}
if (_sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string _localFilePath = _sfd.FileName; //获得文件路径
//获取文件名，不带路径
string _fileNameExt = _localFilePath.Substring(_localFilePath.LastIndexOf("\\", StringComparison.Ordinal) + 1);
DataTable dt = new DataTable();
dt.Columns.Add("Buyer");
dt.Columns.Add("InvoiceBP");
dt.Columns.Add("ApplyDate");
dt.Columns.Add("QuotaNo");
dt.Columns.Add("Commodity");
dt.Columns.Add("CommodityType");
dt.Columns.Add("Brand");
dt.Columns.Add("Quantity");
dt.Columns.Add("ApplyQuantity");
dt.Columns.Add("InvoicedQty");
dt.Columns.Add("AppliedAmount");
dt.Columns.Add("InvoicePrice");
string Buyer = Client.Properties.Resources.Buyer;
string InvoiceBP = ResVATInvoice.InvoiceBP;
string ApplyDate = Client.Properties.Resources.ApplyDate;
string QuotaNo = Client.Properties.Resources.QuotaNo;
string Commodity = Client.Properties.Resources.Commodity;
string CommodityType = Client.Properties.Resources.CommodityType;
string Brand = Client.Properties.Resources.Brand;
string Quantity = Client.Properties.Resources.Quantity;
string ApplyQuantity = Client.Properties.Resources.ApplyQuantity;
string InvoicedQty = "申请已开数量";
string AppliedAmount = Client.Properties.Resources.AppliedAmount;
string InvoicePrice = ResVATInvoice.InvoicePrice;
DataRow dr = dt.NewRow();
dr["Buyer"] = Buyer;
dr["InvoiceBP"] = InvoiceBP;
dr["ApplyDate"] = ApplyDate;
dr["QuotaNo"] = QuotaNo;
dr["Commodity"] = Commodity;
dr["CommodityType"] = CommodityType;
dr["Brand"] = Brand;
dr["Quantity"] = Quantity;
dr["ApplyQuantity"] = ApplyQuantity;
dr["InvoicedQty"] = InvoicedQty;
dr["AppliedAmount"] = AppliedAmount;
dr["InvoicePrice"] = InvoicePrice;
dt.Rows.Add(dr);
foreach(var line in VM.VATInvoiceRequestLinesAll)
{
dr = dt.NewRow();
dr["Buyer"] = line.VATInvoiceRequest.BusinessPartner.Name;
dr["InvoiceBP"] = line.VATInvoiceRequest.InternalCustomer.ShortName;
dr["ApplyDate"] = line.VATInvoiceRequest.RequestDate.HasValue ? Convert.ToDateTime(line.VATInvoiceRequest.RequestDate.Value).ToString("yyyy-MM-dd") : "";
dr["QuotaNo"] = line.Quota.QuotaNo;
dr["Commodity"] = line.Quota.Commodity.Name;
dr["CommodityType"] = line.Quota.CommodityType.Name;
dr["Brand"] = line.Quota.Brand == null ? "" : line.Quota.Brand.Name;
dr["Quantity"] = line.Quota.VerifiedQuantity.ToString(RoundRules.STR_QUANTITY);
dr["ApplyQuantity"] = line.RequestQuantity.HasValue ? line.RequestQuantity.Value.ToString(RoundRules.STR_QUANTITY) : "";
dr["InvoicedQty"] = line.VATInvoicedQuantity.HasValue ? line.VATInvoicedQuantity.Value.ToString(RoundRules.STR_QUANTITY) : "";
dr["AppliedAmount"] = line.RequestAmount.HasValue ? line.RequestAmount.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["InvoicePrice"] = line.RequestPrice.HasValue ? line.RequestPrice.Value.ToString(RoundRules.STR_PRICE) : "";
dt.Rows.Add(dr);
}
RenderToExcel excelHelper = new RenderToExcel();
excelHelper.DataTableToExcel(dt, _localFilePath);
}
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
VM.GetAllQuotas();
if (VM.Quotas != null && VM.Quotas.Count > 0)
{
System.Windows.Forms.SaveFileDialog _sfd = new System.Windows.Forms.SaveFileDialog
{
Filter = "Excel 2003 Files|xls.*",
FilterIndex = 1,
RestoreDirectory = true,
FileName = "合同.xls"
};
if (_sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string _localFilePath = _sfd.FileName; //获得文件路径
DataTable dt = new DataTable();
dt.Columns.Add("QuotaNo");
dt.Columns.Add("ExContractNo");
dt.Columns.Add("BusinessPartner");
dt.Columns.Add("BusinessPartnerFullName");
dt.Columns.Add("InternalCustomer");
dt.Columns.Add("InternalCustomerFullName");
dt.Columns.Add("Commodity");
dt.Columns.Add("TotalBrands");
dt.Columns.Add("Warehouse");
dt.Columns.Add("ContractUDF");
dt.Columns.Add("ImplementedDate");
dt.Columns.Add("Quantity");
dt.Columns.Add("VerQuantity");
dt.Columns.Add("StrPrice");
dt.Columns.Add("Currency");
dt.Columns.Add("PricingType");
dt.Columns.Add("PricingBasis");
dt.Columns.Add("PricingStartDate");
dt.Columns.Add("PricingEndDate");
dt.Columns.Add("ApproveStatus");
dt.Columns.Add("Approval");
dt.Columns.Add("ApprovalDetail");
dt.Columns.Add("RejectReason");
dt.Columns.Add("Description");
string QuotaNo = Properties.Resources.QuotaNo;
string ExContractNo = ResContract.OriginContractNo;
string BusinessPartner = Properties.Resources.BP;
string BusinessPartnerFullName = "业务伙伴全称";
string InternalCustomer = Properties.Resources.SignSide;
string InternalCustomerFullName = "内部客户全称";
string Commodity = Properties.Resources.Commodity;
string TotalBrands = Properties.Resources.Brand;
string Warehouse = Properties.Resources.Warehouse;
string ContractUDF = Properties.Resources.UDF;
string ImplementedDate = Properties.Resources.ImplementedDate;
string Quantity = Properties.Resources.Quantity;
string VerQuantity = "实际数量";
string StrPrice = Properties.Resources.Price;
string Currency = Properties.Resources.PricingCurrency;
string PricingType = Properties.Resources.PricingType;
string PricingBasis = Properties.Resources.PricingReference;
string PricingStartDate = Properties.Resources.PricingStartDate;
string PricingEndDate = Properties.Resources.PricingEndDate;
string ApproveStatus = Properties.Resources.ApprovalStatus;
string Approval = Properties.Resources.Approval;
string ApprovalDetail = Properties.Resources.ApprovalDetail;
string RejectReason = Properties.Resources.RejectReason;
string Description = "备注";
DataRow dr = dt.NewRow();
dr["QuotaNo"] = QuotaNo;
dr["ExContractNo"] = ExContractNo;
dr["BusinessPartner"] = BusinessPartner;
dr["BusinessPartnerFullName"] = BusinessPartnerFullName;
dr["InternalCustomer"] = InternalCustomer;
dr["InternalCustomerFullName"] = InternalCustomerFullName;
dr["Commodity"] = Commodity;
dr["TotalBrands"] = TotalBrands;
dr["Warehouse"] = Warehouse;
dr["ContractUDF"] = ContractUDF;
dr["ImplementedDate"] = ImplementedDate;
dr["Quantity"] = Quantity;
dr["VerQuantity"] = VerQuantity;
dr["StrPrice"] = StrPrice;
dr["Currency"] = Currency;
dr["PricingType"] = PricingType;
dr["PricingBasis"] = PricingBasis;
dr["PricingStartDate"] = PricingStartDate;
dr["PricingEndDate"] = PricingEndDate;
dr["ApproveStatus"] = ApproveStatus;
dr["Approval"] = Approval;
dr["ApprovalDetail"] = ApprovalDetail;
dr["RejectReason"] = RejectReason;
dr["Description"] = Description;
dt.Rows.Add(dr);
foreach (var item in VM.Quotas)
{
dr = dt.NewRow();
dr["QuotaNo"] = item.QuotaNo;
dr["ExContractNo"] = item.Contract.ExContractNo;
dr["BusinessPartner"] = item.Contract.BusinessPartner.ShortName;
dr["BusinessPartnerFullName"] = item.Contract.BusinessPartner.Name;
dr["InternalCustomer"] = item.Contract.InternalCustomer.ShortName;
dr["InternalCustomerFullName"] = item.Contract.InternalCustomer.Name;
dr["Commodity"] = item.Commodity.Name;
dr["TotalBrands"] = item.TotalBrands;
dr["Warehouse"] = item.Warehouse != null ? item.Warehouse.Name : "";
dr["ContractUDF"] = item.Contract.ContractUDF != null ? item.Contract.ContractUDF.Name : "";
dr["ImplementedDate"] = item.ImplementedDate.HasValue ? item.ImplementedDate.Value.ToString("yyyy-MM-dd") : "";
dr["Quantity"] = item.MoreBrandDetail;
dr["VerQuantity"] = item.VerifiedQuantity;
dr["StrPrice"] = item.FinalPrice;
dr["Currency"] = item.Currency.Name;
dr["PricingType"] = new PricingTypeConverter().Convert(item.PricingType, null, null, null);
dr["PricingBasis"] = item.PricingBasis.HasValue ? new PricingBasisConverter().Convert(item.PricingBasis, null, null, null) : "";
dr["PricingStartDate"] = item.PricingStartDate.HasValue ? item.PricingStartDate.Value.ToString("yyyy-MM-dd") : "";
dr["PricingEndDate"] = item.PricingEndDate.HasValue ? item.PricingEndDate.Value.ToString("yyyy-MM-dd") : "";
dr["ApproveStatus"] = new ApproveStatusConverter().Convert(item.ApproveStatus, null, null, null);
dr["ApprovalDetail"] = item.CustomerStrField1 + " " + item.CustomerStrField2;
dr["Approval"] = item.Approval != null ? item.Approval.Name : "";
dr["RejectReason"] = item.RejectReason;
dr["Description"] = item.Contract.Description;
dt.Rows.Add(dr);
}
RenderToExcel excelHelper = new RenderToExcel();
excelHelper.DataTableToExcel(dt, _localFilePath);
}
}
}
private void button3_Click(object sender, RoutedEventArgs e)
{
if (VM.FinalList != null && VM.FinalList.Count > 0)
{
System.Windows.Forms.SaveFileDialog _sfd = new System.Windows.Forms.SaveFileDialog
{
Filter = "Excel 2003 Files|xls.*",
FilterIndex = 1,
RestoreDirectory = true,
FileName = "应收应付报表.xls"
};
if (_sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string _localFilePath = _sfd.FileName; //获得文件路径
//获取文件名，不带路径
string _fileNameExt = _localFilePath.Substring(_localFilePath.LastIndexOf("\\", StringComparison.Ordinal) + 1);
DataTable dt = new DataTable();
dt.Columns.Add("QuotaNo");
dt.Columns.Add("Commodity");
dt.Columns.Add("Brand");
dt.Columns.Add("Date");
dt.Columns.Add("ActualQuantity");
dt.Columns.Add("Price");
dt.Columns.Add("PricingCurrency");
dt.Columns.Add("VatInvoiceQty");
dt.Columns.Add("VatInvoiceAmount");
dt.Columns.Add("Receivable");
dt.Columns.Add("Payable");
dt.Columns.Add("Received");
dt.Columns.Add("Paid");
dt.Columns.Add("AmountRemain");
dt.Columns.Add("SettleCurrency");
string QuotaNo = Client.Properties.Resources.QuotaNo;
string Commodity = Client.Properties.Resources.Commodity;
string Brand = Client.Properties.Resources.Brand;
string Date = Client.Properties.Resources.Date;
string ActualQuantity = Client.Properties.Resources.ActualQuantity;
string Price = Client.Properties.Resources.Price;
string PricingCurrency = Client.Properties.Resources.PricingCurrency;
string VatInvoiceQty = "开票数量";
string VatInvoiceAmount = "开票金额";
string Receivable = Client.Properties.Resources.Receivable;
string Payable = Client.Properties.Resources.Payable;
string Received = Client.View.Reports.ResReport.Received;
string Paid = Client.View.Reports.ResReport.Paid;
string AmountRemain = Client.View.Reports.ResReport.AmountRemain;
string SettleCurrency = Client.Properties.Resources.SettleCurrency;
DataRow dr = dt.NewRow();
dr["QuotaNo"] = QuotaNo;
dr["Commodity"] = Commodity;
dr["Brand"] = Brand;
dr["Date"] = Date;
dr["ActualQuantity"] = ActualQuantity;
dr["Price"] = Price;
dr["PricingCurrency"] = PricingCurrency;
dr["VatInvoiceQty"] = VatInvoiceQty;
dr["VatInvoiceAmount"] = VatInvoiceAmount;
dr["Receivable"] = Receivable;
dr["Payable"] = Payable;
dr["Received"] = Received;
dr["Paid"] = Paid;
dr["AmountRemain"] = AmountRemain;
dr["SettleCurrency"] = SettleCurrency;
dt.Rows.Add(dr);
foreach (var apar in VM.FinalList)
{
dr = dt.NewRow();
dr["QuotaNo"] = apar.QuotaNoStr;
dr["Commodity"] = apar.CommodityName;
dr["Brand"] = apar.BrandName;
dr["Date"] = apar.Date.HasValue ? Convert.ToDateTime(apar.Date.Value).ToString("yyyy-MM-dd") : "";
dr["ActualQuantity"] = apar.VerQty.HasValue ? apar.VerQty.Value.ToString(RoundRules.STR_QUANTITY) : "";
dr["Price"] = apar.NPrice.HasValue ? apar.NPrice.Value.ToString(RoundRules.STR_PRICE) : "";
dr["PricingCurrency"] = apar.PricingCurrency;
dr["VatInvoiceQty"] = apar.VatInvoiceQty.HasValue ? apar.VatInvoiceQty.Value.ToString(RoundRules.STR_QUANTITY) : "";
dr["VatInvoiceAmount"] = apar.VatInvoiceAmount.HasValue ? apar.VatInvoiceAmount.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["Receivable"] = apar.BReceived.HasValue ? apar.BReceived.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["Payable"] = apar.BPaid.HasValue ? apar.BPaid.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["Received"] = apar.SReceived.HasValue ? apar.SReceived.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["Paid"] = apar.SPaid.HasValue ? apar.SPaid.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["AmountRemain"] = apar.AmountRemain.HasValue ? apar.AmountRemain.Value.ToString(RoundRules.STR_AMOUNT) : "";
dr["SettleCurrency"] = apar.SettleCurrency;
dt.Rows.Add(dr);
}
RenderToExcel excelHelper = new RenderToExcel();
excelHelper.DataTableToExcel(dt, _localFilePath);
}
}
}
