private MemoryStream PrintJobSheet(string orderNo, string jobType, string tripId)
{
XtraReport rpt = new XtraReport();
string path1 = string.Format("~/files/photos/");
string path2 = path1.Replace(' ', '_').Replace('\'', '_');
string pathx = path2.Substring(1);
string path3 = MapPath(path2);
string filename = string.Format(@"{0}.jpg", orderNo);
if (!Directory.Exists(path3))
{
Directory.CreateDirectory(path3);
}
string p = string.Format(@"~\files\photos\{0}", filename);
string e_file = HttpContext.Current.Server.MapPath(p);
DateTime now = DateTime.Now;
string file = string.Format(@"~\html\{0}", jobType.ToUpper());
string htmlName = string.Format(@"{0}.html", orderNo);
string httpPath = HttpContext.Current.Request.Url.Host.ToString() + "/html/" + jobType.ToUpper() + "/" + htmlName;
XtraReport rpt_barcode = new XtraReport();
rpt_barcode.LoadLayout(Server.MapPath(@"~\PagesContTrucking\Report\repx\DeliveryOrder_CRA.repx"));
rpt_barcode.DataSource = DocPrint.PrintJobSheet(orderNo, jobType, tripId);
set_signed_barcode(rpt_barcode, orderNo, httpPath, filename);
rpt_barcode.CreateDocument();
rpt_barcode.ExportToImage(e_file);
Dictionary <string, string> d = new Dictionary <string, string>();
string http_Photo_Path = "http://" + HttpContext.Current.Request.Url.Host.ToString() + "/files/photos/" + filename;
string value = string.Format(@"<img src='{0}' alt=''/>", http_Photo_Path);
d.Add("title", orderNo);
d.Add("content", value);
string temp = string.Format(@"~\html\template.html");
html.CreateHtml(temp, file, htmlName, d, "");
rpt.LoadLayout(Server.MapPath(@"~\PagesContTrucking\Report\repx\DeliveryOrder_CRA.repx"));
string sql = string.Format(@"select epodHardCopy from ctm_jobdet2 where Id={0}", tripId);
string hardCopy = SafeValue.SafeString(ConnectSql.ExecuteScalar(sql));
if (hardCopy == "HardCopy")
{
rpt.LoadLayout(Server.MapPath(@"~\PagesContTrucking\Report\repx\DO_HardCopy.repx"));
}
set_signed_barcode_byid(rpt, orderNo, tripId, httpPath, filename);
DataSet set = DocPrint.PrintJobSheet(orderNo, jobType, tripId);
DataTable Mast = set.Tables[0].Copy();
Mast.TableName = "Mast";
if (Mast.Rows.Count > 0)
{
string epodCB1 = SafeValue.SafeString(Mast.Rows[0]["EpodCB1"]);
string epodCB2 = SafeValue.SafeString(Mast.Rows[0]["EpodCB2"]);
string epodCB3 = SafeValue.SafeString(Mast.Rows[0]["EpodCB3"]);
string epodCB4 = SafeValue.SafeString(Mast.Rows[0]["EpodCB4"]);
string epodCB5 = SafeValue.SafeString(Mast.Rows[0]["EpodCB5"]);
string epodCB6 = SafeValue.SafeString(Mast.Rows[0]["EpodCB6"]);
DevExpress.XtraReports.UI.DetailBand details = rpt.Report.Bands["detailBand1"] as DevExpress.XtraReports.UI.DetailBand;
if (details != null)
{
DevExpress.XtraReports.UI.XRCheckBox ckb1 = details.FindControl("ckb1", false) as DevExpress.XtraReports.UI.XRCheckBox;
if (epodCB1 == "Yes")
{
ckb1.Checked = true;
}
DevExpress.XtraReports.UI.XRCheckBox ckb2 = details.FindControl("ckb2", false) as DevExpress.XtraReports.UI.XRCheckBox;
if (epodCB2 == "Yes")
{
ckb2.Checked = true;
}
DevExpress.XtraReports.UI.XRCheckBox ckb3 = details.FindControl("ckb3", false) as DevExpress.XtraReports.UI.XRCheckBox;
if (epodCB3 == "Yes")
{
ckb3.Checked = true;
}
DevExpress.XtraReports.UI.XRCheckBox ckb4 = details.FindControl("ckb4", false) as DevExpress.XtraReports.UI.XRCheckBox;
if (epodCB4 == "Yes")
{
ckb4.Checked = true;
}
DevExpress.XtraReports.UI.XRCheckBox ckb5 = details.FindControl("ckb5", false) as DevExpress.XtraReports.UI.XRCheckBox;
if (epodCB5 == "Yes")
{
ckb5.Checked = true;
}
DevExpress.XtraReports.UI.XRCheckBox ckb6 = details.FindControl("ckb6", false) as DevExpress.XtraReports.UI.XRCheckBox;
if (epodCB6 == "Yes")
{
ckb6.Checked = true;
}
}
}
rpt.DataSource = set;
System.IO.MemoryStream str = new MemoryStream();
rpt.CreateDocument();
rpt.ExportToPdf(str);
return(str);
}
