SMGW_NewWeb.git

parent: fad59c96 | 补丁 | 提交 | ignore whitespace

wangsheng

2021-11-30 7f9be85686afe6ed9ac364e6b3539645b834722d

修复代理商权限问题

13个文件已添加

15个文件已修改

1个文件已删除

	web/.vs/Web/v16/.suo	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/App_Code/WebTool.cs	15 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/App_Code/bin/Debug/App_Code.dll	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/App_Code/bin/Debug/App_Code.pdb	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/App_Code/obj/Debug/App_Code.csproj.AssemblyReference.cache	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/App_Code/obj/Debug/App_Code.csproj.CopyComplete	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/App_Code/obj/Debug/App_Code.csproj.FileListAbsolute.txt	1 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/App_Code/obj/Debug/App_Code.dll	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/App_Code/obj/Debug/App_Code.pdb	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/Dao/obj/Debug/Dao.csproj.AssemblyReference.cache	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/Dao/obj/Debug/Dao.dll	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/Dao/obj/Debug/Dao.pdb	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/Lib/Dao.dll	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/Lib/Dao.pdb	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/Lib/Model.dll	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/Lib/Model.pdb	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/Model/obj/Debug/Model.csproj.AssemblyReference.cache	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/Model/obj/Debug/Model.dll	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/Model/obj/Debug/Model.pdb	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/UMCLib/obj/Debug/UMCLib.csproj.AssemblyReference.cache	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/web/Bin/App_Code.dll	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/web/Bin/App_Code.pdb	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/web/Bin/Dao.dll	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/web/Bin/Dao.pdb	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/web/Bin/Model.dll	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/web/Bin/Model.pdb	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/web/GwClient.ashx	4 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/web/logs/err.txt	99 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	web/web/logs/logx.txt	99 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 web/.vs/Web/v16/.suo

Binary files differ

 web/App_Code/WebTool.cs

@@ -41,12 +41,13 @@
    }
  }

  public void Export(DataTable dataTable, Dictionary<string, string> dictionary, string fileName, HttpResponse Response)
    public void Export(DataTable dataTable, Dictionary<string, string> dictionary, string fileName, HttpResponse Response)
  {
    StringBuilder stringBuilder = new StringBuilder();
    //stringBuilder.Append("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=UTF-8\"/>");//旧的-导出xls
    stringBuilder.Append("<meta http-equiv=\"content-type\" content=\"vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=UTF-8\"/>");//导出格式xlsx
    stringBuilder.AppendLine("<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");
        //stringBuilder.Append("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=UTF-8\"/>");//旧的-导出xls
        //stringBuilder.Append("<meta http-equiv=\"content-type\" content=\"vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=UTF-8\"/>");//导出格式xlsx
        stringBuilder.Append("<meta http-equiv=\"content-type\" content=\"text/csv\"/>");//导出格式xlsx
        stringBuilder.AppendLine("<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");
    stringBuilder.AppendLine("<tr>");
    foreach (KeyValuePair<string, string> keyValuePair in dictionary)
    {
@@ -77,8 +78,10 @@
    }
    stringBuilder.AppendLine("</table>");
    Response.ClearContent();
    Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".xlsx");
    Response.ContentType = "application/excel";
        Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName + ".csv");
        Response.ContentType = "text/csv";
    //Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".xlsx");
    //Response.ContentType = "application/execl";
    Response.ContentEncoding = Encoding.UTF8;
    Response.Write(stringBuilder.ToString());
    Response.End();

 web/App_Code/bin/Debug/App_Code.dll

Binary files differ

 web/App_Code/bin/Debug/App_Code.pdb

Binary files differ

 web/App_Code/obj/Debug/App_Code.csproj.AssemblyReference.cache

Binary files differ

 web/App_Code/obj/Debug/App_Code.csproj.CopyComplete


 web/App_Code/obj/Debug/App_Code.csproj.FileListAbsolute.txt

