更新指定账号审核过滤

Dear_Sheng

2021-07-12 6d426c9e7fbea7b31307a8923e0eef89800f39c1

更新指定账号审核过滤

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

Binary files differ

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

@@ -2,9 +2,12 @@
<configuration>
  <connectionStrings>
    <!--<add name="ConnectionString" connectionString="server=.;uid=yzm;pwd=zjunmedia587GM$$;database=smsdb" providerName="System.Data.SqlClient"/>-->
    <add name="ConnectionString" connectionString="server=.;uid=sa;pwd=123456;database=smsdb" providerName="System.Data.SqlClient"/>
    <add name="ConnectionString" connectionString="Data Source=DESKTOP-MMFLSTG;Initial Catalog=smsdb;Integrated Security=True" providerName="System.Data.SqlClient"/>
  </connectionStrings>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
    </startup>
<appSettings>
  <add key="OutUserid" value="12856,11"/>
</appSettings>
</configuration>

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/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)
                    {
                        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,12 +120,23 @@
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        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"]}");
                            }
                        }
                    }
                }
            }
            catch (Exception ex)

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

@@ -2,9 +2,12 @@
<configuration>
  <connectionStrings>
    <!--<add name="ConnectionString" connectionString="server=.;uid=yzm;pwd=zjunmedia587GM$$;database=smsdb" providerName="System.Data.SqlClient"/>-->
    <add name="ConnectionString" connectionString="server=.;uid=sa;pwd=123456;database=smsdb" providerName="System.Data.SqlClient"/>
    <add name="ConnectionString" connectionString="Data Source=DESKTOP-MMFLSTG;Initial Catalog=smsdb;Integrated Security=True" providerName="System.Data.SqlClient"/>
  </connectionStrings>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
    </startup>
<appSettings>
  <add key="OutUserid" value="12856,11"/>
</appSettings>
</configuration>

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

Binary files differ

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

@@ -2,9 +2,12 @@
<configuration>
  <connectionStrings>
    <!--<add name="ConnectionString" connectionString="server=.;uid=yzm;pwd=zjunmedia587GM$$;database=smsdb" providerName="System.Data.SqlClient"/>-->
    <add name="ConnectionString" connectionString="server=.;uid=sa;pwd=123456;database=smsdb" providerName="System.Data.SqlClient"/>
    <add name="ConnectionString" connectionString="Data Source=DESKTOP-MMFLSTG;Initial Catalog=smsdb;Integrated Security=True" providerName="System.Data.SqlClient"/>
  </connectionStrings>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
    </startup>
<appSettings>
  <add key="OutUserid" value="12856,11"/>
</appSettings>
</configuration>

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

Binary files differ

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

@@ -1 +1 @@
cf16ffa1ea37edaa8cf2978f10377312566fe503
241fe42e299de88b264a7708adbb51e2dd6146e9

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

@@ -24,3 +24,29 @@
C:\Users\Administrator\Desktop\Archives\Repos\掌骏平台自动审核\AutoCheckSMS\bin\Debug\log4net.config
C:\Users\Administrator\Desktop\Archives\Repos\掌骏平台自动审核\AutoCheckSMS\bin\Debug\log4net.dll
C:\Users\Administrator\Desktop\Archives\Repos\掌骏平台自动审核\AutoCheckSMS\bin\Debug\log4net.xml
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\App.config
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\log4net.config
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\AutoCheckSMS.exe.config
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\AutoCheckSMS.exe
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\AutoCheckSMS.pdb
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\log4net.dll
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.EnterpriseLibrary.Common.dll
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.EnterpriseLibrary.Data.dll
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.ServiceLocation.dll
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.Unity.Configuration.dll
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.Unity.dll
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.Unity.Interception.Configuration.dll
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.Unity.Interception.dll
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\log4net.xml
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.EnterpriseLibrary.Common.xml
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.EnterpriseLibrary.Data.xml
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.ServiceLocation.pdb
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.ServiceLocation.xml
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.Unity.xml
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.Unity.Configuration.xml
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.Unity.Interception.xml
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\bin\Debug\Microsoft.Practices.Unity.Interception.Configuration.xml
D:\Company\izjun\掌骏平台自动审核\AutoCheckSMS\obj\Debug\AutoCheckSMS.csproj.CoreCompileInputs.cache
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

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

Binary files differ

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

Binary files differ

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

Binary files differ

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

Binary files differ

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

@@ -5,3 +5,10 @@
C:\Users\Administrator\Desktop\Archives\Repos\掌骏平台自动审核\Test\obj\Debug\Test.exe
C:\Users\Administrator\Desktop\Archives\Repos\掌骏平台自动审核\Test\obj\Debug\Test.pdb
C:\Users\Administrator\Desktop\Archives\Repos\掌骏平台自动审核\Test\obj\Debug\Test.csprojAssemblyReference.cache
D:\Company\izjun\掌骏平台自动审核\Test\bin\Debug\Test.exe.config
D:\Company\izjun\掌骏平台自动审核\Test\bin\Debug\Test.exe
D:\Company\izjun\掌骏平台自动审核\Test\bin\Debug\Test.pdb
D:\Company\izjun\掌骏平台自动审核\Test\obj\Debug\Test.csprojAssemblyReference.cache
D:\Company\izjun\掌骏平台自动审核\Test\obj\Debug\Test.csproj.CoreCompileInputs.cache
D:\Company\izjun\掌骏平台自动审核\Test\obj\Debug\Test.exe
D:\Company\izjun\掌骏平台自动审核\Test\obj\Debug\Test.pdb

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/Test/obj/Debug/Test.csprojAssemblyReference.cache

