public void DC()
{
string slbm = txt_slbm.Text.Trim();
string szdw = txt_szdw.Text.Trim();
string time1 = txttime1.Value.Trim();
string time2 = txttime2.Value.Trim();
DataTable dt = DataSelect(slbm, szdw, time1, time2);

StringBuilder str = new StringBuilder();

str.Append("<meta http-equiv='content-type' content='application/ms-excel; charset=UTF-8'>");
//str.Append("<table cellspacing='0' border='1' id='GridView1' style='width:100%;border-collapse:collapse;font-size:13px;'>");
str.Append("<table border='1' cellpadding='0' cellspacing='0'>");

str.Append("<tr><th>编号</th><th>受理部门</th><th>检查部门</th><th>检查时间</th><th>所在部位</th><th>事由</th><th>序号</th><th>具体内容</th><th>负责人</th><th>整改人</th><th>完成日期</th><th>是否符合</th><th>验证人</th><th>验证日期</th></tr>");

for (int i = 0; i < dt.Rows.Count; i++)
{
string sql2 = "select * from TB_FCZGD_NR where GZD_ID=" + dt.Rows[i]["GZD_ID"] + "";
DataTable tb2 = oh.GetDataTable(sql2);
if (tb2.Rows.Count > 0)
{
str.Append("<tr>");
str.Append("<td rowspan='" + tb2.Rows.Count + "'>" + dt.Rows[i]["GZD_NUMBER"] + "</td>");
str.Append("<td rowspan='" + tb2.Rows.Count + "'>" + dt.Rows[i]["SL_UNIT"] + "</td>");
str.Append("<td rowspan='" + tb2.Rows.Count + "'>" + dt.Rows[i]["JC_UNIT"] + "</td>");
str.Append("<td rowspan='" + tb2.Rows.Count + "'>" + Convert.ToDateTime(dt.Rows[i]["JC_TIME"]).ToString("yyyy-MM-dd") + "</td>");
str.Append("<td rowspan='" + tb2.Rows.Count + "'>" + dt.Rows[i]["JC_BW"] + "</td>");
str.Append("<td rowspan='" + tb2.Rows.Count + "'>" + dt.Rows[i]["SY"] + "</td>");

for (int j = 0; j < tb2.Rows.Count; j++)
{
if (j == 0)
{
str.Append("<td>" + (0 + 1) + "</td>");
str.Append("<td>" + tb2.Rows[0]["NR"] + "</td>");
str.Append("<td>" + tb2.Rows[0]["FZR"] + "</td>");
str.Append("<td>" + tb2.Rows[0]["ZGR"] + "</td>");
string wcrq = tb2.Rows[0]["WCRQ"].ToString() == "" ? "" : Convert.ToDateTime(tb2.Rows[0]["WCRQ"]).ToString("yyyy-MM-dd");
str.Append("<td>" + wcrq + "</td>");
str.Append("<td>" + tb2.Rows[0]["SFFH"] + "</td>");
str.Append("<td>" + tb2.Rows[0]["YZR"] + "</td>");
string yzrq = tb2.Rows[0]["YZRQ"].ToString() == "" ? "" : Convert.ToDateTime(tb2.Rows[0]["YZRQ"]).ToString("yyyy-MM-dd");
str.Append("<td>" + yzrq + "</td>");
str.Append("</tr>");
}
else if (j > 0)
{
str.Append("<tr>");
str.Append("<td>" + (j + 1) + "</td>");
str.Append("<td>" + tb2.Rows[j]["NR"] + "</td>");
str.Append("<td>" + tb2.Rows[j]["FZR"] + "</td>");
str.Append("<td>" + tb2.Rows[j]["ZGR"] + "</td>");
string wcrq = tb2.Rows[j]["WCRQ"].ToString() == "" ? "" : Convert.ToDateTime(tb2.Rows[j]["WCRQ"]).ToString("yyyy-MM-dd");
str.Append("<td>" + wcrq + "</td>");
str.Append("<td>" + tb2.Rows[j]["SFFH"] + "</td>");

str.Append("<td>" + tb2.Rows[j]["YZR"] + "</td>");
string yzrq = tb2.Rows[j]["YZRQ"].ToString() == "" ? "" : Convert.ToDateTime(tb2.Rows[j]["YZRQ"]).ToString("yyyy-MM-dd");
str.Append("<td>" + yzrq + "</td>");

str.Append("</tr>");

}

}
}

}
str.Append("</table>");

HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls");
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.Write(str.ToString());
HttpContext.Current.Response.End();
//Response.Clear();
//Response.Buffer = true;
//Response.Charset = "UTF_8";
//Response.AppendHeader("Content-Disposition", "attachment;filename= " + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls");
//Response.ContentEncoding = System.Text.Encoding.UTF8;
//Response.ContentType = "application/ms-excel";
//this.EnableViewState = false;
//System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("ZH-CN", true);

//Response.Write(str.ToString());

//Response.End();

}