public string ExportExcel()
{
try {
string allSql = getAllSql(SystemSet.EumReportType.ZRS.ToString(), (Hashtable)Session["ZRS_HtStrWhere"]);
if (!string.IsNullOrWhiteSpace(allSql))
{
return(ExcelHelp.DataTableToExcel(new T_Other_BLL().GetQueryList(allSql)));
}
else
{
return(SystemSet._RETURN_FAILURE_VALUE + "KEY=ZrsCertificateSql 获取脚本失败");
}
} catch (Exception ex) {
return(SystemSet._RETURN_FAILURE_VALUE + ex.Message);
}
}
public string ExportEfileConvertLogToExcel()
{
try {
string allSql = PublicModel.getExportExcelSql("EfileConvertSql");
if (!string.IsNullOrWhiteSpace(allSql))
{
return(ExcelHelp.DataTableToExcel(new T_Other_BLL().GetQueryList(string.Format(allSql, Common.Session.GetSession("EfileConvertsqlWhere")))));
}
else
{
return(SystemSet._RETURN_FAILURE_VALUE + "KEY=EfileConvertSql 获取脚本失败");
}
} catch (Exception ex) {
return(SystemSet._RETURN_FAILURE_VALUE + ex.Message);
}
}