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