钉钉消息发送(安装dotnet-sdk-3.1.426-win-x64)
zrg
2024-11-26 3ae7b33dfca55b3e9a745aea8d8e8f3cea67ae87
修复  要发送的信息为空时自动跳过,不进行发送
2个文件已删除
11个文件已修改
115 ■■■■ 已修改文件
DingDingMsg/.vs/DingDingMsg/v16/.suo 补丁 | 查看 | 原始文档 | blame | 历史
DingDingMsg/DingDingMsg/Program.cs 111 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
DingDingMsg/DingDingMsg/Properties/PublishProfiles/FolderProfile1.pubxml.user 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/DingDingMsg.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.AssemblyReference.cache 补丁 | 查看 | 原始文档 | blame | 历史
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.FileListAbsolute.txt 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.AssemblyReference.cache 补丁 | 查看 | 原始文档 | blame | 历史
DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.FileListAbsolute.txt 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DingDingMsg/.vs/DingDingMsg/v16/.suo
Binary files differ
DingDingMsg/DingDingMsg/Program.cs
@@ -12,6 +12,8 @@
        //异常反馈单,异常工艺参数预警   发送钉钉消息
        static DBHelper oCN = new DBHelper();
        static DataSet dt = new DataSet();
        static DataSet dt1 = new DataSet();
        static DataSet dt2 = new DataSet();
        static async Task Main(string[] args)
        {
            //本地
@@ -114,66 +116,77 @@
                            DBHelper.CustomWriteLog("没有更新的语句", DateTime.Now.ToString("yyyy-MM-dd"));
                        }
                        //查询出要发信息的异常参数
                        //string newSql = @"select STUFF((SELECT '; ' + 设备编码 + ' - ' + 工艺参数名称 + ' - 数采值: ' + CAST(数采值 as VARCHAR(10)) + ' - 上限值: ' + CAST(上限值 as VARCHAR(10)) + ' - 下限值: ' + CAST(下限值 as VARCHAR(10))
                        //FROM h_v_Sb_EquipMentCollectionTechParam_ERRList WHERE 发现异常时间 >= DATEADD(minute, -1, GETDATE()) FOR XML PATH('')), 1, 2, '') as 内容";
                        string newSql = @"SELECT 车间, STUFF((  SELECT '; ' + 设备编码 + ' - ' + 工艺参数名称 + ' - 数采值: ' + CAST(数采值 AS VARCHAR(10)) + ' - 上限值: ' + CAST(上限值 AS VARCHAR(10)) + ' - 下限值: ' + CAST(下限值 AS VARCHAR(10))  
                        FROM h_v_Sb_EquipMentCollectionTechParam_ERRList AS InnerTable  WHERE InnerTable.车间 = OuterTable.车间  AND 发现异常时间 >= DATEADD(minute, -1, GETDATE())
                        FOR XML PATH('')  ), 1, 2, '') AS 内容  FROM h_v_Sb_EquipMentCollectionTechParam_ERRList AS OuterTable  GROUP BY 车间  ";
                        DBHelper.CustomWriteLog("查询出要发信息的异常参数"+newSql, DateTime.Now.ToString("yyyy-MM-dd"));
                        dt = oCN.RunProcReturn(newSql, "h_v_Sb_EquipMentCollectionTechParam_ERRList");
                        dt1 = oCN.RunProcReturn(newSql, "h_v_Sb_EquipMentCollectionTechParam_ERRList");
                        string HContext = ""; string HDeptName = "";
                        HContext = dt.Tables[0].Rows[0]["内容"].ToString();
                        HDeptName= dt.Tables[0].Rows[0]["车间"].ToString();
                        DBHelper.CustomWriteLog("查询出要发信息的内容" + HContext, DateTime.Now.ToString("yyyy-MM-dd"));
                        //查询出要发送的人
                        string newSql1 = @"select a.HDingDingUserID 钉钉id,a.Czymc 接收人 from Gy_Czygl a left join System_UserGroupInfo b on a.Czybm = b.UserId
                        left join System_UserGroup c on b.GroupId = c.GroupID  where c.GroupName = '"+ HDeptName + "工艺异常预警接收人'";
                        DBHelper.CustomWriteLog("查询出要发送的人:" + newSql1, DateTime.Now.ToString("yyyy-MM-dd"));
                        dt = oCN.RunProcReturn(newSql1, "Gy_Czygl");
                        DBHelper.CustomWriteLog("开始进入发信息", DateTime.Now.ToString("yyyy-MM-dd"));
                        if (dt.Tables[0].Rows.Count > 0)
                        for (int j = 0; j < dt1.Tables[0].Rows.Count; j++)
                        {
                            DBHelper.CustomWriteLog("进入发信息", DateTime.Now.ToString("yyyy-MM-dd"));
                            for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
                            {
                                string HName = dt.Tables[0].Rows[i]["钉钉id"].ToString();
                                string Stares = dt.Tables[0].Rows[i]["接收人"].ToString();
                                MSG msg = new MSG();
                                //获取企业的access_token的值
                                string response = msg.GetAccessToken(appKey, appSecret);
                                JObject responseJson = JObject.Parse(response);
                                // 获取access_token的值
                                string accessToken = responseJson["accessToken"].ToString();
                                //调用方法发送消息
                                //string agentId = "3118119317";//钉钉后台建立的小程序id
                                //斯莫尔
                                string agentId = "3151454458";//钉钉后台建立的小程序id
                                string userIdList = HName;//钉钉人员的id
                                string deptIdList = "0"; // 空字符串表示不指定部门
                                string toAllUser = "false";
                                string message = HContext;
                                // 调用方法发送消息
                                response = await msg.SendTextMessage(accessToken, agentId, userIdList, deptIdList, toAllUser, message);
                                ResponseData responseData = JsonConvert.DeserializeObject<ResponseData>(response);
                                if (responseData.errcode == 0)
                            DBHelper.CustomWriteLog("异常内容数量   "+ dt1.Tables[0].Rows.Count, DateTime.Now.ToString("yyyy-MM-dd"));
                            HContext = dt1.Tables[0].Rows[j]["内容"].ToString();
                            HDeptName = dt1.Tables[0].Rows[j]["车间"].ToString();
                            DBHelper.CustomWriteLog("异常内容值   "+ HContext, DateTime.Now.ToString("yyyy-MM-dd"));
                            DBHelper.CustomWriteLog("异常车间值   " + HDeptName, DateTime.Now.ToString("yyyy-MM-dd"));
                            if (!string.IsNullOrEmpty(HContext) && HContext.ToLower() != "null")
                            {
                                DBHelper.CustomWriteLog("查询出要发信息的内容" + HContext, DateTime.Now.ToString("yyyy-MM-dd"));
                                //查询出要发送的人
                                string newSql1 = @"select a.HDingDingUserID 钉钉id,a.Czymc 接收人 from Gy_Czygl a left join System_UserGroupInfo b on a.Czybm = b.UserId
                                left join System_UserGroup c on b.GroupId = c.GroupID  where c.GroupName = '" + HDeptName + "工艺异常预警接收人'";
                                DBHelper.CustomWriteLog("查询出要发送的人:" + newSql1, DateTime.Now.ToString("yyyy-MM-dd"));
                                dt = oCN.RunProcReturn(newSql1, "Gy_Czygl");
                                DBHelper.CustomWriteLog("开始进入发信息", DateTime.Now.ToString("yyyy-MM-dd"));
                                if (dt.Tables[0].Rows.Count > 0)
                                {
                                    DBHelper.CustomWriteLog("钉钉异常预警发送成功", DateTime.Now.ToString("yyyy-MM-dd"));
                                }
                                else
                                {
                                    Console.WriteLine(responseData.errcode);
                                    DBHelper.CustomWriteLog("钉钉返回信息:" + response, DateTime.Now.ToString("yyyy-MM-dd"));
                                }
                                    DBHelper.CustomWriteLog("进入发信息", DateTime.Now.ToString("yyyy-MM-dd"));
                                    for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
                                    {
                                        string HName = dt.Tables[0].Rows[i]["钉钉id"].ToString();
                                        string Stares = dt.Tables[0].Rows[i]["接收人"].ToString();
                                        MSG msg = new MSG();
                                        //获取企业的access_token的值
                                        string response = msg.GetAccessToken(appKey, appSecret);
                                        JObject responseJson = JObject.Parse(response);
                                        // 获取access_token的值
                                        string accessToken = responseJson["accessToken"].ToString();
                                        //调用方法发送消息
                                        //string agentId = "3118119317";//钉钉后台建立的小程序id
                                        //斯莫尔
                                        string agentId = "3151454458";//钉钉后台建立的小程序id
                                        string userIdList = HName;//钉钉人员的id
                                        string deptIdList = "0"; // 空字符串表示不指定部门
                                        string toAllUser = "false";
                                        string message = HContext;
                                        // 调用方法发送消息
                                        response = await msg.SendTextMessage(accessToken, agentId, userIdList, deptIdList, toAllUser, message);
                                        ResponseData responseData = JsonConvert.DeserializeObject<ResponseData>(response);
                                        if (responseData.errcode == 0)
                                        {
                                            DBHelper.CustomWriteLog("钉钉异常预警发送成功", DateTime.Now.ToString("yyyy-MM-dd"));
                                        }
                                        else
                                        {
                                            Console.WriteLine(responseData.errcode);
                                            DBHelper.CustomWriteLog("钉钉返回信息:" + response, DateTime.Now.ToString("yyyy-MM-dd"));
                                        }
                                    }
                                    DBHelper.CustomWriteLog("钉钉异常预警发送成功出来", DateTime.Now.ToString("yyyy-MM-dd"));
                                }
                                DBHelper.CustomWriteLog("钉钉异常预警发送成功出来1", DateTime.Now.ToString("yyyy-MM-dd"));
                            }
                            DBHelper.CustomWriteLog("钉钉异常预警发送成功出来2", DateTime.Now.ToString("yyyy-MM-dd"));
                        }
                        DBHelper.CustomWriteLog("钉钉异常预警发送成功出来3", DateTime.Now.ToString("yyyy-MM-dd"));
                    }
                    DBHelper.CustomWriteLog("钉钉异常预警发送成功出来4", DateTime.Now.ToString("yyyy-MM-dd"));
                    lastNewTaskExecution = DateTime.Now;
                }
