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