From 6d426c9e7fbea7b31307a8923e0eef89800f39c1 Mon Sep 17 00:00:00 2001
From: Dear_Sheng <191702387@qq.com>
Date: 星期一, 12 七月 2021 15:57:20 +0800
Subject: [PATCH] 更新指定账号审核过滤
---
掌骏平台自动审核/AutoCheckSMS/SQLHelper.cs | 44 ++++++++++++++++++++++++++++++++++----------
1 files changed, 34 insertions(+), 10 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 129217d..af09f00 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,6 +37,7 @@
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(',');
try
{
string time = DateTime.Now.AddHours(-1).ToString("yyyy-MM-dd HH:mm");
@@ -47,11 +48,22 @@
{
foreach (DataRow dr in dt.Rows)
{
- 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 });
+ foreach (var item in OutUserid)
+ {
+ 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"]}");
+ }
+ }
}
}
}
@@ -99,6 +111,7 @@
List<tbl_sms_task> list = new List<tbl_sms_task>();
try
{
+ string[] OutUserid = System.Configuration.ConfigurationManager.AppSettings["OutUserid"].Trim().Split(',');
string time = DateTime.Now.AddHours(-1).ToString("yyyy-MM-dd HH:mm");
string sql = $"select TaskID,UserID,MsgContent,ReadError,IsAudit from tbl_sms_task_log where CreateTime>= '{time}' and issend=2 and (MsgContent not like '%閫�璁�%' and MsgContent not like '%.c%' and MsgContent not like '%鐐瑰鐐�%') and IsAudit=2";
DataSet ds = da.ExecuteDataSet(CommandType.Text, sql);
@@ -107,11 +120,22 @@
{
foreach (DataRow dr in dt.Rows)
{
- 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 });
+ foreach (var item in OutUserid)
+ {
+ 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"]}");
+ }
+ }
}
}
}
--
Gitblit v1.9.1