/// <summary> /// 出貨明細 /// </summary> public void GetDeliverDetailsPDF() { string deliver_id = Request.Params["deliver_id"]; _DeliverDetailMgr = new DeliverDetailMgr(mySqlConnectionString); DataTable deliverdetail = _DeliverDetailMgr.GetOrderDelivers(deliver_id, 1); 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, 12, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 string filename = "deliver_details_D" + deliver_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(); PdfContentByte cb = writer.DirectContent; cb.BeginText(); DataRow[] singleproduct = new DataRow[] { };//單一商品 DataRow[] fatherproduct = new DataRow[] { };//組合商品中的父商品 DataRow[] sonproduct = new DataRow[] { };//組合商品中的子商品 //DataRow[] normal; //DataRow[] low; //DataRow[] lowstore; //List<DataRow> deliverdetails = new List<DataRow>(); ArrayList combine = new ArrayList(); singleproduct = deliverdetail.Select(" combined_mode<=1 and ddeliver_id=" + deliver_id, "item_id asc");//單一商品 fatherproduct = deliverdetail.Select(" combined_mode>1 and item_mode=1 and ddeliver_id=" + deliver_id, "item_id asc");//組合商品中父商品是否存在 foreach (var item in fatherproduct) { combine.Add(item); sonproduct = deliverdetail.Select(" combined_mode>1 and item_mode<>1 and parent_id=" + item["parent_id"] + " and pack_id=" + item["pack_id"], "item_id asc");//對應組合商品中的子商品 foreach (var son in sonproduct) { son["buy_num"] = (int.Parse(son["buy_num"].ToString()) * int.Parse(son["parent_num"].ToString())).ToString(); combine.Add(son); } } List<DataRow[]> deliverdetails = new List<DataRow[]>(); //normal = deliverdetail.Select("product_freight_set in(1,3) and ddeliver_id=" + deliver_id, "item_id asc");//常溫 //low = deliverdetail.Select("product_freight_set in(2,4) and ddeliver_id=" + deliver_id, "item_id asc");//冷凍 //lowstore = deliverdetail.Select("product_freight_set in(5,6) and ddeliver_id=" + deliver_id, "item_id asc");//冷藏 if (singleproduct.Count() > 0) { deliverdetails.Add(singleproduct); } if (combine.Count > 0) { deliverdetails.Add((DataRow[])combine.ToArray(typeof(DataRow))); } if (deliverdetail.Rows.Count > 0) { cb.SetFontAndSize(bfChinese, 20); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "吉甲地台灣好市集出貨明細", 30, 750, 0); string freight_set = string.Empty; switch (deliverdetail.Rows[0]["freight_set"].ToString().Trim()) { case "1": freight_set = "常溫"; break; case "2": freight_set = "冷凍"; break; case "5": freight_set = "冷藏"; break; } cb.SetFontAndSize(bfChinese, 12); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, freight_set, 350, 780, 0); if (deliverdetail.Rows[0]["estimated_arrival_period"].ToString() != "0") { string estimated_arrival_period = string.Empty; switch (deliverdetail.Rows[0]["estimated_arrival_period"].ToString().Trim()) { case "0": estimated_arrival_period = "不限時"; break; case "1": estimated_arrival_period = "12:00以前"; break; case "2": estimated_arrival_period = "12:00-17:00"; break; case "3": estimated_arrival_period = "17:00-20:00"; break; } cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, estimated_arrival_period, 350, 765, 0); } Phrase ph = new Phrase(); BarCode.Code128 _Code = new BarCode.Code128(); _Code.ValueFont = new System.Drawing.Font("宋体", 20); System.Drawing.Bitmap imgTemp1 = _Code.GetCodeImage("D" + deliverdetail.Rows[0]["deliver_id"].ToString().PadLeft(8, '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 ck = new Chunk(IMG1, 345, -100); //图片可设置 偏移 ph.Add(ck); document.Add(ph); cb.SetFontAndSize(bfChinese, 10); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "付款單號:", 10, 680, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "訂購時間:", 10, 660, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "转单日期:", 200, 660, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "订购人:", 10, 640, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "收货人:", 200, 640, 0); string address = string.Empty; cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, deliverdetail.Rows[0]["order_id"].ToString(), 80, 680, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, deliverdetail.Rows[0]["order_createdate"].ToString() != "0" ? CommonFunction.GetNetTime(long.Parse(deliverdetail.Rows[0]["order_createdate"].ToString())).ToString("yyyy-MM-dd HH:mm:ss") : "", 80, 660, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, deliverdetail.Rows[0]["money_collect_date"].ToString() != "0" ? CommonFunction.GetNetTime(long.Parse(deliverdetail.Rows[0]["money_collect_date"].ToString())).ToString("yyyy-MM-dd HH:mm:ss") : "", 250, 660, 0); //cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, deliverdetail.Rows[0]["holiday_deliver"].ToString() == "1" ? "可" : "不可", 250, 620, 0); //cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, deliverdetail.Rows[0]["note_order"].ToString(), 80, 600, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, deliverdetail.Rows[0]["order_name"].ToString(), 80, 640, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, deliverdetail.Rows[0]["delivery_name"].ToString(), 250, 640, 0); if (deliverdetail.Rows[0]["type"].ToString() != "3") { PdfPTable ptable = new PdfPTable(4); ptable.SetTotalWidth(new float[] { 100, 320, 70, 70 }); PdfPCell cell = new PdfPCell(); cell.BorderWidth = 0.1f; cell.BorderColor = new BaseColor(0, 0, 0); cell = new PdfPCell(new Phrase("商品編號", font)); ptable.AddCell(cell); cell = new PdfPCell(new Phrase("商品名稱", font)); ptable.AddCell(cell); cell = new PdfPCell(new Phrase("數量", font)); ptable.AddCell(cell); cell = new PdfPCell(new Phrase("售价", font)); ptable.AddCell(cell); PdfPCell td = new PdfPCell(); td.BorderWidth = 0.1f; int j = 0; foreach (var item in deliverdetails) { j++; for (int i = 0; i < item.Count(); i++) { string item_id = string.Empty; if (item[i]["item_mode"].ToString() == "1") { item_id = item[i]["parent_id"].ToString(); } else { item_id = item[i]["item_id"].ToString(); } cell = new PdfPCell(new Phrase(item_id, font)); ptable.AddCell(cell); string datacontent = ((item[i]["item_mode"].ToString() == "2") ? " *" : "") + item[i]["product_name"].ToString() + item[i]["product_spec_name"].ToString(); cell = new PdfPCell(new Phrase(item[i]["brand_name"].ToString() + "-" + datacontent, font)); ptable.AddCell(cell); cell = new PdfPCell(new Phrase(item[i]["buy_num"].ToString(), font)); ptable.AddCell(cell); cell = new PdfPCell(new Phrase(item[i]["item_mode"].ToString() == "1" ? "" : item[i]["single_money"].ToString(), font)); ptable.AddCell(cell); } if (deliverdetails.Count > 1 && j != deliverdetails.Count) { td = new PdfPCell(); td.Colspan = 4; td.BorderWidthTop = 0.2f; td.DisableBorderSide(2); ptable.AddCell(td); } } ptable.WriteSelectedRows(0, -1, 10, 620, writer.DirectContent); } else { PdfPTable ptable = new PdfPTable(4); // ptable.WidthPercentage = 90; // ptable.TotalWidth = ptable.WidthPercentage; ptable.SetTotalWidth(new float[] { 100, 350, 70, 70 }); PdfPCell cell = new PdfPCell(); cell.BorderWidth = 0.1f; cell = new PdfPCell(new Phrase("產品細項編號", font)); ptable.AddCell(cell); cell = new PdfPCell(new Phrase("產品名稱", font)); ptable.AddCell(cell); cell = new PdfPCell(new Phrase("規格", font)); ptable.AddCell(cell); cell = new PdfPCell(new Phrase("數量", font)); ptable.AddCell(cell); int j = 0; foreach (var item in deliverdetails) { j++; for (int i = 0; i < item.Count(); i++) { cell = new PdfPCell(new Phrase(item[i]["item_id"].ToString(), font)); ptable.AddCell(cell); cell = new PdfPCell(new Phrase(item[i]["brand_name"].ToString() + "-" + item[i]["product_name"].ToString(), font)); ptable.AddCell(cell); cell = new PdfPCell(new Phrase(item[i]["product_spec_name"].ToString(), font)); ptable.AddCell(cell); cell = new PdfPCell(new Phrase(item[i]["buy_num"].ToString(), font)); ptable.AddCell(cell); } if (deliverdetails.Count > 1 && j != deliverdetails.Count) { cell = new PdfPCell(); cell.Colspan = 4; cell.BorderWidthTop = 0.2f; cell.DisableBorderSide(2); ptable.AddCell(cell); } } ptable.WriteSelectedRows(0, -1, 10, 620, writer.DirectContent); } cb.EndText(); document.Close(); writer.Resume(); 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> /// 订单出货明细 /// </summary> public void GetOrderDetailsPDF() { string deliver_id = Request.Params["deliver_id"]; _DeliverDetailMgr = new DeliverDetailMgr(mySqlConnectionString); DataTable orderdeliver = _DeliverDetailMgr.GetOrderDelivers(deliver_id); Dictionary<string, string> dicproduct_freight_set = new Dictionary<string, string> { { "1", "1" }, { "2", "2" }, { "3", "1" }, { "4", "2" }, { "5", "5" }, { "6", "5" } }; BaseFont bfChinese = BaseFont.CreateFont("C:\\WINDOWS\\Fonts\\simsun.ttc,1", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED); iTextSharp.text.Font font = new iTextSharp.text.Font(bfChinese, 12, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 string filename = "order_details_D" + deliver_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(); PdfContentByte cb = writer.DirectContent; if (orderdeliver.Rows.Count > 0) { #region 生成條形碼 BarCode.Code128 _Code = new BarCode.Code128(); _Code.ValueFont = new System.Drawing.Font("宋体", 20); System.Drawing.Bitmap imgTemp = _Code.GetCodeImage("D" + orderdeliver.Rows[0]["deliver_id"].ToString().PadLeft(8, '0'), 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, 30); IMG.SetAbsolutePosition(345, 740); #endregion cb.BeginText(); cb.SetFontAndSize(bfChinese, 20); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "吉甲地市集出貨明細", 30, 750, 0); //首購 if (orderdeliver.Rows[0]["priority"].ToString() == "1") { PdfPTable ot = new PdfPTable(1); ot.SetTotalWidth(new float[] { 190 }); PdfPCell c = new PdfPCell(new Phrase("", font)); c.FixedHeight = 30; c.BorderWidthBottom = 0.5f; c.BorderWidthLeft = 0.5f; c.BorderWidthRight = 0.5f; c.BorderWidthTop = 0.5f; ot.AddCell(c); ot.WriteSelectedRows(0, -1, 29, 770, cb); } cb.AddImage(IMG); if (orderdeliver.Rows[0]["channel"].ToString() != "1") { cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, orderdeliver.Rows[0]["channel_name_simple"].ToString(), 80, 700, 0); } if (orderdeliver.Rows[0]["retrieve_mode"].ToString() == "1") { cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "7-11取貨", 200, 700, 0); } cb.SetFontAndSize(bfChinese, 10); string freight_set = string.Empty; switch (orderdeliver.Rows[0]["freight_set"].ToString().Trim()) { case "1": freight_set = "常溫"; break; case "2": freight_set = "冷凍"; break; case "5": freight_set = "冷藏"; break; } cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, freight_set, 345, 785, 0); string estimated_arrival_period = string.Empty; if (orderdeliver.Rows[0]["estimated_arrival_period"].ToString() != "0") { switch (orderdeliver.Rows[0]["estimated_arrival_period"].ToString().Trim()) { case "0": estimated_arrival_period = "不限時"; break; case "1": estimated_arrival_period = "12:00以前"; break; case "2": estimated_arrival_period = "12:00-17:00"; break; case "3": estimated_arrival_period = "17:00-20:00"; break; } cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, estimated_arrival_period, 345, 773, 0); } } cb.SetFontAndSize(bfChinese, 10); //cb.SetTextMatrix(150,20); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "訂購人:", 10, 680, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "收件人:", 200, 680, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "付款單號:", 10, 660, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "收件地址:", 200, 660, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "訂購時間:", 10, 640, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "聯絡電話:", 200, 640, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "付款時間:", 10, 620, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "假日可收貨:", 200, 620, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "出貨備註:", 10, 600, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "訂單明細:", 10, 580, 0); if (orderdeliver.Rows.Count > 0 && orderdeliver.Rows[0]["receivable"].ToString() != "0") { cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "應收金額:" + orderdeliver.Rows[0]["receivable"].ToString(), 200, 580, 0); } string address = string.Empty; string deliver_note = string.Empty; if (orderdeliver.Rows.Count > 0) { cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, orderdeliver.Rows[0]["order_name"].ToString(), 65, 680, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, orderdeliver.Rows[0]["delivery_name"].ToString(), 250, 680, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, orderdeliver.Rows[0]["order_id"].ToString(), 65, 660, 0); address += CommonFunction.ZipAddress(orderdeliver.Rows[0]["delivery_zip"].ToString()) + orderdeliver.Rows[0]["delivery_address"].ToString(); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, address, 250, 660, 0); string order_createdate = orderdeliver.Rows[0]["order_createdate"].ToString() != "0" ? CommonFunction.GetNetTime(long.Parse(orderdeliver.Rows[0]["order_createdate"].ToString())).ToString("yyyy-MM-dd HH:mm:ss") : ""; string money_collect_date = orderdeliver.Rows[0]["money_collect_date"].ToString() != "0" ? CommonFunction.GetNetTime(long.Parse(orderdeliver.Rows[0]["money_collect_date"].ToString())).ToString("yyyy-MM-dd HH:mm:ss") : ""; cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, order_createdate, 65, 640, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, orderdeliver.Rows[0]["delivery_mobile"].ToString(), 250, 640, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, money_collect_date, 65, 620, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, orderdeliver.Rows[0]["holiday_deliver"].ToString() == "1" ? "可" : "不可", 260, 620, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, orderdeliver.Rows[0]["note_order"].ToString().Trim(), 65, 600, 0); if (orderdeliver.Rows[0]["delivery_store"].ToString() == "12") { deliver_note = "*自取(取貨地址:台北市南港區八德路4段768巷7號6樓之1,取貨時間週一~週五,AM9:00~PM6:00)"; } else if (orderdeliver.Rows[0]["delivery_store"].ToString() == "13") { deliver_note = "*自取(取貨地址:新北市板橋區三民路二段33號21樓,取貨時間週一~週五,AM9:00~PM6:00)"; } else if (orderdeliver.Rows[0]["delivery_store"].ToString() == "14") { deliver_note = "*自取(取貨地址:新北市永和區成功路一段80號20樓,取貨時間週一~週五,AM9:00~PM6:00)"; } cb.SetFontAndSize(bfChinese, 8); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, deliver_note, 65, 580, 0); } cb.EndText(); PdfPTable ptable = new PdfPTable(7); ptable.WidthPercentage = 98; ptable.SetTotalWidth(new float[] { 50, 280, 50, 50, 50, 50, 50 }); PdfPCell cell; font = new iTextSharp.text.Font(bfChinese, 8, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 cell = new PdfPCell(new Phrase("商品編號", font)); cell.DisableBorderSide(2); cell.DisableBorderSide(8); ptable.AddCell(cell); cell = new PdfPCell(new Phrase("商品名稱", font)); cell.DisableBorderSide(2); cell.DisableBorderSide(8); ptable.AddCell(cell); cell = new PdfPCell(new Phrase("托運單屬性", font)); cell.DisableBorderSide(2); cell.DisableBorderSide(8); ptable.AddCell(cell); cell = new PdfPCell(new Phrase("數量", font)); cell.DisableBorderSide(2); cell.DisableBorderSide(8); ptable.AddCell(cell); cell = new PdfPCell(new Phrase("本次出貨", font)); cell.DisableBorderSide(2); cell.DisableBorderSide(8); ptable.AddCell(cell); cell = new PdfPCell(new Phrase("預計出貨日", font)); cell.DisableBorderSide(2); cell.DisableBorderSide(8); ptable.AddCell(cell); cell = new PdfPCell(new Phrase("供應商自出", font)); cell.DisableBorderSide(2); ptable.AddCell(cell); PdfPCell td; string lastdeliverid = "0"; ArrayList normal = new ArrayList(); ArrayList low = new ArrayList(); ArrayList lowstore = new ArrayList(); DataRow[] sinceorder = new DataRow[] { }; DataRow[] singleproduct = new DataRow[] { };//單一商品 DataRow[] fatherproduct = new DataRow[] { };//組合商品中的父商品 DataRow[] sonproduct = new DataRow[] { };//組合商品中的子商品 ArrayList combine = new ArrayList(); List<DataRow[]> orderdelivers = new List<DataRow[]>(); sinceorder = orderdeliver.Select("dtype=2 and combined_mode<=1 ", "item_id asc");//自出商品 singleproduct = orderdeliver.Select("dtype <>2 and combined_mode<=1 ", "item_id asc");//單一商品 if (singleproduct.Count() > 0) { orderdelivers.Add(singleproduct); } fatherproduct = orderdeliver.Select(" combined_mode>1 and item_mode=1", "item_id asc");//組合商品中父商品是否存在 foreach (var item in fatherproduct) { combine.Add(item); sonproduct = orderdeliver.Select(" combined_mode>1 and item_mode<>1 and parent_id=" + item["parent_id"] + " and pack_id=" + item["pack_id"], "item_id asc");//對應組合商品中的子商品 foreach (var son in sonproduct) { son["buy_num"] = (int.Parse(son["buy_num"].ToString()) * int.Parse(son["parent_num"].ToString())).ToString(); combine.Add(son); } } if (combine.Count > 0) { orderdelivers.Add((DataRow[])combine.ToArray(typeof(DataRow))); } //區分常溫、冷凍、冷藏 foreach (var item in orderdelivers) { foreach (var row in item) { string s = row["product_freight_set"].ToString(); switch (row["product_freight_set"].ToString()) { case "1": case "3": normal.Add(row);//常溫 break; case "2": case "4": low.Add(row);//冷凍 break; case "5": case "6": lowstore.Add(row);//冷藏 break; default: break; } } } orderdelivers = new List<DataRow[]>(); if (normal.Count > 0) { orderdelivers.Add((DataRow[])normal.ToArray(typeof(DataRow))); } if (low.Count > 0) { orderdelivers.Add((DataRow[])low.ToArray(typeof(DataRow))); } if (lowstore.Count > 0) { orderdelivers.Add((DataRow[])lowstore.ToArray(typeof(DataRow))); } if (sinceorder.Count() > 0) { orderdelivers.Add(sinceorder); } int j = 0; foreach (var item in orderdelivers) { j++; for (int i = 0; i < item.Count(); i++) { if (item[i]["ddeliver_id"].ToString() != lastdeliverid || i == 0) { lastdeliverid = item[i]["ddeliver_id"].ToString();//以一個出貨單號為界限 if (lastdeliverid != "0" || i == 0) { td = new PdfPCell(); td.Colspan = 7; td.DisableBorderSide(2); td.DisableBorderSide(4); td.DisableBorderSide(8); //td.BorderWidthTop = 0.2f; ptable.AddCell(td); } } string item_id = string.Empty; if (item[i]["item_mode"].ToString() == "1") { item_id = item[i]["parent_id"].ToString(); } else { item_id = item[i]["item_id"].ToString(); } font = new iTextSharp.text.Font(bfChinese, 8, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 td = new PdfPCell(new Phrase(item_id, font)); td.DisableBorderSide(1); td.DisableBorderSide(2); td.DisableBorderSide(8); //td.BorderWidthLeft = 0.2f; ptable.AddCell(td); string datacontent = ((item[i]["product_mode"].ToString() == "2" && item[i]["item_mode"].ToString() != "1") ? "*" : " ") + item[i]["brand_name"].ToString() + "-" + item[i]["product_name"].ToString() + item[i]["product_spec_name"].ToString(); if (item[i]["combined_mode"].ToString() != "0" && item[i]["item_mode"].ToString() == "2") { datacontent = " " + datacontent; } td = new PdfPCell(new Phrase(datacontent, font)); td.DisableBorderSide(1); td.DisableBorderSide(2); td.DisableBorderSide(8); ptable.AddCell(td); string value = string.Empty; string freight_set = string.Empty; if (dicproduct_freight_set.TryGetValue(item[i]["product_freight_set"].ToString(), out value)) { } switch (value) { case "1": freight_set = "常溫"; break; case "2": freight_set = "冷凍"; break; case "5": freight_set = "冷藏"; break; } td = new PdfPCell(new Phrase(freight_set, font)); td.DisableBorderSide(1); td.DisableBorderSide(2); td.DisableBorderSide(8); //td.BorderWidthLeft = 0.2f; ptable.AddCell(td); font = new iTextSharp.text.Font(bfChinese, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 td = new PdfPCell(new Phrase(item[i]["item_mode"].ToString() != "1" ? item[i]["buy_num"].ToString() : "", font)); td.DisableBorderSide(1); td.DisableBorderSide(2); td.DisableBorderSide(8); // td.BorderWidthLeft = 0.2f; ptable.AddCell(td); td = new PdfPCell(); td.DisableBorderSide(1); td.DisableBorderSide(2); td.DisableBorderSide(8); //td.BorderWidthLeft = 0.2f; ptable.AddCell(td); td = new PdfPCell(); td.DisableBorderSide(1); td.DisableBorderSide(2); td.DisableBorderSide(8); //td.BorderWidthLeft = 0.2f; ptable.AddCell(td); Image image = Image.GetInstance(Server.MapPath("../Content/img/icons/mark.png")); image.ScalePercent(5, 5); if (item[i]["dtype"].ToString() == "2") { td = new PdfPCell(image, false); } else { td = new PdfPCell(); } td.HorizontalAlignment = Element.ALIGN_CENTER; td.VerticalAlignment = Element.ALIGN_MIDDLE; td.DisableBorderSide(1); td.DisableBorderSide(2); ptable.AddCell(td); } } string note_order = orderdeliver.Rows.Count.ToString() != "0" ? orderdeliver.Rows[0]["note_order"].ToString().Trim() : ""; cell = new PdfPCell(new Phrase(new Chunk("備註:" + note_order, font))); cell.Colspan = 7; cell.HorizontalAlignment = Element.ALIGN_LEFT; ptable.AddCell(cell); PdfPTable nulltable = new PdfPTable(2); nulltable.SetWidths(new int[] { 20, 20 }); nulltable.DefaultCell.DisableBorderSide(1); nulltable.DefaultCell.DisableBorderSide(2); nulltable.DefaultCell.DisableBorderSide(4); nulltable.DefaultCell.DisableBorderSide(8); nulltable.AddCell(""); nulltable.AddCell(""); nulltable.SpacingAfter = 250; document.Add(nulltable); ptable.SpacingAfter = 50; document.Add(ptable); font = new iTextSharp.text.Font(bfChinese, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 document.Add(new Phrase("吉甲地市集網路平台購物發票說明:\n", font)); font = new iTextSharp.text.Font(bfChinese, 8, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 document.Add(new Phrase("若您訂購時未選擇開立三聯式發票,平台一律開立電子發票。\n", font)); document.Add(new Phrase("發票將於該筆訂單商品完全出貨之後第10天開立並以E-Mail通知您。\n", font)); document.Add(new Phrase("如需紙本發票請來信客服中心,會計部門將會依需求將電子發票印出並以平信郵寄約2~7個工作天內送達。\n", font)); document.Add(new Phrase("託管發票將會在單月26日進行對獎作業後,系統將會發信通知中獎發票持有人,\n", font)); document.Add(new Phrase("且為保障您的權益,我們將在七個工作天內,以掛號方式把中獎發票寄給您。\n", font)); font = new iTextSharp.text.Font(bfChinese, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑 document.Add(new Phrase("祝您購物愉快!", font)); document.Close(); writer.Resume(); Response.Clear(); Response.Charset = "gb2312"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.AddHeader("Content-Disposition", "attach-ment;filename=" + filename); Response.WriteFile(newPDFName); }