/// <summary> /// 貨運單 delivery_store=42 即 到店取貨 才須匯出貨運單 /// </summary> public void GetShopbillsPDF() { string deliver_id = string.Empty; if (!string.IsNullOrEmpty(Request.Params["deliver_id"])) { deliver_id = Request.Params["deliver_id"]; } string ticket_id = string.Empty; string fticket_id = string.Empty; ; if (!string.IsNullOrEmpty(Request.Params["ticket_id"])) { ticket_id = Request.Params["ticket_id"]; ticket_id = ticket_id.Remove(ticket_id.LastIndexOf(',')); string[] ticket_ids = ticket_id.Split(','); if (ticket_ids.Length > 0) { fticket_id = ticket_ids[0]; } else { fticket_id = ticket_id; } } int i = 0;//用來計算表格數量,來分頁 _DeliverDetailMgr = new DeliverDetailMgr(mySqlConnectionString); DataTable bills = _DeliverDetailMgr.GetWayBills(deliver_id, ticket_id); BaseFont bf = BaseFont.CreateFont("C:\\WINDOWS\\Fonts\\simsun.ttc,1", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED); iTextSharp.text.Font fontChinese = new iTextSharp.text.Font(bf, 8, iTextSharp.text.Font.UNDERLINE, iTextSharp.text.BaseColor.RED); iTextSharp.text.Font font = new iTextSharp.text.Font(bf, 12, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 string filename = string.Empty; if (string.IsNullOrEmpty(ticket_id)) { filename = "shopbills_T" + deliver_id.PadLeft(8, '0') + ".pdf"; } else { filename = "shopbills_T" + fticket_id.PadLeft(8, '0') + ".pdf"; } Document document = new Document(PageSize.A4, (float)5, (float)5, (float)20, (float)0.5); string newPDFName = Server.MapPath(excelPath) + filename; PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(newPDFName, FileMode.Create)); document.Open(); #region 條形碼 foreach (DataRow dr in bills.Rows) { #region 條形碼要顯示的內容 string code1 = string.Empty; string csvuser = "******"; string deliver_stno = dr["deliver_stno"].ToString(); string delivercode = "0".PadLeft(11 - dr["deliver_id"].ToString().Length, '0'); if (deliver_stno.Length >= 1) { switch (deliver_stno.Substring(0, 1)) { case "F": code1 = "1" + csvuser + "00"; break; case "K": code1 = "3" + csvuser + "00"; break; case "L": code1 = "2" + csvuser + "00"; break; default: break; } } code1 += delivercode + dr["deliver_id"].ToString(); int checkcode = 0; for (int j = 0; j < code1.Length; j++) { checkcode += int.Parse(code1.Substring(j, 1)); } checkcode = checkcode % 43; string[] checkcodemap = {"0","1","2","3","4","5","6","7","8","9","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S", "T","U","V","W","X","Y","Z","-",".","SP","$","/","+","%" }; code1 += checkcodemap.GetValue(checkcode).ToString(); string code2 = string.Empty; code2 = csvuser + delivercode.Substring(0, 3) + "963"; string code3 = string.Empty; string nreceivable = string.Empty; string ndeliver_id = string.Empty; ndeliver_id = (delivercode + dr["deliver_id"].ToString()).Substring(3, 8); nreceivable = "0".PadLeft(5 - dr["receivable"].ToString().Length, '0') + dr["receivable"].ToString(); if (dr["order_payment"].ToString() == "20") { code3 = ndeliver_id + "1" + nreceivable; } else { code3 = ndeliver_id + "3" + nreceivable; } int basenum = 0;//奇數 int evennum = 0;//偶數 for (int k = 0; k < code2.Length; k++) { if ((k + 1) % 2 == 1) { basenum += int.Parse(code2.Substring(k, 1)); } else { evennum += int.Parse(code2.Substring(k, 1)); } } for (int l = 0; l < code3.Length; l++) { if ((l + 1) % 2 == 1) { basenum += int.Parse(code3.Substring(l, 1)); } else { evennum += int.Parse(code3.Substring(l, 1)); } } basenum = basenum % 11; evennum = evennum % 11; if (basenum == 10) { basenum = 1; } if (evennum == 10) { evennum = 9; } else if (evennum == 0) { evennum = 8; } code3 += basenum.ToString() + evennum.ToString(); #endregion BarCode.Code128 _Code = new BarCode.Code128(); _Code.ValueFont = new System.Drawing.Font("宋体", 20); System.Drawing.Bitmap imgTemp1 = _Code.GetCodeImage((!string.IsNullOrEmpty(dr["dcrono"].ToString())) ? dr["dcrono"].ToString() : "0", BarCode.Code128.Encode.Code128A); imgTemp1.Save(System.AppDomain.CurrentDomain.BaseDirectory + "\\ImportUserIOExcel\\" + "Code.gif", System.Drawing.Imaging.ImageFormat.Gif); iTextSharp.text.Image IMG1 = iTextSharp.text.Image.GetInstance(Server.MapPath("../ImportUserIOExcel/Code.gif")); IMG1.ScaleToFit(200, 30); Chunk ck1 = new Chunk(IMG1, 0, 0); //图片可设置 偏移 _Code = new BarCode.Code128(); //如果條形碼顯示的內容過長的話,一定要注意設置的字體大小,字體過大,內容不會顯示 _Code.ValueFont = new System.Drawing.Font("宋体", 18); System.Drawing.Bitmap imgTemp2 = _Code.GetCodeImage(code1, BarCode.Code128.Encode.Code128A); imgTemp2.Save(System.AppDomain.CurrentDomain.BaseDirectory + "\\ImportUserIOExcel\\" + "Code.gif", System.Drawing.Imaging.ImageFormat.Gif); iTextSharp.text.Image IMG2 = iTextSharp.text.Image.GetInstance(Server.MapPath("../ImportUserIOExcel/Code.gif")); IMG2.ScaleToFit(200, 30); Chunk ck2 = new Chunk(IMG2, 0, 0); //图片可设置 偏移 _Code = new BarCode.Code128(); _Code.ValueFont = new System.Drawing.Font("宋体", 20); System.Drawing.Bitmap imgTemp3 = _Code.GetCodeImage(code2, BarCode.Code128.Encode.Code128A); imgTemp3.Save(System.AppDomain.CurrentDomain.BaseDirectory + "\\ImportUserIOExcel\\" + "Code.gif", System.Drawing.Imaging.ImageFormat.Gif); iTextSharp.text.Image IMG3 = iTextSharp.text.Image.GetInstance(Server.MapPath("../ImportUserIOExcel/Code.gif")); IMG3.ScaleToFit(200, 30); Chunk ck3 = new Chunk(IMG3, 0, 0); //图片可设置 偏移 _Code = new BarCode.Code128(); _Code.ValueFont = new System.Drawing.Font("宋体", 18); System.Drawing.Bitmap imgTemp4 = _Code.GetCodeImage(code3, BarCode.Code128.Encode.Code128A); imgTemp4.Save(System.AppDomain.CurrentDomain.BaseDirectory + "\\ImportUserIOExcel\\" + "Code.gif", System.Drawing.Imaging.ImageFormat.Gif); iTextSharp.text.Image IMG4 = iTextSharp.text.Image.GetInstance(Server.MapPath("../ImportUserIOExcel/Code.gif")); IMG4.ScaleToFit(200, 30); Chunk ck4 = new Chunk(IMG4, 0, 0); //图片可设置 偏移 #endregion if (i % 3 == 0 && i != 0) { document.NewPage(); } string stnm_1 = string.Empty; string stnm_2 = string.Empty; string stnm = dr["stnm"].ToString(); if (dr["deliver_stno"].ToString().Length >= 1) { switch (dr["deliver_stno"].ToString().Substring(0, 1)) { case "F": if (stnm.Length * 3 >= 6) { stnm_1 = stnm.Substring(0, 6 / 3); } else { stnm_1 = stnm.Substring(0, stnm.Length); } if (stnm.Length * 3 >= 40) { stnm_2 = stnm.Substring(6 / 3, 40 / 3); } else { if (stnm.Length * 3 >= 6) { stnm_2 = stnm.Substring(6 / 3, stnm.Length - 6 / 3); } } break; case "K": if (stnm.Length * 3 >= 4) { stnm_1 = stnm.Substring(0, 4 / 3); } else { stnm_1 = stnm.Substring(0, stnm.Length); } if (stnm.Length * 3 >= 40) { stnm_2 = stnm.Substring(2 / 3, 40 / 3); } else { if (stnm.Length * 3 > 2) { stnm_2 = stnm.Substring(2 / 3, stnm.Length - 2 / 3); } } break; case "L": if (stnm.Length * 3 >= 10) { stnm_1 = stnm.Substring(0, 10 / 3); } else { stnm_1 = stnm.Substring(0, stnm.Length); } if (stnm.Length * 3 >= 40) { stnm_2 = stnm.Substring(9 / 3, 40 / 3); } else { if (stnm.Length * 3 >= 9) { stnm_2 = stnm.Substring(9 / 3, stnm.Length - 9 / 3); } } break; default: break; } } PdfPTable totaltable = new PdfPTable(3); totaltable.WidthPercentage = 100; totaltable.SetWidths(new int[] { 40, 2, 58 }); PdfPTable table = new PdfPTable(3); #region 左邊框 table.SetWidths(new int[] { 25, 15, 60 }); table.DefaultCell.DisableBorderSide(1); table.DefaultCell.DisableBorderSide(2); table.DefaultCell.DisableBorderSide(4); table.DefaultCell.DisableBorderSide(8); PdfPCell cell; font = new iTextSharp.text.Font(bf, 14, iTextSharp.text.Font.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑 cell = new PdfPCell(new PdfPCell(new Phrase(dr["dcrono"].ToString(), font))); cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_MIDDLE; table.AddCell(cell); cell = new PdfPCell(new Phrase(" 提貨人:" + dr["delivery_name"].ToString(), font)); cell.Colspan = 2; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); cell = new PdfPCell(new Phrase(stnm_1 + "\n" + stnm_2, font)); cell.Colspan = 2; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); cell = new PdfPCell(new Phrase(ck1)); cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_MIDDLE; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); cell = new PdfPCell(new Phrase(ck2)); cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; //cell.VerticalAlignment = Element.ALIGN_MIDDLE; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); cell.Colspan = 3; table.AddCell(cell); font = new iTextSharp.text.Font(bf, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 cell = new PdfPCell(new Phrase("廠商出貨編號:" + dr["deliver_id"].ToString(), font)); cell.Colspan = 3; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); cell = new PdfPCell(new Phrase("金額:" + dr["receivable"].ToString() + "元", font)); cell.HorizontalAlignment = Element.ALIGN_LEFT; cell.Colspan = 3; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); cell = new PdfPCell(new Phrase("吉甲地在地好物 www.gigade100.com", font)); cell.HorizontalAlignment = Element.ALIGN_LEFT; cell.Colspan = 3; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); cell = new PdfPCell(new Phrase("客服專線:(02) 2783-4997", font)); cell.HorizontalAlignment = Element.ALIGN_LEFT; cell.Colspan = 3; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); cell = new PdfPCell(new Phrase("若需退貨請消費者聯繫上述電子商務網站\n\n\n\n\n\n", font)); cell.HorizontalAlignment = Element.ALIGN_LEFT; cell.Colspan = 3; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); font = new iTextSharp.text.Font(bf, 14, iTextSharp.text.Font.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑 cell = new PdfPCell(new PdfPCell(new Phrase("D10", font))); cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_MIDDLE; table.AddCell(cell); cell = new PdfPCell(); cell.Colspan = 2; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); #endregion totaltable.AddCell(table); cell = new PdfPCell(); cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(8); totaltable.AddCell(cell); #region 右邊 table = new PdfPTable(6); table.SetWidths(new int[] { 20, 20, 37, 10, 1, 12 }); table.DefaultCell.DisableBorderSide(1); table.DefaultCell.DisableBorderSide(2); table.DefaultCell.DisableBorderSide(4); table.DefaultCell.DisableBorderSide(8); table.DefaultCell.UseAscender = true; table.HorizontalAlignment = Element.ALIGN_CENTER; //table.AddCell(new Phrase(dr["order_payment"].ToString() == "20" ? "取貨付款" : "取貨不付款", font)); cell = new PdfPCell(new PdfPCell(new Phrase(dr["order_payment"].ToString() == "20" ? " 取貨付款" : " 取貨不付款", font))); cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_MIDDLE; cell.Colspan = 3; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); cell = new PdfPCell(new PdfPCell(new Phrase("D10", font))); //cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_MIDDLE; table.AddCell(cell); cell = new PdfPCell(new Phrase()); if (dr["order_payment"].ToString() == "20") { cell.Rowspan = 6; } else { cell.Rowspan = 7; } cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_MIDDLE; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); string delivery_name = string.Empty; for (int k = 0; k < dr["delivery_name"].ToString().Length; k++) { delivery_name += dr["delivery_name"].ToString()[k] + "\n"; } cell = new PdfPCell(new Phrase("吉\n甲\n地\n\n" + delivery_name, font)); if (dr["order_payment"].ToString() == "20") { cell.Rowspan = 6; } else { cell.Rowspan = 7; } cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_MIDDLE; cell.DisableBorderSide(1); cell.DisableBorderSide(2); //cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); cell = new PdfPCell(new Phrase(ck3)); cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_MIDDLE; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); cell.Colspan = 5; table.AddCell(cell); cell = new PdfPCell(new Phrase(ck4)); cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); cell.Colspan = 5; table.AddCell(cell); if (dr["order_payment"].ToString() == "20") { font = new iTextSharp.text.Font(bf, 16, iTextSharp.text.Font.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑 Phrase p = new Phrase("*應付金額:" + dr["receivable"].ToString() + "元*\n\n", font); font = new iTextSharp.text.Font(bf, 12, iTextSharp.text.Font.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑 p.Add(new Phrase("消費者簽名:____________________\n\n\n\n\n", font)); cell = new PdfPCell(p); cell.Colspan = 5; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); } else { Phrase p = new Phrase(); font = new iTextSharp.text.Font(bf, 14, iTextSharp.text.Font.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑 p.Add(new Phrase(" *憑身分證件正本領貨*\n\n", font)); font = new iTextSharp.text.Font(bf, 12, iTextSharp.text.Font.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑 p.Add(new Phrase(" 消費者簽名:____________________\n\n", font)); p.Add(new Phrase(" 消費者身分證末四碼\n", font)); cell = new PdfPCell(p); cell.Colspan = 5; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); PdfPTable stable = new PdfPTable(4); stable.SetTotalWidth(new float[] { 20, 20, 20, 20 }); stable.DefaultCell.FixedHeight = 10; stable.AddCell(new Phrase()); stable.AddCell(new Phrase()); stable.AddCell(new Phrase()); stable.AddCell(new Phrase()); //p.Add(new Phrase("請核對證件\n並 簽 名", font)); cell = new PdfPCell(stable); cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); cell = new PdfPCell(new Phrase("請核對證件\n並 簽 名\n", font)); //cell.AddElement(new Phrase("請核對證件\n並 簽 名", font)); cell.Colspan = 4; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; table.AddCell(cell); } font = new iTextSharp.text.Font(bf, 12, iTextSharp.text.Font.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑 cell = new PdfPCell(new Phrase("\n門市結帳人員簽名:____________________", font)); cell.Colspan = 5; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); table.AddCell(cell); string estimated_delivery_date = (!string.IsNullOrEmpty(dr["estimated_delivery_date"].ToString())) ? DateTime.Parse(dr["estimated_delivery_date"].ToString()).ToString("yyyy/MM/dd") : ""; cell = new PdfPCell(new PdfPCell(new Phrase(dr["deliver_stno"].ToString(), font))); cell.HorizontalAlignment = Element.ALIGN_CENTER; table.AddCell(cell); cell = new PdfPCell(new Phrase(" " + estimated_delivery_date, font)); cell.Colspan = 2; cell.DisableBorderSide(1); cell.DisableBorderSide(2); cell.DisableBorderSide(4); cell.DisableBorderSide(8); //cell.HorizontalAlignment = Element.ALIGN_LEFT; table.AddCell(cell); cell = new PdfPCell(new PdfPCell(new Phrase(dr["dcrono"].ToString(), font))); cell.HorizontalAlignment = Element.ALIGN_CENTER; table.AddCell(cell); table.AddCell(""); //cell = new PdfPCell(new Phrase("11111111111", font)); //cell.Colspan = 5; //table.AddCell(cell); totaltable.AddCell(table); totaltable.SpacingAfter = 25f; #endregion document.Add(totaltable); } document.Close(); Response.Clear(); Response.Charset = "gb2312"; Response.ContentEncoding = System.Text.Encoding.UTF8; // Response.AddHeader("Content-Disposition", "attach-ment;filename=" + System.Web.HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8) + ".pdf "); Response.AddHeader("Content-Disposition", "attach-ment;filename=" + filename); Response.WriteFile(newPDFName); }
/// <summary> /// 貨運單 delivery_store=17 即 吉甲地車隊貨到付款 才須匯出貨運單 /// </summary> public void GetCarWaybillsPDF() { _DeliverDetailMgr = new DeliverDetailMgr(mySqlConnectionString); string deliver_id = string.Empty; if (!string.IsNullOrEmpty(Request.Params["deliver_id"])) { deliver_id = Request.Params["deliver_id"]; } string ticketid = string.Empty; if (!string.IsNullOrEmpty(Request.Params["ticket_id"])) { ticketid = Request.Params["ticket_id"]; ticketid = ticketid.Remove(ticketid.LastIndexOf(',')); } DataTable bills = _DeliverDetailMgr.GetWayBills(deliver_id, ticketid); string estimated_delivery_date = string.Empty; string sestimated_arrival_period = string.Empty; string estimated_arrival_period = string.Empty; string infor = string.Empty; string receivable = string.Empty; string order_id = string.Empty; int i = 0; Document document = new Document(PageSize.A4, (float)5, (float)5, (float)5, (float)0.5); int iTemp = 0; string filename = string.Empty; if (int.TryParse(ticketid, out iTemp)) { filename = "carwaybills_T" + ticketid.PadLeft(8, '0') + ".pdf"; } else { filename = "carwaybills_T" + ticketid.Substring(0, ticketid.IndexOf(',')).ToString().PadLeft(8, '0') + ".pdf"; } string newPDFName = Server.MapPath(excelPath) + filename; PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(newPDFName, FileMode.Create)); document.Open(); BaseFont bfChinese = BaseFont.CreateFont("C:\\WINDOWS\\Fonts\\simsun.ttc,1", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED); iTextSharp.text.Font fontChinese = new iTextSharp.text.Font(bfChinese, 8, iTextSharp.text.Font.UNDERLINE, iTextSharp.text.BaseColor.RED); iTextSharp.text.Font font = new iTextSharp.text.Font(bfChinese, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 foreach (DataRow dr in bills.Rows) { estimated_delivery_date = !string.IsNullOrEmpty(dr["estimated_delivery_date"].ToString()) ? DateTime.Parse(dr["estimated_delivery_date"].ToString()).ToString("yyyy-MM-dd") : DateTime.Now.ToString("yyyy-MM-dd"); estimated_arrival_period = dr["estimated_arrival_period"].ToString(); switch (dr["estimated_arrival_period"].ToString()) { case "0": sestimated_arrival_period = "不限時"; break; case "1": sestimated_arrival_period = "12:00以前"; break; case "2": sestimated_arrival_period = "12:00-17:00"; break; case "3": sestimated_arrival_period = "17:00-20:00"; break; default: break; } //infor = dr["delivery_name"].ToString() + "\n\n" + CommonFunction.ZipAddress(dr["delivery_zip"].ToString()) + "\n" + dr["delivery_address"].ToString() + "\n\n\n" + dr["delivery_mobile"].ToString(); receivable = dr["receivable"].ToString() != "0" ? dr["receivable"].ToString() : "不收款"; order_id = dr["order_id"].ToString(); font = new iTextSharp.text.Font(bfChinese, 16, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 Chunk c1 = new Chunk(dr["delivery_name"].ToString() + "\n\n", font); font = new iTextSharp.text.Font(bfChinese, 8, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 Chunk c2 = new Chunk(CommonFunction.ZipAddress(dr["delivery_zip"].ToString()) + "\n\n" + dr["delivery_address"].ToString() + "\n\n\n", font); font = new iTextSharp.text.Font(bfChinese, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 Chunk c3 = new Chunk(dr["delivery_mobile"].ToString(), font); Phrase pinfor = new Phrase(); pinfor.Add(c1); pinfor.Add(c2); pinfor.Add(c3); BarCode.Code128 _Code = new BarCode.Code128(); _Code.ValueFont = new System.Drawing.Font("宋体", 20); System.Drawing.Bitmap imgTemp = _Code.GetCodeImage(order_id, BarCode.Code128.Encode.Code128A); imgTemp.Save(System.AppDomain.CurrentDomain.BaseDirectory + "\\ImportUserIOExcel\\" + "Code.gif", System.Drawing.Imaging.ImageFormat.Gif); iTextSharp.text.Image IMG = iTextSharp.text.Image.GetInstance(Server.MapPath("../ImportUserIOExcel/Code.gif")); IMG.ScaleToFit(200, 40); Chunk orderidck = new Chunk(IMG, 0, 0); //图片可设置 偏移 imgTemp = _Code.GetCodeImage("D" + dr["deliver_id"].ToString().PadLeft(8, '0'), BarCode.Code128.Encode.Code128A); imgTemp.Save(System.AppDomain.CurrentDomain.BaseDirectory + "\\ImportUserIOExcel\\" + "Code.gif", System.Drawing.Imaging.ImageFormat.Gif); IMG = iTextSharp.text.Image.GetInstance(Server.MapPath("../ImportUserIOExcel/Code.gif")); IMG.ScaleToFit(200, 40); Chunk deliveridck = new Chunk(IMG, 0, 0); //图片可设置 偏移 //PdfContentByte cb = writer.DirectContent; // cb.BeginText(); if (i % 2 == 0 && i != 0) { document.NewPage(); } PdfPTable totaltable = new PdfPTable(3); totaltable.WidthPercentage = 100; totaltable.SetWidths(new int[] { 45, 2, 53 }); totaltable.DefaultCell.DisableBorderSide(1); totaltable.DefaultCell.DisableBorderSide(2); totaltable.DefaultCell.DisableBorderSide(4); totaltable.DefaultCell.DisableBorderSide(8); PdfPCell cell; #region 左邊框 PdfPTable table = new PdfPTable(4); table.SetTotalWidth(new float[] { 60, 75, 10, 100 }); table.DefaultCell.UseAscender = true; table.DefaultCell.HorizontalAlignment = Element.ALIGN_CENTER; table.DefaultCell.VerticalAlignment = Element.ALIGN_MIDDLE; cell = new PdfPCell(new Phrase("出貨日", font)); cell.FixedHeight = 17f; table.AddCell(cell); table.AddCell(new Phrase("預定配送日", font)); cell = new PdfPCell(new Phrase("指定時段", font)); cell.Colspan = 2; table.AddCell(cell); cell = new PdfPCell(new Phrase(DateTime.Now.ToString("yyyyMMdd"), font)); cell.FixedHeight = 17f; table.AddCell(cell); //table.AddCell(new Phrase(DateTime.Now.ToString("yyyyMMdd"), font)); table.AddCell(new Phrase(estimated_delivery_date, font)); table.AddCell(new Phrase(estimated_arrival_period, font)); table.AddCell(new Phrase(sestimated_arrival_period, font)); table.AddCell(new Phrase("收\n件\n人", font)); cell = new PdfPCell(pinfor); cell.Colspan = 3; table.AddCell(cell); table.AddCell(new Phrase("寄件人", font)); font = new iTextSharp.text.Font(bfChinese, 7, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 cell = new PdfPCell(new Phrase("台北市南港區八德路四段768巷5號4F之一 \n\n 吉甲地好市集股份有限公司", font)); cell.UseAscender = true; cell.HorizontalAlignment = 3; cell.Colspan = 3; table.AddCell(cell); font = new iTextSharp.text.Font(bfChinese, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 table.AddCell(new Phrase("訂單編號", font)); cell = new PdfPCell(new Phrase(orderidck)); cell.UseAscender = true; cell.HorizontalAlignment = 1; cell.Colspan = 3; table.AddCell(cell); font = new iTextSharp.text.Font(bfChinese, 14, iTextSharp.text.Font.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑 cell = new PdfPCell(new Phrase("吉\n甲\n地", font)); cell.UseDescender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.DisableBorderSide(4); cell.DisableBorderSide(2); table.AddCell(cell); PdfPTable stable = new PdfPTable(2); stable.DefaultCell.UseAscender = true; stable.DefaultCell.HorizontalAlignment = Element.ALIGN_CENTER; stable.DefaultCell.VerticalAlignment = Element.ALIGN_MIDDLE; font = new iTextSharp.text.Font(bfChinese, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 stable.AddCell(new Phrase("代收貨款", font)); stable.AddCell(new Phrase(receivable, font)); stable.AddCell(new Phrase("出貨單號", font)); cell = new PdfPCell(new Phrase(deliveridck)); float h = cell.Height; cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_MIDDLE; stable.AddCell(cell); cell = new PdfPCell(stable); cell.Colspan = 3; table.AddCell(cell); // table.WriteSelectedRows(0, -1, 10, 820, writer.DirectContent); #endregion #region totaltable.AddCell(table); totaltable.AddCell(" "); #endregion #region 右邊框 font = new iTextSharp.text.Font(bfChinese, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 table = new PdfPTable(6); table.SetTotalWidth(new float[] { 60, 70, 40, 65, 40, 50 }); table.DefaultCell.UseAscender = true; table.DefaultCell.HorizontalAlignment = Element.ALIGN_CENTER; table.DefaultCell.VerticalAlignment = Element.ALIGN_MIDDLE; cell = new PdfPCell(); cell.DisableBorderSide(1); cell.DisableBorderSide(4); table.AddCell(cell); stable = new PdfPTable(1); stable.DefaultCell.UseAscender = true; stable.DefaultCell.HorizontalAlignment = Element.ALIGN_CENTER; stable.DefaultCell.VerticalAlignment = Element.ALIGN_MIDDLE; //stable.AddCell(new Phrase("包裹查詢號碼", font)); cell = new PdfPCell(new Phrase("包裹查詢號碼", font)); cell.FixedHeight = 17f; stable.AddCell(cell); //stable.AddCell(new Phrase("D" + dr["deliver_id"].ToString().PadLeft(8, '0'), font)); cell = new PdfPCell(new Phrase("D" + dr["deliver_id"].ToString().PadLeft(8, '0'), font)); cell.FixedHeight = 17f; stable.AddCell(cell); cell = new PdfPCell(stable); table.AddCell(cell); cell = new PdfPCell(new Phrase(deliveridck)); cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_MIDDLE; cell.Colspan = 2; table.AddCell(cell); table.AddCell(new Phrase("備註", font)); string name = string.Empty; for (int k = 0; k < dr["delivery_name"].ToString().Length; k++) { name += dr["delivery_name"].ToString()[k] + "\n"; } font = new iTextSharp.text.Font(bfChinese, 14, iTextSharp.text.Font.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑 cell = new PdfPCell(new Phrase("吉\n甲\n地\n\n" + name, font)); cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_MIDDLE; cell.Rowspan = 6; table.AddCell(cell); font = new iTextSharp.text.Font(bfChinese, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 table.AddCell(new Phrase("收\n件\n人", font)); cell = new PdfPCell(pinfor); //cell.UseAscender = true; //cell.HorizontalAlignment = Element.ALIGN_LEFT; cell.Colspan = 3; table.AddCell(cell); cell = new PdfPCell(); cell.Rowspan = 5; table.AddCell(cell); table.AddCell(new Phrase("寄件人", font)); font = new iTextSharp.text.Font(bfChinese, 7, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 cell = new PdfPCell(new Phrase("台北市南港區八德路四段768巷5號4F之一 \n\n 吉甲地好市集股份有限公司", font)); //cell.UseAscender = true; //cell.HorizontalAlignment = Element.ALIGN_LEFT; cell.Colspan = 3; table.AddCell(cell); font = new iTextSharp.text.Font(bfChinese, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 table.AddCell(new Phrase("訂單編號", font)); cell = new PdfPCell(new Phrase(orderidck)); cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_MIDDLE; cell.Colspan = 3; table.AddCell(cell); table.AddCell(new Phrase("指定時段", font)); table.AddCell(new Phrase(sestimated_arrival_period, font)); cell = new PdfPCell(new Phrase("\n\n收件人簽名\n\n", font)); cell.Rowspan = 2; cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; // cell.VerticalAlignment = Element.ALIGN_MIDDLE; table.AddCell(cell); PdfPCell ncell = new PdfPCell(); //ncell.DisableBorderSide(1); //ncell.DisableBorderSide(2); ncell.Rowspan = 2; table.AddCell(ncell); //table.AddCell(new Phrase("收件人簽名", font)); cell = new PdfPCell(new Phrase("代收貨款", font)); cell.FixedHeight = h; cell.UseAscender = true; cell.HorizontalAlignment = Element.ALIGN_CENTER; cell.VerticalAlignment = Element.ALIGN_MIDDLE; table.AddCell(cell); table.AddCell(new Phrase(receivable, font)); // table.WriteSelectedRows(0, -1, 280, 820, writer.DirectContent); //table.AddCell(ncell); //table.AddCell(ncell); //table.AddCell(ncell); //table.AddCell(ncell); #endregion totaltable.AddCell(table); // cb.EndText(); totaltable.SpacingAfter = 75f; document.Add(totaltable); i++; } document.Close(); Response.Clear(); Response.Charset = "gb2312"; Response.ContentEncoding = System.Text.Encoding.UTF8; // Response.AddHeader("Content-Disposition", "attach-ment;filename=" + System.Web.HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8) + ".pdf "); Response.AddHeader("Content-Disposition", "attach-ment;filename=" + filename); Response.WriteFile(newPDFName); }
public void GetWaybillsXls() { if (!string.IsNullOrEmpty(Request.Params["ticket_id"])) { string strTemp = Request.Params["ticket_id"].ToString(); strTemp = strTemp.Remove(strTemp.LastIndexOf(',')); string newPDFName = string.Empty; int iTemp = 0; if (int.TryParse(strTemp, out iTemp)) { newPDFName = "waybills_T" + strTemp.PadLeft(8, '0').ToString() + ".xls"; } else { string ss = strTemp.Substring(0, strTemp.IndexOf(',')); newPDFName = "waybills_T" + ss.PadLeft(8, '0').ToString() + ".xls"; } _DeliverDetailMgr = new DeliverDetailMgr(mySqlConnectionString); DataTable dt = _DeliverDetailMgr.GetWayBills(null, strTemp); DataTable dtTemp = new DataTable(); dtTemp.Columns.Add("訂單編號", typeof(String)); dtTemp.Columns.Add("收件人姓名", typeof(String)); dtTemp.Columns.Add("收件人電話", typeof(String)); dtTemp.Columns.Add("收件人手機", typeof(String)); dtTemp.Columns.Add("收件人地址", typeof(String)); dtTemp.Columns.Add("出貨日期\nYYYYMMDD", typeof(String)); dtTemp.Columns.Add("預定配達日期\n YYYYMMDD", typeof(String)); dtTemp.Columns.Add("預定配達時段\n (1:中午前~2:12-17時~3:17-20時~4:不指定~5:20-21時)", typeof(String)); dtTemp.Columns.Add("品名", typeof(String)); dtTemp.Columns.Add("代收貨款", typeof(String)); dtTemp.Columns.Add("溫層\n (1:常溫~2:冷藏~3:冷凍)", typeof(String)); dtTemp.Columns.Add("距離\n (0:同縣市~1:外縣市~2:離島)", typeof(String)); dtTemp.Columns.Add("規格\n (1:60cm~2:90cm~3:120cm~4:150cm)", typeof(String)); dtTemp.Columns.Add("易碎 \n (Y~N)", typeof(String)); dtTemp.Columns.Add("精密 \n (Y~N)", typeof(String)); dtTemp.Columns.Add("備註", typeof(String)); dtTemp.Columns.Add("假日可出貨", typeof(String)); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dtTemp.NewRow(); dr[0] = dt.Rows[i]["order_id"]; dr[1] = dt.Rows[i]["delivery_name"]; dr[2] = dt.Rows[i]["delivery_mobile"]; dr[3] = dt.Rows[i]["delivery_phone"]; dr[4] = CommonFunction.ZipAddress(dt.Rows[i]["delivery_zip"].ToString()) + dt.Rows[i]["delivery_address"].ToString(); dr[5] = DateTime.Now.ToString("yyyy-MM-dd"); dr[7] = dt.Rows[i]["estimated_arrival_period"]; if (dt.Rows[i]["estimated_arrival_period"].ToString() == "2") { dr[8] = "冷凍食品"; } dr[9] = dt.Rows[i]["receivable"]; dr[10] = dt.Rows[i]["freight_set"]; dr[15] = dt.Rows[i]["note_order"]; dr[16] = dt.Rows[i]["holiday_deliver"].ToString() == "1" ? "是" : "否"; dtTemp.Rows.Add(dr); } MemoryStream ms = ExcelHelperXhf.ExportDT(dtTemp, ""); //Response.Clear(); //Response.Charset = "gb2312"; //Response.ContentEncoding = System.Text.Encoding.UTF8; // Response.AddHeader("Content-Disposition", "attach-ment;filename=" + System.Web.HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8) + ".pdf "); Response.AddHeader("Content-Disposition", "attach-ment;filename=" + newPDFName); Response.BinaryWrite(ms.ToArray()); } }