修改，SQL语句剔除各类营销退订写法

Dear_Sheng

2021-08-13 25b8dd11f2ad61567c148ed4f1e03679f9d22ae8

修改，SQL语句剔除各类营销退订写法

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/AutoCheckSMS/.vs/AutoCheckSMS/v16/.suo

Binary files differ

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/AutoCheckSMS/Models/tbl_sms_task.cs

@@ -25,4 +25,9 @@
        public int IsAudit { get => _isAudit; set => _isAudit = value; }
        public int IsSend { get => _isSend; set => _isSend = value; }
    }

    public class UserID
    {
        public string Userid { get; set; }
    }
}

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/AutoCheckSMS/SQLHelper.cs

@@ -37,33 +37,31 @@
        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(',');
            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)
                    {
                        foreach (var item in OutUserid)
                        if (!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},跳过该ID内容");
                                Log4netService.Debug($"【审核操作】存在过滤ID：{item},跳过该ID内容：{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($"存在过滤ID：{dr["UserID"].ToString().Trim()},跳过该ID内容");
                            Log4netService.Debug($"【审核操作】存在过滤ID：{dr["UserID"].ToString().Trim()},跳过该ID内容：{dr["MsgContent"]}");
                        }

                    }
                }
            }

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/AutoCheckSMS/bin/Debug/AutoCheckSMS.exe

Binary files differ

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/AutoCheckSMS/bin/Debug/AutoCheckSMS.pdb

Binary files differ

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/AutoCheckSMS/obj/Debug/AutoCheckSMS.csproj.FileListAbsolute.txt

@@ -50,3 +50,4 @@
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

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/AutoCheckSMS/obj/Debug/AutoCheckSMS.exe

Binary files differ

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/AutoCheckSMS/obj/Debug/AutoCheckSMS.pdb

Binary files differ