//事件入口
- protected void lbtALL_Click(object sender, EventArgs e)
- {
- string content = getExcelContent("全部商户列表", "");
- string css = "";
- string filename = Common.GetGuid() + ".xls";
- ExportExcel.ExportToExcel(filename, content, css);
- }
- private string getExcelContent(string title,string where)
- {
- StringBuilder sb = new StringBuilder();
- sb.Append("<table borderColor='black' border='1' >");
- sb.Append(" <thead>");
- sb.Append(" <tr><th colSpan='8' bgColor='#ccfefe'>" + title + "</th></tr>");
- sb.Append(" <tr>");
- sb.Append(" <th>编号</th>");
- sb.Append(" <th>类别</th>");
- sb.Append(" <th>企业名称</th>");
- sb.Append(" <th>企业地址</th>");
- sb.Append(" <th>企业法人</th>");
- sb.Append(" <th>证件号码</th>");
- sb.Append(" <th>手机号</th>");
- sb.Append(" <th>固定电话</th>");
- sb.Append(" <th>所属</th>");
- sb.Append(" </tr>");
- sb.Append(" </thead>");
- sb.Append(" <tbody>");
- DataTable dt = new dJinYinShangHu().GetCompanyListFromView(where).Tables[0];
- if(dt!=null&&dt.Rows.Count>0)
- {
- foreach(DataRow dr in dt.Rows)
- {
- sb.Append(" <tr>");
- sb.Append(" <td>" + dr["UserName"].ToString() + "</td>");
- sb.Append(" <td>" + dr["type"].ToString() + "</td>");
- sb.Append(" <td>" + dr["CompanyName"].ToString() + "</td>");
- sb.Append(" <td>" + dr["CompanyAddress"].ToString() + "</td>");
- sb.Append(" <td>" + dr["LinkMan"].ToString() + "</td>");
- sb.Append(" <td>'" + dr["CardCode"].ToString() + "</td>");
- sb.Append(" <td>'" + dr["Phone"].ToString() + "</td>");
- sb.Append(" <td>'" + dr["Tel"].ToString() + "</td>");
- sb.Append(" <td>" + dr["BranchName"].ToString() + "</td>");
- sb.Append(" </tr>");
- }
- }
- //sb.Append("<tr class='secondTR'><td></td><td bgcolor='lightskyblue'></td></tr>");
- sb.Append(" </tbody>");
- sb.Append("</table>");
- return sb.ToString();
- public class ExportExcel
- {
- /// <summary>
- /// 以流的形式,可以设置很丰富复杂的样式
- /// </summary>
- /// <param name="content">Excel中内容(Table格式)</param>
- /// <param name="filename">文件名</param>
- /// <param name="cssText">样式内容</param>
- public static void ExportToExcel(string filename, string content, string cssText)
- {
- var res = HttpContext.Current.Response;
- content = String.Format("<style type='text/css'>{0}</style>{1}", cssText, content);
- res.Clear();
- res.Buffer = true;
- res.Charset = "UTF-8";
- res.AddHeader("Content-Disposition", "attachment; filename=" + filename);
- res.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
- res.ContentType = "application/ms-excel;charset=UTF-8";
- res.Write(content);
- res.Flush();
- res.End();
- }
- }