DingDingMsg/DingDingMsg/Properties/PublishProfiles/FolderProfile1.pubxml.user
@@ -4,6 +4,6 @@
-->
<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <History>True|2024-10-20T02:01:37.4542558Z;True|2024-10-14T12:26:09.3008697+08:00;True|2024-10-11T17:14:32.1495789+08:00;True|2024-10-11T17:01:27.4785195+08:00;True|2024-10-11T16:54:48.1999562+08:00;True|2024-10-11T14:35:28.0629168+08:00;True|2024-09-23T18:16:07.9656797+08:00;</History>
    <History>True|2024-11-26T08:37:35.6037283Z;True|2024-11-26T16:19:56.1650507+08:00;True|2024-11-26T16:18:43.9351401+08:00;True|2024-11-26T15:59:33.8234090+08:00;True|2024-11-26T15:52:30.0966988+08:00;True|2024-11-26T15:45:06.3092696+08:00;True|2024-11-25T17:40:06.4971070+08:00;True|2024-11-25T15:49:10.2661307+08:00;True|2024-10-20T10:01:37.4542558+08:00;True|2024-10-14T12:26:09.3008697+08:00;True|2024-10-11T17:14:32.1495789+08:00;True|2024-10-11T17:01:27.4785195+08:00;True|2024-10-11T16:54:48.1999562+08:00;True|2024-10-11T14:35:28.0629168+08:00;True|2024-09-23T18:16:07.9656797+08:00;</History>
  </PropertyGroup>
