From 25b8dd11f2ad61567c148ed4f1e03679f9d22ae8 Mon Sep 17 00:00:00 2001
From: Dear_Sheng <191702387@qq.com>
Date: 星期五, 13 八月 2021 18:00:41 +0800
Subject: [PATCH] 修改，SQL语句剔除各类营销退订写法
---
掌骏平台自动审核/AutoCheckSMS/SQLHelper.cs | 44 +++++++++++++++++++++++++++++++++-----------
1 files changed, 33 insertions(+), 11 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..d9791a2 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,21 +37,31 @@
public List<tbl_sms_task> GetSmsConent()
{
List<tbl_sms_task> list = new List<tbl_sms_task>();
+ string[] Out = System.Configuration.ConfigurationManager.AppSettings["OutUserid"].Trim().Split(',');
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 '%閫�_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)
{
- 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 });
+ if (!Out.Contains(dr["UserID"].ToString().Trim()))
+ {
+ 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锛歿dr["UserID"].ToString().Trim()},璺宠繃璇D鍐呭");
+ Log4netService.Debug($"銆愬鏍告搷浣溿�戝瓨鍦ㄨ繃婊D锛歿dr["UserID"].ToString().Trim()},璺宠繃璇D鍐呭锛歿dr["MsgContent"]}");
+ }
+
}
}
}
@@ -99,6 +109,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 +118,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