protected void btnExport_Click(object sender, EventArgs e)
{
string unityValue = selectedValue.Value;
string kpiName = string.IsNullOrWhiteSpace(drpTags.SelectedValue) ? null : drpTags.SelectedValue;
string beginTime = txtBeginTime.Value;
string endTime = txtEndTime.Value;
int totalCount = 0;
List<KPI_OverLimitRecordEntity> overLimitRecordList = null;
if (unityValue == "U01" || string.IsNullOrWhiteSpace(unityValue)) {
overLimitRecordList = overLimitRecordDal.GetOverLimitRecordEntityList(Convert.ToDateTime(beginTime),
Convert.ToDateTime(endTime), 1, int.MaxValue, out totalCount);
}
else {
overLimitRecordList = overLimitRecordDal.SearchOverLimitRecord(Pager.CurrentPageIndex, Pager.PageSize, kpiName, unityValue, beginTime, endTime, true, ref totalCount);
}
overLimitRecordList = ConverterHelper.ConverterItem(overLimitRecordList);
gvValue.DataSource = overLimitRecordList;
gvValue.DataBind();
if (gvValue.Rows.Count > 0) {
DocExport docEexport = new DocExport();
docEexport.Dt = GridViewHelper.GridView2DataTable(gvValue);
docEexport.Export("SIS超限统计报表");
}
}
// <summary>
/// 导出到EXCEL
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExport_Click(object sender, EventArgs e)
{
if (gvScore.Rows.Count > 0)
{
DocExport docEexport = new DocExport();
docEexport.Dt = GridViewHelper.GridView2DataTable(gvScore);
docEexport.Export("SIS系统实时指标分析报表");
}
return;
}
public static void ExportToSpreadsheet(DataTable dtData, string name)
{
DocExport docEexport = new DocExport();
docEexport.Dt = dtData; //GridViewHelper.GridView2DataTable(gvValue);
docEexport.Export(name);
//System.Web.UI.WebControls.DataGrid dgExport = null;
//// 当前对话
//System.Web.HttpContext curContext = System.Web.HttpContext.Current;
//// IO用于导出并返回excel文件
//System.IO.StringWriter strWriter = null;
//System.Web.UI.HtmlTextWriter htmlWriter = null;
//if (dtData != null)
//{
// // 设置编码和附件格式
// curContext.Response.ContentType = "application/vnd.ms-excel";
// //通过超链接跳转到下载页面，解决弹出该页面的aspx文件要求下载的问题
// //指定下载文件名称
// curContext.Response.AddHeader("Content-Disposition", "attachment;filename=KPIRealTag.xls");
// curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;
// curContext.Response.Charset = "GB2312";
// // 导出excel文件
// strWriter = new System.IO.StringWriter();
// htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// // 为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid
// dgExport = new System.Web.UI.WebControls.DataGrid();
// dgExport.DataSource = dtData.DefaultView;
// dgExport.AllowPaging = false;
// dgExport.DataBind();
// // 返回客户端
// dgExport.RenderControl(htmlWriter);
// curContext.Response.Write(strWriter.ToString());
// curContext.Response.End();
//}
}
protected void btnExport_Click(object sender, EventArgs e)
{
if (gvData.Rows.Count > 0)
{
DocExport docEexport = new DocExport();
docEexport.Dt = GridViewHelper.GridView2DataTable(gvData);
docEexport.Export("SIS实时运行绩效报表");
}
}