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
}
}
|
