private void PrintOrderEdit(string edit_id, string job_id)
{
OrderEditReport report = new OrderEditReport();
try
{
foreach (DataRow r in kitchen_printers_dt.Rows)
{
OrderEditDataSet ds = generateOrderEditDataSet(edit_id, r["Category"].ToString());
if (ds.OrderEditDetails.Rows.Count > 0)
{
report.SetDataSource(ds);
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()
{
OrderEditReport rpt = new OrderEditReport();
rpt.Site = this.Site;
return(rpt);
}
