private void PrintOrderCancellation(string order_id, string job_id)
{
OrderCancellation report = new OrderCancellation();
try
{
report.DataDefinition.FormulaFields["order_id"].Text = "'" + order_id + "'";
foreach (DataRow r in kitchen_printers_dt.Rows)
{
report.PrintOptions.PrinterName = r["Printer"].ToString();
report.PrintToPrinter(1, false, 0, 0);
}
MySqlFunctions.SqlNonQuery("update print_jobs set executed_at = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "' " +
"where id = '" + job_id + "'", Program.GlobalConn);
}
catch (Exception ex)
{
MySqlFunctions.SqlNonQuery("update print_jobs set executed_at = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "', " +
" error = '" + MySql.Data.MySqlClient.MySqlHelper.EscapeString(ex.Message) + "' " +
"where id = '" + job_id + "'", Program.GlobalConn);
}
finally {
report.Dispose();
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
OrderCancellation rpt = new OrderCancellation();
rpt.Site = this.Site;
return(rpt);
}
