更新指定账号审核过滤

Dear_Sheng

2021-07-12 6d426c9e7fbea7b31307a8923e0eef89800f39c1

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/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},跳过该ID内容");
                                Log4netService.Debug($"【审核操作】存在过滤ID：{item},跳过该ID内容：{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},跳过该ID内容");
                                Log4netService.Debug($"【模板操作】存在过滤ID：{item},跳过该ID内容：{dr["MsgContent"]}");
                            }
                        }
                    }
                }
            }