private void btnSelect_Click(object sender, EventArgs e) { IBLL.ICheckBLL bll = new BLL.CheckBLL(); var dt = bll.GetCheckInitSheets(new Model.ic_t_check_init() { check_status = "0" }); frmSelect frm = new frmSelect(); frm.dgv.AddColumn("sheet_no", "批次号", "", 110, 1, ""); frm.dgv.AddColumn("仓库", "仓库", "", 120, 1, ""); frm.dgv.AddColumn("begin_date", "开始日期", "", 100, 1, "yyyy-MM-dd"); frm.dgv.AddColumn("操作员", "操作员", "", 100, 1, ""); frm.dgv.AddColumn("memo", "备注", "", 150, 1, ""); frm.dgv.AddColumn("商品类别", "商品类别", "", 110, 1, ""); frm.Text = "选择盘点批次"; frm.tb = dt; this.txtSheet_no.Text = frm.SelectData("批次号:", "sheet_no"); SendKeys.Send("{Tab}"); if (!string.IsNullOrEmpty(this.txtSheet_no.Text)) { IOrder order = this; order.ShowOrder(this.txtSheet_no.Text); } }
private void bInvoiceNo_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { frmSelect frm = new frmSelect(false); if (frm.ShowDialog() == DialogResult.OK) { Server2Client sc = new Server2Client(); string dt = null; if (frm.RetVal == 0) { Sales s = new Sales(); sc = s.getProfitLoss(frm.DateOn); dt = "Date " + frm.DateOn.ToShortDateString(); } else { Sales s = new Sales(); sc = s.getProfitLoss(frm.DateFrom, frm.DateTo); dt = "Between " + frm.DateFrom.ToShortDateString() + " and " + frm.DateTo.ToShortDateString(); } rptPL rpt = new rptPL() { DataSource = sc.dataTable }; XRSummary gsv = new XRSummary(); XRSummary gbv = new XRSummary(); XRSummary gpf = new XRSummary(); rpt.lbDT.Text = dt; rpt.lbSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}"); rpt.lbSVL.DataBindings.Add("Text", null, "TotalSellingValue", "{0:C2}"); rpt.lbBVL.DataBindings.Add("Text", null, "TotalBuyingValue", "{0:C2}"); rpt.lbPFT.DataBindings.Add("Text", null, "Profit", "{0:C2}"); rpt.lbGSV.DataBindings.Add("Text", null, "TotalSellingValue", "{0:C2}"); rpt.lbGBV.DataBindings.Add("Text", null, "TotalBuyingValue", "{0:C2}"); rpt.lbGPF.DataBindings.Add("Text", null, "Profit", "{0:C2}"); gsv.FormatString = "{0:C2}"; gbv.FormatString = "{0:C2}"; gpf.FormatString = "{0:C2}"; gsv.Running = SummaryRunning.Report; gbv.Running = SummaryRunning.Report; gpf.Running = SummaryRunning.Report; rpt.lbGSV.Summary = gsv; rpt.lbGBV.Summary = gbv; rpt.lbGPF.Summary = gpf; dv.PrintingSystem = rpt.PrintingSystem; rpt.CreateDocument(true); } }
private void btnModificar_Click(object sender, RoutedEventArgs e) { frmSelect f = new frmSelect(); if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK) { MessageBox.Show("Se cerrará el programa para aplicar los cambios realizados.", "Mensaje", MessageBoxButton.OK, MessageBoxImage.Asterisk); System.Windows.Application.Current.Shutdown(); } }
private void button1_Click(object sender, EventArgs e) { frmSelect f = new frmSelect(); if (f.ShowDialog() == DialogResult.OK) { MessageBox.Show("Se cerrará el programa para aplicar los cambios"); Application.Exit(); } // f.Dispose(); }
void App_Startup(object sender, StartupEventArgs e) { if (!isPermited()) { clsBaseMensaje.cs_pxMsgEr("ERR20", ""); isInitialized = false; System.Windows.Application.Current.Shutdown(); } else { //Buscar la ruta de almacen de archivos de FEI. string ruta = new clsRegistry().Read("RUTA"); if (ruta == null) {//En caso no exista mostrar el formulario de seleccion de ruta. frmSelect f = new frmSelect(); if (f.ShowDialog() == DialogResult.OK) { //Si ingresa la ruta mostrar el inicion de sesion. //InicioSesion inicio = new InicioSesion(); //inicio.Show(); presentacion Presentacion_FEI = new presentacion(); Presentacion_FEI.Show(); } } else { //Iniciar configuracion actual y mostrar inicio de sesion. clsBaseConfiguracion configuracion = new clsBaseConfiguracion(); //Mostrar formulario de Inicio de Sesion. //InicioSesion inicio = new InicioSesion(); //inicio.Show(); presentacion Presentacion_FEI = new presentacion(); Presentacion_FEI.Show(); } } }
private void bPurchasedProducts_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { frmSelect frm = new frmSelect(); if (frm.ShowDialog() == DialogResult.OK) { wrPurchases.Server2Client sc; wrPurchases.wsPurchases p = new wrPurchases.wsPurchases(); rptPurchasedProducts rpt = new rptPurchasedProducts(); if (frm.RetVal == 0) { sc = new wrPurchases.Server2Client(); p = new wrPurchases.wsPurchases(); sc = p.getPurchasedProductsByDate(frm.DateOn); rpt.DataSource = sc.dataTable; rpt.lbTTL.Text = "Products purchased On " + frm.DateOn.ToShortDateString(); } else if (frm.RetVal == 1) { sc = new wrPurchases.Server2Client(); p = new wrPurchases.wsPurchases(); sc = p.getPurchasedProductsByDates(frm.DateFrom, frm.DateTo); rpt.DataSource = sc.dataTable; rpt.lbTTL.Text = "Products purchased Between " + frm.DateFrom.ToShortDateString() + " and " + frm.DateTo.ToShortDateString(); } else { sc = new wrPurchases.Server2Client(); p = new wrPurchases.wsPurchases(); sc = p.getPurchasedProductsByInvoice(frm.InvoiceNo); rpt.DataSource = sc.dataTable; rpt.lbTTL.Text = "Purchase detail of Invoice No " + frm.InvoiceNo; } XRSummary stt = new XRSummary(); XRSummary gtt = new XRSummary(); GroupField grp = new GroupField("PurchaseDate"); rpt.GroupHeader1.GroupFields.Add(grp); rpt.lbPDT.DataBindings.Add("Text", null, "PurchaseDate", "{0:dd-MM-yyyy}"); rpt.lbPNM.DataBindings.Add("Text", null, "ProductName"); rpt.lbBCD.DataBindings.Add("Text", null, "BarCode"); rpt.lbSVL.DataBindings.Add("Text", null, "BuyingValue", "{0:C2}"); rpt.lbQTY.DataBindings.Add("Text", null, "SumOfQuantity"); rpt.lbAMT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}"); rpt.lbSTT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}"); rpt.lbGTT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}"); stt.FormatString = "{0:C2}"; gtt.FormatString = "{0:C2}"; stt.Running = SummaryRunning.Group; gtt.Running = SummaryRunning.Report; rpt.lbSTT.Summary = stt; rpt.lbGTT.Summary = gtt; dv.PrintingSystem = rpt.PrintingSystem; rpt.CreateDocument(true); } }
private void bSoldProducts_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { frmSelect frm = new frmSelect(); if (frm.ShowDialog() == DialogResult.OK) { wrSales.Server2Client sc; wrSales.wsSales s; rptSoldProducts rpt = new rptSoldProducts(); wrSettings.wrSettings stg = new wrSettings.wrSettings(); double SVC = 0; if (frm.RetVal == 0) { sc = new wrSales.Server2Client(); s = new wrSales.wsSales(); sc = s.getSoldProductsByDate(frm.DateOn); SVC = stg.GetServicingByDate(frm.DateOn); rptProductSold r = new rptProductSold() { DataSource = sc.dataTable }; //rpt.DataSource = sc.dataTable; //SELECT Sale.InvoiceNo, Product.ProductName, GROUP_CONCAT(Product.BarCode) BarCode, SaleDetail.SellingValue, Sum(SaleDetail.Quantity) AS SumOfQuantity, Sale.Amount, Sale.Discount, Sale.Payment, Sale.Balance r.lbTTL.Text = "Products sold On " + frm.DateOn.ToShortDateString(); XRSummary tam = new XRSummary(); XRSummary tdc = new XRSummary(); XRSummary tpm = new XRSummary(); XRSummary tbl = new XRSummary(); XRSummary gam = new XRSummary(); XRSummary gdc = new XRSummary(); XRSummary gpm = new XRSummary(); XRSummary gbl = new XRSummary(); //GroupField grp = new GroupField("SaleDate"); //GroupField cnm = new GroupField("CustomerName"); GroupField sdt = new GroupField("SaleDate"); GroupField inv = new GroupField("InvoiceNo"); //rpt.GroupHeader1.GroupFields.Add(grp); //rpt.GroupHeader2.GroupFields.Add(cnm); r.grpSDT.GroupFields.Add(sdt); r.grpSDT.GroupFields.Add(inv); //r.sbnINV.Band. r.lbINV.DataBindings.Add("Text", null, "InvoiceNo"); r.lbSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}"); r.lbPNM.DataBindings.Add("Text", null, "ProductName"); r.lbBCD.DataBindings.Add("Text", null, "BarCode"); r.lbSVL.DataBindings.Add("Text", null, "SellingValue", "{0:C2}"); r.lbQTY.DataBindings.Add("Text", null, "SumOfQuantity"); r.lbAMT.DataBindings.Add("Text", null, "Amount", "{0:C2}"); r.lbDSC.DataBindings.Add("Text", null, "Discount", "{0:C2}"); r.lbPAM.DataBindings.Add("Text", null, "Payment", "{0:C2}"); r.lbBAL.DataBindings.Add("Text", null, "Balance", "{0:C2}"); r.lbTAM.DataBindings.Add("Text", null, "Amount", "{0:C2}"); r.lbTDC.DataBindings.Add("Text", null, "Discount", "{0:C2}"); r.lbTPM.DataBindings.Add("Text", null, "Payment", "{0:C2}"); r.lbTBL.DataBindings.Add("Text", null, "Balance", "{0:C2}"); r.lbGAM.DataBindings.Add("Text", null, "Amount", "{0:C2}"); r.lbGDC.DataBindings.Add("Text", null, "Discount", "{0:C2}"); r.lbGPM.DataBindings.Add("Text", null, "Payment", "{0:C2}"); r.lbGBL.DataBindings.Add("Text", null, "Balance", "{0:C2}"); tam.FormatString = "{0:C2}"; tdc.FormatString = "{0:C2}"; tpm.FormatString = "{0:C2}"; tbl.FormatString = "{0:C2}"; gam.FormatString = "{0:C2}"; gdc.FormatString = "{0:C2}"; gpm.FormatString = "{0:C2}"; gbl.FormatString = "{0:C2}"; tam.Running = SummaryRunning.Group; tdc.Running = SummaryRunning.Group; tpm.Running = SummaryRunning.Group; tbl.Running = SummaryRunning.Group; gam.Running = SummaryRunning.Report; gdc.Running = SummaryRunning.Report; gpm.Running = SummaryRunning.Report; gbl.Running = SummaryRunning.Report; r.lbTAM.Summary = tam; r.lbTDC.Summary = tdc; r.lbTPM.Summary = tpm; r.lbTBL.Summary = tbl; r.lbGAM.Summary = gam; r.lbGDC.Summary = gdc; r.lbGPM.Summary = gpm; r.lbGBL.Summary = gbl; r.lbSVC.Text = SVC.ToString("C2"); dv.PrintingSystem = r.PrintingSystem; r.CreateDocument(true); } else if (frm.RetVal == 1) { sc = new wrSales.Server2Client(); s = new wrSales.wsSales(); sc = s.getSoldProductsByDates(frm.DateFrom, frm.DateTo); SVC = stg.GetServicingByDates(frm.DateFrom, frm.DateTo); //rpt.DataSource = sc.dataTable; //rpt.lbTTL.Text = "Products sold Between " + frm.DateFrom.ToShortDateString() + " and " + frm.DateTo.ToShortDateString(); //XRSummary stt = new XRSummary(); //XRSummary gtt = new XRSummary(); //GroupField grp = new GroupField("SaleDate"); //rpt.GroupHeader1.GroupFields.Add(grp); //rpt.lbSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}"); //rpt.lbPNM.DataBindings.Add("Text", null, "ProductName"); //rpt.lbPID.DataBindings.Add("Text", null, "BarCode"); //rpt.lbSVL.DataBindings.Add("Text", null, "SellingValue", "{0:C2}"); //rpt.lbQTY.DataBindings.Add("Text", null, "Quantity"); //rpt.lbAMT.DataBindings.Add("Text", null, "Amount", "{0:C2}"); //rpt.lbSTT.DataBindings.Add("Text", null, "Amount", "{0:C2}"); //rpt.lbGTT.DataBindings.Add("Text", null, "Amount", "{0:C2}"); //stt.FormatString = "{0:C2}"; //gtt.FormatString = "{0:C2}"; //stt.Running = SummaryRunning.Group; //gtt.Running = SummaryRunning.Report; //rpt.lbSTT.Summary = stt; //rpt.lbGTT.Summary = gtt; //dv.PrintingSystem = rpt.PrintingSystem; //rpt.CreateDocument(true); rptProductSold r = new rptProductSold() { DataSource = sc.dataTable }; //rpt.DataSource = sc.dataTable; //SELECT Sale.InvoiceNo, Product.ProductName, GROUP_CONCAT(Product.BarCode) BarCode, SaleDetail.SellingValue, Sum(SaleDetail.Quantity) AS SumOfQuantity, Sale.Amount, Sale.Discount, Sale.Payment, Sale.Balance r.lbTTL.Text = "Products sold On " + frm.DateOn.ToShortDateString(); XRSummary tam = new XRSummary(); XRSummary tdc = new XRSummary(); XRSummary tpm = new XRSummary(); XRSummary tbl = new XRSummary(); XRSummary gam = new XRSummary(); XRSummary gdc = new XRSummary(); XRSummary gpm = new XRSummary(); XRSummary gbl = new XRSummary(); //GroupField grp = new GroupField("SaleDate"); //GroupField cnm = new GroupField("CustomerName"); GroupField sdt = new GroupField("SaleDate"); GroupField inv = new GroupField("InvoiceNo"); //rpt.GroupHeader1.GroupFields.Add(grp); //rpt.GroupHeader2.GroupFields.Add(cnm); r.grpSDT.GroupFields.Add(sdt); r.grpSDT.GroupFields.Add(inv); //r.sbnINV.Band. r.lbINV.DataBindings.Add("Text", null, "InvoiceNo"); r.lbSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}"); r.lbPNM.DataBindings.Add("Text", null, "ProductName"); r.lbBCD.DataBindings.Add("Text", null, "BarCode"); r.lbSVL.DataBindings.Add("Text", null, "SellingValue", "{0:C2}"); r.lbQTY.DataBindings.Add("Text", null, "SumOfQuantity"); r.lbAMT.DataBindings.Add("Text", null, "Amount", "{0:C2}"); r.lbDSC.DataBindings.Add("Text", null, "Discount", "{0:C2}"); r.lbPAM.DataBindings.Add("Text", null, "Payment", "{0:C2}"); r.lbBAL.DataBindings.Add("Text", null, "Balance", "{0:C2}"); r.lbTAM.DataBindings.Add("Text", null, "Amount", "{0:C2}"); r.lbTDC.DataBindings.Add("Text", null, "Discount", "{0:C2}"); r.lbTPM.DataBindings.Add("Text", null, "Payment", "{0:C2}"); r.lbTBL.DataBindings.Add("Text", null, "Balance", "{0:C2}"); r.lbGAM.DataBindings.Add("Text", null, "Amount", "{0:C2}"); r.lbGDC.DataBindings.Add("Text", null, "Discount", "{0:C2}"); r.lbGPM.DataBindings.Add("Text", null, "Payment", "{0:C2}"); r.lbGBL.DataBindings.Add("Text", null, "Balance", "{0:C2}"); tam.FormatString = "{0:C2}"; tdc.FormatString = "{0:C2}"; tpm.FormatString = "{0:C2}"; tbl.FormatString = "{0:C2}"; gam.FormatString = "{0:C2}"; gdc.FormatString = "{0:C2}"; gpm.FormatString = "{0:C2}"; gbl.FormatString = "{0:C2}"; tam.Running = SummaryRunning.Group; tdc.Running = SummaryRunning.Group; tpm.Running = SummaryRunning.Group; tbl.Running = SummaryRunning.Group; gam.Running = SummaryRunning.Report; gdc.Running = SummaryRunning.Report; gpm.Running = SummaryRunning.Report; gbl.Running = SummaryRunning.Report; r.lbTAM.Summary = tam; r.lbTDC.Summary = tdc; r.lbTPM.Summary = tpm; r.lbTBL.Summary = tbl; r.lbGAM.Summary = gam; r.lbGDC.Summary = gdc; r.lbGPM.Summary = gpm; r.lbGBL.Summary = gbl; r.lbSVC.Text = SVC.ToString("C2"); dv.PrintingSystem = r.PrintingSystem; r.CreateDocument(true); } else { sc = new wrSales.Server2Client(); s = new wrSales.wsSales(); //sc = s.getSoldByInvoice(frm.InvoiceNo); sc = s.getSoldProductsByInvoiceNo(frm.InvoiceNo); XRSummary total = new XRSummary(); rptCashMemo rpc = new rptCashMemo() { DataSource = sc.dataTable }; rpc.lblCNM.DataBindings.Add("Text", null, "CustomerName"); rpc.lblADR.DataBindings.Add("Text", null, "Address"); rpc.lblPHN.DataBindings.Add("Text", null, "Phone"); rpc.lblINV.DataBindings.Add("Text", null, "InvoiceNo"); rpc.lblSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}"); rpc.lblPNM.DataBindings.Add("Text", null, "ProductName"); rpc.lbSNO.DataBindings.Add("Text", null, "BarCode"); rpc.lblQTY.DataBindings.Add("Text", null, "Quantity"); rpc.lblPRC.DataBindings.Add("Text", null, "SellingValue", "{0:c}"); rpc.lblDSC.DataBindings.Add("Text", null, "Discount", "{0:C2}"); rpc.lblAMT.DataBindings.Add("Text", null, "Amount", "{0:c}"); rpc.lblTTL.DataBindings.Add("Text", null, "Amount", "{0:c}"); total.FormatString = "{0:C2}"; total.Running = SummaryRunning.Report; rpc.lblTTL.Summary = total; //rpt.lblTTL.Text = s.Amount.ToString("c2"); double dsc = 0; int amt = 0; for (int i = 0; i <= sc.dataTable.Rows.Count - 1; i++) { dsc += Convert.ToDouble(sc.dataTable.Rows[i].ItemArray[10]); amt += Convert.ToInt32(sc.dataTable.Rows[i].ItemArray[9]); } if (dsc <= 0) { rpc.xrLabel8.Visible = false; rpc.lblDSC.Visible = false; } rpc.lblAMW.Text = "Rupees " + Utils.NumbersToWords(Convert.ToInt32(amt)) + " only"; dv.PrintingSystem = rpc.PrintingSystem; rpc.CreateDocument(true); } } }
public void TestSelect() {//选择测试 frmSelect frm = new frmSelect(m_vtkfrom); frm.Show(); }
private void bSoldProducts_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { frmSelect frm = new frmSelect(); if (frm.ShowDialog() == DialogResult.OK) { Server2Client sc; Sales s; rptSoldProducts rpt = new rptSoldProducts(); if (frm.RetVal == 0) { sc = new Server2Client(); s = new Sales(); sc = s.getSoldProducts(frm.DateOn); rpt.DataSource = sc.dataTable; rpt.lbTTL.Text = "Products sold On " + frm.DateOn.ToShortDateString(); XRSummary stt = new XRSummary(); XRSummary gtt = new XRSummary(); GroupField grp = new GroupField("SaleDate"); rpt.GroupHeader1.GroupFields.Add(grp); rpt.lbSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}"); rpt.lbPNM.DataBindings.Add("Text", null, "ProductName"); rpt.lbPID.DataBindings.Add("Text", null, "BarCode"); rpt.lbSVL.DataBindings.Add("Text", null, "SumOfSellingValue", "{0:C2}"); rpt.lbQTY.DataBindings.Add("Text", null, "SumOfQuantity"); rpt.lbAMT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}"); rpt.lbSTT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}"); rpt.lbGTT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}"); stt.FormatString = "{0:C2}"; gtt.FormatString = "{0:C2}"; stt.Running = SummaryRunning.Group; gtt.Running = SummaryRunning.Report; rpt.lbSTT.Summary = stt; rpt.lbGTT.Summary = gtt; dv.PrintingSystem = rpt.PrintingSystem; rpt.CreateDocument(true); } else if (frm.RetVal == 1) { sc = new Server2Client(); s = new Sales(); sc = s.getSoldProducts(frm.DateFrom, frm.DateTo); rpt.DataSource = sc.dataTable; rpt.lbTTL.Text = "Products sold Between " + frm.DateFrom.ToShortDateString() + " and " + frm.DateTo.ToShortDateString(); XRSummary stt = new XRSummary(); XRSummary gtt = new XRSummary(); GroupField grp = new GroupField("SaleDate"); rpt.GroupHeader1.GroupFields.Add(grp); rpt.lbSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}"); rpt.lbPNM.DataBindings.Add("Text", null, "ProductName"); rpt.lbPID.DataBindings.Add("Text", null, "BarCode"); rpt.lbSVL.DataBindings.Add("Text", null, "SumOfSellingValue", "{0:C2}"); rpt.lbQTY.DataBindings.Add("Text", null, "SumOfQuantity"); rpt.lbAMT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}"); rpt.lbSTT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}"); rpt.lbGTT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}"); stt.FormatString = "{0:C2}"; gtt.FormatString = "{0:C2}"; stt.Running = SummaryRunning.Group; gtt.Running = SummaryRunning.Report; rpt.lbSTT.Summary = stt; rpt.lbGTT.Summary = gtt; dv.PrintingSystem = rpt.PrintingSystem; rpt.CreateDocument(true); } else { sc = new Server2Client(); s = new Sales(); sc = s.getSoldProducts(frm.InvoiceNo); XRSummary total = new XRSummary(); rptCashMemo rpc = new rptCashMemo() { DataSource = sc.dataTable }; rpc.lblCNM.DataBindings.Add("Text", null, "CustomerName"); rpc.lblADR.DataBindings.Add("Text", null, "Address"); rpc.lblPHN.DataBindings.Add("Text", null, "Phone"); rpc.lblINV.DataBindings.Add("Text", null, "InvoiceNo"); rpc.lblSDT.DataBindings.Add("Text", null, "SaleDate"); rpc.lblPNM.DataBindings.Add("Text", null, "ProductName"); rpc.lbSNO.DataBindings.Add("Text", null, "BarCode"); rpc.lblQTY.DataBindings.Add("Text", null, "Quantity"); rpc.lblPRC.DataBindings.Add("Text", null, "SellingValue", "{0:c}"); rpc.lblDSC.DataBindings.Add("Text", null, "Discount", "{0:C2}"); rpc.lblAMT.DataBindings.Add("Text", null, "Amount", "{0:c}"); rpc.lblTTL.DataBindings.Add("Text", null, "Payment", "{0:c}"); total.FormatString = "{0:C2}"; total.Running = SummaryRunning.Report; rpc.lblTTL.Summary = total; //rpt.lblTTL.Text = s.Amount.ToString("c2"); int amt = 0; for (int i = 0; i <= sc.dataTable.Rows.Count - 1; i++) { amt += Convert.ToInt32(sc.dataTable.Rows[i].ItemArray[9]); } rpc.lblAMW.Text = "Rupees " + Utils.NumbersToWords(Convert.ToInt32(amt)) + " only"; dv.PrintingSystem = rpc.PrintingSystem; rpc.CreateDocument(true); } } }