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

Dear_Sheng

2021-08-13 25b8dd11f2ad61567c148ed4f1e03679f9d22ae8

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/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"]}");
                        }

                    }
                }
            }