推荐订阅源

public class ExPDF
{
           
    static string sqlStr = "select Member_Value from MDB_Archive_Member where Member_ID in (000000,000000) order by Member_ID ";
    int dtc;
    Document document = new Document();
    static BaseFont bfHei = BaseFont.CreateFont(@ConfigurationManager.AppSettings["windir"].Replace("system32","fonts")+@"\SIMHEI.TTF", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);
    static Font font = new Font(bfHei, 12);
    DataSet ds;
    DataTable dt;
    public ExPDF()
    {
    }
    public void MakePDF(string entityID,string fn)
    {
        ds = SqlHelper.ExecuteDataset(SqlHelper.ToEposConnString, CommandType.Text, sqlStr);
        SqlParameter spa = new SqlParameter("@VarEntityid", entityID);
        DataSet dst = SqlHelper.ExecuteDataset(SqlHelper.ToEposConnString, CommandType.StoredProcedure, "DSC_SP_ExportAuthedShop", spa);

        PdfWriter.GetInstance(document, new FileStream(HttpContext.Current.Request.PhysicalApplicationPath + "/" + System.Configuration.ConfigurationSettings.AppSettings["UploadFilePath"].ToString() + "/" + fn + ".pdf", FileMode.Create));
        document.Open();

        for (int ii = 0; ii < dst.Tables.Count; ii++)
        {
            dt = dst.Tables[ii];
            dtc = dt.Rows.Count;
            if (dtc > 0)
            {
                int P = int.Parse(System.Math.Floor((double)(dtc / 10)).ToString());
                int Pc = dtc % 10;
                if (P == 0)
                {
                    for (int i = 0; i < 1; i++)
                    {
                        PdfRot(i * 10, (i + 1) * 10);
                    }
                }
                if (Pc == 0 && P > 0)
                {
                    for (int i = 0; i < P; i++)
                    {
                        PdfRot(i * 10, (i + 1) * 10);
                        if (i + 1 < P)
                        {
                            document.NewPage();
                        }
                    }
                }
                if (Pc > 0 && P > 0)
                {
                    for (int i = 0; i < P + 1; i++)
                    {
                        PdfRot(i * 10, (i + 1) * 10);
                        if (i + 1 < P + 1)
                        {
                            document.NewPage();
                        }
                    }
                }
            }
            if (ii + 1 < dst.Tables.Count)
            {
                document.NewPage();
            }
        }
        document.Close();
    }
    public void PdfRot(int start,int end)
    {

        Image ln = Image.GetInstance(HttpContext.Current.Request.PhysicalApplicationPath + "/EXCEL/ln.jpg");
        ln.Alignment = Image.RIGHT_ALIGN;
        ln.ScalePercent(25);
        document.Add(ln);

        string text = @"“***”****合同（编号：" + (dt.Rows.Count>0?dt.Rows[0]["DEALER_NO"].ToString():"") + @"）附件

    
                        “***”********表格
   
";
        string text_b = "　　本店铺名单表格作为甲乙双方《“***”******》的附件，明确乙方开设的店铺的名称、地址，与《“***”******》具有相同的法律效力，有效期自" + dt.Rows[0][dt.Columns.Count - 1].ToString().Substring(0, 4) + "年" + dt.Rows[0][dt.Columns.Count - 1].ToString().Substring(4, 2) + "月" + dt.Rows[0][dt.Columns.Count - 1].ToString().Substring(6, 2) + "日" + "至" + DateTime.Today.AddYears(1).ToString("yyyy") + "年" + int.Parse(ds.Tables[0].Rows[1]["Member_Value"].ToString()).ToString("00月00日") + "止。（在《“***”******》的有效期限内）。";
        document.Add(new Paragraph(text, font));
        document.Add(new Paragraph(text_b, font));

        Table aTable = new Table(7, 2);
        aTable.Cellpadding = 2;
        aTable.WidthPercentage = 100;
        aTable.AddCell(new Paragraph("**ID", font));
        Cell c = new Cell(new Paragraph("**名称", font));
        c.Colspan = 3;
        aTable.AddCell(c);

        c = new Cell(new Paragraph("**地址", font));
        c.Colspan = 3;
        aTable.AddCell(c);

        for (int i = start; i < end;i++ )
        {
            if (i < dtc)
            {
                aTable.AddCell(new Paragraph(dt.Rows[i][0].ToString(), font));
                c = new Cell(new Paragraph(dt.Rows[i][2].ToString(), font));
                c.Colspan = 3;
                aTable.AddCell(c);
                c = new Cell(new Paragraph(dt.Rows[i][3].ToString(), font));
                c.Colspan = 3;
                aTable.AddCell(c);
                //aTable.AddCell(new Paragraph(dt.Rows[i][2].ToString(), font));
                //aTable.AddCell(new Paragraph(dt.Rows[i][3].ToString(), font));
            }
        }
        document.Add(aTable);

        string vtext = @"　　我****乙方在以上****“***”产品。

                                                    ***有限公司

                                                            " + dt.Rows[0][dt.Columns.Count - 1].ToString().Substring(0, 4) + "年" + dt.Rows[0][dt.Columns.Count - 1].ToString().Substring(4, 2) + "月" + dt.Rows[0][dt.Columns.Count - 1].ToString().Substring(6, 2) + "日";
        document.Add(new Paragraph(vtext, font));
    }
}