| | |
| | | //异常反馈单,异常工艺参数预警 发送钉钉消息 |
| | | 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) |
| | | { |
| | | //本地 |
| | |
| | | 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; |
| | | } |
| | | |