@@ -63,7 +63,6 @@
D:\Company\SMGW_NewWeb\web\App_Code\bin\Debug\Dao.dll
D:\Company\SMGW_NewWeb\web\App_Code\bin\Debug\Ionic.Zip.dll
D:\Company\SMGW_NewWeb\web\App_Code\obj\Debug\App_Code.csproj.CoreCompileInputs.cache
D:\Company\SMGW_NewWeb\web\App_Code\obj\Debug\App_Code.csproj.CopyComplete
D:\Company\SMGW_NewWeb\web\App_Code\obj\Debug\App_Code.dll
D:\Company\SMGW_NewWeb\web\App_Code\obj\Debug\App_Code.pdb
D:\Company\SMGW_NewWeb\web\App_Code\obj\Debug\App_Code.csproj.AssemblyReference.cache

 web/App_Code/obj/Debug/App_Code.dll

Binary files differ

 web/App_Code/obj/Debug/App_Code.pdb

Binary files differ

 web/Dao/obj/Debug/Dao.csproj.AssemblyReference.cache

Binary files differ

 web/Dao/obj/Debug/Dao.dll

Binary files differ

 web/Dao/obj/Debug/Dao.pdb

Binary files differ

 web/Lib/Dao.dll

Binary files differ

 web/Lib/Dao.pdb

Binary files differ

 web/Lib/Model.dll

Binary files differ

 web/Lib/Model.pdb

Binary files differ

 web/Model/obj/Debug/Model.csproj.AssemblyReference.cache

Binary files differ

 web/Model/obj/Debug/Model.dll

Binary files differ

 web/Model/obj/Debug/Model.pdb

Binary files differ

 web/UMCLib/obj/Debug/UMCLib.csproj.AssemblyReference.cache

Binary files differ

 web/web/Bin/App_Code.dll

Binary files differ

 web/web/Bin/App_Code.pdb

Binary files differ

 web/web/Bin/Dao.dll

Binary files differ

 web/web/Bin/Dao.pdb

Binary files differ

 web/web/Bin/Model.dll

Binary files differ

 web/web/Bin/Model.pdb

Binary files differ

 web/web/GwClient.ashx

@@ -250,11 +250,11 @@
        client.ClientID = clientID;
        client.Password = password;
        client.ClientName = clientName;
        client.Address = address;
        client.Address = address;//地址
        client.Remark = remark;
        client.Telephone = telephone;
        client.Agent = agent;
        client.PermissionData = permissionData;
        client.PermissionData = permissionData;//权限数据

        _Dao.Update(client);


 web/web/logs/err.txt

@@ -891,3 +891,102 @@
   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#7   2021-10-19 14:01:10,954 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#7   2021-10-19 14:01:10,999 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20211019 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#7   2021-10-19 14:01:44,063 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#7   2021-10-19 14:01:44,090 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#8   2021-10-19 14:01:53,190 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#8   2021-10-19 14:01:53,217 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#8   2021-10-19 14:02:56,301 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#8   2021-10-19 14:02:56,337 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#17  2021-10-19 14:05:02,692 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#17  2021-10-19 14:05:02,731 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#33  2021-10-19 14:14:50,106 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#33  2021-10-19 14:14:50,142 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#23  2021-10-19 14:18:23,598 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#23  2021-10-19 14:18:23,637 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#7   2021-10-19 14:23:51,423 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#7   2021-10-19 14:23:51,461 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#16  2021-10-19 14:26:04,611 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#16  2021-10-19 14:26:04,657 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204




 web/web/logs/logx.txt

@@ -891,3 +891,102 @@
   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#7   2021-10-19 14:01:10,954 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#7   2021-10-19 14:01:10,999 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20211019 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#7   2021-10-19 14:01:44,063 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#7   2021-10-19 14:01:44,090 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#8   2021-10-19 14:01:53,190 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#8   2021-10-19 14:01:53,217 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#8   2021-10-19 14:02:56,301 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#8   2021-10-19 14:02:56,337 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#17  2021-10-19 14:05:02,692 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#17  2021-10-19 14:05:02,731 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#33  2021-10-19 14:14:50,106 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#33  2021-10-19 14:14:50,142 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#23  2021-10-19 14:18:23,598 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#23  2021-10-19 14:18:23,637 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#7   2021-10-19 14:23:51,423 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#7   2021-10-19 14:23:51,461 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204



#16  2021-10-19 14:26:04,611 Common.dll OracleHelper.ExecuteReader              ORA-00918: 未明确定义列

   在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

   在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219



