From 6ee5f70d0b3e5bf50a43a71af18624dcabbb2d0c Mon Sep 17 00:00:00 2001
From: wangsheng <123456>
Date: 星期四, 09 九月 2021 15:44:56 +0800
Subject: [PATCH] 新增过滤ID条件，符合过滤ID的不进行审核，过滤ID：传入一级ID自动获取到其下及本身所有ID，均不进行过滤，也可传入子ID
---
掌骏平台自动审核/AutoCheckSMS/bin/Debug/AutoCheckSMS.exe | 0
掌骏平台自动审核/AutoCheckSMS/obj/Debug/AutoCheckSMS.exe | 0
掌骏平台自动审核/AutoCheckSMS/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache | 0
掌骏平台自动审核/TestTemplate/obj/Debug/TestTemplate.csproj.AssemblyReference.cache | 0
掌骏平台自动审核/AutoCheckSMS/bin/Debug/AutoCheckSMS.pdb | 0
掌骏平台自动审核/AutoCheckSMS/bin/Debug/logs/Error2021-07-12.log | 0
掌骏平台自动审核/Test/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache | 0
掌骏平台自动审核/AutoCheckSMS/.vs/AutoCheckSMS/v16/.suo | 0
掌骏平台自动审核/AutoCheckSMS/bin/Debug/logs/app2021-07-12.log | 15 +++++++
掌骏平台自动审核/AutoCheckSMS/SQLHelper.cs | 90 +++++++++++++++++++++++++++++++++++++++++++-
掌骏平台自动审核/Test/obj/Debug/Test.csproj.AssemblyReference.cache | 0
掌骏平台自动审核/TestTemplate/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache | 0
掌骏平台自动审核/AutoCheckSMS/obj/Debug/AutoCheckSMS.pdb | 0
掌骏平台自动审核/AutoCheckSMS/obj/Debug/AutoCheckSMS.csproj.FileListAbsolute.txt | 1
14 files changed, 102 insertions(+), 4 deletions(-)
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/.vs/AutoCheckSMS/v16/.suo" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/.vs/AutoCheckSMS/v16/.suo"
index 95451a4..2978e6a 100644
--- "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/.vs/AutoCheckSMS/v16/.suo"
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/.vs/AutoCheckSMS/v16/.suo"
Binary files differ
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/SQLHelper.cs" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/SQLHelper.cs"
index d9791a2..dce49fc 100644
--- "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/SQLHelper.cs"
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/SQLHelper.cs"
@@ -38,17 +38,39 @@
{
List<tbl_sms_task> list = new List<tbl_sms_task>();
string[] Out = System.Configuration.ConfigurationManager.AppSettings["OutUserid"].Trim().Split(',');
+
+ string U_sql = "select userid,parentuserid from tbl_user where isuse=1 and isdelete=0";
+ DataSet U_ds1 = da.ExecuteDataSet(CommandType.Text, U_sql);
+ DataTable U_dt = U_ds1.Tables[0];
+ List<GetUserID> IGetID = new List<GetUserID>();
+ foreach (DataRow item in U_dt.Rows)
+ {
+ IGetID.Add(new GetUserID{
+ UserID = item[0].ToString(),
+ ParentuserID = item[1].ToString()
+ });
+ }
+ List<GetUserID> GetID = GetSonUsserID(Out, IGetID);
+
+ string[] I_Out = new string[GetID.Count];
+ int i = 0;
+ foreach (var item in GetID)
+ {
+ I_Out[i] = item.UserID;
+ i++;
+ }
+ Log4netService.Debug($"杩囨护ID涓暟:{GetID.Count}");
try
{
string time = DateTime.Now.AddHours(-1).ToString("yyyy-MM-dd HH:mm");
- string sql = $"select TaskID,UserID,MsgContent,ReadError,IsAudit from tbl_sms_task where CreateTime>= '{time}'and IsAudit=0 and ReadError like '%鍒嗗寘瀹屾垚%' and MsgContent not like '%鍥瀇閫�%' and MsgContent not like '%閫�璁�%' and MsgContent not like '%閫�_T%' and MsgContent not like '%.c%' and MsgContent not like '%鐐瑰鐐�%')";
+ string sql = $"select TaskID,UserID,MsgContent,ReadError,IsAudit from tbl_sms_task where CreateTime>= '{time}'and IsAudit=0 and ReadError like '%鍒嗗寘瀹屾垚%' and msgContent not like '%閫�' and MsgContent not like '%鍥瀇閫�%' and MsgContent not like '%閫�璁�%' and MsgContent not like '%閫�_T%' and MsgContent not like '%.c%' and MsgContent not like '%鐐瑰鐐�%'";
DataSet ds = da.ExecuteDataSet(CommandType.Text, sql);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
- if (!Out.Contains(dr["UserID"].ToString().Trim()))
+ if (!I_Out.Contains(dr["UserID"].ToString().Trim()))
{
int taskid = int.Parse(dr["TaskID"].ToString());
int userid = int.Parse(dr["UserID"].ToString());
@@ -58,7 +80,7 @@
}
else
{
- Console.WriteLine($"瀛樺湪杩囨护ID锛歿dr["UserID"].ToString().Trim()},璺宠繃璇D鍐呭");
+ Console.WriteLine($"銆愬鏍告搷浣溿�戝瓨鍦ㄨ繃婊D锛歿dr["UserID"].ToString().Trim()},璺宠繃璇D鍐呭");
Log4netService.Debug($"銆愬鏍告搷浣溿�戝瓨鍦ㄨ繃婊D锛歿dr["UserID"].ToString().Trim()},璺宠繃璇D鍐呭锛歿dr["MsgContent"]}");
}
@@ -73,6 +95,68 @@
}
/// <summary>
+ /// 閫掑綊鑾峰彇鑾峰彇瀛怚D
+ /// </summary>
+ /// <param name="UserID">浼犲叆涓�绾D</param>
+ /// <param name="GetID">浼犲叆璐﹀彿琛�</param>
+ /// <returns></returns>
+ public static List<GetUserID> GetSonUsserID(string[] UserID, List<GetUserID> GetID)
+ {
+ List<GetUserID> LGetID = new List<GetUserID>();
+ List<GetUserID> LID = new List<GetUserID>();
+ for (int i = 0; i < UserID.Length; i++)
+ {
+ LID.AddRange(GetID.Where(a => a.ParentuserID == UserID[i]).ToList());//灏咷etID涓鍚堜竴绾D鐨勬墍鏈夊瓙ID浼犲叆LID
+
+ }
+ if (LID.Count != 0)//閫掑綊鏉′欢
+ {
+ string[] SonID = new string[LID.Count];
+ int i = 0;
+ foreach (var item in LID)
+ {
+ //Console.WriteLine($"閫掑綊 ID锛歿item.ParentuserID} 瀛怚D锛歿item.UserID}");
+ SonID[i] = item.UserID;
+ i++;
+ }//灏嗗瓙ID杞垚鏁扮粍
+ //for (int l = 0; l < SonID.Length; l++)
+ //{
+ // Console.WriteLine($"闇�瑕侀�掑綊鐨処D锛歿SonID[l]}");
+ //}
+
+ for (int h = 0; h < UserID.Length; h++)
+ {
+ LGetID.Add(new GetUserID
+ {
+ UserID = UserID[h].ToString(),
+ ParentuserID = 0.ToString()
+ });
+ }
+ LGetID.AddRange(GetSonUsserID(SonID, GetID));
+ }
+ else
+ {
+ for (int i = 0; i < UserID.Length; i++)
+ {
+ LGetID.Add(new GetUserID
+ {
+ UserID = UserID[i].ToString(),
+ ParentuserID = 0.ToString()
+ });
+ }
+ return LGetID;
+ }
+ return LGetID;
+ }
+
+ public class GetUserID
+ {
+ public string UserID { get; set; }
+ public string ParentuserID { get; set; }
+ }
+
+
+ /// <summary>
/// 鏇存柊瀹℃牳鐘舵��
/// </summary>
/// <param name="audit"></param>
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/AutoCheckSMS.exe" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/AutoCheckSMS.exe"
index 3d073e3..000eb6e 100644
--- "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/AutoCheckSMS.exe"
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/AutoCheckSMS.exe"
Binary files differ
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/AutoCheckSMS.pdb" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/AutoCheckSMS.pdb"
index 021b567..ecaa1a3 100644
--- "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/AutoCheckSMS.pdb"
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/AutoCheckSMS.pdb"
Binary files differ
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/logs/Error2021-07-12.log" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/logs/Error2021-07-12.log"
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/logs/Error2021-07-12.log"
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/logs/app2021-07-12.log" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/logs/app2021-07-12.log"
new file mode 100644
index 0000000..91530be
--- /dev/null
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/bin/Debug/logs/app2021-07-12.log"
@@ -0,0 +1,15 @@
+2021-07-12 15:43:46,750 [1] DEBUG RollingFileLog - 加载模板...263
+2021-07-12 15:43:46,823 [5] DEBUG RollingFileLog - 模板处理线程启动...线程ID:5
+2021-07-12 15:43:46,824 [5] DEBUG RollingFileLog - 模板处理
+2021-07-12 15:43:46,832 [4] DEBUG RollingFileLog - 获取待审核的记录:0
+2021-07-12 15:43:56,839 [4] DEBUG RollingFileLog - 获取待审核的记录:0
+2021-07-12 15:44:06,849 [4] DEBUG RollingFileLog - 获取待审核的记录:0
+2021-07-12 15:44:16,858 [4] DEBUG RollingFileLog - 获取待审核的记录:0
+2021-07-12 15:44:26,866 [4] DEBUG RollingFileLog - 获取待审核的记录:0
+2021-07-12 15:44:36,882 [4] DEBUG RollingFileLog - 获取待审核的记录:0
+2021-07-12 15:44:46,890 [4] DEBUG RollingFileLog - 获取待审核的记录:0
+2021-07-12 15:44:51,996 [5] DEBUG RollingFileLog - 模板处理
+2021-07-12 15:44:56,899 [4] DEBUG RollingFileLog - 获取待审核的记录:0
+2021-07-12 15:45:06,910 [4] DEBUG RollingFileLog - 获取待审核的记录:0
+2021-07-12 15:45:16,922 [4] DEBUG RollingFileLog - 获取待审核的记录:0
+2021-07-12 15:45:26,928 [4] DEBUG RollingFileLog - 获取待审核的记录:0
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/AutoCheckSMS.csproj.FileListAbsolute.txt" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/AutoCheckSMS.csproj.FileListAbsolute.txt"
index af4ada5..3e4adde 100644
--- "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/AutoCheckSMS.csproj.FileListAbsolute.txt"
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/AutoCheckSMS.csproj.FileListAbsolute.txt"
@@ -50,4 +50,3 @@
D:\Company\izjun\鎺岄獜骞冲彴鑷姩瀹℃牳\AutoCheckSMS\obj\Debug\AutoCheckSMS.csproj.CopyComplete
D:\Company\izjun\鎺岄獜骞冲彴鑷姩瀹℃牳\AutoCheckSMS\obj\Debug\AutoCheckSMS.exe
D:\Company\izjun\鎺岄獜骞冲彴鑷姩瀹℃牳\AutoCheckSMS\obj\Debug\AutoCheckSMS.pdb
-D:\Company\izjun\鎺岄獜骞冲彴鑷姩瀹℃牳\AutoCheckSMS\obj\Debug\AutoCheckSMS.csprojAssemblyReference.cache
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/AutoCheckSMS.exe" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/AutoCheckSMS.exe"
index 3d073e3..000eb6e 100644
--- "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/AutoCheckSMS.exe"
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/AutoCheckSMS.exe"
Binary files differ
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/AutoCheckSMS.pdb" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/AutoCheckSMS.pdb"
index 021b567..ecaa1a3 100644
--- "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/AutoCheckSMS.pdb"
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/AutoCheckSMS.pdb"
Binary files differ
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache"
index 535a200..8e3c41f 100644
--- "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache"
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/AutoCheckSMS/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache"
Binary files differ
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/Test/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/Test/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache"
index 8b75767..562721a 100644
--- "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/Test/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache"
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/Test/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache"
Binary files differ
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/Test/obj/Debug/Test.csproj.AssemblyReference.cache" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/Test/obj/Debug/Test.csproj.AssemblyReference.cache"
new file mode 100644
index 0000000..67f5af4
--- /dev/null
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/Test/obj/Debug/Test.csproj.AssemblyReference.cache"
Binary files differ
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/TestTemplate/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/TestTemplate/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache"
index b5a8bf0..7aca831 100644
--- "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/TestTemplate/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache"
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/TestTemplate/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache"
Binary files differ
diff --git "a/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/TestTemplate/obj/Debug/TestTemplate.csproj.AssemblyReference.cache" "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/TestTemplate/obj/Debug/TestTemplate.csproj.AssemblyReference.cache"
new file mode 100644
index 0000000..59bc59d
--- /dev/null
+++ "b/\346\216\214\351\252\217\345\271\263\345\217\260\350\207\252\345\212\250\345\256\241\346\240\270/TestTemplate/obj/Debug/TestTemplate.csproj.AssemblyReference.cache"
Binary files differ
--
Gitblit v1.9.1