Binary files differ

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

Binary files differ

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

Binary files differ

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/TestTemplate/App.config

@@ -2,7 +2,7 @@
<configuration>
  <connectionStrings>
    <!--<add name="ConnectionString" connectionString="server=.;uid=yzm;pwd=zjunmedia587GM$$;database=smsdb" providerName="System.Data.SqlClient"/>-->
    <add name="ConnectionString" connectionString="server=.;uid=sa;pwd=123456;database=smsdb" providerName="System.Data.SqlClient"/>
    <add name="ConnectionString" connectionString="Data Source=DESKTOP-MMFLSTG;Initial Catalog=smsdb;Integrated Security=True" providerName="System.Data.SqlClient"/>
  </connectionStrings>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/TestTemplate/bin/Debug/App.config

Binary files differ

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

Binary files differ

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

Binary files differ

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

Binary files differ

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/TestTemplate/bin/Debug/Microsoft.Practices.ServiceLocation.xml

Binary files differ

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/TestTemplate/bin/Debug/Microsoft.Practices.Unity.Interception.xml

Binary files differ

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

Binary files differ

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

@@ -2,7 +2,7 @@
<configuration>
  <connectionStrings>
    <!--<add name="ConnectionString" connectionString="server=.;uid=yzm;pwd=zjunmedia587GM$$;database=smsdb" providerName="System.Data.SqlClient"/>-->
    <add name="ConnectionString" connectionString="server=.;uid=sa;pwd=123456;database=smsdb" providerName="System.Data.SqlClient"/>
    <add name="ConnectionString" connectionString="Data Source=DESKTOP-MMFLSTG;Initial Catalog=smsdb;Integrated Security=True" providerName="System.Data.SqlClient"/>
  </connectionStrings>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />

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

Binary files differ

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/TestTemplate/bin/Debug/log4net.xml

Diff too large

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/TestTemplate/obj/Debug/TestTemplate.csproj.CoreCompileInputs.cache

@@ -1 +1 @@
a99203b17f1c99a90226b37b308bb31b79490da3
7a82d43fc49ece2595b02ec058f9013e7b9695ad

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

@@ -24,3 +24,29 @@
C:\Users\Administrator\Desktop\Archives\Repos\掌骏平台自动审核\TestTemplate\obj\Debug\TestTemplate.csproj.CopyComplete
C:\Users\Administrator\Desktop\Archives\Repos\掌骏平台自动审核\TestTemplate\obj\Debug\TestTemplate.exe
C:\Users\Administrator\Desktop\Archives\Repos\掌骏平台自动审核\TestTemplate\obj\Debug\TestTemplate.pdb
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\log4net.config
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\App.config
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\TestTemplate.exe.config
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\TestTemplate.exe
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\TestTemplate.pdb
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\AutoCheckSMS.exe
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\Microsoft.Practices.EnterpriseLibrary.Data.dll
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\log4net.dll
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\Microsoft.Practices.EnterpriseLibrary.Common.dll
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\Microsoft.Practices.ServiceLocation.dll
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\Microsoft.Practices.Unity.dll
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\Microsoft.Practices.Unity.Interception.dll
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\AutoCheckSMS.pdb
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\AutoCheckSMS.exe.config
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\Microsoft.Practices.EnterpriseLibrary.Data.xml
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\log4net.xml
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\Microsoft.Practices.EnterpriseLibrary.Common.xml
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\Microsoft.Practices.ServiceLocation.pdb
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\Microsoft.Practices.ServiceLocation.xml
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\Microsoft.Practices.Unity.xml
D:\Company\izjun\掌骏平台自动审核\TestTemplate\bin\Debug\Microsoft.Practices.Unity.Interception.xml
D:\Company\izjun\掌骏平台自动审核\TestTemplate\obj\Debug\TestTemplate.csprojAssemblyReference.cache
D:\Company\izjun\掌骏平台自动审核\TestTemplate\obj\Debug\TestTemplate.csproj.CoreCompileInputs.cache
D:\Company\izjun\掌骏平台自动审核\TestTemplate\obj\Debug\TestTemplate.csproj.CopyComplete
D:\Company\izjun\掌骏平台自动审核\TestTemplate\obj\Debug\TestTemplate.exe
D:\Company\izjun\掌骏平台自动审核\TestTemplate\obj\Debug\TestTemplate.pdb

 ÕÆ¿¥Æ½Ì¨×Ô¶¯ÉóºË/TestTemplate/obj/Debug/TestTemplate.csprojAssemblyReference.cache

Binary files differ

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

Binary files differ

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

Binary files differ