#16  2021-10-19 14:26:04,657 Dao.dll GwSmDao.LoadInfoListcount                  ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1  and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)

   在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227

   在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204

			@@ -41,12 +41,13 @@
			}
			}

			public void Export(DataTable dataTable, Dictionary<string, string> dictionary, string fileName, HttpResponse Response)
			public void Export(DataTable dataTable, Dictionary<string, string> dictionary, string fileName, HttpResponse Response)
			{
			StringBuilder stringBuilder = new StringBuilder();
			//stringBuilder.Append("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=UTF-8\"/>");//旧的-导出xls
			stringBuilder.Append("<meta http-equiv=\"content-type\" content=\"vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=UTF-8\"/>");//导出格式xlsx
			stringBuilder.AppendLine("<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");
			//stringBuilder.Append("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=UTF-8\"/>");//旧的-导出xls
			//stringBuilder.Append("<meta http-equiv=\"content-type\" content=\"vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=UTF-8\"/>");//导出格式xlsx
			stringBuilder.Append("<meta http-equiv=\"content-type\" content=\"text/csv\"/>");//导出格式xlsx
			stringBuilder.AppendLine("<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");
			stringBuilder.AppendLine("<tr>");
			foreach (KeyValuePair<string, string> keyValuePair in dictionary)
			{
			@@ -77,8 +78,10 @@
			}
			stringBuilder.AppendLine("</table>");
			Response.ClearContent();
			Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".xlsx");
			Response.ContentType = "application/excel";
			Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName + ".csv");
			Response.ContentType = "text/csv";
			//Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".xlsx");
			//Response.ContentType = "application/execl";
			Response.ContentEncoding = Encoding.UTF8;
			Response.Write(stringBuilder.ToString());
			Response.End();

			@@ -63,7 +63,6 @@
			D:\Company\SMGW_NewWeb\web\App_Code\bin\Debug\Dao.dll
			D:\Company\SMGW_NewWeb\web\App_Code\bin\Debug\Ionic.Zip.dll
			D:\Company\SMGW_NewWeb\web\App_Code\obj\Debug\App_Code.csproj.CoreCompileInputs.cache
			D:\Company\SMGW_NewWeb\web\App_Code\obj\Debug\App_Code.csproj.CopyComplete
			D:\Company\SMGW_NewWeb\web\App_Code\obj\Debug\App_Code.dll
			D:\Company\SMGW_NewWeb\web\App_Code\obj\Debug\App_Code.pdb
			D:\Company\SMGW_NewWeb\web\App_Code\obj\Debug\App_Code.csproj.AssemblyReference.cache

			@@ -250,11 +250,11 @@
			client.ClientID = clientID;
			client.Password = password;
			client.ClientName = clientName;
			client.Address = address;
			client.Address = address;//地址
			client.Remark = remark;
			client.Telephone = telephone;
			client.Agent = agent;
			client.PermissionData = permissionData;
			client.PermissionData = permissionData;//权限数据

			_Dao.Update(client);

			@@ -891,3 +891,102 @@
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227
			在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204

			#7 2021-10-19 14:01:10,954 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列
			在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219

			#7 2021-10-19 14:01:10,999 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20211019 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227
			在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204

			#7 2021-10-19 14:01:44,063 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列
			在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219

			#7 2021-10-19 14:01:44,090 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227
			在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204

			#8 2021-10-19 14:01:53,190 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列
			在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219

			#8 2021-10-19 14:01:53,217 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227
			在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204

			#8 2021-10-19 14:02:56,301 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列
			在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219

			#8 2021-10-19 14:02:56,337 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227
			在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204

			#17 2021-10-19 14:05:02,692 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列
			在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219

			#17 2021-10-19 14:05:02,731 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227
			在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204

			#33 2021-10-19 14:14:50,106 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列
			在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219

			#33 2021-10-19 14:14:50,142 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227
			在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204

			#23 2021-10-19 14:18:23,598 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列
			在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219

			#23 2021-10-19 14:18:23,637 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227
			在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204

			#7 2021-10-19 14:23:51,423 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列
			在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219

			#7 2021-10-19 14:23:51,461 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227
			在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204

			#16 2021-10-19 14:26:04,611 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列
			在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
			在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219

			#16 2021-10-19 14:26:04,657 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210929 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 6)
			在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227
			在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 204