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