/// <summary>
/// 導出DataTable数据到PDF
/// </summary>
/// <param name="dtSource">表名</param>
/// <param name="isColumnName">是否顯示列名</param>
/// <param name="FileName">文件完整路徑</param>
/// <param name="arrColWidth">列寬比例數組，數組長度必須等於DataTable列數；</param>
/// <param name="pdftable">公共模块</param>
/// <param name="pdffooter">落款</param>
/// <param name="title">標題</param>
/// <param name="header">頁眉</param>
/// <param name="rows">表頭分rows列显示</param>
/// <param name="count">每頁最多顯示count組記錄</param>
public void ExportDataTableToPDF(DataTable dtSource, bool isColumnName, string FileName, float[] arrColWidth, PdfPTable pdftable,PdfPTable pdffooter, string title, string header, int cols, uint count)
{
try
{
//創建實例
document = new Document(PageSize.A4.Rotate());
PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(FileName, FileMode.Create));
OpenDocument();
//設置title和頁眉
writer.PageEvent = new HeaderAndFooterEvent();
HeaderAndFooterEvent.basefont = basefont;
HeaderAndFooterEvent.header = header;
HeaderAndFooterEvent.isPdfTable = true;
HeaderAndFooterEvent.pdftable = pdftable;
HeaderAndFooterEvent.PAGE_NUMBER = true;
HeaderAndFooterEvent.tpl = writer.DirectContent.CreateTemplate(100, 100);
if (!string.IsNullOrEmpty(title))
{
document.Add(HeaderAndFooterEvent.InsertTitleContent(title));
}
//添加table
int rows = (int)(dtSource.Columns.Count / cols);
if (dtSource.Columns.Count % cols != 0)
{
rows = rows + 1;
}
PdfPTable table = new PdfPTable(cols);
table.WidthPercentage = 100;
//沒有傳遞列寬比例時，獲取默認列表比較
float[] newArrColWidth = new float[dtSource.Columns.Count];
for (int i = 0; i < dtSource.Columns.Count; i++)
{
if (arrColWidth.Length > i)
{
newArrColWidth[i] = arrColWidth[i];
}
else
{
newArrColWidth[i] = newArrColWidth[i - cols];
}
}
table.SetWidths(arrColWidth);
//列名代表表頭
#region 是否顯示列名
if (isColumnName)
{
for (int i = 0; i < dtSource.Columns.Count; i++)
{
PdfPCell cell = new PdfPCell(new Phrase(dtSource.Columns[i].ColumnName, new Font(basefont, defaultFontSize, Font.BOLD)));
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.HorizontalAlignment = Element.ALIGN_CENTER;//水平居中
if (i / cols % rows == 0)
{
cell.DisableBorderSide(2); //1，2，4，8 分别对应每行的上，下，左，右四个边框．
}
else if (i / cols % (rows - 1) == 0)
{
cell.DisableBorderSide(1);
}
else
{
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
}
table.AddCell(cell);
}
for (int j = dtSource.Columns.Count; j < cols * rows; j++)
{
PdfPCell cell = new PdfPCell(new Phrase("", new Font(basefont, defaultFontSize)));
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.HorizontalAlignment = Element.ALIGN_CENTER;//水平居中
if (rows == 1)
{
}
else if (j / cols % rows == 0)
{
cell.DisableBorderSide(2); //1，2，4，8 分别对应每行的上，下，左，右四个边框．
}
else if (j / cols % (rows - 1) == 0)
{
cell.DisableBorderSide(1);
}
else
{
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
}
table.AddCell(cell);
}
}
#endregion
document.Add(pdftable);
for (int i = 0; i < dtSource.Rows.Count; i++)
{
for (int j = 0; j < dtSource.Columns.Count; j++)
{
PdfPCell cell = new PdfPCell(new Phrase(dtSource.Rows[i][j].ToString(), font));
if (i%2==1)
{
cell.BackgroundColor = BaseColor.LIGHT_GRAY;
}
else
{
cell.BackgroundColor = BaseColor.WHITE;
}
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.HorizontalAlignment = Element.ALIGN_LEFT;//水平居左
if (rows == 1)
{
}
else if (j / cols % rows == 0)
{
cell.DisableBorderSide(2); //1，2，4，8 分别对应每行的上，下，左，右四个边框．
}
else if (j / cols % (rows - 1) == 0)
{
cell.DisableBorderSide(1);
}
else
{
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
}
table.AddCell(cell);
}
if (dtSource.Columns.Count == cols * rows)
{
if ((i + 1) % count == 0 && i != dtSource.Rows.Count - 1)
{
document.Add(table);
table.Rows.Clear();
document.NewPage();
}
}
for (int j = dtSource.Columns.Count; j < cols * rows; j++)
{
PdfPCell cell = new PdfPCell(new Phrase("", font));
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.HorizontalAlignment = Element.ALIGN_CENTER;//水平居右
if (rows == 1)
{
}
else if (j / cols % rows == 0)
{
cell.DisableBorderSide(2); //1，2，4，8 分别对应每行的上，下，左，右四个边框．
}
else if (j / cols % (rows - 1) == 0)
{
cell.DisableBorderSide(1);
}
else
{
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
}
table.AddCell(cell);
if ((i + 1) % count == 0 && i != dtSource.Rows.Count - 1 && j == cols * rows - 1)
{
document.Add(table);
table.Rows.Clear();
document.NewPage();
}
}
}
document.Add(table);
document.Add(pdffooter);
////關閉document
//writer.Flush();
//writer.CloseStream = true;
document.Close(); //
}
catch (Exception ex)
{
throw new Exception("PdfManagement-->ExportDataTableToPDF-->" + ex.Message);
}
}
/// <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);
}
/// <summary>
/// 導出DataTable数据到PDF
/// </summary>
/// <param name="dt">表名</param>
/// <param name="FileName">文件完整路徑</param>
/// <param name="pdftable">公共模块</param>
/// <param name="header">頁眉</param>
/// <param name="rows">表頭分N列显示</param>
public void ExportDataTableToPDF(DataTable dtSource, string FileName, PdfPTable pdftable, string title, string header, int cols)
{
try
{
//創建實例
document = new Document(PageSize.A4);
PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(FileName, FileMode.Create));
OpenDocument();
//設置title和頁眉
writer.PageEvent = new HeaderAndFooterEvent();
HeaderAndFooterEvent.basefont = basefont;
HeaderAndFooterEvent.header = header;
HeaderAndFooterEvent.isPdfTable = true;
HeaderAndFooterEvent.pdftable = pdftable;
HeaderAndFooterEvent.PAGE_NUMBER = true;
HeaderAndFooterEvent.tpl = writer.DirectContent.CreateTemplate(100, 100);
if (!string.IsNullOrEmpty(title))
{
document.Add(HeaderAndFooterEvent.InsertTitleContent(title));
}
//添加table
int rows = (int)(dtSource.Columns.Count / cols);
if (dtSource.Columns.Count % cols != 0)
{
rows = rows + 1;
}
PdfPTable table = new PdfPTable(cols);
table.WidthPercentage = 100;
//沒有傳遞列寬比例時，獲取默認列表比較
//table.SetWidths(arrColWidth);
//列名代表表頭
for (int i = 0; i < dtSource.Columns.Count; i++)
{
PdfPCell cell = new PdfPCell(new Phrase(dtSource.Columns[i].ColumnName, new Font(basefont, defaultFontSize, Font.BOLD)));
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.HorizontalAlignment = Element.ALIGN_CENTER;//水平居中
if (i / cols % rows == 0)
{
cell.DisableBorderSide(2); //1，2，4，8 分别对应每行的上，下，左，右四个边框．
}
else if (i / cols % (rows - 1) == 0)
{
cell.DisableBorderSide(1);
}
else
{
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
}
table.AddCell(cell);
}
for (int j = dtSource.Columns.Count; j < cols * rows; j++)
{
PdfPCell cell = new PdfPCell(new Phrase("", new Font(basefont, defaultFontSize, Font.BOLD)));
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.HorizontalAlignment = Element.ALIGN_CENTER;//水平居中
if (rows == 1)
{
}
else if (j / cols % rows == 0)
{
cell.DisableBorderSide(2); //1，2，4，8 分别对应每行的上，下，左，右四个边框．
}
else if (j / cols % (rows - 1) == 0)
{
cell.DisableBorderSide(1);
}
else
{
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
}
table.AddCell(cell);
}
for (int i = 0; i < dtSource.Rows.Count; i++)
{
for (int j = 0; j < dtSource.Columns.Count; j++)
{
PdfPCell cell = new PdfPCell(new Phrase(dtSource.Rows[i][j].ToString(), font));
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.HorizontalAlignment = Element.ALIGN_RIGHT;//水平居右
if (rows == 1)
{
}
else if (j / cols % rows == 0)
{
cell.DisableBorderSide(2); //1，2，4，8 分别对应每行的上，下，左，右四个边框．
}
else if (j / cols % (rows - 1) == 0)
{
cell.DisableBorderSide(1);
}
else
{
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
}
table.AddCell(cell);
}
for (int j = dtSource.Columns.Count; j < cols * rows; j++)
{
PdfPCell cell = new PdfPCell(new Phrase("", font));
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.HorizontalAlignment = Element.ALIGN_RIGHT;//水平居右
if (rows == 1)
{
}
else if (j / cols % rows == 0)
{
cell.DisableBorderSide(2); //1，2，4，8 分别对应每行的上，下，左，右四个边框．
}
else if (j / cols % (rows - 1) == 0)
{
cell.DisableBorderSide(1);
}
else
{
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
}
table.AddCell(cell);
}
}
document.Add(pdftable);
document.Add(table);
////關閉document
//writer.Flush();
//writer.CloseStream = true;
document.Close(); //
}
catch (Exception ex)
{
throw new Exception("PdfManagement-->ExportDataTableToPDF-->" + ex.Message);
}
}
/// <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>
/// 貨運單 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>
/// 订单出货明细
/// </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);
}
public void KTPrintPDF()
{
PdfHelper pdf = new PdfHelper();
List<string> pdfList = new List<string>();
float[] arrColWidth = new float[] { 60, 60, 100, 60, 50, 30, 60, 60, 60, 60 };
int index = 0;
string newFileName = string.Empty;
string newName = string.Empty;
string json = string.Empty;
IialgQuery q = new IialgQuery();
if (!string.IsNullOrEmpty(Request.Params["KT_NO"].Trim().ToUpper()))//by zhaozhi0623j add 20151006
{
q.doc_no = Request.Params["KT_NO"].Trim().ToUpper();
}
try
{
List<IialgQuery> store = new List<IialgQuery>();
_iagMgr = new IialgMgr(mySqlConnectionString);
int totalCount = 0;
q.IsPage = false;
store = _iagMgr.GetIialgList(q, out totalCount);
int rid = 0;
DataTable _dtBody = new DataTable();
if (store.Count > 0)
{
_dtBody.Columns.Add("商品細項編號", typeof(string));
_dtBody.Columns.Add("主料位", typeof(string));
_dtBody.Columns.Add("商品名稱", typeof(string));
_dtBody.Columns.Add("規格", typeof(string));
_dtBody.Columns.Add("調整原因", typeof(string));
_dtBody.Columns.Add("數量", typeof(string));
_dtBody.Columns.Add("调整料位", typeof(string));
_dtBody.Columns.Add("有效日期", typeof(string));
_dtBody.Columns.Add("前置單號", typeof(string));
_dtBody.Columns.Add("備註", typeof(string));
for (int i = 0; i < store.Count; i++)
{
store[i].id = rid++;
store[i].qty = store[i].qty_o + store[i].adj_qty;
DataRow newRow = _dtBody.NewRow();
newRow["商品細項編號"] = store[i].item_id;
newRow["主料位"] = store[i].loc_id;
newRow["商品名稱"] = store[i].product_name;
newRow["規格"] = string.IsNullOrEmpty(store[i].prod_sz) ? " " : store[i].prod_sz;
newRow["調整原因"] = string.IsNullOrEmpty(store[i].iarc_id) ? " " : store[i].iarc_id;
newRow["數量"] = store[i].adj_qty;
newRow["调整料位"] = store[i].loc_R;
newRow["有效日期"] = store[i].cde_dt.ToString("yyyy-MM-dd").Substring(0, 10) == "0001-01-01" ? " " : store[i].cde_dt.ToString("yyyy-MM-dd").Substring(0, 10);
newRow["前置單號"] = string.IsNullOrEmpty(store[i].po_id) ? " " : store[i].po_id;
newRow["備註"] = string.IsNullOrEmpty(store[i].remarks) ? " " : store[i].remarks;
_dtBody.Rows.Add(newRow);
}
}
string UsingName = " ";
String UsingTime = " ";
if (store.Count > 0)
{
UsingName = store[0].name;
UsingTime = store[0].create_dtim.ToString("yyyy/MM/dd");
}
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.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑
string filename = "庫存調整" + DateTime.Now.ToString("yyyyMMddHHmmss");
Document document = new Document(PageSize.A4.Rotate());
string newPDFName = Server.MapPath(excelPath) + filename;
PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(newPDFName, FileMode.Create));
document.Open();
#region 庫存調整單頭
PdfPTable ptable = new PdfPTable(10);
ptable.WidthPercentage = 100;//表格寬度
ptable.SetTotalWidth(arrColWidth);
PdfPCell cell = new PdfPCell();
cell = new PdfPCell(new Phrase("執行人員:" + UsingName, new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 8;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("執行日期:" + UsingTime, new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 8;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 4)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 10;
//cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
//cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 15)));
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" 庫存調整單", new iTextSharp.text.Font(bf, 15)));
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("單號" + ":" + q.doc_no, new iTextSharp.text.Font(bf, 10)));// ipoStore[a].po_type_desc
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 4)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 10;
cell.DisableBorderSide(1);
//cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
//cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("商品細項編號", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("主料位", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("商品名稱", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("規格", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("調整原因", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("數量", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
//cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("调整料位", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("有效日期", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("前置單號", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
//cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("備註", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
//cell.DisableBorderSide(8);
ptable.AddCell(cell);
//cell.UseAscender = true;
//cell.HorizontalAlignment = Element.ALIGN_CENTER;//字體垂直居中
//cell.VerticalAlignment = Element.ALIGN_MIDDLE;//字體水平居中
//cell.BorderWidth = 0.1f;
//cell.BorderColor = new BaseColor(0, 0, 0);
#endregion
#region 庫存調整單尾
PdfPTable ptablefoot = new PdfPTable(10);
ptablefoot.WidthPercentage = 100;//表格寬度
ptablefoot.SetTotalWidth(arrColWidth);
PdfPCell footcell = new PdfPCell();
footcell.UseAscender = true;
footcell.HorizontalAlignment = Element.ALIGN_CENTER;//字體垂直居中
footcell.VerticalAlignment = Element.ALIGN_MIDDLE;//字體水平居中
footcell.BorderWidth = 0.1f;
footcell.BorderColor = new BaseColor(0, 0, 0);
footcell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 15)));
footcell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//footcell.HorizontalAlignment = Element.ALIGN_LEFT;//水平居右
footcell.Colspan = 10;
footcell.DisableBorderSide(1);
footcell.DisableBorderSide(2);
footcell.DisableBorderSide(4);
footcell.DisableBorderSide(8);
ptablefoot.AddCell(footcell);
footcell = new PdfPCell(new Phrase("印表日期:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), new iTextSharp.text.Font(bf, 10)));
footcell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居右
// footcell.HorizontalAlignment = Element.ALIGN_LEFT;//水平居右
footcell.Colspan = 2;
footcell.DisableBorderSide(1);
footcell.DisableBorderSide(2);
footcell.DisableBorderSide(4);
footcell.DisableBorderSide(8);
ptablefoot.AddCell(footcell);
footcell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 10)));
footcell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居右
// footcell.HorizontalAlignment = Element.ALIGN_LEFT;//水平居右
footcell.Colspan = 1;
footcell.DisableBorderSide(1);
footcell.DisableBorderSide(2);
footcell.DisableBorderSide(4);
footcell.DisableBorderSide(8);
ptablefoot.AddCell(footcell);
footcell = new PdfPCell(new Phrase("印表人:" + (System.Web.HttpContext.Current.Session["caller"] as Caller).user_username, new iTextSharp.text.Font(bf, 10)));
footcell.VerticalAlignment = Element.ALIGN_RIGHT;//水平居右
footcell.Colspan = 2;
footcell.DisableBorderSide(1);
footcell.DisableBorderSide(2);
footcell.DisableBorderSide(4);
footcell.DisableBorderSide(8);
ptablefoot.AddCell(footcell);
footcell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 10)));
footcell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居右
// footcell.HorizontalAlignment = Element.ALIGN_LEFT;//水平居右
footcell.Colspan = 3;
footcell.DisableBorderSide(1);
footcell.DisableBorderSide(2);
footcell.DisableBorderSide(4);
footcell.DisableBorderSide(8);
ptablefoot.AddCell(footcell);
footcell = new PdfPCell(new Phrase("主管簽核:__________________", new iTextSharp.text.Font(bf, 10)));
footcell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
footcell.Colspan = 2;
footcell.DisableBorderSide(1);
footcell.DisableBorderSide(2);
footcell.DisableBorderSide(4);
footcell.DisableBorderSide(8);
ptablefoot.AddCell(footcell);
#endregion
if (store.Count == 0)
{
document = new Document(PageSize.A4.Rotate());
if (!document.IsOpen())
{
document.Open();
}
cell = new PdfPCell(new Phrase(" ", font));
cell.Colspan = 4;
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("此庫調單庫調數據不存在!", font));
cell.Colspan = 7;
cell.DisableBorderSide(4);
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
ptable.AddCell(cell);
// document.Add(ptable);
//document.Add(ptablefoot);
newFileName = newPDFName + "_part" + index++ + "." + "pdf";
pdf.ExportDataTableToPDF(_dtBody, false, newFileName, arrColWidth, ptable, ptablefoot, "", "", 10, uint.Parse(store.Count.ToString()));/*第一7是列，第二個是行*/
pdfList.Add(newFileName);
}
else
{
newFileName = newPDFName + "_part" + index++ + "." + "pdf";
pdf.ExportDataTableToPDF(_dtBody, false, newFileName, arrColWidth, ptable, ptablefoot, "", "", 10, uint.Parse(store.Count.ToString()));/*第一7是列，第二個是行*/
pdfList.Add(newFileName);
}
//newFileName = newPDFName + "_part" + index++ + "." + "pdf";
//pdf.ExportDataTableToPDF(newFileName, ptable, "", "");
//pdfList.Add(newFileName);
//document.Add(ptable);
//document.NewPage();
newFileName = newPDFName + "." + "pdf";
pdf.MergePDF(pdfList, newFileName);
Response.Clear();
Response.Charset = "gb2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AddHeader("Content-Disposition", "attach-ment;filename=" + filename + ".pdf");
Response.WriteFile(newFileName);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 匯出盤點工作PDF
/// </summary>
public void CountBookPDF()
{
PdfHelper pdf = new PdfHelper();
List<string> pdfList = new List<string>();
float[] arrColWidth = new float[] { 25, 60, 40, 40, 55,40, 140, 50, 40, 50};
string newFileName = string.Empty;
string newName = string.Empty;
string json = string.Empty;
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.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑
string filename = "盤點工作" + DateTime.Now.ToString("yyyyMMddHHmmss");
Document document = new Document(PageSize.A4.Rotate());
string newPDFName = Server.MapPath(excelPath) + filename;
PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(newPDFName, FileMode.Create));
document.Open();
int index = 0;
CbjobMasterQuery query = new CbjobMasterQuery();
List<CbjobMasterQuery> cbjobList = new List<CbjobMasterQuery>();
query.IsPage = false;
if (!string.IsNullOrEmpty(Request.Params["rowIDs"]))
{
query.row_id_IN = Request.Params["rowIDs"].TrimEnd(',');
}
_CbjobMasterMgr = new CbjobMasterMgr(mySqlConnectionString);
int totalCount = 0;
cbjobList = _CbjobMasterMgr.GetjobMaster(query, out totalCount);
DataTable _dtBody = new DataTable();
_dtBody.Columns.Add("編號", typeof(string));
_dtBody.Columns.Add("條碼", typeof(string));
_dtBody.Columns.Add("料位", typeof(string));
_dtBody.Columns.Add("現有庫存", typeof(string));
_dtBody.Columns.Add("盤點數量", typeof(string));
_dtBody.Columns.Add("效期控制", typeof(string));
_dtBody.Columns.Add("品名", typeof(string));
_dtBody.Columns.Add("規格", typeof(string));
_dtBody.Columns.Add("細項編號", typeof(string));
_dtBody.Columns.Add("備註", typeof(string));
PdfPTable ptablefoot = new PdfPTable(10);
if (cbjobList.Count > 0)
{
_cbjobMgr = new CbjobDetailMgr(mySqlConnectionString);
for (int i = 0; i < cbjobList.Count; i++)
{
CbjobDetail cbdetail = new CbjobDetail();
cbdetail.cb_jobid = cbjobList[i].cbjob_id;
DataTable _dtdetail = _cbjobMgr.GetDetailTable(cbdetail);
_dtBody.Rows.Clear();
#region 標頭
#region 標頭
PdfPTable ptable = new PdfPTable(10);
ptable.WidthPercentage = 100;//表格寬度
ptable.SetTotalWidth(arrColWidth);
PdfPCell cell = new PdfPCell();
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 10;
cell.DisableBorderSide(1);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" 盤點薄" + "-" + cbdetail.cb_jobid, new iTextSharp.text.Font(bf, 18)));
cell.VerticalAlignment = Element.ALIGN_LEFT;
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 10;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
//cell.DisableBorderSide(8);
ptable.AddCell(cell);
#endregion
#region 表頭
cell = new PdfPCell(new Phrase("編號", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("條碼", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("料位", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("現有庫存", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("盤點數量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("效期控制", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("品名", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("規格", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("細項編號", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("備註", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
ptable.AddCell(cell);
#endregion
#endregion
if (_dtdetail.Rows.Count > 0)
{
_IiupcMgr = new IupcMgr(mySqlConnectionString);
int a = 0;
foreach (DataRow rows in _dtdetail.Rows)
{
a++;
string upc_id = string.Empty;
#region 取條碼
List<IupcQuery> list = new List<IupcQuery>();
IupcQuery iupc_query = new IupcQuery();
if (!string.IsNullOrEmpty(rows["item_id"].ToString()))
{
uint item_id = uint.Parse(rows["item_id"].ToString());
iupc_query.item_id = item_id;
iupc_query.upc_type_flg = "1";
list = _IiupcMgr.GetIupcByType(iupc_query);
if (list.Count > 0)
{
upc_id = list[0].upc_id;
}
else
{
iupc_query.upc_type_flg = "3";
list = _IiupcMgr.GetIupcByType(iupc_query);
if (list.Count > 0)
{
upc_id = list[0].upc_id;
}
else
{
iupc_query.upc_type_flg = "2";
list = _IiupcMgr.GetIupcByType(iupc_query);
if (list.Count > 0)
{
upc_id = list[0].upc_id;
}
}
}
}
else
{
upc_id = " ";
}
#endregion
DataRow row = _dtBody.NewRow();
row["編號"] = a;
row["條碼"] = upc_id;
row["料位"] = rows["loc_id"];
row["現有庫存"] = rows["prod_qty"];
row["盤點數量"] = "";
row["效期控制"] = string.IsNullOrEmpty(rows["pwy_dte_ctl"].ToString()) ? "否" : (rows["pwy_dte_ctl"].ToString() == "Y" ? "是" : "否");
row["品名"] = rows["product_name"];
row["規格"] = rows["spec_title_1"];
row["細項編號"] = rows["item_id"];
row["備註"] = " ";
_dtBody.Rows.Add(row);
}
}
newFileName = newPDFName + "_part" + index++ + "." + "pdf";
pdf.ExportDataTableToPDF(_dtBody, false, newFileName, arrColWidth, ptable, ptablefoot, "", "", 10, uint.Parse(_dtBody.Rows.Count.ToString()));/*第一7是列，第二個是行*/
pdfList.Add(newFileName);
}
}
if (_dtBody.Rows.Count == 0)
{
#region 標頭
#region 標頭
PdfPTable ptable = new PdfPTable(10);
ptable.WidthPercentage = 100;//表格寬度
ptable.SetTotalWidth(arrColWidth);
PdfPCell cell = new PdfPCell();
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 10;
cell.DisableBorderSide(1);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" 盤點薄", new iTextSharp.text.Font(bf, 18)));
cell.VerticalAlignment = Element.ALIGN_LEFT;
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 10;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
//cell.DisableBorderSide(8);
ptable.AddCell(cell);
#endregion
#region 表頭
cell = new PdfPCell(new Phrase("編號", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("條碼", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("料位", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("現有庫存", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("盤點數量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("效期控制", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("品名", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("規格", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("細項編號", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("備註", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
ptable.AddCell(cell);
#endregion
#endregion
document = new Document(PageSize.A4.Rotate());
if (!document.IsOpen())
{
document.Open();
}
cell = new PdfPCell(new Phrase(" ", font));
cell.Colspan = 4;
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("此工作代號無數據!", font));
cell.Colspan = 3;
cell.DisableBorderSide(4);
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", font));
cell.Colspan = 3;
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
//cell.DisableBorderSide(8);
ptable.AddCell(cell);
// document.Add(ptable);
//document.Add(ptablefoot);
newFileName = newPDFName + "_part" + index++ + "." + "pdf";
pdf.ExportDataTableToPDF(_dtBody, false, newFileName, arrColWidth, ptable, ptablefoot, "", "", 10, uint.Parse(_dtBody.Rows.Count.ToString()));/*第一7是列，第二個是行*/
pdfList.Add(newFileName);
}
newFileName = newPDFName + "." + "pdf";
pdf.MergePDF(pdfList, newFileName);
Response.Clear();
Response.Charset = "gb2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AddHeader("Content-Disposition", "attach-ment;filename=" + filename + ".pdf");
Response.WriteFile(newFileName);
}
public void AseldPDFS()
{
PdfHelper pdf = new PdfHelper();
List<string> pdfList = new List<string>();
float[] arrColWidth = new float[] { 135,50,45, 60, 55, 55,60, 45, 35, 45, 45, 35 };
int index = 0;
string newFileName = string.Empty;
string newName = string.Empty;
string json = string.Empty;
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.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑
string filename = "總量撿貨報表" + DateTime.Now.ToString("yyyyMMddHHmmss");
Document document = new Document(PageSize.A4.Rotate());
string newPDFName = Server.MapPath(excelPath) + filename;
PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(newPDFName, FileMode.Create));
document.Open();
string user_username = (Session["caller"] as Caller).user_username;
DataTable aseldTable = new DataTable();
DataTable assg_idTable = new DataTable();
AseldQuery ase_query = new AseldQuery();
ase_query.IsPage = false;
ase_query.assg_id = string.Empty;
ase_query.start_dtim = DateTime.MinValue;
ase_query.change_dtim = DateTime.MinValue;
int total = 0;
//PdfHelper pdf = new PdfHelper();
//List<string> pdfList = new List<string>();
//string newfilename = string.Empty;
//string filename = "待撿貨商品報表" + DateTime.Now.ToString("yyyyMMddHHmmss");
//string newPDFName = Server.MapPath(excelPath) + filename;
//int index = 0;
int serchWhr = 0;
if (!string.IsNullOrEmpty(Request.Params["assg_id"]))
{
ase_query.assg_id = Request.Params["assg_id"].Trim();
serchWhr++;
}
DateTime date = DateTime.MinValue;
if (Request.Params["start_time"] != "null" && Request.Params["end_time"] != "null")
{
if (DateTime.TryParse(Request.Params["start_time"], out date))
{
ase_query.start_dtim = Convert.ToDateTime(date.ToString("yyyy-MM-dd HH:mm:ss"));
}
if (DateTime.TryParse(Request.Params["end_time"], out date))
{
ase_query.change_dtim = Convert.ToDateTime(date.ToString("yyyy-MM-dd HH:mm:ss"));
}
serchWhr++;
}
IAseldImplMgr aseldMgr = new AseldMgr(mySqlConnectionString);
DataTable _dtBody = new DataTable();
_dtBody.Columns.Add("商品名稱", typeof(string));
_dtBody.Columns.Add("料位編號", typeof(string));
_dtBody.Columns.Add("撿貨庫存", typeof(string));
_dtBody.Columns.Add("本次撿貨量", typeof(string));
_dtBody.Columns.Add("製造日期", typeof(string));
_dtBody.Columns.Add("有效日期", typeof(string));
_dtBody.Columns.Add("條碼", typeof(string));
_dtBody.Columns.Add("細項編號", typeof(string));
_dtBody.Columns.Add("訂貨量", typeof(string));
_dtBody.Columns.Add("已撿貨量", typeof(string));
_dtBody.Columns.Add("待撿貨量", typeof(string));
_dtBody.Columns.Add("備註", typeof(string));
PdfPTable ptablefoot = new PdfPTable(14);
#region MyRegion
#region 數據行
if (ase_query.assg_id != string.Empty)
{
_dtBody.Rows.Clear();
aseldTable = aseldMgr.GetAseldTable(ase_query, out total);
#region 標頭
#region 表頭
PdfPTable ptable = new PdfPTable(12);
ptable.WidthPercentage = 100;//表格寬度
ptable.SetTotalWidth(arrColWidth);
PdfPCell cell = new PdfPCell();
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 12;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("總量撿貨報表", new iTextSharp.text.Font(bf, 18)));
cell.VerticalAlignment = Element.ALIGN_LEFT;
cell.Colspan = 5;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 12;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("印表人：" + user_username, new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 6;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("印表時間：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 12;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
#endregion
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 4;
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("工作代號:" + ase_query.assg_id, new iTextSharp.text.Font(bf, 15)));
cell.VerticalAlignment = Element.ALIGN_CENTER;
cell.Colspan = 5;
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 3;
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("商品名稱", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("料位編號", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("撿貨庫存", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("本次撿貨量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("製造日期", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
//cell = new PdfPCell(new Phrase("撿貨料位編號", new iTextSharp.text.Font(bf, 8)));
//cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(8);
//ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("有效日期", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("條碼", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("細項編號", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("訂貨量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("已撿貨量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("待撿貨量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
//cell = new PdfPCell(new Phrase("創建時間", new iTextSharp.text.Font(bf, 8)));
//cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("備註", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
ptable.AddCell(cell);
#endregion
#region 新增功能
if (aseldTable.Rows.Count > 0)
{
_iinvd = new IinvdMgr(mySqlConnectionString);// GetSearchIinvd
_IiupcMgr = new IupcMgr(mySqlConnectionString);
foreach (DataRow rows in aseldTable.Rows)
{
IinvdQuery IinvdQuery = new IinvdQuery();
IinvdQuery.item_id = uint.Parse(rows["item_id"].ToString());
IinvdQuery.ista_id = "A";
List<IinvdQuery> Store = new List<IinvdQuery>();
Store = _iinvd.GetPlasIinvd(IinvdQuery);
int P_num = string.IsNullOrEmpty(rows["out_qty"].ToString()) ? 0 : int.Parse(rows["out_qty"].ToString()); /*要撿貨的數量*/
string upc_id = string.Empty;
#region 取條碼
List<IupcQuery> list = new List<IupcQuery>();
IupcQuery iupc_query = new IupcQuery();
if (!string.IsNullOrEmpty(rows["item_id"].ToString()))
{
uint item_id = uint.Parse(rows["item_id"].ToString());
iupc_query.item_id = item_id;
iupc_query.upc_type_flg = "1";
list = _IiupcMgr.GetIupcByType(iupc_query);
if (list.Count > 0)
{
upc_id = list[0].upc_id;
}
else
{
iupc_query.upc_type_flg = "3";
list = _IiupcMgr.GetIupcByType(iupc_query);
if (list.Count > 0)
{
upc_id = list[0].upc_id;
}
else
{
iupc_query.upc_type_flg = "2";
list = _IiupcMgr.GetIupcByType(iupc_query);
if (list.Count > 0)
{
upc_id = list[0].upc_id;
}
}
}
}
else
{
upc_id = " ";
}
#endregion
if (Store.Count > 0)
{
int crorow = 0;
for (int i = 0; i < Store.Count; i++)
{
DataRow row = _dtBody.NewRow();
if (Store[i].prod_qty > P_num)
{
if (crorow != 0)
{
row["商品名稱"] = "";
row["條碼"] = "";
row["細項編號"] ="";
row["訂貨量"] = "";
row["已撿貨量"] = "";
row["待撿貨量"] = "";
row["料位編號"] = "";
}
else
{
row["商品名稱"] = rows["product_name"] + rows["spec"].ToString();
row["條碼"] = upc_id;
row["細項編號"] = rows["item_id"];
row["訂貨量"] = rows["ord_qty"];
row["已撿貨量"] = rows["act_pick_qty"];
row["待撿貨量"] = rows["out_qty"];
row["料位編號"] = rows["loc_id"];
}
row["製造日期"] = string.IsNullOrEmpty(Store[i].made_date.ToString()) ? " " : Store[i].made_date.ToString("yyyy/MM/dd");
row["有效日期"] = string.IsNullOrEmpty(Store[i].cde_dt.ToString()) ? " " : Store[i].cde_dt.ToString("yyyy/MM/dd");
row["撿貨庫存"] = P_num;
row["本次撿貨量"] = " ";
row["備註"] = " ";
// row["撿貨料位編號"] = Store[i].plas_loc_id;
// row["創建時間"] = rows["create_dtim"];
_dtBody.Rows.Add(row);
break;
}
else
{
if (crorow != 0)
{
row["商品名稱"] = "";
row["條碼"] = "";
row["細項編號"] = "";
row["訂貨量"] = "";
row["已撿貨量"] = "";
row["待撿貨量"] = "";
row["料位編號"] = "";
}
else
{
row["商品名稱"] = rows["product_name"] + rows["spec"].ToString();
row["條碼"] = upc_id;
row["細項編號"] = rows["item_id"];
row["訂貨量"] = rows["ord_qty"];
row["已撿貨量"] = rows["act_pick_qty"];
row["待撿貨量"] = rows["out_qty"];
row["料位編號"] = rows["loc_id"];
}
row["製造日期"] = string.IsNullOrEmpty(Store[i].made_date.ToString()) ? " " : Store[i].made_date.ToString("yyyy/MM/dd");
row["有效日期"] = string.IsNullOrEmpty(Store[i].cde_dt.ToString()) ? " " : Store[i].cde_dt.ToString("yyyy/MM/dd");
row["撿貨庫存"] = Store[i].prod_qty;
row["本次撿貨量"] = " ";
//row["撿貨料位編號"] = Store[i].plas_loc_id;
// row["創建時間"] = rows["create_dtim"];
row["備註"] = " ";
_dtBody.Rows.Add(row);
P_num -= Store[i].prod_qty;
crorow++;
if (P_num == 0)
break;
}
}
// _dtBody.Rows.Add(row);
}
else
{
DataRow row = _dtBody.NewRow();
row["商品名稱"] = rows["product_name"] + rows["spec"].ToString();
row["條碼"] = upc_id;
row["細項編號"] = rows["item_id"];
row["訂貨量"] = rows["ord_qty"];
row["已撿貨量"] = rows["act_pick_qty"];
row["待撿貨量"] = rows["out_qty"];
row["本次撿貨量"] = " ";
row["料位編號"] = rows["loc_id"];
//row["撿貨料位編號"] = " ";
row["撿貨庫存"] = 0;
row["製造日期"] = " ";
row["有效日期"] = " ";
// row["創建時間"] = rows["create_dtim"];
row["備註"] = " ";
_dtBody.Rows.Add(row);
}
}
}
#endregion
// pdfList.Add(MakePDF(aseldTable, ase_query.assg_id, user_username, newPDFName, index++));
newFileName = newPDFName + "_part" + index++ + "." + "pdf";
pdf.ExportDataTableToPDF(_dtBody, false, newFileName, arrColWidth, ptable, ptablefoot, "", "", 12, uint.Parse(_dtBody.Rows.Count.ToString()));/*第一7是列，第二個是行*/
pdfList.Add(newFileName);
}
else if (ase_query.start_dtim != DateTime.MinValue && ase_query.change_dtim != DateTime.MinValue || serchWhr == 0)
{
assg_idTable = aseldMgr.GetAseldTablePDF(ase_query);
for (int a = 0; a < assg_idTable.Rows.Count; a++)
{
ase_query.assg_id = assg_idTable.Rows[a]["assg_id"].ToString();
aseldTable = aseldMgr.GetAseldTable(ase_query, out total);
_dtBody.Rows.Clear();
#region 標頭
#region 表頭
PdfPTable ptable = new PdfPTable(12);
ptable.WidthPercentage = 100;//表格寬度
ptable.SetTotalWidth(arrColWidth);
PdfPCell cell = new PdfPCell();
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 12;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("總量撿貨報表", new iTextSharp.text.Font(bf, 18)));
cell.VerticalAlignment = Element.ALIGN_LEFT;
cell.Colspan = 5;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 12;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("印表人：" + user_username, new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 6;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("印表時間：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 12;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
#endregion
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 4;
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("工作代號:" + ase_query.assg_id, new iTextSharp.text.Font(bf, 15)));
cell.VerticalAlignment = Element.ALIGN_CENTER;
cell.Colspan = 5;
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 3;
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("商品名稱", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("料位編號", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("撿貨庫存", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("本次撿貨量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("製造日期", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
//cell = new PdfPCell(new Phrase("撿貨料位編號", new iTextSharp.text.Font(bf, 8)));
//cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(8);
//ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("有效日期", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("條碼", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("細項編號", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("訂貨量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("已撿貨量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("待撿貨量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
//cell = new PdfPCell(new Phrase("創建時間", new iTextSharp.text.Font(bf, 8)));
//cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("備註", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
ptable.AddCell(cell);
#endregion
#region 新增功能
if (aseldTable.Rows.Count > 0)
{
_iinvd = new IinvdMgr(mySqlConnectionString);// GetSearchIinvd
_IiupcMgr = new IupcMgr(mySqlConnectionString);
foreach (DataRow rows in aseldTable.Rows)
{
IinvdQuery IinvdQuery = new IinvdQuery();
IinvdQuery.item_id = uint.Parse(rows["item_id"].ToString());
IinvdQuery.ista_id = "A";
List<IinvdQuery> Store = new List<IinvdQuery>();
Store = _iinvd.GetPlasIinvd(IinvdQuery);
int P_num = string.IsNullOrEmpty(rows["out_qty"].ToString()) ? 0 : int.Parse(rows["out_qty"].ToString()); /*要撿貨的數量*/
string upc_id = string.Empty;
#region 取條碼
List<IupcQuery> list = new List<IupcQuery>();
IupcQuery iupc_query = new IupcQuery();
if (!string.IsNullOrEmpty(rows["item_id"].ToString()))
{
uint item_id = uint.Parse(rows["item_id"].ToString());
iupc_query.item_id = item_id;
iupc_query.upc_type_flg = "1";
list = _IiupcMgr.GetIupcByType(iupc_query);
if (list.Count > 0)
{
upc_id = list[0].upc_id;
}
else
{
iupc_query.upc_type_flg = "3";
list = _IiupcMgr.GetIupcByType(iupc_query);
if (list.Count > 0)
{
upc_id = list[0].upc_id;
}
else
{
iupc_query.upc_type_flg = "2";
list = _IiupcMgr.GetIupcByType(iupc_query);
if (list.Count > 0)
{
upc_id = list[0].upc_id;
}
}
}
}
else
{
upc_id = " ";
}
#endregion
if (Store.Count > 0)
{
int crorow = 0;
for (int i = 0; i < Store.Count; i++)
{
DataRow row = _dtBody.NewRow();
if (Store[i].prod_qty > P_num)
{
if (crorow != 0)
{
row["商品名稱"] = "";
row["條碼"] = "";
row["細項編號"] = "";
row["訂貨量"] = "";
row["已撿貨量"] = "";
row["待撿貨量"] = "";
row["料位編號"] = "";
}
else
{
row["商品名稱"] = rows["product_name"] + rows["spec"].ToString();
row["條碼"] = upc_id;
row["細項編號"] = rows["item_id"];
row["訂貨量"] = rows["ord_qty"];
row["已撿貨量"] = rows["act_pick_qty"];
row["待撿貨量"] = rows["out_qty"];
row["料位編號"] = rows["loc_id"];
}
row["製造日期"] = string.IsNullOrEmpty(Store[i].made_date.ToString()) ? " " : Store[i].made_date.ToString("yyyy/MM/dd");
row["有效日期"] = string.IsNullOrEmpty(Store[i].cde_dt.ToString()) ? " " : Store[i].cde_dt.ToString("yyyy/MM/dd");
row["撿貨庫存"] = P_num;
row["本次撿貨量"] = " ";
row["備註"] = " ";
_dtBody.Rows.Add(row);
break;
}
else
{
if (crorow != 0)
{
row["商品名稱"] = "";
row["條碼"] = "";
row["細項編號"] = "";
row["訂貨量"] = "";
row["已撿貨量"] = "";
row["待撿貨量"] = "";
row["料位編號"] = "";
}
else
{
row["商品名稱"] = rows["product_name"] + rows["spec"].ToString();
row["條碼"] = upc_id;
row["細項編號"] = rows["item_id"];
row["訂貨量"] = rows["ord_qty"];
row["已撿貨量"] = rows["act_pick_qty"];
row["待撿貨量"] = rows["out_qty"];
row["料位編號"] = rows["loc_id"];
}
row["製造日期"] = string.IsNullOrEmpty(Store[i].made_date.ToString()) ? " " : Store[i].made_date.ToString("yyyy/MM/dd");
row["有效日期"] = string.IsNullOrEmpty(Store[i].cde_dt.ToString()) ? " " : Store[i].cde_dt.ToString("yyyy/MM/dd");
row["撿貨庫存"] = Store[i].prod_qty;
row["本次撿貨量"] = " ";
//row["撿貨料位編號"] = Store[i].plas_loc_id;
// row["創建時間"] = rows["create_dtim"];
row["備註"] = " ";
_dtBody.Rows.Add(row);
crorow++;
P_num -= Store[i].prod_qty;
if (P_num == 0)
break;
}
}
// _dtBody.Rows.Add(row);
}
else
{
DataRow row = _dtBody.NewRow();
row["商品名稱"] = rows["product_name"] + rows["spec"].ToString();
row["條碼"] = upc_id;
row["細項編號"] = rows["item_id"];
row["訂貨量"] = rows["ord_qty"];
row["已撿貨量"] = rows["act_pick_qty"];
row["待撿貨量"] = rows["out_qty"];
row["本次撿貨量"] = " ";
row["料位編號"] = rows["loc_id"];
//row["撿貨料位編號"] = " ";
row["撿貨庫存"] = 0;
row["製造日期"] = " ";
row["有效日期"] = " ";
// row["創建時間"] = rows["create_dtim"];
row["備註"] = " ";
_dtBody.Rows.Add(row);
}
}
}
#endregion
// pdfList.Add(MakePDF(aseldTable, ase_query.assg_id, user_username, newPDFName, index++));
newFileName = newPDFName + "_part" + index++ + "." + "pdf";
pdf.ExportDataTableToPDF(_dtBody, false, newFileName, arrColWidth, ptable, ptablefoot, "", "", 12, uint.Parse(_dtBody.Rows.Count.ToString()));/*第一7是列，第二個是行*/
pdfList.Add(newFileName);
}
}
#endregion
#endregion
if (_dtBody.Rows.Count == 0)
{
#region 標頭
#region 表頭
PdfPTable ptable = new PdfPTable(12);
ptable.WidthPercentage = 100;//表格寬度
ptable.SetTotalWidth(arrColWidth);
PdfPCell cell = new PdfPCell();
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 12;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("總量撿貨報表", new iTextSharp.text.Font(bf, 18)));
cell.VerticalAlignment = Element.ALIGN_LEFT;
cell.Colspan = 5;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 12;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("印表人：" + user_username, new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 6;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("印表時間：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 12;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
#endregion
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 4;
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("工作代號:" + ase_query.assg_id, new iTextSharp.text.Font(bf, 15)));
cell.VerticalAlignment = Element.ALIGN_CENTER;
cell.Colspan = 5;
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 3;
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("商品名稱", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("料位編碼", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("撿貨庫存", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("本次撿貨量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("製造日期", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
//cell = new PdfPCell(new Phrase("撿貨料位編號", new iTextSharp.text.Font(bf, 8)));
//cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(8);
//ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("有效日期", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("條碼", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("細項編號", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("訂貨量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("已撿貨量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("待撿貨量", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
//cell = new PdfPCell(new Phrase("創建時間", new iTextSharp.text.Font(bf, 8)));
//cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("備註", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
ptable.AddCell(cell);
#endregion
document = new Document(PageSize.A4.Rotate());
if (!document.IsOpen())
{
document.Open();
}
cell = new PdfPCell(new Phrase(" ", font));
cell.Colspan = 5;
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("此工作代號無數據!", font));
cell.Colspan = 9;
cell.DisableBorderSide(4);
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
ptable.AddCell(cell);
// document.Add(ptable);
//document.Add(ptablefoot);
newFileName = newPDFName + "_part" + index++ + "." + "pdf";
pdf.ExportDataTableToPDF(_dtBody, false, newFileName, arrColWidth, ptable, ptablefoot, "", "", 12, uint.Parse(_dtBody.Rows.Count.ToString()));/*第一7是列，第二個是行*/
pdfList.Add(newFileName);
}
//else
//{
// newFileName = newPDFName + "_part" + index++ + "." + "pdf";
// pdf.ExportDataTableToPDF(_dtBody, false, newFileName, arrColWidth, ptable, ptablefoot, "", "", 11, uint.Parse(_dtBody.Rows.Count.ToString()));/*第一7是列，第二個是行*/
// pdfList.Add(newFileName);
//}
newFileName = newPDFName + "." + "pdf";
pdf.MergePDF(pdfList, newFileName);
Response.Clear();
Response.Charset = "gb2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AddHeader("Content-Disposition", "attach-ment;filename=" + filename + ".pdf");
Response.WriteFile(newFileName);
}
/// <summary>
/// 匯出pdf文檔
/// </summary>
//public void WritePdf()
//{
// string newName = string.Empty;
// string json = string.Empty;
// IpodQuery ipod = new IpodQuery();
// IpoQuery ipo = new IpoQuery();
// if (!string.IsNullOrEmpty(Request.Params["Poid"]))
// {
// ipo.po_id = Request.Params["Poid"];
// }
// if (!string.IsNullOrEmpty(Request.Params["Potype"]))
// {
// ipo.po_type = Request.Params["Potype"];
// }
// List<IpodQuery> ipodStore = new List<IpodQuery>();
// List<IpoQuery> ipoStore = new List<IpoQuery>();
// _ipoMgr = new IpoMgr(mySqlConnectionString);
// int totalCount = 0;
// ipo.IsPage = false;
// ipoStore = _ipoMgr.GetIpoList(ipo, out totalCount);
// try
// {
// #region 採購單匯出
// 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.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑
// string filename = "採購單"+ DateTime.Now.ToString("yyyyMMddHHmmss") +".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();
// //運送方式
// _paraMgr = new ParameterMgr(mySqlConnectionString);
// List<Parametersrc> parameterStore = new List<Parametersrc>();
// parameterStore = _paraMgr.GetElementType("product_freight");
// for (int a = 0; a < ipoStore.Count; a++)//循環單頭
// {
// //GetIpodListExprot
// _ipodMgr = new IpodMgr(mySqlConnectionString);
// ipod = new IpodQuery();
// ipod.po_id = ipoStore[a].po_id;
// ipodStore = new List<IpodQuery>();
// ipodStore = _ipodMgr.GetIpodListExprot(ipod);
// Dictionary<int, List<IpodQuery>> product_freight_set_mapping = new Dictionary<int, List<IpodQuery>>();
// #region 通過運送方式把採購單分開--一張採購單，分成常溫，冷凍等採購單
// for (int i = 0; i < ipodStore.Count; i++)//通過運送方式保存到字典里
// {
// ipodStore[i].spec = GetProductSpec(ipodStore[i].item_id.ToString());
// IupcQuery upc = new IupcQuery();
// upc.item_id = ipodStore[i].item_id;
// List<IupcQuery> upcStore = new List<IupcQuery>();
// _IiupcMgr = new IupcMgr(mySqlConnectionString);
// upcStore = _IiupcMgr.GetIupcByItemID(upc);
// if (upcStore.Count > 0)
// {
// ipodStore[i].upc_id = upcStore[0].upc_id;
// }
// int freiset = ipodStore[i].product_freight_set;
// if (!product_freight_set_mapping.Keys.Contains(freiset))
// {
// List<IpodQuery> s = new List<IpodQuery>();
// product_freight_set_mapping.Add(freiset, s);
// }
// product_freight_set_mapping[freiset].Add(ipodStore[i]);
// }
// #endregion
// #region 針對匯出一個而無商品的pdf
// if (ipodStore.Count == 0)
// {
// #region 獲取供應商信息
// Vendor vendor = new Vendor();
// _vendorMgr = new VendorMgr(mySqlConnectionString);
// vendor.erp_id = ipoStore[a].vend_id;
// vendor = _vendorMgr.GetSingle(vendor);
// #endregion
// #region 採購單標題
// PdfContentByte cb = writer.DirectContent;
// cb.BeginText();
// cb.SetFontAndSize(bf, 15);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "吉甲地好市集股份有限公司", 220, 790, 0);
// font = new iTextSharp.text.Font(bf, 12, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑
// cb.SetFontAndSize(bf, 12);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "採購單" + "-" + ipoStore[a].po_type_desc, 280, 770, 0);
// cb.SetFontAndSize(bf, 8);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "公司電話：", 60, 760, 0);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "公司傳真：", 470, 760, 0);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "製造日期：" + DateTime.Now.ToString("yyyy/MM/dd"), 60, 750, 0);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "頁", 510, 750, 0);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "次", 530, 750, 0);
// #endregion
// PdfPTable ptable = new PdfPTable(6);
// ptable.WidthPercentage = 150;//表格寬度
// font = new iTextSharp.text.Font(bf, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑
// ptable.SetTotalWidth(new float[] { 82, 50, 100, 90, 110, 71 });
// PdfPCell cell = new PdfPCell();
// cell.UseAscender = true;
// cell.HorizontalAlignment = Element.ALIGN_CENTER;//字體垂直居中
// cell.VerticalAlignment = Element.ALIGN_MIDDLE;//字體水平居中
// cell.BorderWidth = 0.1f;
// cell.BorderColor = new BaseColor(0, 0, 0);
// #region 上部分
// cell = new PdfPCell(new Phrase("採購單別:" + ipoStore[a].po_type, font));
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("交易幣別:" + "世界貨幣", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("匯率:" + "浮動", font));
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("運輸方式:" , font));
// cell.Colspan = 2;
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("商品是新品么？:", font));//新品
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("所在層:", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("採購單(" + ipoStore[a].po_type_desc + ")", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("預約到貨日期:", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("採購單號:" + ipoStore[a].po_id, font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("課稅別:", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("營業稅率:", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("價格條件:", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("單據日期:" + DateTime.Now.ToString("yyyy/MM/dd"), font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("採購人員:" + ipoStore[a].buyer, font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase((System.Web.HttpContext.Current.Session["caller"] as Caller).user_username, font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("廠別代號:", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("gigade(讀取)", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("廠商代號:" + ipoStore[a].vend_id, font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("付款條件(讀取)", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("月結N天(讀取):", font));
// cell.Colspan = 3;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("廠商全名(讀取):" , font));
// cell.Colspan = 4;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("備註:", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("廠商地址:", font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(" ", font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("聯絡人(讀取):", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("廠商電話:" , font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("廠商傳真:" , font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("送貨地址(讀取):", font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(" ", font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("預計送貨日期(讀取):", font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("配送聯絡人(讀取):", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("配送電話(讀取):", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("配送傳真(讀取):", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("處理備註:", font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("運送備註:", font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// ptable.AddCell(cell);
// #endregion
// ptable.WriteSelectedRows(0, -1, 46, 740, writer.DirectContent);//顯示的開始行，結束航(-1為所有)x坐標，y坐標
// 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 = 292;
// document.Add(nulltable);
// ptable = new PdfPTable(6);
// ptable.WidthPercentage = 86;//表格寬度
// font = new iTextSharp.text.Font(bf, 9, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑
// ptable.SetTotalWidth(new float[] { 90, 130, 50, 50, 60, 120 });
// cell = new PdfPCell(new Phrase("此採購單商品不存在!", font));
// cell.Colspan = 6;
// ptable.AddCell(cell);
// cb.EndText();
// document.Add(ptable);
// document.NewPage();
// }
// #endregion
// foreach (int key in product_freight_set_mapping.Keys)
// {
// #region 取出運送方式
// string procduct_freight = "";
// for (int i = 0; i < parameterStore.Count; i++)
// {
// if (key.ToString() == parameterStore[i].ParameterCode)
// {
// procduct_freight = parameterStore[i].parameterName;
// }
// }
// #endregion
// #region 獲取供應商信息
// Vendor vendor = new Vendor();
// _vendorMgr = new VendorMgr(mySqlConnectionString);
// vendor.erp_id = ipoStore[a].vend_id;
// vendor = _vendorMgr.GetSingle(vendor);
// #endregion
// #region 採購單標題
// PdfContentByte cb = writer.DirectContent;
// cb.BeginText();
// cb.SetFontAndSize(bf, 15);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "吉甲地好市集股份有限公司", 220, 790, 0);
// font = new iTextSharp.text.Font(bf, 12, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑
// cb.SetFontAndSize(bf, 12);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "採購單" + "-" + ipoStore[a].po_type_desc, 280, 770, 0);
// cb.SetFontAndSize(bf, 8);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "公司電話：", 60, 760, 0);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "公司傳真：", 470, 760, 0);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "製造日期：" + DateTime.Now.ToString("yyyy/MM/dd"), 60, 750, 0);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "頁", 510, 750, 0);
// cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "次", 530, 750, 0);
// #endregion
// PdfPTable ptable = new PdfPTable(6);
// ptable.WidthPercentage = 150;//表格寬度
// font = new iTextSharp.text.Font(bf, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑
// ptable.SetTotalWidth(new float[] { 82, 50, 100, 90, 110, 71 });
// PdfPCell cell = new PdfPCell();
// cell.UseAscender = true;
// cell.HorizontalAlignment = Element.ALIGN_CENTER;//字體垂直居中
// cell.VerticalAlignment = Element.ALIGN_MIDDLE;//字體水平居中
// cell.BorderWidth = 0.1f;
// cell.BorderColor = new BaseColor(0, 0, 0);
// #region 上部分
// cell = new PdfPCell(new Phrase("採購單別:" + ipoStore[a].po_type, font));
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("交易幣別:" + "世界貨幣", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("匯率:" + "浮動", font));
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("運輸方式:" + procduct_freight, font));
// cell.Colspan = 2;
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("商品是新品么？:", font));//新品
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("所在層:", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("採購單(" + ipoStore[a].po_type_desc + ")", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("預約到貨日期:", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("採購單號:" + ipoStore[a].po_id, font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("課稅別:", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("營業稅率:", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("價格條件:", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("單據日期:" + DateTime.Now.ToString("yyyy/MM/dd"), font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("採購人員:" + ipoStore[a].buyer, font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase((System.Web.HttpContext.Current.Session["caller"] as Caller).user_username, font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("廠別代號:" , font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("gigade(讀取)", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("廠商代號:" + ipoStore[a].vend_id, font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(vendor == null ? "暫無此信息" : vendor.vendor_name_simple, font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("付款條件(讀取)", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("月結N天(讀取):", font));
// cell.Colspan = 3;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(vendor == null ? "廠商全名(讀取):暫無此信息" :"廠商全名:"+ vendor.vendor_name_full, font));
// cell.Colspan = 4;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("備註:", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(vendor == null ? "廠商地址:暫無此信息" : "廠商地址:"+vendor.company_address, font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(" ", font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("聯絡人(讀取):", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(vendor == null?"廠商電話:暫無此信息" :"廠商電話:"+ vendor.company_phone, font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(vendor == null? "廠商傳真:暫無此信息" :"廠商傳真:"+ vendor.company_fax, font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("送貨地址(讀取):", font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(" ", font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("預計送貨日期(讀取):", font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("配送聯絡人(讀取):", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("配送電話(讀取):", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("配送傳真(讀取):", font));
// cell.Colspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("處理備註:", font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("運送備註:", font));
// cell.Colspan = 6;
// cell.DisableBorderSide(1);
// ptable.AddCell(cell);
// #endregion
// ptable.WriteSelectedRows(0, -1, 46, 740, writer.DirectContent);//顯示的開始行，結束航(-1為所有)x坐標，y坐標
// 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 = 292;
// document.Add(nulltable);
// ptable = new PdfPTable(6);
// ptable.WidthPercentage = 86;//表格寬度
// font = new iTextSharp.text.Font(bf, 9, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑
// ptable.SetTotalWidth(new float[] { 90, 130, 50, 50, 60, 120 });
// #region 下面表格頭部
// cell = new PdfPCell(new Phrase("條碼", font));
// cell.Rowspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("品號", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("採購數量", font));
// cell.HorizontalAlignment = Element.ALIGN_RIGHT;//.setHorizontalAlignment(Element.ALIGN_CENTER);
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("允收天數", font));
// cell.HorizontalAlignment = Element.ALIGN_RIGHT;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("製造日期", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("備註", font));
// cell.Rowspan = 3;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("品名", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("允收數量", font));
// cell.HorizontalAlignment = Element.ALIGN_RIGHT;//.setHorizontalAlignment(Element.ALIGN_CENTER);
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("允出天數", font));
// cell.HorizontalAlignment = Element.ALIGN_RIGHT;//.setHorizontalAlignment(Element.ALIGN_CENTER);
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("有效日期", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(4);
// cell.Rowspan = 2;
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("料位", font));
// cell.DisableBorderSide(1);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("規格", font));
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("不允收數量", font));
// cell.HorizontalAlignment = Element.ALIGN_RIGHT;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("有效期天數", font));
// cell.HorizontalAlignment = Element.ALIGN_RIGHT;//.setHorizontalAlignment(Element.ALIGN_CENTER);
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// #endregion
// _ipodMgr = new IpodMgr(mySqlConnectionString);
// ipod = new IpodQuery();
// ipod.po_id = ipoStore[a].po_id;
// ipod.IsPage = false;
// ipodStore = new List<IpodQuery>();
// ipodStore = _ipodMgr.GetIpodList(ipod, out totalCount);
// List<IpodQuery> Ipodleibie = new List<IpodQuery>();
// Ipodleibie.AddRange(product_freight_set_mapping[key]);
// #region 循環讀取數據填入表格
// for (int i = 0; i < Ipodleibie.Count; i++)
// {
// //string sResult = "";
// //if (ipodStore[i].pod_id.ToString().Length < 4)
// //{
// // for (int n = 0; n < 4 - (ipodStore[i].pod_id.ToString().Length); n++)
// // {
// // sResult += "0";
// // }
// //}
// cell = new PdfPCell(new Phrase(Ipodleibie[i].upc_id, font));//條碼
// cell.Rowspan = 2;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(Ipodleibie[i].Erp_Id.ToString(), font));//品號
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(Ipodleibie[i].qty_ord.ToString(), font));//採購數量qty_ord
// cell.HorizontalAlignment = Element.ALIGN_RIGHT;//.setHorizontalAlignment(Element.ALIGN_CENTER);
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(Ipodleibie[i].cde_dt_var.ToString(), font));//允收天數cde_dt_var
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// cell.HorizontalAlignment = Element.ALIGN_RIGHT;//.setHorizontalAlignment(Element.ALIGN_CENTER);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("", font));//製造日期
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("", font));//備註
// cell.Rowspan = 3;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(Ipodleibie[i].product_name, font));//品名
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(Ipodleibie[i].qty_claimed.ToString(), font));//允收數量
// cell.HorizontalAlignment = Element.ALIGN_RIGHT;//.setHorizontalAlignment(Element.ALIGN_CENTER);
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(Ipodleibie[i].cde_dt_shp.ToString(), font));//允出天數
// cell.HorizontalAlignment = Element.ALIGN_RIGHT;//.setHorizontalAlignment(Element.ALIGN_CENTER);
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase("", font));//有效日期
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(4);
// cell.Rowspan = 2;
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(Ipodleibie[i].loc_id, font));//料位
// cell.DisableBorderSide(1);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(Ipodleibie[i].spec, font));//規格
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(Ipodleibie[i].qty_damaged.ToString(), font));//不允收數量
// cell.HorizontalAlignment = Element.ALIGN_RIGHT;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// cell = new PdfPCell(new Phrase(Ipodleibie[i].cde_dt_incr.ToString(), font));//有效期天數
// cell.HorizontalAlignment = Element.ALIGN_RIGHT;
// cell.DisableBorderSide(1);
// cell.DisableBorderSide(4);
// ptable.AddCell(cell);
// }
// #endregion
// //cell = new PdfPCell(new Phrase(" 數量合計:" + 5, font));
// //cell.Colspan = 2;
// //cell.DisableBorderSide(1);
// //cell.DisableBorderSide(8);
// //cell.HorizontalAlignment = Element.ALIGN_CENTER;
// //ptable.AddCell(cell);
// //cell = new PdfPCell(new Phrase(" 採購金額:", font));
// //cell.Colspan = 2;
// //cell.HorizontalAlignment = Element.ALIGN_CENTER;
// //cell.DisableBorderSide(1);
// //cell.DisableBorderSide(4);
// //cell.DisableBorderSide(8);
// //ptable.AddCell(cell);
// //cell = new PdfPCell(new Phrase(" 稅額:", font));
// //cell.Colspan = 2;
// //cell.HorizontalAlignment = Element.ALIGN_CENTER;
// //cell.DisableBorderSide(1);
// //cell.DisableBorderSide(4);
// //ptable.AddCell(cell);
// //cell = new PdfPCell(new Phrase(" 金額合計:", font));
// //cell.Colspan = 2;
// //cell.DisableBorderSide(1);
// //cell.DisableBorderSide(4);
// //ptable.AddCell(cell);
// //Sumtable.AddCell(ptable);
// cb.EndText();
// // Sumtable.SpacingAfter = 0;
// ptable.SpacingAfter = 250;
// //Sumtable.WriteSelectedRows(0, -1, 60, 740, writer.DirectContent);//顯示的開始行，結束航(-1為所有)x坐標，y坐標
// document.Add(ptable);
// document.NewPage();
// }
// }
// 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);
// //}
// #endregion
// //}
// }
// catch (Exception ex)
// {
// //cb.EndText();
// //writer.Resume();
// //Response.Clear();
// }
//}
public void WritePdf()
{
PdfHelper pdf = new PdfHelper();
List<string> pdfList = new List<string>();
//float[] arrColWidth_pftable = new float[] { 30,100, 80, 60, 60, 60, 60 };
float[] arrColWidth = new float[] { 30, 100, 80, 60, 60, 60, 60 };
int index = 0;
string newFileName = string.Empty;
string newName = string.Empty;
string json = string.Empty;
IpodQuery ipod = new IpodQuery();
IpoQuery ipo = new IpoQuery();
if (!string.IsNullOrEmpty(Request.Params["Poid"]))
{
ipo.po_id = Request.Params["Poid"];
}
if (!string.IsNullOrEmpty(Request.Params["Potype"]))
{
ipo.po_type = Request.Params["Potype"];
}
if (!string.IsNullOrEmpty(Request.Params["start_time"]))
{
ipo.start_time = Convert.ToDateTime(Request.Params["start_time"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["end_time"]))
{
ipo.end_time = Convert.ToDateTime(Request.Params["end_time"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["freight"]))
{
ipo.freight = Convert.ToInt32(Request.Params["freight"].ToString());
}
List<IpodQuery> ipodStore = new List<IpodQuery>();
List<IpoQuery> ipoStore = new List<IpoQuery>();
_ipoMgr = new IpoMgr(mySqlConnectionString);
int totalCount = 0;
ipo.IsPage = false;
ipoStore = _ipoMgr.GetIpoList(ipo, out totalCount);
//if (!string.IsNullOrEmpty(Request.Params["freight"]))
//{
// if (Request.Params["freight"].ToString() != "0")
// {
// _ipodMgr = new IpodMgr(mySqlConnectionString);
// List<IpoQuery> newstore = new List<IpoQuery>();
// foreach (IpoQuery item in ipoStore)
// {
// if (!string.IsNullOrEmpty(item.po_id))
// {
// if (_ipodMgr.GetIpodfreight(item.po_id, Convert.ToInt32(Request.Params["freight"].ToString())))
// {
// newstore.Add(item);
// }
// }
// }
// ipoStore = newstore;
// }
//}
try
{
#region 採購單匯出
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.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑
string filename = "採購單" + DateTime.Now.ToString("yyyyMMddHHmmss");
Document document = new Document(PageSize.A4);
string newPDFName = Server.MapPath(excelPath) + filename;
PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(newPDFName, FileMode.Create));
document.Open();
//運送方式
_paraMgr = new ParameterMgr(mySqlConnectionString);
List<Parametersrc> parameterStore = new List<Parametersrc>();
parameterStore = _paraMgr.GetElementType("product_freight");
if (ipoStore.Count == 0)
{
}
for (int a = 0; a < ipoStore.Count; a++)//循環單頭
{
_ipodMgr = new IpodMgr(mySqlConnectionString);
ipod = new IpodQuery();
ipod.po_id = ipoStore[a].po_id;
ipodStore = new List<IpodQuery>();
ipodStore = _ipodMgr.GetIpodListExprot(ipod);
Dictionary<int, List<IpodQuery>> product_freight_set_mapping = new Dictionary<int, List<IpodQuery>>();
#region 通過運送方式把採購單分開--一張採購單，分成常溫，冷凍等採購單
for (int i = 0; i < ipodStore.Count; i++)//通過運送方式保存到字典里
{
ipodStore[i].spec = GetProductSpec(ipodStore[i].prod_id.ToString());//--------取值出錯了item_id-----------
IupcQuery upc = new IupcQuery();
_IiupcMgr = new IupcMgr(mySqlConnectionString);
upc.item_id = uint.Parse(ipodStore[i].prod_id);//--------取值出錯了item_id-----------
//獲取國際條碼
List<IupcQuery> upcInternationalStore = new List<IupcQuery>();
upc.upc_type_flg = "1";
upcInternationalStore = _IiupcMgr.GetIupcByType(upc);
//獲取店內條碼
List<IupcQuery> upcShopStore = new List<IupcQuery>();
upc.upc_type_flg = "3";
upcShopStore = _IiupcMgr.GetIupcByType(upc);
if (upcInternationalStore.Count > 0)
{
ipodStore[i].upc_id_international = upcInternationalStore[0].upc_id;
}
if (upcShopStore.Count > 0)
{
ipodStore[i].upc_id_shop = upcShopStore[0].upc_id;
}
int freiset = ipodStore[i].product_freight_set;
if (!product_freight_set_mapping.Keys.Contains(freiset))
{
List<IpodQuery> s = new List<IpodQuery>();
product_freight_set_mapping.Add(freiset, s);
}
product_freight_set_mapping[freiset].Add(ipodStore[i]);
}
#endregion
#region 針對匯出一個而無商品的pdf
if (ipodStore.Count == 0)
{
#region 獲取供應商信息
Vendor vendor = new Vendor();
_vendorMgr = new VendorMgr(mySqlConnectionString);
vendor.erp_id = ipoStore[a].vend_id;
vendor = _vendorMgr.GetSingle(vendor);
#endregion
#region 採購單標題
PdfPTable ptable = new PdfPTable(7);
ptable.WidthPercentage = 100;//表格寬度
font = new iTextSharp.text.Font(bf, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑
ptable.SetTotalWidth(arrColWidth);
PdfPCell cell = new PdfPCell();
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 15)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" 吉甲地好市集股份有限公司", new iTextSharp.text.Font(bf, 15)));
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.Colspan = 5;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("採購單" + "-" + ipoStore[a].po_type_desc, new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("公司電話：", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 6;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("公司傳真：", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 1;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("製造日期：" + DateTime.Now.ToString("yyyy/MM/dd"), new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell.UseAscender = true;
cell.HorizontalAlignment = Element.ALIGN_CENTER;//字體垂直居中
cell.VerticalAlignment = Element.ALIGN_MIDDLE;//字體水平居中
cell.BorderWidth = 0.1f;
cell.BorderColor = new BaseColor(0, 0, 0);
#endregion
#region 上部分
cell = new PdfPCell(new Phrase("採購單別:" + ipoStore[a].po_type, font));
cell.Colspan = 2;
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("交易幣別:" + "世界貨幣", font));
cell.Colspan = 1;
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("匯率:" + "浮動", font));
cell.Colspan = 2;
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("運輸方式:", font));
cell.Colspan = 2;
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("商品是新品么？:", font));//新品
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("所在層:", font));
cell.Colspan = 1;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("採購單(" + ipoStore[a].po_type_desc + ")", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("預約到貨日期:", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("採購單號:" + ipoStore[a].po_id, font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("課稅別:", font));
cell.Colspan = 1;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("營業稅率:", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("價格條件:", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("單據日期:" + DateTime.Now.ToString("yyyy/MM/dd"), font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("採購人員:" + ipoStore[a].buyer, font));
cell.Colspan = 1;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase((System.Web.HttpContext.Current.Session["caller"] as Caller).user_username, font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("廠別代號:", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("gigade(讀取)", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("廠商代號:" + ipoStore[a].vend_id, font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", font));
cell.Colspan = 1;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("付款條件(讀取)", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("月結N天(讀取):", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("廠商全名(讀取):", font));
cell.Colspan = 5;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("備註:", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("廠商地址:", font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("聯絡人(讀取):", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("廠商電話:", font));
cell.Colspan = 1;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("廠商傳真:", font));
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("送貨地址(讀取):", font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("預計送貨日期(讀取):", font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("配送聯絡人(讀取):", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("配送電話(讀取):", font));
cell.Colspan = 1;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("配送傳真(讀取):", font));
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("處理備註:", font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("運送備註:", font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
ptable.AddCell(cell);
#endregion
cell = new PdfPCell(new Phrase("此採購單商品不存在!", font));
cell.Colspan = 7;
ptable.AddCell(cell);
newFileName = newPDFName + "_part" + index++ + "." + "pdf";
pdf.ExportDataTableToPDF(newFileName, ptable, "", "");
pdfList.Add(newFileName);
document.Add(ptable);
document.NewPage();
}
#endregion
foreach (int key in product_freight_set_mapping.Keys)
{
#region 取出運送方式
string procduct_freight = "";
for (int i = 0; i < parameterStore.Count; i++)
{
if (key.ToString() == parameterStore[i].ParameterCode)
{
procduct_freight = parameterStore[i].parameterName;
}
}
#endregion
#region 獲取供應商信息
Vendor vendor = new Vendor();
_vendorMgr = new VendorMgr(mySqlConnectionString);
vendor.erp_id = ipoStore[a].vend_id;
vendor = _vendorMgr.GetSingle(vendor);
#endregion
#region 採購單標題
PdfPTable ptable = new PdfPTable(7);
ptable.WidthPercentage = 100;//表格寬度
font = new iTextSharp.text.Font(bf, 10, iTextSharp.text.Font.NORMAL, new iTextSharp.text.BaseColor(0, 0, 0));//黑
ptable.SetTotalWidth(arrColWidth);
PdfPCell cell = new PdfPCell();
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 15)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" 吉甲地好市集股份有限公司", new iTextSharp.text.Font(bf, 15)));
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.Colspan = 5;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" 採購單" + "-" + ipoStore[a].po_type_desc, new iTextSharp.text.Font(bf, 12)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("公司電話：", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 6;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("公司傳真：", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 1;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("製造日期：" + DateTime.Now.ToString("yyyy/MM/dd"), new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 8)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell.UseAscender = true;
cell.HorizontalAlignment = Element.ALIGN_CENTER;//字體垂直居中
cell.VerticalAlignment = Element.ALIGN_MIDDLE;//字體水平居中
cell.BorderWidth = 0.1f;
cell.BorderColor = new BaseColor(0, 0, 0);
#endregion
#region 上部分
cell = new PdfPCell(new Phrase("採購單別:" + ipoStore[a].po_type, font));
cell.Colspan = 2;
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("交易幣別:" + "世界貨幣", font));
cell.Colspan = 1;
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("匯率:" + "浮動", font));
cell.Colspan = 2;
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
if (procduct_freight != "常溫" && procduct_freight != "冷凍")
{
;
}
cell = new PdfPCell(new Phrase("運輸方式:" + procduct_freight, font));
cell.Colspan = 2;
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("商品是新品么？:", font));//新品
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("所在層:", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("採購單(" + ipoStore[a].po_type_desc + ")", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("預約到貨日期:", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("採購單號:" + ipoStore[a].po_id, font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("課稅別:", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("營業稅率:", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("價格條件:", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("單據日期:" + DateTime.Now.ToString("yyyy/MM/dd"), font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("採購人員:", font));
//cell = new PdfPCell(new Phrase("採購人員:" + ipoStore[a].buyer, font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase((System.Web.HttpContext.Current.Session["caller"] as Caller).user_username, font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("廠別代號:", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("gigade(讀取)", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("廠商代號:" + ipoStore[a].vend_id, font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(vendor == null ? "暫無此信息" : vendor.vendor_name_simple, font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("付款條件(讀取)", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("月結N天(讀取):", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(vendor == null ? "廠商全名(讀取):暫無此信息" : "廠商全名:" + vendor.vendor_name_full, font));
cell.Colspan = 5;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("備註:", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(vendor == null ? "廠商地址:暫無此信息" : "廠商地址:" + vendor.company_address, font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("聯絡人(讀取):", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(vendor == null ? "廠商電話:暫無此信息" : "廠商電話:" + vendor.company_phone, font));
cell.Colspan = 1;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(vendor == null ? "廠商傳真:暫無此信息" : "廠商傳真:" + vendor.company_fax, font));
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("送貨地址(讀取):", font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("預計送貨日期(讀取):", font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("配送聯絡人(讀取):", font));
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("配送電話(讀取):", font));
cell.Colspan = 1;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("配送傳真(讀取):", font));
cell.Colspan = 4;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("處理備註:", font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("運送備註:", font));
cell.Colspan = 7;
cell.DisableBorderSide(1);
ptable.AddCell(cell);
#endregion
#region 下面表格頭部
cell = new PdfPCell(new Phrase("序號", font));
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
//cell.DisableBorderSide(2);
cell.Rowspan = 3;
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("國際條碼", font));
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("品號", font));
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("採購數量", font));
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("允收天數", font));
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("製造日期", font));
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("備註", font));
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("供應商店內碼", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("品名", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("允收數量", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("允出天數", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("有效日期", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("料位", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("規格", font));
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("不允收數量", font));
cell.DisableBorderSide(1);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("有效期天數", font));
cell.DisableBorderSide(1);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", font));
cell.DisableBorderSide(1);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", font));
cell.DisableBorderSide(1);
ptable.AddCell(cell);
#endregion
_ipodMgr = new IpodMgr(mySqlConnectionString);
ipod = new IpodQuery();
ipod.po_id = ipoStore[a].po_id;
ipod.IsPage = false;
ipodStore = new List<IpodQuery>();
ipodStore = _ipodMgr.GetIpodList(ipod, out totalCount);
List<IpodQuery> Ipodleibie = new List<IpodQuery>();
Ipodleibie.AddRange(product_freight_set_mapping[key]);
#region 循環讀取數據填入表格
DataTable Ipod_dt = new DataTable();
Ipod_dt.Columns.Add("序號", typeof(string));
Ipod_dt.Columns.Add("國際條碼", typeof(string));
Ipod_dt.Columns.Add("品號", typeof(string));
Ipod_dt.Columns.Add("採購數量", typeof(string));
Ipod_dt.Columns.Add("允收天數", typeof(string));
Ipod_dt.Columns.Add("製造日期", typeof(string));
Ipod_dt.Columns.Add("備註", typeof(string));
Ipod_dt.Columns.Add("Empty_1", typeof(string));
Ipod_dt.Columns.Add("供應商店內碼", typeof(string));
Ipod_dt.Columns.Add("品名", typeof(string));
Ipod_dt.Columns.Add("允收數量", typeof(string));
Ipod_dt.Columns.Add("允出天數", typeof(string));
Ipod_dt.Columns.Add("有效日期", typeof(string));
Ipod_dt.Columns.Add("Empty_3", typeof(string));
Ipod_dt.Columns.Add("Empty_4", typeof(string));
Ipod_dt.Columns.Add("料位", typeof(string));
Ipod_dt.Columns.Add("規格", typeof(string));
Ipod_dt.Columns.Add("不允收數量", typeof(string));
Ipod_dt.Columns.Add("有效期天數", typeof(string));
Ipod_dt.Columns.Add("Empty_5", typeof(string));
Ipod_dt.Columns.Add("Empty_6", typeof(string));
for (int i = 0; i < Ipodleibie.Count; i++)
{
DataRow newRow = Ipod_dt.NewRow();
newRow["國際條碼"] = Ipodleibie[i].upc_id_international;
newRow["品號"] = Ipodleibie[i].Erp_Id.ToString();
newRow["採購數量"] = Ipodleibie[i].qty_ord.ToString();
newRow["允收天數"] = Ipodleibie[i].cde_dt_var.ToString();
newRow["製造日期"] = "";
newRow["備註"] = "";
newRow["Empty_1"] = (i + 1).ToString(); //序號
newRow["供應商店內碼"] = Ipodleibie[i].upc_id_shop;
newRow["品名"] = Ipodleibie[i].product_name;
newRow["允收數量"] = Ipodleibie[i].qty_claimed.ToString();
newRow["允出天數"] = Ipodleibie[i].cde_dt_shp.ToString();
newRow["有效日期"] = "";
newRow["Empty_3"] = "";
newRow["Empty_4"] = "";
newRow["料位"] = Ipodleibie[i].loc_id;
newRow["規格"] = Ipodleibie[i].spec;
newRow["不允收數量"] = Ipodleibie[i].qty_damaged.ToString();
newRow["有效期天數"] = Ipodleibie[i].cde_dt_incr.ToString();
newRow["Empty_5"] = "";
newRow["Empty_6"] = "";
Ipod_dt.Rows.Add(newRow);
}
#endregion
////////
newFileName = newPDFName + "_part" + index++ + "." + "pdf";
pdf.ExportDataTableToPDF(Ipod_dt, false, newFileName, arrColWidth, ptable, "", "", 7, 7);/*第一7是列，第二個是行*/
pdfList.Add(newFileName);
}
}
newFileName = newPDFName + "." + "pdf";
pdf.MergePDF(pdfList, newFileName);
Response.Clear();
Response.Charset = "gb2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AddHeader("Content-Disposition", "attach-ment;filename=" + filename + ".pdf");
Response.WriteFile(newFileName);
//}
#endregion
}
catch (Exception ex)
{
//cb.EndText();
//writer.Resume();
//Response.Clear();
}
}
