From 341da63fe63e2cae3337c5a090624400d7244c11 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期二, 02 七月 2024 21:22:18 +0800
Subject: [PATCH] 钉钉消息加入日志,
---
DingDingMsg/DingDingMsg/DingDingMsg.csproj.user | 6 +++
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.FileListAbsolute.txt | 21 ++++++++++
DingDingMsg/.vs/DingDingMsg/v16/.suo | 0
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.AssemblyReference.cache | 0
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.pdb | 0
DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/Vlog/2024-07-02.txt | 15 +++++++
DingDingMsg/.vs/DingDingMsg/DesignTimeBuild/.dtbcache.v2 | 0
DingDingMsg/DingDingMsg/obj/Debug/DingDingMsg.1.0.0.nuspec | 20 ++++++++++
DingDingMsg/DingDingMsg/bin/Debug/DingDingMsg.1.0.0.nupkg | 0
DingDingMsg/DingDingMsg/DBHelper.cs | 46 ++++++++++++++++++++++
DingDingMsg/DingDingMsg/Program.cs | 11 ++---
DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/DingDingMsg.pdb | 0
12 files changed, 111 insertions(+), 8 deletions(-)
diff --git a/DingDingMsg/.vs/DingDingMsg/DesignTimeBuild/.dtbcache.v2 b/DingDingMsg/.vs/DingDingMsg/DesignTimeBuild/.dtbcache.v2
index 5a8f160..9f6d2a2 100644
--- a/DingDingMsg/.vs/DingDingMsg/DesignTimeBuild/.dtbcache.v2
+++ b/DingDingMsg/.vs/DingDingMsg/DesignTimeBuild/.dtbcache.v2
Binary files differ
diff --git a/DingDingMsg/.vs/DingDingMsg/v16/.suo b/DingDingMsg/.vs/DingDingMsg/v16/.suo
index 7a4be5b..f3a9854 100644
--- a/DingDingMsg/.vs/DingDingMsg/v16/.suo
+++ b/DingDingMsg/.vs/DingDingMsg/v16/.suo
Binary files differ
diff --git a/DingDingMsg/DingDingMsg/DBHelper.cs b/DingDingMsg/DingDingMsg/DBHelper.cs
index 3b3b2a1..efce6a2 100644
--- a/DingDingMsg/DingDingMsg/DBHelper.cs
+++ b/DingDingMsg/DingDingMsg/DBHelper.cs
@@ -1,7 +1,9 @@
-锘縰sing System;
+锘縰sing Newtonsoft.Json;
+using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
+using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
@@ -431,5 +433,47 @@
CnClose();
CnDispose();
}
+
+ private static readonly object lockObj = new object();
+ //鍐欐棩蹇�
+ public static void CustomWriteLog(object obj, string FileName, string filePath = "Vlog", bool isAppend = true)
+ {
+ try
+ {
+ lock (lockObj)
+ {
+ filePath = $@"{filePath}\{FileName}.txt";
+
+ filePath = AppDomain.CurrentDomain.BaseDirectory + filePath;
+
+ if (!System.IO.Directory.Exists(Path.GetDirectoryName(filePath)))
+ {
+ System.IO.Directory.CreateDirectory(Path.GetDirectoryName(filePath));
+ }
+
+ bool fileExists = System.IO.File.Exists(filePath);
+ //涓嶅瓨鍦� 鍒欏垱寤鸿鏂囦欢
+ if (!fileExists)
+ {
+ System.IO.File.Create(filePath).Close();
+ }
+
+ using (StreamWriter writer = new StreamWriter(filePath, isAppend))
+ {
+ //瀛樺湪鐨勬椂鍊欐墠鍐欎竴琛�
+ if (fileExists && isAppend)
+ {
+ writer.WriteLine();
+ }
+
+ var content = obj is string ? obj : JsonConvert.SerializeObject(obj);
+ writer.WriteLine($"{DateTime.Now} {content}");
+ }
+ }
+ }
+ catch (Exception ex)
+ {
+ }
+ }
}
}
diff --git a/DingDingMsg/DingDingMsg/DingDingMsg.csproj.user b/DingDingMsg/DingDingMsg/DingDingMsg.csproj.user
new file mode 100644
index 0000000..5df420f
--- /dev/null
+++ b/DingDingMsg/DingDingMsg/DingDingMsg.csproj.user
@@ -0,0 +1,6 @@
+锘�<?xml version="1.0" encoding="utf-8"?>
+<Project ToolsVersion="Current" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
+ <PropertyGroup>
+ <ShowAllFiles>false</ShowAllFiles>
+ </PropertyGroup>
+</Project>
\ No newline at end of file
diff --git a/DingDingMsg/DingDingMsg/Program.cs b/DingDingMsg/DingDingMsg/Program.cs
index 459fb4e..b42f385 100644
--- a/DingDingMsg/DingDingMsg/Program.cs
+++ b/DingDingMsg/DingDingMsg/Program.cs
@@ -16,10 +16,9 @@
{
string appKey = "dingrsrzhdyn3mlaof95";
string appSecret = "RAqH6YtZnPLCpDbuqfaYQkKkVtVdS0wqfC8I26X6qiS-8eoCJCNrzx3fubGND4Sq";
- Console.WriteLine("Hello World!");
+ Console.WriteLine("绋嬪簭姝ｅ湪鎵ц,璇蜂笉瑕佸叧闂�!!!!");
while (true)
{
- Console.WriteLine("Hello World!1");
//鏌ユ暟鎹�
string sql = "select a.HInterID,a.HReceiveMan 鎺ユ敹浜�,c.HDingDingUserID 閽夐拤id,b.HDescription 鍐呭 from OA_ErrMsgBackBillSub2" +
" a inner join OA_ErrMsgBackBillMain b on a.HInterID=b.HInterID left join Gy_Czygl c " +
@@ -60,16 +59,14 @@
string sql1 = "update OA_ErrMsgBackBillSub2 set HSendFlag='1' where HReceiveMan in ('" + Stares + "')";
oCN.RunProc(sql1);
Console.WriteLine(sql1);
+ DBHelper.CustomWriteLog("閽夐拤杩斿洖淇℃伅:"+response+" 鏇存柊瀛愯〃璇彞:"+sql1, DateTime.Now.ToString("yyyy-MM-dd"));
}
else
{
Console.WriteLine(responseData.errcode);
+ DBHelper.CustomWriteLog("閽夐拤杩斿洖淇℃伅:" + response, DateTime.Now.ToString("yyyy-MM-dd"));
}
-
- }
-
-
-
+ }
}
// 绛夊緟涓�鍒嗛挓
diff --git a/DingDingMsg/DingDingMsg/bin/Debug/DingDingMsg.1.0.0.nupkg b/DingDingMsg/DingDingMsg/bin/Debug/DingDingMsg.1.0.0.nupkg
new file mode 100644
index 0000000..0aa99d6
--- /dev/null
+++ b/DingDingMsg/DingDingMsg/bin/Debug/DingDingMsg.1.0.0.nupkg
Binary files differ
diff --git a/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/DingDingMsg.pdb b/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/DingDingMsg.pdb
index 9373c26..dff242b 100644
--- a/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/DingDingMsg.pdb
+++ b/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/DingDingMsg.pdb
Binary files differ
diff --git a/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/Vlog/2024-07-02.txt b/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/Vlog/2024-07-02.txt
new file mode 100644
index 0000000..43f69d5
--- /dev/null
+++ b/DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/Vlog/2024-07-02.txt
@@ -0,0 +1,15 @@
+2024/7/2 21:05:55 閽夐拤杩斿洖淇℃伅:{"errcode":0,"errmsg":"ok","task_id":3165700882944,"request_id":"16mg1ldq6z11j"} 鏇存柊瀛愯〃璇彞:update OA_ErrMsgBackBillSub2 set HSendFlag='1' where HReceiveMan in ('寮犵憺骞�')
+
+2024/7/2 21:06:00 閽夐拤杩斿洖淇℃伅:{"errcode":0,"errmsg":"ok","task_id":3164678153205,"request_id":"15sq8m7iyid3v"} 鏇存柊瀛愯〃璇彞:update OA_ErrMsgBackBillSub2 set HSendFlag='1' where HReceiveMan in ('浣欐�濇澃')
+
+2024/7/2 21:06:01 閽夐拤杩斿洖淇℃伅:{"errcode":0,"errmsg":"ok","task_id":3169343584156,"request_id":"16mo0g1pnusay"} 鏇存柊瀛愯〃璇彞:update OA_ErrMsgBackBillSub2 set HSendFlag='1' where HReceiveMan in ('鏉ㄤ箰')
+
+2024/7/2 21:06:01 閽夐拤杩斿洖淇℃伅:{"errcode":0,"errmsg":"ok","task_id":3165696885235,"request_id":"16kzgzu1cx5mw"} 鏇存柊瀛愯〃璇彞:update OA_ErrMsgBackBillSub2 set HSendFlag='1' where HReceiveMan in ('鏅剷绔�')
+
+2024/7/2 21:06:02 閽夐拤杩斿洖淇℃伅:{"errcode":0,"errmsg":"ok","task_id":3164668263691,"request_id":"16l28rpuv1xg9"} 鏇存柊瀛愯〃璇彞:update OA_ErrMsgBackBillSub2 set HSendFlag='1' where HReceiveMan in ('鏅剷绔�')
+
+2024/7/2 21:06:02 閽夐拤杩斿洖淇℃伅:{"errcode":0,"errmsg":"ok","task_id":3167779443991,"request_id":"15rdh7i30ubwn"} 鏇存柊瀛愯〃璇彞:update OA_ErrMsgBackBillSub2 set HSendFlag='1' where HReceiveMan in ('寮犵憺骞�')
+
+2024/7/2 21:06:03 閽夐拤杩斿洖淇℃伅:{"errcode":0,"errmsg":"ok","task_id":3167795343392,"request_id":"15r926xqwmk72"} 鏇存柊瀛愯〃璇彞:update OA_ErrMsgBackBillSub2 set HSendFlag='1' where HReceiveMan in ('浣欐�濇澃')
+
+2024/7/2 21:06:12 閽夐拤杩斿洖淇℃伅:{"errcode":0,"errmsg":"ok","task_id":3169325770146,"request_id":"16mh98twpxfjs"} 鏇存柊瀛愯〃璇彞:update OA_ErrMsgBackBillSub2 set HSendFlag='1' where HReceiveMan in ('鏉ㄤ箰')
diff --git a/DingDingMsg/DingDingMsg/obj/Debug/DingDingMsg.1.0.0.nuspec b/DingDingMsg/DingDingMsg/obj/Debug/DingDingMsg.1.0.0.nuspec
new file mode 100644
index 0000000..11b33d7
--- /dev/null
+++ b/DingDingMsg/DingDingMsg/obj/Debug/DingDingMsg.1.0.0.nuspec
@@ -0,0 +1,20 @@
+锘�<?xml version="1.0" encoding="utf-8"?>
+<package xmlns="http://schemas.microsoft.com/packaging/2012/06/nuspec.xsd">
+ <metadata>
+ <id>DingDingMsg</id>
+ <version>1.0.0</version>
+ <authors>DingDingMsg</authors>
+ <requireLicenseAcceptance>false</requireLicenseAcceptance>
+ <description>Package Description</description>
+ <dependencies>
+ <group targetFramework=".NETCoreApp3.1">
+ <dependency id="Newtonsoft.Json" version="13.0.3" exclude="Build,Analyzers" />
+ <dependency id="System.Data.SqlClient" version="4.8.6" exclude="Build,Analyzers" />
+ </group>
+ </dependencies>
+ </metadata>
+ <files>
+ <file src="D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\DingDingMsg.runtimeconfig.json" target="lib\netcoreapp3.1\DingDingMsg.runtimeconfig.json" />
+ <file src="D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\DingDingMsg.dll" target="lib\netcoreapp3.1\DingDingMsg.dll" />
+ </files>
+</package>
\ No newline at end of file
diff --git a/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.AssemblyReference.cache b/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.AssemblyReference.cache
index f5e894a..a323781 100644
--- a/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.AssemblyReference.cache
+++ b/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.AssemblyReference.cache
Binary files differ
diff --git a/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.FileListAbsolute.txt b/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.FileListAbsolute.txt
index 7cb0ec1..a89eb41 100644
--- a/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.FileListAbsolute.txt
+++ b/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.FileListAbsolute.txt
@@ -19,3 +19,24 @@
D:\鏅轰簯杩堟�漒MES\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.genruntimeconfig.cache
D:\鏅轰簯杩堟�漒MES\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\Newtonsoft.Json.dll
D:\鏅轰簯杩堟�漒MES\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.csproj.AssemblyReference.cache
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\DingDingMsg.exe
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\DingDingMsg.deps.json
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\DingDingMsg.runtimeconfig.json
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\DingDingMsg.runtimeconfig.dev.json
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\DingDingMsg.dll
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\DingDingMsg.pdb
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\Newtonsoft.Json.dll
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\System.Data.SqlClient.dll
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\runtimes\win-arm64\native\sni.dll
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\runtimes\win-x64\native\sni.dll
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\runtimes\win-x86\native\sni.dll
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\runtimes\unix\lib\netcoreapp2.1\System.Data.SqlClient.dll
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\bin\Debug\netcoreapp3.1\runtimes\win\lib\netcoreapp2.1\System.Data.SqlClient.dll
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.AssemblyInfoInputs.cache
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.AssemblyInfo.cs
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.csproj.CoreCompileInputs.cache
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.csproj.CopyComplete
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.dll
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.pdb
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.genruntimeconfig.cache
+D:\鏅轰簯杩堟�漒DingDingMsg\DingDingMsg\DingDingMsg\obj\Debug\netcoreapp3.1\DingDingMsg.csproj.AssemblyReference.cache
diff --git a/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.pdb b/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.pdb
index 9373c26..dff242b 100644
--- a/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.pdb
+++ b/DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.pdb
Binary files differ
--
Gitblit v1.9.1