页面,Default.aspx
protected void Button1_Click(object sender, EventArgs e)
{
if (Test.WriteFile(this.Title.Text, this.Content.Text))
{
Response.Write("添加成功");
Response.Redirect("~/news/text1.htm");
}
else
{
Response.Write("生成HTML出错!");
}
}
类:Test.cs
public static int Insert(string strText,string strContent)
{
string con=System.Configuration.ConfigurationManager.AppSettings["connString"];
SqlConnection conn = new SqlConnection(con);
conn.Open();
string StrSql = "insert into news values('"+strText+"','"+strContent+"')";
SqlCommand comm = new SqlCommand(StrSql,conn);
int i = comm.ExecuteNonQuery();
conn.Close();
return i;
}
public static bool WriteFile(string strText, string strContent)
{
int a = Insert(strText,strContent);
if (a != 0)
{
string title = "";
string StrSql = "select * from news";
string con = System.Configuration.ConfigurationManager.AppSettings["connString"];
SqlConnection conn = new SqlConnection(con);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(StrSql, conn);
DataSet ds = new DataSet();
da.Fill(ds, "news");
title += "<table border='1' width='200'>";
for (int i = 0; i < ds.Tables[0].Rows.Count;i++ )
{
title += "<tr><td width='200'><a href='/News_xia/Default2.aspx?id="+ds.Tables[0].Rows[i][0].ToString()+"'>" + ds.Tables[0].Rows[i][1].ToString() + "</a></td></tr>";
}
title += "</table>";
string path = HttpContext.Current.Server.MapPath("~/news/");
Encoding code = Encoding.GetEncoding("gb2312");
// 读取模板文件
string temp = HttpContext.Current.Server.MapPath("~/news/text.htm");
StreamReader sr = null;
StreamWriter sw = null;
string str = "";
try
{
sr = new StreamReader(temp, code);
str = sr.ReadToEnd();
//HttpContext.Current.Response.Write(str);
// 读取文件
}
catch (Exception exp)
{
HttpContext.Current.Response.Write(exp.Message);
HttpContext.Current.Response.End();
sr.Close();
}
string htmlfilename = "text1.htm";
// 替换内容
// 这时,模板文件已经读入到名称为str的变量中了
str = str.Replace("biaoti", title);
// 写文件
try
{
FileInfo fi = new FileInfo(path + htmlfilename);
if (fi.Exists)
{
fi.Delete();
}
sw = new StreamWriter(path + htmlfilename, false, code);
sw.Write(str);
sw.Flush();
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.Message);
HttpContext.Current.Response.End();
}
finally
{
sw.Close();
}
return true;
//此函数放在Conn.CS基类中了
}
else
{
return false;
//HttpContext.Current.Response.Write("<script>alert('添加失败')</script>");
}
}
text.htm 页面
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>ShowArticle</title>
</head>
<body>
<div> biaoti </div>
<br/>
</body>
</html>