public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport5 rpt = new CrystalReport5();
rpt.Site = this.Site;
return(rpt);
}
private void button1_Click(object sender, EventArgs e)
{
CrystalReport5 xxx = new CrystalReport5();
xxx.DataSourceConnections[0].SetConnection("THANH\\SQLEXPRESS","Po",true);
MessageBox.Show(xxx.DataSourceConnections[0].DatabaseName);
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 = "1001";
crParameterFieldDefinitions = xxx.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@Store_ID"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue1.Value = textBox1.Text;
crParameterFieldDefinitions1 = xxx.DataDefinition.ParameterFields;
crParameterFieldDefinition1 = crParameterFieldDefinitions1["@Invoice_Number"];
crParameterValues1 = crParameterFieldDefinition1.CurrentValues;
crParameterValues1.Clear();
crParameterValues1.Add(crParameterDiscreteValue1);
crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1);
xxx.PrintToPrinter(1, true, 1, 1);
crystalReportViewer1.ReportSource = xxx;
}
private void button51_Click(object sender, EventArgs e)
{
getGui.DeleteInvoiceItemized(StaticClass.storeId, this.invoiceNum);
if (myCash1.listInvoiceItem.Rows.Count == 0)
{
myCash1.invoiceTotal.Rows[0][15] = "V";
getGui.CloseTable(StaticClass.storeId, invoiceNum);
}
else
{
myCash1.invoiceTotal.Rows[0][57] = Convert.ToInt32(myCash1.invoiceTotal.Rows[0][57]) + 1;
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();
SendToKitchen();
if (myCash1.listInvoiceItem.Rows.Count != 0)
{
Printer printer = serviceGet.GetPrinterByName(StaticClass.storeId, StaticClass.stationId, "Hóa đơn");
if(!(printer == null || printer.Details == "NONE" || printer.Disable == true))
{
CrystalReport5 xxx = new CrystalReport5();
xxx.DataSourceConnections[0].SetConnection(StaticClass.serverName, StaticClass.databaseName, true);
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterValues crParameterValues = new ParameterValues();
ParameterFieldDefinitions crParameterFieldDefinitions1;
ParameterValues crParameterValues1 = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = StaticClass.storeId;
crParameterFieldDefinitions = xxx.DataDefinition.ParameterFields;
ParameterFieldDefinition crParameterFieldDefinition = crParameterFieldDefinitions["@Store_ID"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
crParameterDiscreteValue1.Value = invoiceNum;
crParameterFieldDefinitions1 = xxx.DataDefinition.ParameterFields;
ParameterFieldDefinition crParameterFieldDefinition1 = crParameterFieldDefinitions1["@Invoice_Number"];
crParameterValues1 = crParameterFieldDefinition1.CurrentValues;
crParameterValues1.Clear();
crParameterValues1.Add(crParameterDiscreteValue1);
crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1);
xxx.DataSourceConnections[0].SetConnection(StaticClass.serverName, StaticClass.databaseName, true);
xxx.PrintOptions.PrinterName = printer.Details;
xxx.PrintOptions.ApplyPageMargins(new PageMargins(1, 2, 1, 0));
xxx.PrintToPrinter(1, false, 0, 0);
}
}
this.Dispose();
formLayout.FrmLayout_Load(null, null);
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
CrystalReport5 rpt = new CrystalReport5();
rpt.Site = this.Site;
return rpt;
}
private void PrintTamtinh()
{
if (myCash1.listInvoiceItem.Rows.Count != 0)
{
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;
//}
//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);
CrystalReport5 xxx = new CrystalReport5();
string[] pa = { "@Store_ID", "@Invoice_Number", "table" };
object[] value = { StaticClass.storeId, invoiceNum, tableName };
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);
//}
xxx.Dispose();
}
}
}
private void button51_Click(object sender, EventArgs e)
{
getGui.DeleteInvoiceItemized(StaticClass.storeId, this.invoiceNum);
if (myCash1.listInvoiceItem.Rows.Count == 0)
{
myCash1.invoiceTotal.Rows[0][15] = "V";
getGui.CloseTable(StaticClass.storeId, invoiceNum);
}
else
{
myCash1.invoiceTotal.Rows[0][57] = Convert.ToInt32(myCash1.invoiceTotal.Rows[0][57]) + 1;
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());
}
}
UpdateInvoiceTotals();
if (myCash1.listInvoiceItem.Rows.Count != 0)
{
CrystalReport5 xxx = new CrystalReport5();
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);
crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1);
xxx.PrintToPrinter(1, true, 1, 1);
}
this.Dispose();
formLayout.FrmLayout_Load(null, null);
}