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