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/SQLHelper.cs | 116 +++++++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 99 insertions(+), 17 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/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 af09f00..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"
@@ -37,33 +37,53 @@
public List<tbl_sms_task> GetSmsConent()
{
List<tbl_sms_task> list = new List<tbl_sms_task>();
- string[] OutUserid = System.Configuration.ConfigurationManager.AppSettings["OutUserid"].Trim().Split(',');
+ 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 '%.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)
{
- foreach (var item in OutUserid)
+ if (!I_Out.Contains(dr["UserID"].ToString().Trim()))
{
- if(dr["UserID"].ToString()!=item)
- {
- int taskid = int.Parse(dr["TaskID"].ToString());
- int userid = int.Parse(dr["UserID"].ToString());
- string content = dr["MsgContent"].ToString();
- int isaudit = int.Parse(dr["IsAudit"].ToString());
- list.Add(new tbl_sms_task() { TaskID = taskid, UserID = userid, MsgContent = content, IsAudit = isaudit });
- }
- else
- {
- Console.WriteLine($"瀛樺湪杩囨护ID锛歿item},璺宠繃璇D鍐呭");
- Log4netService.Debug($"銆愬鏍告搷浣溿�戝瓨鍦ㄨ繃婊D锛歿item},璺宠繃璇D鍐呭锛歿dr["MsgContent"]}");
- }
- }
+ int taskid = int.Parse(dr["TaskID"].ToString());
+ int userid = int.Parse(dr["UserID"].ToString());
+ string content = dr["MsgContent"].ToString();
+ int isaudit = int.Parse(dr["IsAudit"].ToString());
+ list.Add(new tbl_sms_task() { TaskID = taskid, UserID = userid, MsgContent = content, IsAudit = isaudit });
+ }
+ else
+ {
+ Console.WriteLine($"銆愬鏍告搷浣溿�戝瓨鍦ㄨ繃婊D锛歿dr["UserID"].ToString().Trim()},璺宠繃璇D鍐呭");
+ Log4netService.Debug($"銆愬鏍告搷浣溿�戝瓨鍦ㄨ繃婊D锛歿dr["UserID"].ToString().Trim()},璺宠繃璇D鍐呭锛歿dr["MsgContent"]}");
+ }
+
}
}
}
@@ -75,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>
--
Gitblit v1.9.1