From 374ce4ffd0c459bb4067e8d5765f972668aff9b1 Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期四, 02 三月 2023 14:56:23 +0800
Subject: [PATCH] 变更oracle访问组件
---
web/web/GwSm.ashx | 26 +++++++++++++++++++++++---
1 files changed, 23 insertions(+), 3 deletions(-)
diff --git a/web/web/GwSm.ashx b/web/web/GwSm.ashx
index e2c8e76..6c25e4e 100644
--- a/web/web/GwSm.ashx
+++ b/web/web/GwSm.ashx
@@ -10,9 +10,16 @@
public class GwSm : PageHandler<SysUser>
{
+ private int _userId = -1;
+ private string _userType = "";
+ private string _account = "";
+
public override JsonPageResult ProcessRequestInternal(PageContext<Model.SysUser> context)
{
string action = context.GetString("action");
+ _userId = context.SessionObject.UserID;
+ _userType = context.SessionObject.UserType;
+ _account = context.SessionObject.Account;
switch (action)
{
@@ -63,8 +70,11 @@
int recordCount = 0;
int pageSize = context.GetInt("pageSize", 20);
int pageIndex = context.GetInt("pageIndex", 1);
+
+ //鏍规嵁绯荤粺鐢ㄦ埛鑾峰彇鏈夋潈闄愬鎴疯处鍙�
+ string permissionsSQL = new GwClientDao().GetSpPermissions(_userId, _userType, "sm");
- List<Model.GwSm> list = dao.LoadInfoList(selectedApMID, selectedOpName, selectedClientID, selectedSpID, selectedDestnationID, selectedDate, selectedBeginTime, selectedEndTime, selectedContent, selectedOpStat, TStatus, out recordCount, pageSize, pageIndex);
+ List<Model.GwSm> list = dao.LoadInfoList(selectedApMID, selectedOpName, selectedClientID, selectedSpID, selectedDestnationID, selectedDate, selectedBeginTime, selectedEndTime, selectedContent, selectedOpStat, TStatus, permissionsSQL, out recordCount, pageSize, pageIndex );
string str = "";
@@ -93,7 +103,15 @@
if (item.ResendStatus == 1 && item.ResendFlag == 1) { resendStatusText = "<span class='text-danger'>澶辫触鐭俊宸茶ˉ鍙�</span>"; }
if (item.ResendStatus == 1 && item.ResendFlag == 0) { resendStatusText = "<span class='text-success'>琛ュ彂璁板綍</span>"; }
str += "<td>" + resendStatusText + "</td>";
- str += "<td>" + (item.OpDeliverTime - item.SubmitTime).TotalSeconds + "</td>";
+ if (item.OpDeliverTime.ToString() == "0001/1/1 0:00:00" || item.OpDeliverTime == null)
+ {
+ str += "<td>" + "鏃犳硶璁＄畻" + "</td>";
+ }
+ else
+ {
+ str += "<td>" + (item.OpDeliverTime - item.SubmitTime).TotalSeconds + "</td>";
+ }
+
str += "<td>" + item.APFeeCount + "/" + item.OPFeeCount + "</td>";
str += "<td>" + item.APResult + "/" + item.OPResult + "</td>";
str += @"<td class=""text-right"">" + (item.SubmitTime == DateTime.MinValue ? string.Empty : item.SubmitTime.ToString("yy-MM-dd HH:mm:ss")) + "</td>";
@@ -157,8 +175,10 @@
int recordCount = 0;
int pageSize = context.GetInt("pageSize", 20);
int pageIndex = context.GetInt("pageIndex", 1);
+
+ string permissionsSQL = new GwClientDao().GetSpPermissions(_userId, _userType, "sm");
- List<Model.GwSm> list = dao.LoadInfoList(selectedApMID, selectedOpName, selectedClientID, selectedSpID, selectedDestnationID, selectedDate, selectedBeginTime, selectedEndTime, selectedContent, selectedOpStat, TStatus, out recordCount, pageSize, pageIndex, "ReSend");
+ List<Model.GwSm> list = dao.LoadInfoList(selectedApMID, selectedOpName, selectedClientID, selectedSpID, selectedDestnationID, selectedDate, selectedBeginTime, selectedEndTime, selectedContent, selectedOpStat, TStatus, permissionsSQL, out recordCount, pageSize, pageIndex, "ReSend");
string str = "";
--
Gitblit v1.9.1