protected void Button1_Click(object sender, EventArgs e)
{
string strname = "信息名称";
string strWord = ExprotMissionToWord(Server.MapPath("/word/WordModel.htm"));
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename="+HttpUtility.UrlEncode(strname,System.Text.Encoding.UTF8).ToString()+".doc"); //必须的
Response.AddHeader("Content-type", "application");
Response.ContentType = "application/ms-html";
Response.ContentEncoding = System.Text.Encoding.Default; //如果不行改为utf7,默认一般可以,处理头部乱码的问题
Response.Write(strWord);
Response.Flush();
Response.Close();
}
public string ExprotMissionToWord(string templatePath)
{
DateTime DateStr = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
DBDbHelperSQL.connectionString = "server=127.0.0.1;database=abc;uid=sa;pwd=ll";
StringBuilder sb = new StringBuilder(1024);
StringBuilder strSql = new StringBuilder();
StreamReader sr = new StreamReader(templatePath, Encoding.Default);
sb.Append(sr.ReadToEnd());
sr.Close();
strSql.Append("select");
strSql.Append(" *");
strSql.Append(" from table where code='abc'");
SqlDataReader sdr = DBDbHelperSQL.ExecuteReader(strSql.ToString());
if (sdr.Read())
{
sb.Replace("{orgcode}", sdr["orgcode"].ToString())
要处理替换的数据在此操作
}
sdr.Close();
sdr.Dispose();
return sb.ToString();
}