using iTextSharp;
using iTextSharp.text;
using iTextSharp.text.pdf;

public ActionResult PdfExport(int y = 2014, int m = 1, string departmentcd = "",string outFlag="1")        {            System.Collections.ArrayList anonymousEntities = new System.Collections.ArrayList();            foreach (var item in db.WorkRecords.ToList())            {                WorkRecords workrecord = new WorkRecords();                workrecord.UserCD = item.UserCD;                workrecord.UserName = item.UserName;                anonymousEntities.Add(workrecord);            }            byte[] file = new byte[1];            string depname = new BLL.DepartMentsBLL().GetDepartmentNameByCD(int.Parse(departmentcd));            string filename = depname + y.ToString() + "年" + m.ToString() + "月.pdf";           // filename = HttpUtility.UrlEncode(filename);            Document document = new Document(PageSize.A4, 5, 5, 20, 10);            //PdfWriter writer = PdfWriter.GetInstance(document, new System.IO.FileStream(System.Web.HttpContext.Current.Server.MapPath("/material/pdfsample.pdf"), System.IO.FileMode.Create));            PdfWriter writer = PdfWriter.GetInstance(document, new System.IO.FileStream(System.Web.HttpContext.Current.Server.MapPath("/PDF/pdfsample.pdf"), System.IO.FileMode.Create));             BaseFont bfChinese =iTextSharp.text.pdf.BaseFont.CreateFont(@"C:\WINDOWS\Fonts\MSMINCHO.TTC,1", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);            Font fontChinese1 = new Font(bfChinese, 10);            Font ftitle = new Font(bfChinese, 16, Font.NORMAL, BaseColor.BLACK);            Font fontRukuHeader = new Font(bfChinese, 14, Font.NORMAL, BaseColor.BLACK);            Font footerChinese = new Font(bfChinese,12, Font.NORMAL, BaseColor.BLACK);            Font footerChinese_3 = new Font(bfChinese, 9, Font.NORMAL, BaseColor.BLACK);            document.Open();            Paragraph title1 = new Paragraph("注意事項", ftitle);            title1.Alignment = Element.ALIGN_LEFT;             document.Add(title1);            Paragraph title2 = new Paragraph("申请", ftitle);            title2.Alignment = Element.ALIGN_CENTER;             document.Add(title2);            document.NewPage();//创建下一页            PdfPTable table = new PdfPTable(6);            //Paragraph title3 = new Paragraph("一覧\n", ftitle);            //title3.Alignment = Element.ALIGN_LEFT;             //document.Add(title3);            Chunk ch = new Chunk("一覧");            ch.setLineHeight(2);            ch.Font = ftitle;            document.Add(ch);                          table.DefaultCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;            table.DefaultCell.VerticalAlignment = PdfPCell.ALIGN_CENTER;            table.WidthPercentage = 90;            Font headerfont1 = new Font(bfChinese, 12, Font.BOLD, BaseColor.WHITE);            //table header            table.AddCell(makerCell("社員番号", headerfont1));            table.AddCell(makerCell("社員名", headerfont1));            table.AddCell(makerCell("時間外", headerfont1));            table.AddCell(makerCell("休日出勤", headerfont1));            table.AddCell(makerCell("祝日出勤", headerfont1));            table.AddCell(makerCell("総計", headerfont1));                               string DepartmentCDs = "";                if (String.IsNullOrEmpty(departmentcd))                {                    departmentcd = new NewWorkManager.BLL.UsersBLL().GetDepartmentCD(User.Identity.Name).ToString();                    DepartmentCDs = departmentcd;                }                else                {                    int intid = int.Parse(departmentcd);                    var dep = db.Departments.Where(a => a.FatherDepartmentCD == intid).ToList();                    foreach (var item in dep)                    {                        DepartmentCDs += item.DepartmentCD.ToString() + ",";                        var smalldep = db.Departments.Where(a => a.FatherDepartmentCD == item.DepartmentCD).ToList();                        foreach (var smallitem in smalldep)                        {                            DepartmentCDs += smallitem.DepartmentCD.ToString() + ",";                        }                    }                }                ViewBag.id = new SelectList(db.Departments.Where(a => a.IsActiveFlg == 1), "DepartmentCD", "DepartmentName", departmentcd);                string[] s = DepartmentCDs.Split(new char[] { ‘,‘ });                List<int> list = new List<int> { };                foreach (var a in s)                {                    if (!String.IsNullOrEmpty(a))                    {                        list.Add(int.Parse(a));                    }                }                list.Add(int.Parse(departmentcd));                var dbthisDepartment = from w in db.WorkRecords                                       where list.Contains(w.DepartmentCD)                                       select w;                DateTime clearmonth = DateTime.Parse(y.ToString() + "/" + m.ToString() + "/1");                var dbapplication = dbthisDepartment.Where(a => a.ClearingMonth == clearmonth && a.ApproveFlg1 == 1 && a.ApproveFlg2 == 1 && (a.IsAdjustFlg == 0 || (a.IsAdjustFlg == 1 && a.WorkType == 3))).ToList();                table.DefaultCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;                  foreach (var item in dbapplication.Select(a => a.UserCD).Distinct().ToList())                {                    table.AddCell(new Phrase(item.ToString(), footerChinese));                     table.AddCell(new Phrase(new NewWorkManager.BLL.UsersBLL().getRealNameByName(item).ToString(), footerChinese));                    table.AddCell(new Phrase(dbapplication.Where(a => a.UserCD == item && a.WorkType == 1).Select(a => a.WorkTimeTotalHour).Sum().ToString(), footerChinese));                    table.AddCell(new Phrase(dbapplication.Where(a => a.UserCD == item && (a.WorkType == 2 || (a.WorkType == 3 && a.IsAdjustFlg == 1))).Select(a => a.WorkTimeTotalHour).Sum().ToString(), footerChinese));                    table.AddCell(new Phrase(dbapplication.Where(a => a.UserCD == item && a.WorkType == 3 && a.IsAdjustFlg == 0).Select(a => a.WorkTimeTotalHour).Sum().ToString(), footerChinese));                    table.AddCell(new Phrase(dbapplication.Where(a => a.UserCD == item).Select(a => a.WorkTimeTotalHour).Sum().ToString(), footerChinese));                }                table.AddCell(new Phrase(""));                table.AddCell(new Phrase("合計",footerChinese));                table.AddCell(new Phrase(dbapplication.Where(a => a.WorkType == 1).Select(a => a.WorkTimeTotalHour).Sum().ToString(),footerChinese));                table.AddCell(new Phrase(dbapplication.Where(a => (a.WorkType == 2 || (a.WorkType == 3 && a.IsAdjustFlg == 1))).Select(a => a.WorkTimeTotalHour).Sum().ToString(),footerChinese));                table.AddCell(new Phrase(dbapplication.Where(a => a.WorkType == 3 && a.IsAdjustFlg == 0).Select(a => a.WorkTimeTotalHour).Sum().ToString(),footerChinese));                table.AddCell(new Phrase(dbapplication.Select(a => a.WorkTimeTotalHour).Sum().ToString(),footerChinese));           document.Add(table);                     document.Close();           string fullFileName = System.Web.HttpContext.Current.Server.MapPath("/PDF/pdfsample.pdf");           Byte[] btArray = WriteToPdf(fullFileName, DateTime.Now.ToString("yyyyMMddhhmmssff"), bfChinese);           //fullFileName = Server.MapPath("/material/pdfsample.pdf");           FileStream fs = new FileStream(fullFileName, FileMode.Create, FileAccess.Write);           fs.Write(btArray, 0, btArray.Length);           fs.Flush();           fs.Close();           //fullFileName = Server.MapPath("/material/pdfsample.pdf");           filename = depname + y.ToString() + "年" + m.ToString() + "月.pdf";           FileInfo downloadFile = new FileInfo(fullFileName);           Response.Clear();           Response.ClearHeaders();           Response.Buffer = false;           Response.ContentType = "application/octet-stream";           Response.AppendHeader("Content-Disposition", "attachment;filename=" + filename);           Response.AppendHeader("Content-Length", downloadFile.Length.ToString());            //System.Web.HttpContext.Current.Response.WriteFile(downloadFile.FullName);           Response.WriteFile(downloadFile.FullName);           Response.Flush();           Response.End();           return null;         }        public  PdfPCell makerCell(string str,Font fon){            PdfPCell cell=new PdfPCell(new Phrase(str,fon));                       BaseColor bs = new BaseColor(System.Drawing.Color.FromArgb(79, 129, 189));            cell.BackgroundColor = bs;            return cell;        }        public static byte[] WriteToPdf(string sourceFile, string stringToWriteToPdf, BaseFont bfChinese)        {            PdfReader reader = new PdfReader(sourceFile);            using (MemoryStream stream = new MemoryStream())            {                PdfStamper pdfstamper = new PdfStamper(reader, stream);                for (int i = 1; i <= reader.NumberOfPages; i++)                {                    Rectangle pageSize = reader.GetPageSizeWithRotation(i);                    PdfContentByte pdfpageContents = pdfstamper.GetUnderContent(i);                    pdfpageContents.BeginText();                    pdfpageContents.SetFontAndSize(bfChinese, 40);                    pdfpageContents.SetRGBColorFill(192, 192, 192);                    float textAngle = 45.0f;                    pdfpageContents.ShowTextAligned(PdfContentByte.ALIGN_CENTER, stringToWriteToPdf, pageSize.Width / 2, pageSize.Height / 2, textAngle);                    pdfpageContents.EndText();                }                pdfstamper.FormFlattening = true;                pdfstamper.Close();                reader.Close();                return stream.ToArray();            }        }