namespace BankAccount.test

{

 /// <summary>

 /// HtmlWriter 的摘要说明。

 /// </summary>

 public class HtmlWriter : System.Web.UI.Page

 {

  private System.Data.SqlClient.SqlDataAdapter myAdapter;

  private System.Data.SqlClient.SqlConnection myConn;

  private System.Data.DataTable myDt;

  private string strConn = ConfigurationSettings.AppSettings["cns"];

  private void Page_Load(object sender, System.EventArgs e)

  {

   try

   {

    string Sqlstr = "Select Cmp_description from Company where Cmp_number = '123567'";

    string cription="";

    myDt = new DataTable();

    myConn = new SqlConnection(strConn);

    myConn.Open();

    myAdapter = new SqlDataAdapter(Sqlstr,myConn);

    myAdapter.Fill(myDt);

    if(myDt.Rows.Count>0)

    {

     cription = myDt.Rows[0]["Cmp_description"].ToString();

    }

    string title = "这是动态生成的静态页面";

    string dhtml = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//CN\"><html><head>"+

     "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">"+

     "<title>"+ title +"</title></head><body topmargin=0>";

    dhtml += "<table width=760 valign=top border=1 cellspacing=1 cellpadding=0 align=center>"+

     "<tr><td height=5>"+ title  +"</td></tr><tr><td height=200 align=center>"+ cription +"</td></tr></table>"+

     "</body></html>";

    string Filename = DateTime.Now.ToString("yyyyMMddHHmmss")+".html";//动态的文件名

    string Filepath = Server.MapPath(@"\BankAccount\test\");

    string Cname = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString();

    string Filecreatepath = Filepath + Cname + @"\";//页面要保存的路径

    //动态生成的静态页面按年月保存本年本月的文件夹中

    if (Directory.Exists(Filecreatepath)) //判断当月的文件夹是否存在,

    {

     //调用创建html静态页面方法

     Create_html(Filecreatepath+Filename,dhtml);

    }

    else

    {

     //创建页面保存到的文件夹

     DirectoryInfo di = Directory.CreateDirectory(Filecreatepath);

     Create_html(Filecreatepath+Filename,dhtml);

    }

   }

   catch(IOException ex)

   {

    throw ex;

   }

  }

  private void Create_html(string allfilename,string htmlcode)

  {

   FileStream CreateFile = new FileStream(allfilename,FileMode.CreateNew);

   StreamWriter sw = new StreamWriter(CreateFile);

   sw.WriteLine(htmlcode);//将拼好的Html代码写入页面中

   sw.Close();

   Page.RegisterStartupScript("","<script>window.alert('The file created successfully.!')</script>");

  }

  #region Web 窗体设计器生成的代码

  override protected void OnInit(EventArgs e)

  {

   //

   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。

   //

   InitializeComponent();

   base.OnInit(e);

  }


  /// <summary>

  /// 设计器支持所需的方法 - 不要使用代码编辑器修改

  /// 此方法的内容。

  /// </summary>

  private void InitializeComponent()

  {   

   this.Load += new System.EventHandler(this.Page_Load);

  }

  #endregion

 }

}