protected void btnprint_click1(object sender, EventArgs e) { string url = ddllst.SelectedValue + ".aspx?print=1&pgid=" + ddllst.SelectedValue + "&refid=" + hfdid.Value; PDFGenerator obj = new PDFGenerator(); obj.Genratepdf(System.Configuration.ConfigurationManager.AppSettings["pdfcreatehostname"].ToString() + "Certificates/" + url, ddllst.SelectedItem.Text + ".pdf"); //shtml = shtml.Replace("Â", ""); //shtml = shtml.Replace("’", "'"); }
protected void Page_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); if (Request.QueryString.Count == 1) { dt = PersonLicensing.Utilities_Licensing.Getlabelsbyid(Request.QueryString[0].ToString()); } else { dt = PersonLicensing.Utilities_Licensing.Getlabels(Request.QueryString[0].ToString(), Request.QueryString[1].ToString(), Request.QueryString[2].ToString(), Request.QueryString[3].ToString(), Request.QueryString[4].ToString()); } // IEnumerable list = Enumerable.Range(1, dt.Rows.Count/30); // dtllst.DataSource = dt; // dtllst.DataBind(); int rem = dt.Rows.Count % 3; int div = dt.Rows.Count / 30 + 1; if (rem > 0) { for (int i = 3 - rem; i > 0; i--) { DataRow dr = dt.NewRow(); foreach (DataColumn dc in dt.Columns) { dr[dc.ColumnName] = ""; } dt.Rows.Add(dr); } } StringBuilder stb = new StringBuilder(); #region style stb.Append("<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:w='urn:schemas-microsoft-com:office:word' xmlns='http://www.w3.org/TR/REC-html40'><head> <!--[if gte mso 9]> <xml> <w:WordDocument> <w:View>Print</w:View> <w:Zoom>90</w:Zoom> <w:DoNotOptimizeForBrowser/> </w:WordDocument> </xml> <![endif]-->"); stb.Append(" <style>"); stb.Append("<!--"); stb.Append("/* Font Definitions */"); stb.Append("@font-face"); stb.Append("{font-family:Arial;"); stb.Append("panose-1:2 11 6 4 3 5 4 4 2 4;"); stb.Append("mso-font-charset:0;"); stb.Append("mso-generic-font-family:Arial;"); stb.Append("mso-font-pitch:variable;"); stb.Append("mso-font-signature:-520081665 -1073717157 41 0 66047 0;}"); stb.Append("@font-face"); stb.Append("{font-family:Arial;"); stb.Append("panose-1:2 11 6 4 3 5 4 4 2 4;"); stb.Append("mso-font-charset:0;"); stb.Append("mso-generic-font-family:Arial;"); stb.Append("mso-font-pitch:variable;"); stb.Append("mso-font-signature:-1593833729 1073750107 16 0 415 0;}"); stb.Append("/* Style Definitions */"); stb.Append("p.MsoNormal, li.MsoNormal, div.MsoNormal"); stb.Append("{mso-style-unhide:no;"); stb.Append("mso-style-qformat:yes;"); stb.Append("mso-style-parent:"); stb.Append("margin:0in;"); stb.Append("margin-bottom:.0001pt;"); stb.Append("mso-pagination:widow-orphan;"); stb.Append("font-size:9.0pt;"); stb.Append("mso-bidi-font-size:12.0pt;"); stb.Append("font-family:Arial,sans-serif);"); stb.Append("mso-fareast-font-family:Arial;"); stb.Append("mso-bidi-font-family:Arial;"); stb.Append("mso-ansi-language:EN-US;"); stb.Append("mso-fareast-language:EN-US;}"); stb.Append("p.MsoAcetate, li.MsoAcetate, div.MsoAcetate"); stb.Append("{mso-style-noshow:yes;"); stb.Append("mso-style-unhide:no;"); stb.Append("margin:0in;"); stb.Append("margin-bottom:.0001pt;"); stb.Append("mso-pagination:widow-orphan;"); stb.Append("font-size:8.0pt;"); stb.Append("font-family:Arial,sans-serif;"); stb.Append("mso-fareast-font-family:Arial;"); stb.Append("mso-ansi-language:EN-US;"); stb.Append("mso-fareast-language:EN-US;}"); stb.Append("p.Name, li.Name, div.Name"); stb.Append("{mso-style-name:Name;"); stb.Append("mso-style-unhide:no;"); stb.Append("margin-top:0in;"); stb.Append("margin-right:.2in;"); stb.Append("margin-bottom:0in;"); stb.Append("margin-left:.2in;text-transform:capitalize;"); stb.Append("margin-bottom:.0001pt;"); stb.Append("mso-pagination:widow-orphan;"); stb.Append("font-size:8.0pt;"); stb.Append("mso-bidi-font-size:8.0pt;"); stb.Append("font-family:Arial,sans-serif;"); stb.Append("mso-fareast-font-family:Arial;"); stb.Append("mso-bidi-font-family:Arial;"); stb.Append("mso-ansi-language:EN-US;"); stb.Append("mso-fareast-language:EN-US;"); stb.Append("mso-bidi-font-weight:normal;}"); stb.Append("p.Address, li.Address, div.Address"); stb.Append("{mso-style-name:Address;"); stb.Append("mso-style-unhide:no;"); stb.Append("mso-style-parent:Name;"); stb.Append("margin-top:0in;"); stb.Append("margin-right:.2in;"); stb.Append("margin-bottom:0in;"); stb.Append("margin-left:.2in;text-transform:capitalize;"); stb.Append("margin-bottom:.0001pt;"); stb.Append("mso-pagination:widow-orphan;"); stb.Append("font-size:8.0pt;"); stb.Append("mso-bidi-font-size:8.0pt;"); stb.Append("font-family:Arial,sans-serif;"); stb.Append("mso-fareast-font-family:Arial;"); stb.Append("mso-bidi-font-family:Arial;"); stb.Append("mso-ansi-language:EN-US;"); stb.Append("mso-fareast-language:EN-US;}"); stb.Append(".MsoChpDefault"); stb.Append("{mso-style-type:export-only;"); stb.Append("mso-default-props:yes;"); stb.Append("font-size:10.0pt;"); stb.Append("mso-ansi-font-size:10.0pt;"); stb.Append("mso-bidi-font-size:10.0pt;}"); stb.Append("@page WordSection1"); stb.Append("{size:8.5in 11.0in;"); stb.Append(" margin:.5in 13.6pt 0in 13.6pt;"); stb.Append("mso-header-margin:.5in;"); stb.Append("mso-footer-margin:.5in;"); stb.Append("mso-paper-source:4;}"); stb.Append("div.WordSection1"); stb.Append("{page:WordSection1;}"); stb.Append("</style>"); stb.Append("</head>"); stb.Append("<body>"); #endregion for (int page = 0; page < div; page++) { stb.Append(" <div class=WordSection1>"); stb.Append(" <table border=0 cellspacing=0 cellpadding=0 "); // stb.Append(" mso-border-insidev:.5pt solid windowtext'>"); for (int data = page * 30; data < ((page * 30) + 30) && data < dt.Rows.Count; data += 3) { stb.Append(" <tr style='height:1.0in'>"); stb.Append(" <td width=252 style='width:189.0pt;padding:0in .55pt 0in .55pt;height:1.0in'>"); stb.Append(" <p class=Name><span lang=EN-US>" + dt.Rows[data]["Name"].ToString().ToUpper() + "</span></p>"); if (dt.Rows[data]["Addr_line1"].ToString() != dt.Rows[data]["Addr_line2"].ToString() && dt.Rows[data]["Addr_line2"].ToString().Trim() != "") { stb.Append(" <p class=Address><span lang=EN-US>" + dt.Rows[data]["Addr_line1"].ToString().ToUpper() + "<br>" + dt.Rows[data]["Addr_line2"].ToString().ToUpper() + "</span></p>"); } else { stb.Append(" <p class=Address><span lang=EN-US>" + dt.Rows[data]["Addr_line1"].ToString().ToUpper() + "</span></p>"); } //stb.Append(" <p class=Address><span lang=EN-US>" + dt.Rows[data]["Addr_line2"].ToString() + "</span></p>"); stb.Append(" <p class=Address><span lang=EN-US>" + dt.Rows[data]["Addr_city"].ToString().ToUpper() + dt.Rows[data]["Addr_state"].ToString().ToUpper() + "<span"); stb.Append(" style='mso-spacerun:yes'> </span>" + dt.Rows[data]["Addr_zipcode"].ToString() + "</span></p>"); stb.Append(" </td>"); stb.Append(" <td width=12 style='width:9.0pt;"); stb.Append(" padding:0in .75pt 0in .75pt;height:1.0in'>"); stb.Append(" <p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>"); stb.Append(" </td>"); stb.Append(" <td width=252 style='width:189.0pt;"); stb.Append(" padding:0in .55pt 0in .55pt;height:1.0in'>"); stb.Append(" <p class=Name><span lang=EN-US>" + dt.Rows[data + 1]["Name"].ToString().ToUpper() + "</span></p>"); if (dt.Rows[data + 1]["Addr_line1"].ToString() != dt.Rows[data + 1]["Addr_line2"].ToString() && dt.Rows[data + 1]["Addr_line2"].ToString().Trim() != "") { stb.Append(" <p class=Address><span lang=EN-US>" + dt.Rows[data + 1]["Addr_line1"].ToString().ToUpper() + "<br>" + dt.Rows[data + 1]["Addr_line2"].ToString().ToUpper() + "</span></p>"); } else { stb.Append(" <p class=Address><span lang=EN-US>" + dt.Rows[data + 1]["Addr_line1"].ToString().ToUpper() + "</span></p>"); } //stb.Append(" <p class=Address><span lang=EN-US>" + dt.Rows[data + 1]["Addr_line2"].ToString() + "</span></p>"); stb.Append(" <p class=Address><span lang=EN-US>" + dt.Rows[data + 1]["Addr_city"].ToString().ToUpper() + dt.Rows[data + 1]["Addr_state"].ToString().ToUpper() + "<span"); stb.Append(" style='mso-spacerun:yes'> </span>" + dt.Rows[data + 1]["Addr_zipcode"].ToString() + "</span></p>"); stb.Append(" </td>"); stb.Append(" <td width=12 style='width:9.0pt;"); stb.Append(" padding:0in .55pt 0in .55pt;height:1.0in'>"); stb.Append(" <p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>"); stb.Append(" </td>"); stb.Append(" <td width=252 style='width:189.0pt;"); stb.Append(" padding:0in .55pt 0in .55pt;height:1.0in'>"); stb.Append(" <p class=Name><span lang=EN-US>" + dt.Rows[data + 2]["Name"].ToString().ToUpper() + "</span></p>"); if (dt.Rows[data + 2]["Addr_line1"].ToString() != dt.Rows[data + 2]["Addr_line2"].ToString() && dt.Rows[data + 2]["Addr_line2"].ToString().Trim() != "") { stb.Append(" <p class=Address><span lang=EN-US>" + dt.Rows[data + 2]["Addr_line1"].ToString().ToUpper() + "<br>" + dt.Rows[data + 2]["Addr_line2"].ToString().ToUpper() + "</span></p>"); } else { stb.Append(" <p class=Address><span lang=EN-US>" + dt.Rows[data + 2]["Addr_line1"].ToString().ToUpper() + "</span></p>"); } // stb.Append(" <p class=Address><span lang=EN-US>" + dt.Rows[data + 2]["Addr_line2"].ToString() + "</span></p>"); stb.Append(" <p class=Address><span lang=EN-US>" + dt.Rows[data + 2]["Addr_city"].ToString().ToUpper() + dt.Rows[data + 2]["Addr_state"].ToString().ToUpper() + "<span"); stb.Append(" style='mso-spacerun:yes'> </span>" + dt.Rows[data + 2]["Addr_zipcode"].ToString() + "</span></p>"); stb.Append(" </td>"); stb.Append(" </tr>"); } stb.Append("</table>"); stb.Append(" <p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>"); stb.Append(" </div>"); } stb.Append("</body>"); stb.Append("</html>"); // Response.Write(stb.ToString()); // stb.Append("<br><br><table style='margin-left:20px;margin-bottom:80px;table-layout:fixed' cellspacing='0' border='1' bordercolor='#000000' cellpadding='0'>"); // for (int i = 1; i <=dt.Rows.Count; i++) // { // if (i % 3 == 1) // stb.Append("<tr>"); // if (i % 3 == 0) // { // stb.Append("<td valign='top' width='320px' height='120px'>"+getformat(dt.Rows[i-1])+"</td>"); // stb.Append("</tr>"); // } // else // { // stb.Append("<td valign='top' width='320px' height='120px'>"+getformat(dt.Rows[i-1])+"</td><td width='20px'> </td>"); // } // if (i != 0 && i % 30 == 0) // { // stb.Append("</table>"); // stb.Append("<div style='page-break-before:always'><br><br><br></div>"); // stb.Append("<table style='margin-left:20px;margin-bottom:80px;table-layout:fixed' cellspacing='0' border='1' bordercolor='#000000' cellpadding='0'>"); // } // } // stb.Append("</table>"); //// for(int i=0;i<10;i++) // // stb.Append("<tr><td valign='top' width='390px' height='150px'>1</td><td width='20px'> </td><td valign='top' width='390px' height='150px'>2</td><td width='20px'> </td><td valign='top' width='390px' height='150px'>3</td></tr>"); // // Response.Write(stb.ToString()); PDFGenerator pdf = new PDFGenerator(); pdf.Genratewordtext(stb.ToString(), "Maillabels"); }