public ActionResult PrintView(string CPno, int QueueID) { BillPrint bill = new BillPrint(); bill = BL.PrintBill(QueueID, CPno); return(PartialView("PrintBill", bill)); }
public BillPrint PrintBill(int QueueId, string CPno) { try { SqlParameter[] sqlparam; sqlparam = new SqlParameter[3]; sqlparam[0] = new SqlParameter("@flag", "1"); sqlparam[1] = new SqlParameter("@QueueId", QueueId); sqlparam[2] = new SqlParameter("@CPno", CPno); DataSet ds = CommonFunction.GetDataSet("USP_Get_PrintBillingDetails", sqlparam, ""); BillPrint BP = new BillPrint(); List <Bill> lst = new List <Bill>(); if (ds != null && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { CommonFunction.ReflectSingleData(BP, dr); } DataTable dt1 = ds.Tables[1]; foreach (DataRow dr in dt1.Rows) { Bill Model = new Bill(); CommonFunction.ReflectSingleData(Model, dr); lst.Add(Model); } } BP.lstBill = lst; return(BP); } catch (Exception Ex) { throw Ex; } }
public ActionResult PrintDentalView(string Print) { Bal_ExpensesDetails BL = new Bal_ExpensesDetails(); BillPrint bill = new BillPrint(); int QueueID = Convert.ToInt16(Session["QueueID"].ToString()); string CPno = Session["CPno"].ToString(); bill = BL.PrintBill(QueueID, CPno); return(PartialView("PrintDental", bill)); }
public ActionResult PrintBill(string CPno, int QueueID) { try { BillPrint bill = new BillPrint(); bill = BL.PrintBill(QueueID, CPno); return(null); } catch (Exception ex) { throw ex; } }
/// <summary> /// 打印或预览发货单 /// </summary> /// <param name="invoiceList">整理过的发货清单</param> /// <param name="isPreview">true:预览,false:打印</param> private bool PrintInvoice(List <InvoiceListModelEdit> invoiceList, bool isPreview) { InvoiceModelPrint invoicePrintInfo; BillModel invoiceTemplate; //配置打印信息 if (isPreview) { decimal money = invoiceList.Sum(_func => _func.单价 * _func.数量); invoicePrintInfo = new InvoiceModelPrint() { 联系人 = 发货单.联系人, 金额 = money, 总页码 = Global.User.发货单总页码 + 1, 分页码 = _收货公司.发货单分页码 + 1, 打印时间 = DateTime.Now, Comment = 发货单.Comment, 公司名称 = _收货公司.称, 赊欠金额 = _收货公司.赊欠金额 + money }; } else { try { invoicePrintInfo = Global.SQL.PrintInvoice(发货单.ID, 已付款); } catch (Exception e) { SendMessage("打印失败", "SQL.PrintInvoice:" + e.Message); return(false); } } //获取模板 try { invoiceTemplate = XmlLinq.GetInvoiceTemplate(invoicePrintInfo, 已付款); } catch (Exception e) { SendMessage("打印失败", "XmlLinq.GetInvoiceTemplate:" + e.Message); return(false); } //打印 try { BillPrint <InvoiceListModelEdit> print = new BillPrint <InvoiceListModelEdit>(invoiceTemplate, invoiceList); if (isPreview) { print.PreviewPage(); } else { print.PrintPage(); } return(true); } catch (Exception e) { SendMessage("打印失败", "BillPrint:" + e.Message); return(false); } }
public IHttpActionResult getBillByTPId(int id) { BillPrint billPrint = this.transitPass.getBillByTPId(id); return(Json(billPrint)); }
async void PrintBill(string BillNo, bool IsNew = false) { try { using (SqlConnection conn = new SqlConnection(GlobalClass.TConnectionString)) { string PType = conn.ExecuteScalar <string>("SELECT PType From ParkingSales PS JOIN ParkingSalesDetails PSD ON PS.BillNo = PSD.BillNo AND PS.FYID = PSD.FYID WHERE PS.BillNo = @BillNo AND PS.FYID = @FYID", new { BillNo = BillNo, FYID = GlobalClass.FYID }); if (string.IsNullOrEmpty(PType)) { MessageBox.Show("Invalid Invoice No", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Exclamation); return; } else if (PType == "P") { MessageBox.Show("Entrance Invoice cannot be loaded in this interface.", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Exclamation); return; } var vSales = conn.Query <TParkingSales>("SELECT BillNo, FYID, TDate, TMiti, TTime, UserName [Description], BillTo, BILLTOADD, BILLTOPAN, Amount, Discount, NonTaxable, Taxable, VAT, GrossAmount, RefBillNo, TaxInvoice, Remarks, PS.UID, SESSION_ID, PID FROM ParkingSales PS JOIN Users U ON PS.UID = U.UID WHERE BillNo = @BillNo AND FYID = @FYID", new { BillNo = BillNo, FYID = GlobalClass.FYID }).FirstOrDefault(); var vSDetailList = new List <TParkingSalesDetails>( conn.Query <TParkingSalesDetails>("SELECT BillNo, FYID, PTYPE, ProdId, [Description], Quantity, Rate, Amount, Discount, NonTaxable, Taxable, VAT, NetAmount, Remarks FROM ParkingSalesDetails WHERE BillNo = @BillNo AND FYID = @FYID", new { BillNo = BillNo, FYID = GlobalClass.FYID })); string InWords = GlobalClass.GetNumToWords(conn, vSales.GrossAmount); string DuplicateCaption = (IsNew) ? String.Empty : GlobalClass.GetReprintCaption(BillNo); var pslip = new BillPrint { CompanyName = GlobalClass.CompanyName, CompanyAddress = GlobalClass.CompanyAddress, CompanyPan = GlobalClass.CompanyPan, PSales = vSales, PSDetails = vSDetailList, InWords = InWords, DuplicateCaption = DuplicateCaption }; if (IsNew) { pslip.InvoiceTitle = "TAX INVOICE"; pslip.Print(); pslip.InvoiceTitle = "INVOIVE"; pslip.Print(); } else { pslip.InvoiceTitle = "INVOIVE"; pslip.Print(); GlobalClass.SavePrintLog(BillNo, null, DuplicateCaption); GlobalClass.SetUserActivityLog("Voucher Sales Invoice", "Re-Print", WorkDetail: string.Empty, VCRHNO: BillNo, Remarks: "Reprinted : " + DuplicateCaption); if (MessageBox.Show("Would you like to reprint Vouchers as well?", MessageBoxCaption, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { VoucherSelection vs = conn.Query <VoucherSelection>("SELECT MIN(VoucherNo) VNOFrom, MAX(VoucherNo) VNOTo FROM ParkingVouchers WHERE BillNo = @BillNo AND FYID = @FYID", new { BillNo = BillNo, FYID = GlobalClass.FYID }).FirstOrDefault(); wVoucherSelect wVS = new wVoucherSelect() { DataContext = vs }; wVS.ShowDialog(); vp = new wVoucherPrintProgress() { DataContext = this }; vp.Show(); await PrintVouchers(BillNo, false, vs); vp.Close(); } } } } catch (Exception Ex) { MessageBox.Show(GlobalClass.GetRootException(Ex).Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error); } }