From bc037c4d44846befb4015d915dad0db6b3e337e3 Mon Sep 17 00:00:00 2001
From: pzy <2829717936@qq.com>
Date: 星期二, 13 八月 2024 16:10:09 +0800
Subject: [PATCH] 工艺参数分类基础功能实现
---
WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs | 114 +++++++++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 110 insertions(+), 4 deletions(-)
diff --git a/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs b/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs
index befbdcc..8a23c05 100644
--- a/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs
+++ b/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs
@@ -1,4 +1,5 @@
-锘縰sing Newtonsoft.Json;
+锘縰sing DLL;
+using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
@@ -7,6 +8,7 @@
using System.Linq;
using System.Net;
using System.Net.Http;
+using System.Threading.Tasks;
using System.Web.Http;
using WebAPI.Models;
@@ -17,6 +19,9 @@
private json objJsonResult = new json();
public DataSet ds = new DataSet();
public WebServer webserver = new WebServer();
+
+ //鑾峰彇绯荤粺鍙傛暟
+ Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
public DBUtility.ClsPub.Enum_BillStatus BillStatus;//鍗曟嵁鐘舵�侊紙鏂板锛屼慨鏀癸紝娴忚锛屾洿鏂板崟浠凤紝鍙樻洿锛�
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
@@ -473,6 +478,8 @@
{
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
+ //閮ㄩ棬,鍙戠幇浜�,璐熻矗浜�,璁惧
+ _ = SendDingDingAsync(oBill.omodel.HDeptID, oBill.omodel.HEmpID, oBill.omodel.HManagerID, oBill.omodel.HEquipID,2);
}
else
{
@@ -813,6 +820,8 @@
{
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
+ //閮ㄩ棬,鍙戠幇浜�,璐熻矗浜�,璁惧
+ _ = SendDingDingAsync(oBill.omodel.HDeptID, oBill.omodel.HEmpID, oBill.omodel.HManagerID, oBill.omodel.HEquipID, 3);
}
else
{
@@ -1100,9 +1109,10 @@
//淇濆瓨瀹屾瘯鍚庡鐞�
bool bResult;
if (oBill.omodel.HInterID == 0)
- {
- // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
- bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
+ {
+ bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
+ //閮ㄩ棬,鍙戠幇浜�,璐熻矗浜�,璁惧
+ _ = SendDingDingAsync(oBill.omodel.HDeptID, oBill.omodel.HEmpID, oBill.omodel.HManagerID, oBill.omodel.HEquipID,1);
}
else
{
@@ -2935,5 +2945,101 @@
}
}
#endregion
+
+
+ #region 璁惧鏁呴殰 鐧昏/璁板綍/楠屾敹 鍙戦�佹秷鎭�
+ /// <summary>
+ /// 寮傚父鍙嶉 鎺ユ敹,澶勭悊,楠屾敹鍗曚繚瀛樺彂閫佹秷鎭�
+ /// </summary>
+ /// <param name="HSendMan"></param>
+ /// <param name="HHandleEmpID"></param>
+ /// <param name="HDescription"></param>
+ /// <param name="HCopyMan"></param>
+ /// <returns></returns>
+ public async Task<object> SendDingDingAsync(long HDeptID, long HEmpID, long HManagerID, long HEquipID,int num)
+ {
+
+ string concatenatedNames = "";
+ string HDescription = "";
+ string appKey = "";
+ string appSecret = "";
+ string sReturn = "";
+ string agentIds = "";
+ Cls_DDMsg msg = new Cls_DDMsg();
+ if (oSystemParameter.ShowBill(ref sReturn) == true)
+ {
+ //绯荤粺鍙傛暟鏄惁 N涓烘湰鍦帮紝Y涓烘柉鑾皵
+ if (oSystemParameter.omodel.OA_ErrMsgBackBill_SendDingDingMsg == "N")
+ {
+ appKey = "dingrsrzhdyn3mlaof95";
+ appSecret = "RAqH6YtZnPLCpDbuqfaYQkKkVtVdS0wqfC8I26X6qiS-8eoCJCNrzx3fubGND4Sq";
+ agentIds = "3118119317";
+ }
+ else if (oSystemParameter.omodel.OA_ErrMsgBackBill_SendDingDingMsg == "Y")
+ {
+ appKey = "dingkdddbhdcssk7jduw";
+ appSecret = "iv07c-GLfJPnzfJaNAAOfJDl3Z-eODvDAhlInMZCZhGorkle5Evbaxx3ImylvdjQ";
+ agentIds = "3151454458";
+ }
+
+ }
+
+ //閮ㄩ棬
+ string sql = "select HName from Gy_Department where HItemID='" + HDeptID + "'";
+ ds = oCN.RunProcReturn(sql, "Gy_Department");
+ string HDeptName = ds.Tables[0].Rows[0]["HName"].ToString();
+
+ //鍙戠幇浜�
+ string sql1 = "select HName from Gy_Employee where HItemID='" + HEmpID + "'";
+ ds = oCN.RunProcReturn(sql1, "Gy_Employee");
+ string HEmpName = ds.Tables[0].Rows[0]["HName"].ToString();
+
+ //璐熻矗浜�
+ string sql2 = "select HName from Gy_Employee where HItemID='" + HManagerID + "'";
+ ds = oCN.RunProcReturn(sql2, "Gy_Employee");
+ string HManagerName = ds.Tables[0].Rows[0]["HName"].ToString();
+
+ //璁惧
+ string sql3 = "select HName from Gy_EquipFileBillMain where HInterID='" + HEquipID + "'";
+ ds = oCN.RunProcReturn(sql3, "Gy_EquipFileBillMain");
+ string HEquipName = ds.Tables[0].Rows[0]["HName"].ToString();
+
+ //鍙戦�佸唴瀹�
+ if (num==1)
+ {
+ HDescription = "鍙戠幇浜�:'" + HEmpName + "',鍦�'" + HDeptName + "',鍙戠幇'" + HEquipName + "',鎹熷潖,璇峰尯鍩熻礋璐ｄ汉:'" + HManagerName + "',灏藉揩鍒扮幇鍦虹淮淇�!!";
+ }
+ else if (num==2)
+ {
+ HDescription = "缁翠慨浜�:'" + HEmpName + "',鍦�'" + HDeptName + "',宸茬淮淇�'" + HEquipName + "',璇峰彂鐜颁汉:'" + HManagerName + "',灏藉揩鍒扮幇鍦虹‘璁ゆ槸鍚︾淮淇畬鎴�!!";
+ }
+ else if (num==3)
+ {
+ HDescription = "楠屾敹浜�:'" + HEmpName + "',鍦�'" + HDeptName + "',宸查獙鏀�'" + HEquipName + "',宸查�氱煡:'" + HManagerName + "',缁翠慨璁惧绗﹀悎楠屾敹!!";
+ }
+
+
+ //鎺ユ敹浜洪拤閽塱d
+ string sql4 = "select HDingDingUserID 閽夐拤id from Gy_Czygl where Czymc in ('" + HManagerName + "')";
+ ds = oCN.RunProcReturn(sql4, "Gy_Czygl");
+ concatenatedNames = ds.Tables[0].Rows[0]["閽夐拤id"].ToString();
+
+ //鑾峰彇浼佷笟鐨刟ccess_token鐨勫��
+ string response = msg.GetAccessToken(appKey, appSecret);
+ JObject responseJson = JObject.Parse(response);
+ // 鑾峰彇access_token鐨勫��
+ string accessToken = responseJson["accessToken"].ToString();
+
+ //璋冪敤鏂规硶鍙戦�佹秷鎭�
+ string agentId = agentIds;//閽夐拤鍚庡彴寤虹珛鐨勫皬绋嬪簭id
+ string userIdList = concatenatedNames;//閽夐拤浜哄憳鐨刬d
+ string deptIdList = "0"; // 绌哄瓧绗︿覆琛ㄧず涓嶆寚瀹氶儴闂�
+ string toAllUser = "false";
+ string message = HDescription;
+ response = await msg.SendTextMessage(accessToken, agentId, userIdList, deptIdList, toAllUser, message);
+ Console.WriteLine(response);
+ return response;
+ }
+ #endregion
}
}
--
Gitblit v1.9.1