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/GwAuditCache.ashx |   45 +++++++++++++++++++++++++++++++++++++--------
 1 files changed, 37 insertions(+), 8 deletions(-)

diff --git a/web/web/GwAuditCache.ashx b/web/web/GwAuditCache.ashx
index af115f6..77a685c 100644
--- a/web/web/GwAuditCache.ashx
+++ b/web/web/GwAuditCache.ashx
@@ -27,6 +27,8 @@
                 return this.loadDetail(context);
             case "load":
                 return this.Load(context);
+            case "editContent":
+                return this.EditContent(context);
             default:
                 throw new Exception("Invalid Action=" + @string);
         }
@@ -43,19 +45,19 @@
 
     private JsonPageResult Load(PageContext<SysUser> context)
     {
-        DateTime dateTime1 = context.GetDateTime("StartTime");
-        DateTime dateTime2 = context.GetDateTime("EndTime");
-        int int1 = context.GetInt("auditingStatus");
-        string string1 = context.GetString("content");
-        string string2 = context.GetString("spids");
+        DateTime startTime = context.GetDateTime("StartTime");
+        DateTime endTime = context.GetDateTime("EndTime");
+        int auditingStatus = context.GetInt("auditingStatus");
+        string content = context.GetString("content");
+        string spids = context.GetString("spids");
         int recordCount = 0;
-        int int2 = context.GetInt("pageSize", 20);
-        int int3 = context.GetInt("pageIndex", 1);
+        int pageSize = context.GetInt("pageSize", 20);
+        int pageIndex = context.GetInt("pageIndex", 1);
         string opname = context.GetString("opname");
         using (GwAuditCacheDao gwAuditCacheDao = new GwAuditCacheDao())
         {
             StringBuilder stringBuilder = new StringBuilder();
-            DataTable dataTable = gwAuditCacheDao.LoadCache(dateTime1, dateTime2, int1, string1, string2, out recordCount, int2, int3, opname);
+            DataTable dataTable = gwAuditCacheDao.LoadCache(startTime, endTime, auditingStatus, content, spids, out recordCount, pageSize, pageIndex, opname);
             if (dataTable.Rows.Count > 0)
             {
                 foreach (DataRow row in (InternalDataCollectionBase)dataTable.Rows)
@@ -64,6 +66,7 @@
                     stringBuilder.Append("<tr>");
                     stringBuilder.AppendFormat("<td><input type=\"checkbox\" name=\"hashCode\" checked value=\"{0}\" /></td>", (object)dataRowReader.GetString("HASH_CODE"));
                     stringBuilder.Append("<td>" + dataRowReader.GetString("SP_ID") + "</td>");
+                    stringBuilder.Append("<td>" + dataRowReader.GetString("CLIENT_ID")+"</td>");
                     stringBuilder.Append("<td>" + (object)dataRowReader.GetString("OP_NAME") + "</td>");
                     stringBuilder.Append("<td>" + dataRowReader.GetString("MSG_CONTENT") + "</td>");
                     stringBuilder.Append("<td>" + dataRowReader.GetString("KEYWORD") + "</td>");
@@ -88,6 +91,32 @@
             });
         }
     }
+    
+    //鍐呭缂栬緫
+    public JsonPageResult EditContent(PageContext<SysUser> context)
+    {
+        string sms = context.GetString("newSms");
+        if (string.IsNullOrEmpty(sms))
+        {
+            throw new ArgumentException("璇疯緭鍏ヤ慨鏀瑰唴瀹癸紝涓嶅厑璁镐负绌猴紒锛�");
+        }
+
+        using (GwAuditCacheDao gwAuditCacheDao = new GwAuditCacheDao())
+        {
+            string[] strArray = JsonConvert.DeserializeObject<string[]>(context.GetString("hashCodes"));
+            IEnumerable<string> enumerable = Enumerable.Distinct<string>((IEnumerable<string>)strArray);
+            StringBuilder stringBuilder = new StringBuilder();
+            foreach (string hashCode in enumerable)
+            {
+                if (!gwAuditCacheDao.UpdateCacheContent(hashCode, sms))
+                    stringBuilder.AppendFormat("淇敼鍐呭杩囩▼鍙戠敓閿欒锛寋0}锛氫慨鏀瑰け璐ワ紒", hashCode);
+            }
+            stringBuilder.AppendLine();
+            stringBuilder.AppendFormat("鍐呭璋冩暣瀹屾垚锛屽叡" + (object)strArray.Length + "涓唴瀹癸紒");
+            return new JsonPageResult(true, (object)stringBuilder.ToString());
+        }
+    }
+
 
     /// <summary>
     /// 鎵瑰噯锛堝甫閫氶亾锛�

--
Gitblit v1.9.1