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