public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { Re_ThanhToan rpt = new Re_ThanhToan(); rpt.Site = this.Site; return(rpt); }
private void button54_Click(object sender, EventArgs e) { if(myCash1.listInvoiceItem.Rows.Count != 0) { FrmPay frmPay = new FrmPay(); frmPay.textBox1.Text = frmPay.textBox2.Text = String.Format("{0:0,0}", Convert.ToDecimal(myCash1.label_Total.Text)); if(frmPay.ShowDialog() == DialogResult.OK) { myCash1.invoiceTotal.Rows[0]["Amt_Tendered"] = frmPay.tienTra; myCash1.invoiceTotal.Rows[0]["Amt_Change"] = frmPay.tienThoi; myCash1.invoiceTotal.Rows[0]["Status"] = "C"; myCash1.invoiceTotal.Rows[0]["Payment_Method"] = frmPay.hinhThucTra; if(frmPay.hinhThucTra == "CA") { myCash1.invoiceTotal.Rows[0]["CA_Amount"] = Convert.ToDecimal(myCash1.label_Total.Text); } else if (frmPay.hinhThucTra == "CC") { myCash1.invoiceTotal.Rows[0]["CC_Amount"] = Convert.ToDecimal(myCash1.label_Total.Text); } else if (frmPay.hinhThucTra == "DC") { myCash1.invoiceTotal.Rows[0]["DC_Amount"] = Convert.ToDecimal(myCash1.label_Total.Text); } myCash1.invoiceTotal.Rows[0]["Cashier_ID"] = StaticClass.cashierId; getGui.DeleteInvoiceItemized(StaticClass.storeId, this.invoiceNum); if (myCash1.listInvoiceItem.Rows.Count == 0) { myCash1.invoiceTotal.Rows[0][15] = "V"; getGui.CloseTable(StaticClass.storeId, invoiceNum); } else { foreach (DataRow c in myCash1.listInvoiceItem.Rows) { getGui.UpdateInvoiceItemized(StaticClass.storeId, invoiceNum, c[2].ToString(), c[3].ToString(), c[12].ToString(), c[1].ToString(), c[6].ToString(), c[7].ToString(), c[8].ToString(), c[5].ToString(), c[19].ToString()); } } UpdateInvoiceTotals(); getGui.DeleteInvoiceOnhold(StaticClass.storeId,invoiceNum); SendToKitchen(); this.Dispose(); formLayout.FrmLayout_Load(null, null); formLogin.RequestMess("UpdateForm"); Printer printer = serviceGet.GetPrinterByName(StaticClass.storeId, StaticClass.stationId, "Hóa đơn"); if (!(printer == null || printer.Details == "NONE" || printer.Disable == true)) { Re_ThanhToan xxx = new Re_ThanhToan(); xxx.DataSourceConnections[0].SetConnection(StaticClass.serverName, StaticClass.databaseName, true); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterFieldDefinitions crParameterFieldDefinitions1; ParameterFieldDefinition crParameterFieldDefinition1; ParameterValues crParameterValues1 = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = StaticClass.storeId; crParameterFieldDefinitions = xxx.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["@Store_ID"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue1.Value = invoiceNum; crParameterFieldDefinitions1 = xxx.DataDefinition.ParameterFields; crParameterFieldDefinition1 = crParameterFieldDefinitions1["@Invoice_Number"]; crParameterValues1 = crParameterFieldDefinition1.CurrentValues; crParameterValues1.Clear(); crParameterValues1.Add(crParameterDiscreteValue1); xxx.PrintOptions.PrinterName = printer.Details; crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1); xxx.PrintOptions.ApplyPageMargins(new PageMargins(1, 2, 1, 0)); xxx.PrintToPrinter(1, false, 0, 0); } } } else { Alert.Show("Hóa đơn chưa có hàng",Color.Red); } }
private void printThanhToan(string invoiceNumber, string tableNumber) { Printer printer = serviceGet.GetPrinterByName(StaticClass.storeId, StaticClass.stationId, "Hóa đơn"); if (!(printer == null || printer.Details == "NONE" || printer.Disable == true)) { Re_ThanhToan xxx = new Re_ThanhToan(); string[] pa = { "@Store_ID", "@Invoice_Number", "table" }; object[] value = { StaticClass.storeId, invoiceNumber, tableNumber }; serviceGet.FillDataReport(xxx, pa, value, true); //xxx.PrintOptions.PrinterName = printer.Details; xxx.PrintOptions.ApplyPageMargins(new PageMargins(1, 2, 1, 0)); Utilities.Utils.Print(xxx, Printer.PrinterHoadon); //try //{ // xxx.PrintToPrinter(1, false, 0, 0); //} //catch (Exception) //{ // Alert.Show("Lỗi máy in", Color.Red); //} //Service.CashdrawerService.OpenCashDrawer1(printer.Details); xxx.Dispose(); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { Re_ThanhToan rpt = new Re_ThanhToan(); rpt.Site = this.Site; return rpt; }
private void printThanhToan(string invoiceNumber,string tableNumber,bool cashdrawer) { Printer printer = serviceGet.GetPrinterByName(StaticClass.storeId, StaticClass.stationId, "Hóa đơn"); if (!(printer == null || printer.Details == "NONE" || printer.Disable == true)) { //if (StaticClass.mode == "AUT") //{ // xxx.DataSourceConnections[0].SetConnection(StaticClass.serverName, StaticClass.databaseName, true); //} //else if (StaticClass.mode == "SQL") //{ // xxx.SetDatabaseLogon(StaticClass.userName, StaticClass.password, StaticClass.serverName, // StaticClass.databaseName,true); // xxx.DataSourceConnections[0].IntegratedSecurity = true; // //ConnectionInfo crConnectionInfo = new ConnectionInfo(); // //crConnectionInfo.ServerName = StaticClass.serverName; // //crConnectionInfo.DatabaseName = StaticClass.databaseName; // //crConnectionInfo.UserID = StaticClass.userName; // //crConnectionInfo.Password = StaticClass.password; // //crConnectionInfo.IntegratedSecurity = false; // //Tables crTables = xxx.Database.Tables; // //for (int j = 0; j < crTables.Count; j++) // //{ // // Table crTable = crTables[j]; // // TableLogOnInfo crTableLogOnInfo = crTable.LogOnInfo; // // crTableLogOnInfo.ConnectionInfo = crConnectionInfo; // // crTable.ApplyLogOnInfo(crTableLogOnInfo); // // crTable.Location = crConnectionInfo.DatabaseName + ".dbo." + crTable.Name; // //} //} //else //{ // return; //} //ParameterFieldDefinitions crParameterFieldDefinitions; //ParameterFieldDefinition crParameterFieldDefinition; //ParameterValues crParameterValues = new ParameterValues(); //ParameterFieldDefinitions crParameterFieldDefinitions1; //ParameterFieldDefinition crParameterFieldDefinition1; //ParameterValues crParameterValues1 = new ParameterValues(); //ParameterFieldDefinitions crParameterFieldDefinitions2; //ParameterFieldDefinition crParameterFieldDefinition2; //ParameterValues crParameterValues2 = new ParameterValues(); //ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); //ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue(); //ParameterDiscreteValue crParameterDiscreteValue2 = new ParameterDiscreteValue(); //crParameterDiscreteValue.Value = StaticClass.storeId; //crParameterFieldDefinitions = xxx.DataDefinition.ParameterFields; //crParameterFieldDefinition = crParameterFieldDefinitions["@Store_ID"]; //crParameterValues = crParameterFieldDefinition.CurrentValues; //crParameterValues.Clear(); //crParameterValues.Add(crParameterDiscreteValue); //crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); //crParameterDiscreteValue1.Value = invoiceNum; //crParameterFieldDefinitions1 = xxx.DataDefinition.ParameterFields; //crParameterFieldDefinition1 = crParameterFieldDefinitions1["@Invoice_Number"]; //crParameterValues1 = crParameterFieldDefinition1.CurrentValues; //crParameterValues1.Clear(); //crParameterValues1.Add(crParameterDiscreteValue1); //crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1); //crParameterDiscreteValue2.Value = tableName; //crParameterFieldDefinitions2 = xxx.DataDefinition.ParameterFields; //crParameterFieldDefinition2 = crParameterFieldDefinitions2["table"]; //crParameterValues2 = crParameterFieldDefinition2.CurrentValues; //crParameterValues2.Clear(); //crParameterValues2.Add(crParameterDiscreteValue2); //crParameterFieldDefinition2.ApplyCurrentValues(crParameterValues2); Re_ThanhToan xxx = new Re_ThanhToan(); string[] pa = { "@Store_ID", "@Invoice_Number", "table" }; object[] value = { StaticClass.storeId, invoiceNumber, tableNumber }; serviceGet.FillDataReport(xxx, pa, value, true); //xxx.PrintOptions.PrinterName = printer.Details; xxx.PrintOptions.ApplyPageMargins(new PageMargins(1, 2, 1, 0)); try { if(cashdrawer) { Service.CashdrawerService.OpenCashDrawer1(printer.Details); } } catch (Exception) { Alert.Show("Lỗi máy in", Color.Red); return; } Utilities.Utils.Print(xxx,Printer.PrinterHoadon); xxx.Dispose(); } }