private void PrintOrderForKitchens(string order_id, string job_id, string title = "New Order") { NewOrderReport report = new NewOrderReport(); try { report.DataDefinition.FormulaFields["ReportTitle"].Text = "'" + title + "'"; foreach (DataRow r in kitchen_printers_dt.Rows) { NewOrderDataSet ds = generateNewOrderDataSet(order_id, r["Category"].ToString()); if (ds.OrderDetail.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() { NewOrderReport rpt = new NewOrderReport(); rpt.Site = this.Site; return(rpt); }