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);
}
}
public string getAllSql(string codeType, Hashtable ht)
{
string allSql = string.Empty;
if (ht.ContainsKey("ReadyCheckBookTypeFlag") && Common.ConvertEx.ToInt(ht["ReadyCheckBookTypeFlag"]) == 1) //未发放
{
if (codeType == SystemSet.EumReportType.ZRS.ToString())
{
allSql = PublicModel.getExportExcelSql("ZrsCertificateSql_1");
}
else if (codeType == SystemSet.EumReportType.RKZ.ToString())
{
allSql = PublicModel.getExportExcelSql("RkzCertificateSql_1");
}
else if (codeType == SystemSet.EumReportType.ZMS.ToString())
{
allSql = PublicModel.getExportExcelSql("ZmsCertificateSql_1");
}
}
if (ht.ContainsKey("ReadyCheckBookTypeFlag") && Common.ConvertEx.ToInt(ht["ReadyCheckBookTypeFlag"]) == 0) //未发放
{
if (codeType == SystemSet.EumReportType.ZRS.ToString())
{
allSql = PublicModel.getExportExcelSql("ZrsCertificateSql_2");
}
else if (codeType == SystemSet.EumReportType.RKZ.ToString())
{
allSql = PublicModel.getExportExcelSql("RkzCertificateSql_2");
}
else if (codeType == SystemSet.EumReportType.ZMS.ToString())
{
allSql = PublicModel.getExportExcelSql("ZmsCertificateSql_2");
}
}
allSql = string.Format(allSql, readBLL.GetListPagingForQueryWhere(ht));
return(allSql);
}
