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