</Project>
DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/DingDingMsg.pdb
Binary files differ
DingDingMsg/DingDingMsg/bin/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb
Binary files differ
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.AssemblyReference.cache
Binary files differ
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.csproj.FileListAbsolute.txt
@@ -39,4 +39,3 @@
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
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/DingDingMsg.pdb
Binary files differ
DingDingMsg/DingDingMsg/obj/Debug/netcoreapp3.1/win-x64/DingDingMsg.pdb
Binary files differ
DingDingMsg_EarlyWarning/bin/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb
Binary files differ
DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.AssemblyReference.cache
Binary files differ
DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.csproj.FileListAbsolute.txt
@@ -18,4 +18,3 @@
D:\智云迈思\DingDingMsg\DingDingMsg_EarlyWarning\obj\Debug\netcoreapp3.1\DingDingMsg_EarlyWarning.dll
D:\智云迈思\DingDingMsg\DingDingMsg_EarlyWarning\obj\Debug\netcoreapp3.1\DingDingMsg_EarlyWarning.pdb
D:\智云迈思\DingDingMsg\DingDingMsg_EarlyWarning\obj\Debug\netcoreapp3.1\DingDingMsg_EarlyWarning.genruntimeconfig.cache
D:\智云迈思\DingDingMsg\DingDingMsg_EarlyWarning\obj\Debug\netcoreapp3.1\DingDingMsg_EarlyWarning.csproj.AssemblyReference.cache
DingDingMsg_EarlyWarning/obj/Debug/netcoreapp3.1/DingDingMsg_EarlyWarning.pdb
Binary files differ