private string ddUrl = ""; //钉钉前端地址 public void ProcessRequest(HttpContext context) { //判断客户端请求是否为post方法 if (context.Request.HttpMethod.ToUpper() != "POST") { context.Response.Write("{\"errmsg\":\"请求方式不允许,请使用POST方式(DD0001)\",\"errcode\":1}"); return; } string ymadk = System.Configuration.ConfigurationManager.AppSettings["ymadk"].ToString() + "/"; //数据库链接 string connectionString = ToolsClass.GetConfig("DataOnLine"); //sqlServer da = new DbHelper.SqlHelper("SqlServer", connectionString); SqlHelper = new BankDbHelper.SqlHelper("SqlServer", connectionString); string signUrl = ToolsClass.GetConfig("signUrl"); context.Response.ContentType = "text/plain"; //获取请求json using (var reader = new StreamReader(context.Request.InputStream, Encoding.UTF8)) { CsJson = reader.ReadToEnd(); } if (CsJson == "") { context.Response.Write("{\"errmsg\":\"报文格式错误(DD0003)\",\"errcode\":1}"); return; } CsJson = Regex.Replace(CsJson, @"[\n\r]", "").Replace(@"\n", ",").Replace("'", "‘").Replace("\t", ":").Replace("\r", ",").Replace("\n", ","); //#微应用ID:agentId #企业ID:corpId #应用的唯一标识:appKey #应用的密钥:appSecret string AppWyy = ToolsClass.GetConfig("AppWyy"); string[] ScList = AppWyy.Split('$'); string agentId = ScList[0].ToString(); string corpId = ScList[1].ToString(); string appKey = ScList[2].ToString(); string appSecret = ScList[3].ToString(); isWrite = ToolsClass.GetConfig("isWrite"); ddUrl = ToolsClass.GetConfig("ddUrl"); if (isWrite == "1") { ToolsClass.TxtLog("差旅费申请审批日志", "\r\n申请审批入参:" + CsJson + "\r\n"); } string IsLocalHost = "0"; //前端传入数据 TravelApprovalMul traApprClass = new TravelApprovalMul(); traApprClass = (TravelApprovalMul)JsonConvert.DeserializeObject(CsJson, typeof(TravelApprovalMul)); string result = string.Empty; IsLocalHost = traApprClass.IsLocalHost == null ? "0" : traApprClass.IsLocalHost; string path = context.Request.Path.Replace("Approval/CLFBXSP.ashx", "clfbxspmul"); //验证请求sign string sign = ToolsClass.md5(signUrl + path + "Romens1/DingDing2" + path, 32); ToolsClass.TxtLog("生成的sign", "生成的" + sign + "传入的sign" + traApprClass.Sign + "\r\n 后台字符串:" + signUrl + path + "Romens1/DingDing2" + path); if (sign != traApprClass.Sign) { context.Response.Write("{\"errmsg\":\"认证信息Sign不存在或者不正确!\",\"errcode\":1}"); return; } GetMulParams getMulParams = new GetMulParams(); #region 获取access_token url = "https://oapi.dingtalk.com/gettoken?appkey=" + appKey + "&appsecret=" + appSecret; FhJson = ToolsClass.ApiFun("GET", url, ""); TokenClass tokenClass = new TokenClass(); tokenClass = (TokenClass)JsonConvert.DeserializeObject(FhJson, typeof(TokenClass)); string access_token = tokenClass.access_token; int errcode = tokenClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取ACCESS_TOKEN报错(DD0004)\",\"errcode\":1}"); return; } #endregion 获取access_token #region 获取用户详情 url = "https://oapi.dingtalk.com/user/get?access_token=" + access_token + "&userid=" + traApprClass.DDAuditingId; FhJson = ToolsClass.ApiFun("GET", url, ""); GetUserXq userXqClass = new GetUserXq(); userXqClass = (GetUserXq)JsonConvert.DeserializeObject(FhJson, typeof(GetUserXq)); errcode = userXqClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取审批人详细信息报错(DD6003)\",\"errcode\":1}"); return; } string audiName = userXqClass.name; #endregion 获取用户详情 #region 获取用户guid Sql = $"select top 1 a.GUID,b.TotalAmount,b.OffDay from operators a left join (select sum(TotalAmount) TotalAmount, sum(OffDay) OffDay from ExpetravDetail where billno = '[申请号]' group by billno) b on 1 = 1 where a.code = '[工号]'"; Sql = Sql.Replace("[申请号]", traApprClass.BillNo).Replace("[工号]", userXqClass.jobnumber); obj = da.GetDataTable(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"用户不存在(DD6000)\",\"errcode\":1}"); return; } dt = obj as DataTable; string AuditingGuid = dt.Rows[0]["GUID"].ToString(); #endregion 获取用户guid //判断当前是流程节点中的哪个流程 Sql = $"select count( DISTINCT NodeNumber) NodeNumber from ApprovalComments where BillNo ='{traApprClass.BillNo}' and BillClassId='{traApprClass.BillClassId}'"; //得到当前流程节点的数量 string nodeNumber = da.GetValue(Sql).ToString(); //得到当前流程信息 NodeInfo[] NodeInfo = (NodeInfo[])JsonConvert.DeserializeObject(da.GetValue($"select ProcessNodeInfo from ExpeTrav where BillNo='{traApprClass.BillNo}'").ToString(), typeof(NodeInfo[])); XXTZ xxtzClass2 = new XXTZ(); StringBuilder piddept = new StringBuilder(); string sql = ""; DataTable logComments = new DataTable(); StringBuilder logcoments = new StringBuilder(); if (traApprClass.IsSp == "1") { audiIdea = "同意"; } else if (traApprClass.IsSp == "2") { audiIdea = "驳回"; } else { audiIdea = "抄送"; } //获取当前单号的发起人和待报销人 string fqrall = traApprClass.DDOperatorId; var fqr = da.GetDataTable($"select DDOperatorId,InsteadOperatorGuid,IsSp from ExpeTrav where BillNo = '{traApprClass.BillNo}'"); if (fqr.Rows.Count == 0) { context.Response.Write("{\"errmsg\":\"当前单据已撤回\",\"errcode\":1}"); return; } else if (fqr.Rows[0]["IsSp"].ToString() == "3") { context.Response.Write("{\"errmsg\":\"当前单据已撤回\",\"errcode\":1}"); return; } if (fqr.Rows[0]["InsteadOperatorGuid"].ToString() != fqrall) { fqrall = fqrall + "," + fqr.Rows[0]["InsteadOperatorGuid"].ToString(); } //判断当前人是否已经审批过 Sql = $"select * from ApprovalComments where ApprovalStatus='0' and BillNo ='{traApprClass.BillNo}' and ApprovalID='{userXqClass.jobnumber}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and BillClassId='{traApprClass.BillClassId}'"; ToolsClass.TxtLog("差旅费申请审批日志", "\r\n查询当前人的审批节点" + Sql + "\r\n"); if (da.GetDataTable(Sql).Rows.Count == 0) { ToolsClass.TxtLog("差旅费申请审批日志", "\r\n返回前端信息:" + JsonConvert.SerializeObject(new PublicResult { errcode = "1", errmsg = "当前单据您已经审批过,请勿点击太快或者重复提交!" })); context.Response.Write(JsonConvert.SerializeObject(new PublicResult { errcode = "1", errmsg = "当前单据您已经审批过,请勿点击太快或者重复提交!" })); return; } //如果审批人意见为同意 if (audiIdea == "同意" || audiIdea == "抄送") { try { bool processIsEnd = false; processIsEnd = CommonHelper.SaveComments(traApprClass, userXqClass, nodeNumber, context, ddUrl, "差旅费申请审批日志", out result); //可以给下个人发送消息 if (processIsEnd) //如果当前流程节点走完 { //判断当前单号是否已经结束 sql = ""; sql = $"select ISSP from ExpeTrav where BillNo ='{traApprClass.BillNo}'"; if (da.GetValue(sql).ToString() != "0") { if (IsLocalHost == "0") { result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog("差旅费申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); } else { result = JsonConvert.SerializeObject(new ResultGetMulParams { errcode = "0", errmsg = "", NextUrl = "" }); ToolsClass.TxtLog("差旅费申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); } return; } //判断是否是根结点,判断数量(去重)是否小于流程的长度 //是否是最后一个流程 if (int.Parse(nodeNumber) < NodeInfo.Length) { NodeInfoDetailPerson[] NodeInfodetailPeople = NodeInfo[int.Parse(nodeNumber)].NodeInfoDetails[0].Persons; //插入相应的信息到comments表中 sqlList.Clear(); for (int i = 0; i < NodeInfodetailPeople.Length; i++) { sqlTou.Clear(); sqlTou.Append("insert into ApprovalComments(CommentsId,BillClassId,BillNo,ApprovalID,ApprovalName,ApprovalComments,ApprovalStatus,AType,ApprovalDate,IsAndOr,IsLeader,PersonType,NodeNumber) values('") .Append(Guid.NewGuid().ToString()).Append("','") .Append(traApprClass.BillClassId).Append("','") .Append(traApprClass.BillNo).Append("','") .Append(NodeInfodetailPeople[i].PersonId).Append("','") .Append(NodeInfodetailPeople[i].PersonName).Append("','")//内部数据库用户GUID .Append("").Append("','") .Append("0").Append("','") .Append(NodeInfodetailPeople[i].AType).Append("','") .Append(DateTime.Now).Append("','") .Append(NodeInfo[int.Parse(nodeNumber)].NodeInfoDetails[0].IsAndOr).Append("','") .Append(NodeInfo[int.Parse(nodeNumber)].NodeInfoDetails[0].IsLeader).Append("','") .Append(NodeInfo[int.Parse(nodeNumber)].NodeInfoType).Append("','") .Append(int.Parse(nodeNumber) + 2).Append("')"); sqlList.Add(sqlTou.ToString()); if (isWrite == "1") { ToolsClass.TxtLog("差旅费申请审批日志", "\r\n操作ApprovalComments表:" + sqlTou.ToString() + "\r\n"); } } //执行SQL语句Insert obj = da.ExecSql(sqlList); if (obj == null) { context.Response.Write("{\"errmsg\":\"保存多级流程差旅费报销审批节点信息出错(DD6002)\",\"errcode\":1}"); return; } //获取下个节点的人员信息 for (int i = 0; i < NodeInfodetailPeople.Length; i++) { if (i > 0) { piddept.Append(","); } //判断传空 if (NodeInfodetailPeople[i].PersonId != "") { sql = ""; sql = $"select distinct DDId from FlowEmployee where EmployeeCode ='{NodeInfodetailPeople[i].PersonId}'"; piddept.Append(da.GetValue(sql).ToString()); } } //给申请人发送审批意见 给下个节点的人员发送目前为止的审批状态及意见,给之前的人也发 //获取现在的审批意见 sql = ""; sql = $"select ApprovalComments,ApprovalName,ApprovalID from ApprovalComments where BillNo ='{traApprClass.BillNo}' and BillClassId='{traApprClass.BillClassId}'"; logComments = da.GetDataTable(sql); //"【出差】\r\n审批意见: " + traApprClass.AuditingIdea + "\"}}}"; for (int i = 0; i < logComments.Rows.Count; i++) { if (i > 0) { logcoments.Append(","); } //piddept.Append(","); sql = ""; sql = $"select distinct DDId from FlowEmployee where EmployeeCode ='{logComments.Rows[i]["ApprovalID"].ToString()}'"; //piddept.Append(da.GetValue(sql).ToString()); logcoments.Append(logComments.Rows[i]["ApprovalName"].ToString() + ":" + logComments.Rows[i]["ApprovalComments"].ToString()); } //&AType={NodeInfodetailPeople[0].AType} urlcsjson = ddUrl + $"/clfui/shenpi/index.html?billno={traApprClass.BillNo}&BillClassId={traApprClass.BillClassId}&showmenu=false"; urlcsjson = HttpUtility.UrlEncode(urlcsjson, System.Text.Encoding.UTF8); CsJson = "{\"agent_id\":\"" + agentId + "\",\"userid_list\":\"" + piddept.ToString() + "," + fqrall + "\",\"msg\":{\"msgtype\":\"link\",\"link\":{\"messageUrl\":\"" + "dingtalk://dingtalkclient/page/link?url=" + urlcsjson + "&pc_slide=true\",\"picUrl\":\"@\",\"title\":\"已" + audiIdea + "【" + audiName + "】\",\"text\":\"金额: " + dt.Rows[0]["TotalAmount"].ToString() + "¥ 调休: " + dt.Rows[0]["OffDay"].ToString() + "天\r\n申请人: " + traApprClass.OperatorName + "【差旅费】\r\n审批意见: " + traApprClass.AuditingIdea + "\"}}}"; url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; FhJson = ToolsClass.ApiFun("POST", url, CsJson); if (isWrite == "1") { ToolsClass.TxtLog("差旅费申请审批日志", "\r\n发送通知调用钉钉api入参:" + CsJson + "\r\n出参:" + FhJson); } xxtzClass2 = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); errcode = xxtzClass2.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"您的差旅费报销审批消息通知失败(DD6004)\",\"errcode\":1}"); return; } sql = $"update ExpeTrav set HangState = '0',HangDDIDs = '' where billno = '{traApprClass.BillNo}'"; da.ExecSql(sql); TaskFactory taskFactory = new TaskFactory(); //如果下个是抄送人 if (NodeInfo[int.Parse(nodeNumber)].NodeInfoType == "3") { //根据数据开启多个线程调用审批接口 taskFactory.StartNew(() => { for (int i = 0; i < NodeInfodetailPeople.Length; i++) { HttpWebRequest webrequest = (HttpWebRequest)WebRequest.Create(ymadk + "clfbxspmul"); webrequest.Method = "post"; new Action(() => { fasongqingqiu ad = new fasongqingqiu { BillNo = traApprClass.BillNo, DDAuditingId = da.GetValue($"select distinct ddid from FlowEmployee where employeecode='{NodeInfodetailPeople[i].PersonId}'").ToString(), IsSp = "3", DDOperatorId = traApprClass.DDOperatorId, OperatorName = traApprClass.OperatorName, BillClassId = traApprClass.BillClassId, Sign = sign }; byte[] postdatabyte = Encoding.UTF8.GetBytes(JsonConvert.SerializeObject(ad)); webrequest.ContentLength = postdatabyte.Length; Stream stream; stream = webrequest.GetRequestStream(); stream.Write(postdatabyte, 0, postdatabyte.Length); stream.Close(); using (var httpWebResponse = webrequest.GetResponse()) using (StreamReader responseStream = new StreamReader(httpWebResponse.GetResponseStream())) { String ret = responseStream.ReadToEnd(); } }).Invoke(); } }); } if (NodeInfo[int.Parse(nodeNumber)].NodeInfoType == "2") { DataRow[] dataRows = null; sql = ""; sql = $"select ApprovalComments,ApprovalName,ApprovalID from ApprovalComments where BillNo ='{traApprClass.BillNo}' and BillClassId='{traApprClass.BillClassId}' and ApprovalStatus ='1'"; logComments = da.GetDataTable(sql); //如果下个环节中的人在之前已同意,自动调用此接口同意完成审批 taskFactory.StartNew(() => { for (int i = 0; i < NodeInfodetailPeople.Length; i++) { dataRows = logComments.Select("ApprovalID ='" + NodeInfodetailPeople[i].PersonId + "'"); //如果之前已经同意或者是发起人 if (dataRows.Length != 0 || da.GetValue($"select distinct DDId from FlowEmployee where EmployeeCode ='{NodeInfodetailPeople[i].PersonId}'").ToString() == traApprClass.DDOperatorId) { HttpWebRequest webrequest = (HttpWebRequest)WebRequest.Create(ymadk + "clfbxspmul"); webrequest.Method = "post"; new Action(() => { fasongqingqiu ad = new fasongqingqiu { BillNo = traApprClass.BillNo, DDAuditingId = da.GetValue($"select distinct ddid from FlowEmployee where employeecode='{NodeInfodetailPeople[i].PersonId}'").ToString(), IsSp = "1", DDOperatorId = traApprClass.DDOperatorId, OperatorName = traApprClass.OperatorName, BillClassId = traApprClass.BillClassId, AuditingIdea = "同意", Sign = sign }; byte[] postdatabyte = Encoding.UTF8.GetBytes(JsonConvert.SerializeObject(ad)); webrequest.ContentLength = postdatabyte.Length; Stream stream; stream = webrequest.GetRequestStream(); stream.Write(postdatabyte, 0, postdatabyte.Length); stream.Close(); using (var httpWebResponse = webrequest.GetResponse()) using (StreamReader responseStream = new StreamReader(httpWebResponse.GetResponseStream())) { String ret = responseStream.ReadToEnd(); } }).Invoke(); } } }); } } //如果是最后一级 //给申请人发送审批意见 给之前的人发 //获取现在的审批意见 else { //更新单据消息id与返回内容 Sql = "update EXPETRAV set IsSp='1' where billno='" + traApprClass.BillNo + "'"; if (isWrite == "1") { ToolsClass.TxtLog("差旅费申请审批日志", "\r\n更新EXPETRAV表:" + Sql.ToString() + "\r\n"); } obj = da.ExecSql(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"更新审批信息出错(DD6006)\",\"errcode\":1}"); return; } #region 调用审核存储过程 billno = traApprClass.BillNo; keyValuePairs = CommonHelper.sqlPro(billno, billTypeNo, AuditingGuid, ProName); if (keyValuePairs["ReturnValue"].ToString() != "0") { ToolsClass.TxtLog("差旅费申请审批日志", "\r\n调用存储过程失败:" + keyValuePairs["ReturnMsg"].ToString() + "\r\n"); Sql = "update EXPETRAV set IsSp='0' where billno='" + traApprClass.BillNo + "'"; obj = da.ExecSql(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"更新审批状态出错(DD6006)\",\"errcode\":1}"); return; } Sql = $"update ApprovalComments set ApprovalComments='',Urls='',ApprovalStatus='0',ApprovalDate='{DateTime.Now}',DDMessageId='' where BillNo ='{traApprClass.BillNo}' and ApprovalID='{userXqClass.jobnumber}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and BillClassId='{traApprClass.BillClassId}'"; ToolsClass.TxtLog("差旅费申请审批日志", "\r\n存储过程报错后执行语句:" + sql + "\r\n" + Sql); SqlHelper.ExecSql(Sql); context.Response.Write("{\"errmsg\":\"" + keyValuePairs["ReturnMsg"].ToString() + "(DD9003)\",\"errcode\":1}"); return; } #endregion 调用审核存储过程 sql = $"select ApprovalComments,ApprovalName,ApprovalID from ApprovalComments where BillNo ='{traApprClass.BillNo}' and BillClassId='{traApprClass.BillClassId}'"; logComments = da.GetDataTable(sql); //"【出差】\r\n审批意见: " + traApprClass.AuditingIdea + "\"}}}"; for (int i = 0; i < logComments.Rows.Count; i++) { if (i > 0) { logcoments.Append(","); //piddept.Append(","); } sql = ""; sql = $"select distinct DDId from FlowEmployee where EmployeeCode ='{logComments.Rows[i]["ApprovalID"].ToString()}'"; //piddept.Append(da.GetValue(sql).ToString()); logcoments.Append(logComments.Rows[i]["ApprovalName"].ToString() + ":" + logComments.Rows[i]["ApprovalComments"].ToString()); } urlcsjson = ddUrl + $"/clfui/shenpi/index.html?billno={traApprClass.BillNo}&BillClassId={traApprClass.BillClassId}&showmenu=false"; urlcsjson = HttpUtility.UrlEncode(urlcsjson, System.Text.Encoding.UTF8); CsJson = "{\"agent_id\":\"" + agentId + "\",\"userid_list\":\"" + fqrall + "\",\"msg\":{\"msgtype\":\"link\",\"link\":{\"messageUrl\":\"" + "dingtalk://dingtalkclient/page/link?url=" + urlcsjson + "&pc_slide=true\",\"picUrl\":\"@\",\"title\":\"已" + audiIdea + "【" + audiName + "】\",\"text\":\"金额: " + dt.Rows[0]["TotalAmount"].ToString() + "¥ 调休: " + dt.Rows[0]["OffDay"].ToString() + "天\r\n申请人: " + traApprClass.OperatorName + "【差旅费】\r\n审批意见: " + logcoments.ToString() + "\"}}}"; url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; FhJson = ToolsClass.ApiFun("POST", url, CsJson); if (isWrite == "1") { ToolsClass.TxtLog("差旅费申请审批日志", "\r\n发送通知调用钉钉api入参:" + CsJson + "\r\n出参:" + FhJson); } xxtzClass2 = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); errcode = xxtzClass2.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"您的差旅费报申请消息通知失败(DD6004)\",\"errcode\":1}"); return; } } } else { ToolsClass.TxtLog("差旅费申请审批日志", "\r\n不给下个人发消息???:" + result + "\r\n"); context.Response.Write(result); return; } //var resultgetmul = ; if (IsLocalHost == "0") { result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog("差旅费申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); } else { result = JsonConvert.SerializeObject(new ResultGetMulParams { errcode = "0", errmsg = "", NextUrl = "" }); ToolsClass.TxtLog("差旅费申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); } return; } catch (Exception ex) { Sql = $"update ApprovalComments set ApprovalComments='',Urls='',ApprovalStatus='0',ApprovalDate='{DateTime.Now}',DDMessageId='' where BillNo ='{traApprClass.BillNo}' and ApprovalID='{userXqClass.jobnumber}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and BillClassId='{traApprClass.BillClassId}'"; SqlHelper.ExecSql(Sql); ToolsClass.TxtLog("差旅费申请审批日志", "\r\n操作ApprovalComments表:" + Sql + "\r\n"); context.Response.Write(JsonConvert.SerializeObject(new CommonModel { errcode = "-1", errmsg = $"单据审批失败,失败原因{ex.Message + ex.StackTrace}" })); context.Response.End(); } } //如果是已驳回,给操作人发送通知,将意见及日期保存到ApprovalComments表,并改变状态,,改变出差申请表中的状态,改为2,代表已驳回 if (audiIdea == "驳回") { //将意见及日期保存到ApprovalComments表,并改变状态 Sql = ""; Sql = $"update ApprovalComments set ApprovalComments='{traApprClass.AuditingIdea}',Urls='{JsonConvert.SerializeObject(traApprClass.Urls)}',ApprovalStatus='{traApprClass.IsSp}',ApprovalDate='{DateTime.Now}' where BillNo ='{traApprClass.BillNo}' and ApprovalID='{userXqClass.jobnumber}' and BillClassId='{traApprClass.BillClassId}' and NodeNumber ='{int.Parse(nodeNumber) + 1}'"; da.ExecSql(Sql); if (isWrite == "1") { ToolsClass.TxtLog("差旅费申请审批日志", "\r\n操作ApprovalComments表:" + Sql + "\r\n"); } //更新单据消息id与返回内容 Sql = "update EXPETRAV set IsSp='" + traApprClass.IsSp + "',isAuditing = '1' where billno='" + traApprClass.BillNo + "'"; if (isWrite == "1") { ToolsClass.TxtLog("差旅费申请审批日志", "\r\n操作EXPETRAV表" + Sql.ToString() + "\r\n"); } obj = da.ExecSql(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"更新审批信息出错(DD6006)\",\"errcode\":1}"); return; } //给当前节点以前的人及申请人发送通知,通知已驳回,并改变出差申请表中的状态 sql = ""; sql = $"select ApprovalComments,ApprovalName,ApprovalID from ApprovalComments where BillNo ='{traApprClass.BillNo}' and BillClassId='{traApprClass.BillClassId}'"; logComments = da.GetDataTable(sql); //"【出差】\r\n审批意见: " + traApprClass.AuditingIdea + "\"}}}"; for (int i = 0; i < logComments.Rows.Count; i++) { if (i > 0) { logcoments.Append(","); //piddept.Append(","); } sql = ""; sql = $"select distinct DDId from FlowEmployee where EmployeeCode ='{logComments.Rows[i]["ApprovalID"].ToString()}'"; //piddept.Append(da.GetValue(sql).ToString()); logcoments.Append(logComments.Rows[i]["ApprovalName"].ToString() + ":" + logComments.Rows[i]["ApprovalComments"].ToString()); } urlcsjson = ddUrl + $"/clfui/shenpi/index.html?billno={traApprClass.BillNo}&BillClassId={traApprClass.BillClassId}&showmenu=false"; urlcsjson = HttpUtility.UrlEncode(urlcsjson, System.Text.Encoding.UTF8); CsJson = "{\"agent_id\":\"" + agentId + "\",\"userid_list\":\"" + fqrall + "\",\"msg\":{\"msgtype\":\"link\",\"link\":{\"messageUrl\":\"" + "dingtalk://dingtalkclient/page/link?url=" + urlcsjson + "&pc_slide=true\",\"picUrl\":\"@\",\"title\":\"已" + audiIdea + "【" + audiName + "】\",\"text\":\"金额: " + dt.Rows[0]["TotalAmount"].ToString() + "¥ 调休: " + dt.Rows[0]["OffDay"].ToString() + "天\r\n申请人: " + traApprClass.OperatorName + "【差旅费】\r\n审批意见: " + traApprClass.AuditingIdea + "\"}}}"; url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; FhJson = ToolsClass.ApiFun("POST", url, CsJson); if (isWrite == "1") { ToolsClass.TxtLog("差旅费申请审批日志", "\r\n发送通知调用钉钉api入参:" + CsJson + "\r\n出参:" + FhJson); } xxtzClass2 = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); errcode = xxtzClass2.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"您的差旅费报销消息通知失败(DD6004)\",\"errcode\":1}"); return; } sql = $"update EXPETRAV set HangState = '0',HangDDIDs = '' where billno = '{traApprClass.BillNo}'"; da.ExecSql(sql); if (IsLocalHost == "0") { result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog("差旅费申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); } else { result = JsonConvert.SerializeObject(new ResultGetMulParams { errcode = "0", errmsg = "", NextUrl = "" }); ToolsClass.TxtLog("差旅费申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); } return; } }
string ddUrl = ""; //钉钉前端地址 public void ProcessRequest(HttpContext context) { //判断客户端请求是否为post方法 if (context.Request.HttpMethod.ToUpper() != "POST") { context.Response.Write("{\"errmsg\":\"请求方式不允许,请使用POST方式(DD0001)\",\"errcode\":1}"); return; } //数据库链接 connectionString = ToolsClass.GetConfig("DataOnLine"); //sqlServer da = new DbHelper.SqlHelper("SqlServer", connectionString); //获取请求json using (var reader = new StreamReader(context.Request.InputStream, Encoding.UTF8)) { CsJson = reader.ReadToEnd(); } if (CsJson == "") { context.Response.Write("{\"errmsg\":\"报文格式错误(DD0003)\",\"errcode\":1}"); return; } CsJson = Regex.Replace(CsJson, @"[\n\r]", "").Replace(@"\n", ""); //#微应用ID:agentId #企业ID:corpId #应用的唯一标识:appKey #应用的密钥:appSecret AppWyy = ToolsClass.GetConfig("AppWyy"); ScList = AppWyy.Split('$'); agentId = ScList[0].ToString(); corpId = ScList[1].ToString(); appKey = ScList[2].ToString(); appSecret = ScList[3].ToString(); isWrite = ToolsClass.GetConfig("isWrite"); ddUrl = ToolsClass.GetConfig("ddUrl"); if (isWrite == "1") { ToolsClass.TxtLog("DDLog", "\r\nTravelReq=>入参:" + CsJson + "\r\n"); } CCSQ ccsqClass = new CCSQ(); ccsqClass = (CCSQ)JsonConvert.DeserializeObject(CsJson, typeof(CCSQ)); //ccsqClass.Notes = Regex.Replace(ccsqClass.Notes, @"[\n\r]", "").Replace("\\", ""); //ccsqClass.TravelReason = Regex.Replace(ccsqClass.TravelReason, @"[\n\r]", "").Replace("//", ""); if (ccsqClass.Detail.Length <= 0) { context.Response.Write("{\"errmsg\":\"行程不允许为空,请添加行程(DD6001)\",\"errcode\":1}"); return; } try { #region 获取access_token url = "https://oapi.dingtalk.com/gettoken?appkey=" + appKey + "&appsecret=" + appSecret; FhJson = ToolsClass.ApiFun("GET", url, ""); TokenClass tokenClass = new TokenClass(); tokenClass = (TokenClass)JsonConvert.DeserializeObject(FhJson, typeof(TokenClass)); access_token = tokenClass.access_token; errcode = tokenClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取ACCESS_TOKEN报错(DD0004)\",\"errcode\":1}"); return; } #endregion #region 获取用户详情 url = "https://oapi.dingtalk.com/user/get?access_token=" + access_token + "&userid=" + ccsqClass.DDOperatorId; FhJson = ToolsClass.ApiFun("GET", url, ""); GetUserXq userXqClass = new GetUserXq(); userXqClass = (GetUserXq)JsonConvert.DeserializeObject(FhJson, typeof(GetUserXq)); errcode = userXqClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取申请人详细信息报错(DD6003)\",\"errcode\":1}"); return; } operatorName = userXqClass.name; #endregion #region 获取用户guid Sql = "select top 1 guid from Employee where employeecode='" + userXqClass.jobnumber + "'"; obj = da.GetValue(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"用户不存在(DD6000)\",\"errcode\":1}"); return; } operatorGuid = obj.ToString(); #endregion #region 获取申请流水号 Sql = "select dbo.GetBillNo('DDTrvelReq','" + userXqClass.jobnumber + "',getdate())"; obj = da.GetValue(Sql); billno = obj.ToString(); if (billno == "1") { billno = "CL" + userXqClass.jobnumber + DateTime.Now.ToString("yyyyMMdd") + "0001"; Sql = "update BillNumber set MaxNum=1,BillDate=convert(varchar(20),GETDATE(),120) where BillGuid='DDTrvelReq' and BillDate<>convert(varchar(20),GETDATE(),120)"; } else { Sql = "update BillNumber set MaxNum=MaxNum+1,BillDate=convert(varchar(20),GETDATE(),120) where BillGuid='DDTrvelReq'"; } obj = da.ExecSql(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"更新审批信息出错(DD6006)\",\"errcode\":1}"); return; } #endregion #region 保存行程信息 sqlList.Clear(); sqlTou.Clear(); sqlTou.Append("insert into TravelReq(BillNo,TravelReason,Notes,DDOperatorId,OperatorGuid,BillDate,SelAuditingGuid,CopyPerson,OperatorName,SelAuditingName,CopyPersonName,AppendixUrl,PictureUrl) Values('").Append(billno).Append("','") .Append(ccsqClass.TravelReason).Append("','") .Append(ccsqClass.Notes).Append("','") .Append(ccsqClass.DDOperatorId).Append("','") .Append(operatorGuid).Append("','") //内部数据库用户GUID .Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("','") .Append(ccsqClass.SelAuditingGuid).Append("','") .Append(ccsqClass.CopyPerson).Append("','") .Append(operatorName).Append("','") .Append(ccsqClass.SelAuditingName).Append("','") .Append(ccsqClass.CopyPersonName).Append("','") .Append(ccsqClass.AppendixUrl).Append("','") .Append(ccsqClass.PictureUrl).Append("')"); sqlList.Add(sqlTou.ToString()); if (isWrite == "1") { ToolsClass.TxtLog("DDLog", "\r\nTravelReq=>insert:" + sqlTou.ToString() + "\r\n"); } sqlTou.Clear(); sqlTou.Append("insert into TravelReqDetail(BillNo,Guid,TranMode,OtherTranMode,IsReturn,DepaCity,DepaCity1,DepaCity2,DestCity,DestCity1,DestCity2,StartDate,EndDate,Hours,Days,BearOrga,CustCode,CustName,Peers,PeersName) Values('"); for (int i = 0; i < ccsqClass.Detail.Length; i++) { sqlTi.Clear(); sqlTi.Append(sqlTou.ToString()).Append(billno).Append("','") .Append(Guid.NewGuid().ToString()).Append("','") .Append(ccsqClass.Detail[i].TranMode).Append("','") .Append(ccsqClass.Detail[i].OtherTranMode).Append("','") .Append(ccsqClass.Detail[i].IsReturn).Append("','") .Append(ccsqClass.Detail[i].DepaCity).Append("','") .Append(ccsqClass.Detail[i].DepaCity1).Append("','") .Append(ccsqClass.Detail[i].DepaCity2).Append("','") .Append(ccsqClass.Detail[i].DestCity).Append("','") .Append(ccsqClass.Detail[i].DestCity1).Append("','") .Append(ccsqClass.Detail[i].DestCity2).Append("','") .Append(ccsqClass.Detail[i].StartDate).Append(":01','") .Append(ccsqClass.Detail[i].EndDate).Append(":01','") .Append(ccsqClass.Detail[i].Hours).Append("','") .Append(ccsqClass.Detail[i].Days).Append("','") .Append(ccsqClass.Detail[i].BearOrga).Append("','") .Append(ccsqClass.Detail[i].CustCode).Append("','") .Append(ccsqClass.Detail[i].CustName).Append("','") .Append(ccsqClass.Detail[i].Peers).Append("','") .Append(ccsqClass.Detail[i].PeersName).Append("')"); sqlList.Add(sqlTi.ToString()); if (isWrite == "1") { ToolsClass.TxtLog("DDLog", "\r\nTravelReq=>insert:" + sqlTi.ToString() + "\r\n"); } } //执行SQL语句Insert obj = da.ExecSql(sqlList); if (obj == null) { context.Response.Write("{\"errmsg\":\"保存出差申请信息出错(DD6002)\",\"errcode\":1}"); return; } #endregion #region 发送工作通知消息 url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; CsJson = "{\"agent_id\":\"" + agentId + "\",\"userid_list\":\"" + ccsqClass.SelAuditingGuid + "," + ccsqClass.CopyPerson + "," + ccsqClass.DDOperatorId + "\",\"msg\":{\"msgtype\":\"link\",\"link\":{\"messageUrl\":\"" + ddUrl + "/shenpi/index.html?billno=" + billno + "\",\"picUrl\":\"@\",\"title\":\"" + operatorName + "的【出差】申请\",\"text\":\"出发日期: " + ccsqClass.Detail[0].StartDate.Substring(0, 10) + "\r\n返程日期: " + ccsqClass.Detail[0].EndDate.Substring(0, 10) + "\r\n事由: " + ccsqClass.TravelReason + "\"}}}"; FhJson = ToolsClass.ApiFun("POST", url, CsJson); XXTZ xxtzClass = new XXTZ(); xxtzClass = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); errcode = xxtzClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"您的出差申请消息通知失败(DD6004)\",\"errcode\":1}"); return; } #endregion #region 更新单据消息id与返回内容 //Sql = "update TravelReq set task_id='" + xxtzClass.task_id + "',request_id='" + xxtzClass.request_id + "',returnMsg='" + FhJson.ToString() + "' where billno='" + billno + "'"; //obj = da.ExecSql(Sql); //if (obj == null) //{ // if (isWrite == "1") // { // ToolsClass.TxtLog("DDLog", "\r\nTravelReq=>update:" + Sql.ToString() + "\r\n"); // } // context.Response.Write("{\"errmsg\":\"保存消息通知信息出错(DD6005)\",\"errcode\":1}"); // return; //} #endregion context.Response.Write("{\"errmsg\":\"ok\",\"errcode\":0}"); return; } catch (Exception ex) { context.Response.Write("{\"errmsg\":\"提交的信息有误(DD0005)\",\"errcode\":1}"); context.Response.End(); } }
string ddUrl = ""; //钉钉前端地址 public void ProcessRequest(HttpContext context) { //判断客户端请求是否为post方法 if (context.Request.HttpMethod.ToUpper() != "POST") { context.Response.Write("{\"errmsg\":\"请求方式不允许,请使用POST方式(DD0001)\",\"errcode\":1}"); return; } //数据库链接 connectionString = ToolsClass.GetConfig("DataOnLine"); //sqlServer da = new DbHelper.SqlHelper("SqlServer", connectionString); //获取请求json using (var reader = new StreamReader(context.Request.InputStream, Encoding.UTF8)) { CsJson = reader.ReadToEnd(); } if (CsJson == "") { context.Response.Write("{\"errmsg\":\"报文格式错误(DD0003)\",\"errcode\":1}"); return; } CsJson = Regex.Replace(CsJson, @"[\n\r]", "").Replace(@"\n", ""); //#微应用ID:agentId #企业ID:corpId #应用的唯一标识:appKey #应用的密钥:appSecret AppWyy = ToolsClass.GetConfig("AppWyy"); ScList = AppWyy.Split('$'); agentId = ScList[0].ToString(); corpId = ScList[1].ToString(); appKey = ScList[2].ToString(); appSecret = ScList[3].ToString(); isWrite = ToolsClass.GetConfig("isWrite"); ddUrl = ToolsClass.GetConfig("ddUrl"); if (isWrite == "1") { ToolsClass.TxtLog("DDLog", "\r\nTxfAudi=>入参:" + CsJson + "\r\n"); } //前端传入数据 TravelApproval traApprClass = new TravelApproval(); traApprClass = (TravelApproval)JsonConvert.DeserializeObject(CsJson, typeof(TravelApproval)); try { if (traApprClass.IsSp == "1") { audiIdea = "同意"; } else if (traApprClass.IsSp == "2") { audiIdea = "驳回"; } else { audiIdea = "抄送"; } if (traApprClass.FeeType == "01") { //市内交通费 billTypeNo = "100520005015"; ProName = "EXPEAUDITING"; typeName = "交通费"; typeUrl = ddUrl + "/jtfui/shenpi/index.html?billno="; } else if (traApprClass.FeeType == "02") { //通讯费 billTypeNo = "100520005020"; ProName = "EXPEAUDITING"; typeName = "通讯费"; typeUrl = ddUrl + "/txfui/shenpi/index.html?billno="; } else if (traApprClass.FeeType == "03") { //车辆费 billTypeNo = "100520005025"; ProName = "EXPEAUDITING"; typeName = "车辆费"; typeUrl = ddUrl + "/clui/shenpi/index.html?billno="; } else if (traApprClass.FeeType == "04") { //房租费 billTypeNo = "100520005030"; ProName = "EXPEAUDITING"; typeName = "房租费"; typeUrl = ddUrl + "/fzfui/shenpi/index.html?billno="; } else if (traApprClass.FeeType == "05") { //水费 billTypeNo = "100520005035"; ProName = "EXPEAUDITING"; typeName = "水费"; typeUrl = ddUrl + "/sfui/shenpi/index.html?billno="; } else if (traApprClass.FeeType == "06") { //电费 billTypeNo = "100520005040"; ProName = "EXPEAUDITING"; typeName = "电费"; typeUrl = ddUrl + "/dfui/shenpi/index.html?billno="; } else if (traApprClass.FeeType == "00") { //招待费 billTypeNo = "100520005010"; ProName = "EXPEAUDITING"; typeName = "招待费"; typeUrl = ddUrl + "/zdfui/shenpi/index.html?billno="; } else { context.Response.Write("{\"errmsg\":\"提交的报销类型不存在(DD9001)\",\"errcode\":1}"); return; } #region 获取access_token url = "https://oapi.dingtalk.com/gettoken?appkey=" + appKey + "&appsecret=" + appSecret; FhJson = ToolsClass.ApiFun("GET", url, ""); TokenClass tokenClass = new TokenClass(); tokenClass = (TokenClass)JsonConvert.DeserializeObject(FhJson, typeof(TokenClass)); access_token = tokenClass.access_token; errcode = tokenClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取ACCESS_TOKEN报错(DD0004)\",\"errcode\":1}"); return; } #endregion #region 获取用户详情 url = "https://oapi.dingtalk.com/user/get?access_token=" + access_token + "&userid=" + traApprClass.DDAuditingId; FhJson = ToolsClass.ApiFun("GET", url, ""); GetUserXq userXqClass = new GetUserXq(); userXqClass = (GetUserXq)JsonConvert.DeserializeObject(FhJson, typeof(GetUserXq)); errcode = userXqClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取审批人详细信息报错(DD6003)\",\"errcode\":1}"); return; } audiName = userXqClass.name; #endregion #region 获取用户guid if (traApprClass.FeeType == "00") { Sql = "select top 1 a.Guid,b.BillCount,b.FeeAmount from Employee a left join (select BillCount,FeeAmount from EXPEENTEMENT where billno = '[申请号]') b on 1 = 1 where a.employeecode = '[工号]'"; } else { Sql = "select top 1 a.Guid,b.BillCount,b.FeeAmount from Employee a left join (select BillCount,FeeAmount from EXPEOTHER where billno = '[申请号]') b on 1 = 1 where a.employeecode = '[工号]'"; } Sql = Sql.Replace("[申请号]", traApprClass.BillNo).Replace("[工号]", userXqClass.jobnumber); obj = da.GetDataTable(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"用户不存在(DD6000)\",\"errcode\":1}"); return; } dt = obj as DataTable; AuditingGuid = dt.Rows[0]["Guid"].ToString(); #endregion #region 更新审批信息 if (traApprClass.FeeType == "00") { //更新单据消息id与返回内容 Sql = "update EXPEENTEMENT set IsSp='" + traApprClass.IsSp + "',auditingidea='" + traApprClass.AuditingIdea + "',DDAuditingId='" + traApprClass.DDAuditingId + "',auditingguid='" + AuditingGuid + "' where billno='" + traApprClass.BillNo + "'"; } else { //更新单据消息id与返回内容 Sql = "update EXPEOTHER set IsSp='" + traApprClass.IsSp + "',auditingidea='" + traApprClass.AuditingIdea + "',DDAuditingId='" + traApprClass.DDAuditingId + "',auditingguid='" + AuditingGuid + "' where billno='" + traApprClass.BillNo + "'"; } if (isWrite == "1") { ToolsClass.TxtLog("DDLog", "\r\nTxfAudi=>update:" + Sql.ToString() + "\r\n"); } obj = da.ExecSql(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"更新审批信息出错(DD6006)\",\"errcode\":1}"); return; } #endregion #region 调用审核存储过程 if (traApprClass.IsSp == "1") { billno = traApprClass.BillNo; if (!sqlPro()) { if (traApprClass.FeeType == "00") { Sql = "update EXPEENTEMENT set IsSp='0',auditingidea=null,DDAuditingId=null,auditingguid=null where billno='" + traApprClass.BillNo + "'"; } else { Sql = "update EXPEOTHER set IsSp='0',auditingidea=null,DDAuditingId=null,auditingguid=null where billno='" + traApprClass.BillNo + "'"; } obj = da.ExecSql(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"更新审批状态出错(DD6006)\",\"errcode\":1}"); return; } context.Response.Write("{\"errmsg\":\"" + ProResult + "(DD9003)\",\"errcode\":1}"); return; } } #endregion #region 发送工作通知消息 CsJson = "{\"agent_id\":\"" + agentId + "\",\"userid_list\":\"" + traApprClass.DDAuditingId + "," + traApprClass.CopyPerson + "," + traApprClass.DDOperatorId + "\",\"msg\":{\"msgtype\":\"link\",\"link\":{\"messageUrl\":\"" + typeUrl + "" + traApprClass.BillNo + "\",\"picUrl\":\"@\",\"title\":\"已" + audiIdea + "【" + audiName + "】\",\"text\":\"金额: " + dt.Rows[0]["FeeAmount"].ToString() + "¥ 发票: " + dt.Rows[0]["BillCount"].ToString() + "张\r\n申请人: " + traApprClass.OperatorName + "【" + typeName + "】\r\n审批意见: " + traApprClass.AuditingIdea + "\"}}}"; url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; FhJson = ToolsClass.ApiFun("POST", url, CsJson); if (isWrite == "1") { ToolsClass.TxtLog("DDLog", "\r\nTxfAudi=>CsJson:" + CsJson + "FhJson\r\n:" + FhJson); } XXTZ xxtzClass2 = new XXTZ(); xxtzClass2 = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); errcode = xxtzClass2.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"您的报销申请消息通知失败(DD6004)\",\"errcode\":1}"); return; } #endregion context.Response.Write("{\"errmsg\":\"ok\",\"errcode\":0}"); return; } catch (Exception ex) { context.Response.Write("{\"errmsg\":\"提交的信息有误(DD0005)\",\"errcode\":1}"); context.Response.End(); } }
public void ProcessRequest(HttpContext context) { //判断客户端请求是否为post方法 if (context.Request.HttpMethod.ToUpper() != "POST") { context.Response.Write(JsonConvert.SerializeObject(new CommonModel { errcode = "1", errmsg = "请求方式不允许,请使用POST方式" })); return; } try { string signUrl = ToolsClass.GetConfig("signUrl"); context.Response.ContentType = "text/plain"; //数据库链接 connectionString = ToolsClass.GetConfig("DataOnLine"); string MedConfig180AuditingInfo = ToolsClass.GetConfig("MedConfig180AuditingInfo"); //sqlServer da = new DbHelper.SqlHelper("SqlServer", connectionString); //获取请求json using (var reader = new StreamReader(context.Request.InputStream, Encoding.UTF8)) { CsJson = reader.ReadToEnd(); } if (CsJson == "") { context.Response.Write(JsonConvert.SerializeObject(new CommonModel { errcode = "1", errmsg = "报文格式错误" })); return; } CsJson = Regex.Replace(CsJson, @"[\n\r]", "").Replace(@"\n", ",").Replace("'", "‘").Replace("\t", ":").Replace("\r", ",").Replace("\n", ","); ToolsClass.TxtLog("获取审批流程信息日志", "\r\n入参:" + CsJson + "\r\n"); //json转Hashtable object jgobj = ToolsClass.DeserializeObject(CsJson); Hashtable returnhash = jgobj as Hashtable; if (returnhash == null) { context.Response.Write(JsonConvert.SerializeObject(new CommonModel { errcode = "1", errmsg = "报文格式错误" })); return; } string path = context.Request.Path.Replace("Approval/ProcessInfo.ashx", "getprocessbegin"); //验证请求sign string sign = ToolsClass.md5(signUrl + path + "Romens1/DingDing2" + path, 32); ToolsClass.TxtLog("生成的sign", "生成的" + sign + "传入的sign" + returnhash["Sign"].ToString() + "\r\n 后台字符串:" + signUrl + path + "Romens1/DingDing2" + path); if (sign != returnhash["Sign"].ToString()) { context.Response.Write(JsonConvert.SerializeObject(new CommonModel { errcode = "1", errmsg = "Sign不正确" })); return; } string MedConfig180 = string.Empty; selType = returnhash["TypeId"].ToString(); DDOperatorId = returnhash["DDOperatorId"].ToString(); DDOperatorName = returnhash["DDOperatorName"].ToString(); if (returnhash.ContainsKey("MedConfig180")) { MedConfig180 = returnhash["MedConfig180"].ToString(); } //#微应用ID:agentId #企业ID:corpId #应用的唯一标识:appKey #应用的密钥:appSecret AppWyy = ToolsClass.GetConfig("AppWyy"); ScList = AppWyy.Split('$'); agentId = ScList[0].ToString(); corpId = ScList[1].ToString(); appKey = ScList[2].ToString(); appSecret = ScList[3].ToString(); isWrite = ToolsClass.GetConfig("isWrite"); ddUrl = ToolsClass.GetConfig("ddUrl"); #region 获取access_token url = "https://oapi.dingtalk.com/gettoken?appkey=" + appKey + "&appsecret=" + appSecret; fjsons = ToolsClass.ApiFun("GET", url, ""); TokenClass tokenClass = new TokenClass(); tokenClass = (TokenClass)JsonConvert.DeserializeObject(fjsons, typeof(TokenClass)); access_token = tokenClass.access_token; int errcode = tokenClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"" + tokenClass.errmsg + "\",\"errcode\":1}"); return; } #endregion 获取access_token #region 获取用户详情 url = "https://oapi.dingtalk.com/user/get?access_token=" + access_token + "&userid=" + DDOperatorId; fjsons = ToolsClass.ApiFun("GET", url, ""); GetUserXq userXqClass = new GetUserXq(); userXqClass = (GetUserXq)JsonConvert.DeserializeObject(fjsons, typeof(GetUserXq)); errcode = userXqClass.errcode; if (errcode != 0) { context.Response.Write(JsonConvert.SerializeObject(new CommonModel { errcode = "1", errmsg = userXqClass.errmsg })); return; } #endregion 获取用户详情 List <RUPNodeinfo> NodeInfo = new List <RUPNodeinfo>(); string returnProcess = ""; //取用户信息,进入功能时获取审批流程信息 if (selType == "psin") { //如果是高级领导发起审批 if (da.GetDataTable($"select * from flowemployee where orgcode ='00' and isleader='1' and ddid='{DDOperatorId}' and disable ='0'").Rows.Count != 0) { DataTable roleWithEmp = da.GetDataTable("select distinct Type,PersonId,PersonName from RoleWithEmp where status = '1'"); if (roleWithEmp.Rows.Count == 0) { context.Response.Write(JsonConvert.SerializeObject(new CommonModel { errcode = "1", errmsg = "未配置高级领导审批流程,请联系相关人员进行RoleWithEmp中数据配置!" })); return; } DataRow[] dataRows1, dataRows2 = null; //为1 的是集团财务 dataRows1 = roleWithEmp.Select("Type ='1'"); List <RUPNodeinfodetail> NodeInfoDetailsCW = new List <RUPNodeinfodetail>(), NodeInfoDetailsCN = new List <RUPNodeinfodetail>(); List <RUPPerson> Personscaiwu = new List <RUPPerson>(), Personscn = new List <RUPPerson>(); for (int ri = 0; ri < dataRows1.Length; ri++) { Personscaiwu.Add(new RUPPerson { AType = "集团财务", PersonId = dataRows1[ri]["PersonId"].SqlDataBankToString(), PersonName = dataRows1[ri]["PersonName"].SqlDataBankToString() }); } NodeInfoDetailsCW.Add(new RUPNodeinfodetail { GroupType = "集团财务", IsAndOr = "1", IsLeader = "0", Persons = Personscaiwu }); NodeInfo.Add(new RUPNodeinfo { NodeInfoDetails = NodeInfoDetailsCW, NodeInfoType = "2" }); //为2的是出纳 dataRows2 = roleWithEmp.Select("Type ='2'"); for (int ci = 0; ci < dataRows2.Length; ci++) { Personscn.Add(new RUPPerson { AType = "出纳", PersonId = dataRows2[ci]["PersonId"].SqlDataBankToString(), PersonName = dataRows2[ci]["PersonName"].SqlDataBankToString() }); } NodeInfoDetailsCN.Add(new RUPNodeinfodetail { GroupType = "出纳", IsAndOr = "1", IsLeader = "0", Persons = Personscn }); NodeInfo.Add(new RUPNodeinfo { NodeInfoDetails = NodeInfoDetailsCN, NodeInfoType = "2" }); returnProcess = JsonConvert.SerializeObject(new ReturnUserProcess { NodeInfo = NodeInfo, errcode = "0", errmsg = "" }); if (isWrite == "1") { ToolsClass.TxtLog("获取审批流程信息日志", "\r\n返回高级领导审批流程:" + returnProcess + "\r\n"); } context.Response.Write(returnProcess); return; } if (MedConfig180 == "1") { List <RUPNodeinfodetail> NodeInfoDetailsYB = new List <RUPNodeinfodetail>(); List <RUPPerson> PersonsYB = new List <RUPPerson>(); NodeInfo.Clear(); PersonsYB.Add(new RUPPerson { AType = "指定人", PersonId = MedConfig180AuditingInfo.Split(',')[0], PersonName = MedConfig180AuditingInfo.Split(',')[1] }); NodeInfoDetailsYB.Add(new RUPNodeinfodetail { GroupType = "指定人", IsAndOr = "1", IsLeader = "0", Persons = PersonsYB }); NodeInfo.Add(new RUPNodeinfo { NodeInfoDetails = NodeInfoDetailsYB, NodeInfoType = "2" }); returnProcess = JsonConvert.SerializeObject(new ReturnUserProcess { NodeInfo = NodeInfo, errcode = "0", errmsg = "" }); context.Response.Write(returnProcess); return; } string BillClassId = returnhash["BillClassId"].ToString(); string billName = returnhash["BillName"].ToString(); string deptCode = returnhash["DeptCode"].ToString(); sql = $"select nodeid,BilliClassid,BillClassName,NodeNumber,CharacterTypes,ApprovalType,persons,IsAndOr,IsEnd from ApprovalNode where BilliClassid = '{BillClassId}' order by NodeNumber"; //找到相对应的流程信息 DataTable processdt = da.GetDataTable(sql); DataTable deptdt; DataTable roledt; NodeInfo.Clear(); //嗯 开始组json,如果你看到这段代码,劝你别轻举妄动,仔细观察再改,容易出事,修改之前切记切记,三思而后行 List <RUPPerson> PersonsRy, PersonsJs, PersonsCs, PersonsBm1 = new List <RUPPerson>(), PersonsBm2 = new List <RUPPerson>(), PersonsBm3 = new List <RUPPerson>(), PersonsBm4 = new List <RUPPerson>(), PersonsBm5 = new List <RUPPerson>(); List <RUPNodeinfodetail> NodeInfoDetailsRy, NodeInfoDetailsCs, NodeInfoDetailsJs, NodeInfoDetailsBm1 = new List <RUPNodeinfodetail>(), NodeInfoDetailsBm2 = new List <RUPNodeinfodetail>(), NodeInfoDetailsBm3 = new List <RUPNodeinfodetail>(), NodeInfoDetailsBm4 = new List <RUPNodeinfodetail>(), NodeInfoDetailsBm5 = new List <RUPNodeinfodetail>(); PSPPerson pSPPerson = new PSPPerson(); string deptid, deptname; //是否是主管 PSPApprovalType pSPApprovalType = new PSPApprovalType(); for (int i = 0; i < processdt.Rows.Count; i++) { PSPPerson[] Persons = (PSPPerson[])JsonConvert.DeserializeObject(processdt.Rows[i]["Persons"].SqlDataBankToString(), typeof(PSPPerson[])); if (processdt.Rows[i]["CharacterTypes"].SqlDataBankToString() == "2") { pSPApprovalType = null; pSPApprovalType = (PSPApprovalType)JsonConvert.DeserializeObject(processdt.Rows[i]["ApprovalType"].SqlDataBankToString(), typeof(PSPApprovalType)); //按照人员审批 if (pSPApprovalType.Type == "1") { PersonsRy = new List <RUPPerson>(); NodeInfoDetailsRy = new List <RUPNodeinfodetail>(); for (int k = 0; k < Persons.Length; k++) { PersonsRy.Add(new RUPPerson { AType = "指定人", PersonId = Persons[k].PersonId, PersonName = Persons[k].PersonName }); } NodeInfoDetailsRy.Add(new RUPNodeinfodetail { GroupType = "指定人", IsAndOr = processdt.Rows[i]["IsAndOr"].SqlDataBankToString(), IsLeader = "0", Persons = PersonsRy }); NodeInfo.Add(new RUPNodeinfo { NodeInfoDetails = NodeInfoDetailsRy, NodeInfoType = "2" }); } //按照部门审批 if (pSPApprovalType.Type == "2") { //查询当前的人的级别以及部门编号 取isleader最大的为准 sql = $"select a.IsLeader IsLeader, b.guid orgcode from FlowEmployee a join Organization b on a.orgcode = b. guid where a.EmployeeCode = '{userXqClass.jobnumber}' and a.orgcode ='{deptCode}' and a.disable ='0' order by a.IsLeader desc"; DataTable loinfo = da.GetDataTable(sql); if (loinfo.Rows.Count == 0) { context.Response.Write(JsonConvert.SerializeObject(new CommonModel { errcode = "1", errmsg = "未配置审批流程,请联系相关人员进行FlowEmployee表配置!" })); return; } string leaderlevel = loinfo.Rows[0]["IsLeader"].SqlDataBankToString(); string orgcode = loinfo.Rows[0]["orgcode"].SqlDataBankToString(); //直接主管 一级主管 if (pSPApprovalType.Level == "1") { //判断他是否是主管 if (int.Parse(leaderlevel) > 0) { sql = null; sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = '{orgcode}') and disable ='0' and IsLeader ='1' "; } else { sql = null; // sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode= (select guid from Organization where guid = '{orgcode}') and disable ='0' and IsLeader ='{int.Parse(leaderlevel) + 1}'"; sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode= (select guid from Organization where guid = '{orgcode}') and disable ='0' and IsLeader ='1'"; } deptdt = da.GetDataTable(sql); if (deptdt.Rows.Count != 0) { for (int k = 0; k < deptdt.Rows.Count; k++) { deptid = deptdt.Rows[k]["EmployeeCode"].SqlDataBankToString(); deptname = deptdt.Rows[k]["EmployeeName"].SqlDataBankToString(); PersonsBm1.Add(new RUPPerson { AType = "直接主管", PersonId = deptid, PersonName = deptname }); } NodeInfoDetailsBm1.Add(new RUPNodeinfodetail { GroupType = "直接主管", IsAndOr = processdt.Rows[i]["IsAndOr"].SqlDataBankToString(), IsLeader = "1", Persons = PersonsBm1 }); NodeInfo.Add(new RUPNodeinfo { NodeInfoDetails = NodeInfoDetailsBm1, NodeInfoType = "2" }); } } //二级主管 if (pSPApprovalType.Level == "2") { //判断他是否是主管 if (int.Parse(leaderlevel) > 0) { //二级主管 sql = null; //sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = '{orgcode}')) and disable ='0' and IsLeader ='{int.Parse(leaderlevel) + 2}'"; sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = '{orgcode}')) and disable ='0' and IsLeader ='1'"; } else //当前人不是主管 { sql = null; //sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select guid from Organization where guid = '{orgcode}')) and disable ='0' and IsLeader ='{int.Parse(leaderlevel) + 2}'"; sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select guid from Organization where guid = '{orgcode}')) and disable ='0' and IsLeader ='1'"; } deptdt = da.GetDataTable(sql); if (deptdt.Rows.Count != 0) { for (int k = 0; k < deptdt.Rows.Count; k++) { deptid = deptdt.Rows[k]["EmployeeCode"].SqlDataBankToString(); deptname = deptdt.Rows[k]["EmployeeName"].SqlDataBankToString(); PersonsBm2.Add(new RUPPerson { AType = "二级主管", PersonId = deptid, PersonName = deptname }); } NodeInfoDetailsBm2.Add(new RUPNodeinfodetail { GroupType = "二级主管", IsAndOr = processdt.Rows[i]["IsAndOr"].SqlDataBankToString(), IsLeader = "1", Persons = PersonsBm2 }); NodeInfo.Add(new RUPNodeinfo { NodeInfoDetails = NodeInfoDetailsBm2, NodeInfoType = "2" }); } } //三级主管 if (pSPApprovalType.Level == "3") { //判断他是否是主管 if (int.Parse(leaderlevel) > 0) { sql = null; //三级主管 //sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode = (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = '{orgcode}'))) and disable ='0' and IsLeader ='{int.Parse(leaderlevel) + 3}'"; sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode = (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = '{orgcode}'))) and disable ='0' and IsLeader ='1"; } else { sql = null; //sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode = (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select guid from Organization where guid = '{orgcode}'))) and disable ='0' and IsLeader ='{int.Parse(leaderlevel) + 3}'"; sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode = (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select guid from Organization where guid = '{orgcode}'))) and disable ='0' and IsLeader ='1"; } deptdt = da.GetDataTable(sql); if (deptdt.Rows.Count != 0) { for (int k = 0; k < deptdt.Rows.Count; k++) { deptid = deptdt.Rows[k]["EmployeeCode"].SqlDataBankToString(); deptname = deptdt.Rows[k]["EmployeeName"].SqlDataBankToString(); PersonsBm3.Add(new RUPPerson { AType = "三级主管", PersonId = deptid, PersonName = deptname }); } NodeInfoDetailsBm3.Add(new RUPNodeinfodetail { GroupType = "三级主管", IsAndOr = processdt.Rows[i]["IsAndOr"].SqlDataBankToString(), IsLeader = "1", Persons = PersonsBm3 }); NodeInfo.Add(new RUPNodeinfo { NodeInfoDetails = NodeInfoDetailsBm3, NodeInfoType = "2" }); } } //四级主管 if (pSPApprovalType.Level == "4") { //判断他是否是主管 if (int.Parse(leaderlevel) > 0) { sql = null; //四级主管 //sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode =(select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = '{orgcode}')))) and disable ='0' and IsLeader ='{int.Parse(leaderlevel) + 4}'"; sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode =(select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = '{orgcode}')))) and disable ='0' and IsLeader ='1'"; } else { sql = null; //员工的四级主管 //sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode =(select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select guid from Organization where guid = '{orgcode}')))) and disable ='0' and IsLeader ='{int.Parse(leaderlevel) + 4}'"; sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode =(select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select guid from Organization where guid = '{orgcode}')))) and disable ='0' and IsLeader ='1'"; } deptdt = da.GetDataTable(sql); if (deptdt.Rows.Count != 0) { for (int k = 0; k < deptdt.Rows.Count; k++) { deptid = deptdt.Rows[k]["EmployeeCode"].SqlDataBankToString(); deptname = deptdt.Rows[k]["EmployeeName"].SqlDataBankToString(); PersonsBm4.Add(new RUPPerson { AType = "四级主管", PersonId = deptid, PersonName = deptname }); } NodeInfoDetailsBm4.Add(new RUPNodeinfodetail { GroupType = "四级主管", IsAndOr = processdt.Rows[i]["IsAndOr"].SqlDataBankToString(), IsLeader = "1", Persons = PersonsBm4 }); NodeInfo.Add(new RUPNodeinfo { NodeInfoDetails = NodeInfoDetailsBm4, NodeInfoType = "2" }); } } //五级主管 if (pSPApprovalType.Level == "5") { //判断他是否是主管 if (int.Parse(leaderlevel) > 0) { sql = null; //五级主管 //sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode =(select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid =(select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = '{orgcode}'))))) and disable ='0' and IsLeader ='{int.Parse(leaderlevel) + 5}'"; sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode =(select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid =(select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = '{orgcode}'))))) and disable ='0' and IsLeader ='1'"; } else { sql = null; //员工的五级主管 // sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode =(select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid =(select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select guid from Organization where guid = '{orgcode}'))))) and disable ='0' and IsLeader ='{int.Parse(leaderlevel) + 5}'"; sql = $"select EmployeeCode, EmployeeName from FlowEmployee where orgcode =(select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid =(select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid = (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select case when isnull(Guid,'')='00' then '' else ParentGuid end ParentGuid from Organization where guid= (select guid from Organization where guid = '{orgcode}'))))) and disable ='0' and IsLeader ='1'"; } deptdt = da.GetDataTable(sql); if (deptdt.Rows.Count != 0) { for (int k = 0; k < deptdt.Rows.Count; k++) { deptid = deptdt.Rows[k]["EmployeeCode"].SqlDataBankToString(); deptname = deptdt.Rows[k]["EmployeeName"].SqlDataBankToString(); PersonsBm5.Add(new RUPPerson { AType = "五级主管", PersonId = deptid, PersonName = deptname }); } NodeInfoDetailsBm5.Add(new RUPNodeinfodetail { GroupType = "五级主管", IsAndOr = processdt.Rows[i]["IsAndOr"].SqlDataBankToString(), IsLeader = "1", Persons = PersonsBm5 }); NodeInfo.Add(new RUPNodeinfo { NodeInfoDetails = NodeInfoDetailsBm5, NodeInfoType = "2" }); } } } //按角色审批 type 为3 level 为角色id if (pSPApprovalType.Type == "3") { #region //当前操作人的部门deptCode //当前环节的角色组名称是pSPApprovalType.Level sql = ""; sql = $"select distinct a.EmployeeCode EmployeeCode, a.EmployeeName EmployeeName,b.RoleName RoleName,c.roleid from FlowEmployee a join EmpsRoleId c on a.EmployeeCode = c.EmployeeCode join role b on b.roleid = c.roleid where c.RoleId in (select RoleId from RoleWithOrg where orgcode='{deptCode}' and status ='1') and c.Roleid in (select Roleid from Role where RoleGroupId = '{pSPApprovalType.Level}' and status ='1') and a.disable ='0' and c.status ='1' and b.status='1'"; ToolsClass.TxtLog("获取审批流程信息", "\r\n查询相应角色sql:" + sql + "\r\n"); roledt = da.GetDataTable(sql); if (roledt.Rows.Count != 0) { NodeInfoDetailsJs = new List <RUPNodeinfodetail>(); PersonsJs = new List <RUPPerson>(); for (int k = 0; k < roledt.Rows.Count; k++) { deptid = roledt.Rows[k]["EmployeeCode"].SqlDataBankToString(); deptname = roledt.Rows[k]["EmployeeName"].SqlDataBankToString(); PersonsJs.Add(new RUPPerson { AType = roledt.Rows[k]["RoleName"].SqlDataBankToString(), PersonId = deptid, PersonName = deptname }); } NodeInfoDetailsJs.Add(new RUPNodeinfodetail { GroupType = da.GetValue($"select RoleGroupName from RoleGroup where RoleGroupId ='{pSPApprovalType.Level}'").SqlDataBankToString(), IsAndOr = processdt.Rows[i]["IsAndOr"].SqlDataBankToString(), IsLeader = "0", Persons = PersonsJs }); NodeInfo.Add(new RUPNodeinfo { NodeInfoDetails = NodeInfoDetailsJs, NodeInfoType = "2" }); } #endregion } } //抄送环节 if (processdt.Rows[i]["CharacterTypes"].SqlDataBankToString() == "3") { NodeInfoDetailsCs = new List <RUPNodeinfodetail>(); PersonsCs = new List <RUPPerson>(); for (int k = 0; k < Persons.Length; k++) { PersonsCs.Add(new RUPPerson { AType = "抄送人", PersonId = Persons[k].PersonId, PersonName = Persons[k].PersonName }); } NodeInfoDetailsCs.Add(new RUPNodeinfodetail { GroupType = "抄送人", IsAndOr = "", IsLeader = "0", Persons = PersonsCs }); NodeInfo.Add(new RUPNodeinfo { NodeInfoDetails = NodeInfoDetailsCs, NodeInfoType = "3" }); } } returnProcess = JsonConvert.SerializeObject(new ReturnUserProcess { NodeInfo = NodeInfo, errcode = "0", errmsg = "" }); ToolsClass.TxtLog("获取审批流程信息日志", "\r\n返回当前操作人审批流程:" + returnProcess + "\r\n"); context.Response.Write(returnProcess); return; } //获取用户当前的部门 else if (selType == "deptin") { sql = $"select a.IsLeader IsLeader, b.guid orgcode,b.Name orgName,b.ParentGuid from FlowEmployee a join Organization b on a.orgcode = b. guid where a.EmployeeCode = '{userXqClass.jobnumber}' and a.disable = '0'"; DataTable loinfo = da.GetDataTable(sql); string orgcode, orgName, ParentGuid; List <Organization> DeptInfo = new List <Organization>(); for (int i = 0; i < loinfo.Rows.Count; i++) { orgcode = loinfo.Rows[i]["orgcode"].SqlDataBankToString(); orgName = loinfo.Rows[i]["orgName"].SqlDataBankToString(); ParentGuid = loinfo.Rows[i]["ParentGuid"].SqlDataBankToString(); DeptInfo.Add(new Organization { OrgCode = orgcode, OrgName = orgName, ParentGuid = ParentGuid }); } string result = JsonConvert.SerializeObject(new ReturnUserOrg { DeptInfo = DeptInfo, errcode = "0", errmsg = "ok" }); ToolsClass.TxtLog("获取用户当前的部门", $"执行的sql:{ sql }\r\n,返回的数据:\r\n{result}"); context.Response.Write(result); return; } } catch (Exception ex) { context.Response.Write(JsonConvert.SerializeObject(new CommonModel { errcode = "1", errmsg = ex.Message })); return; } }
string ddUrl = ""; //钉钉前端地址 public void ProcessRequest(HttpContext context) { //判断客户端请求是否为post方法 if (context.Request.HttpMethod.ToUpper() != "POST") { context.Response.Write("{\"errmsg\":\"请求方式不允许,请使用POST方式(DD0001)\",\"errcode\":1}"); return; } //数据库链接 connectionString = ToolsClass.GetConfig("DataOnLine"); //sqlServer da = new DbHelper.SqlHelper("SqlServer", connectionString); //获取请求json using (var reader = new StreamReader(context.Request.InputStream, Encoding.UTF8)) { CsJson = reader.ReadToEnd(); } if (CsJson == "") { context.Response.Write("{\"errmsg\":\"报文格式错误(DD0003)\",\"errcode\":1}"); return; } CsJson = Regex.Replace(CsJson, @"[\n\r]", "").Replace(@"\n", ""); //#微应用ID:agentId #企业ID:corpId #应用的唯一标识:appKey #应用的密钥:appSecret AppWyy = ToolsClass.GetConfig("AppWyy"); ScList = AppWyy.Split('$'); agentId = ScList[0].ToString(); corpId = ScList[1].ToString(); appKey = ScList[2].ToString(); appSecret = ScList[3].ToString(); isWrite = ToolsClass.GetConfig("isWrite"); ddUrl = ToolsClass.GetConfig("ddUrl"); if (isWrite == "1") { ToolsClass.TxtLog("DDLog", "\r\nProInfo=>入参:" + CsJson + "\r\n"); } //前端传入数据 TravelApproval traApprClass = new TravelApproval(); traApprClass = (TravelApproval)JsonConvert.DeserializeObject(CsJson, typeof(TravelApproval)); try { if (traApprClass.IsAuditing == "1") { audiIdea = "同意"; } else if (traApprClass.IsAuditing == "2") { audiIdea = "驳回"; } else { audiIdea = "抄送"; } #region 获取access_token url = "https://oapi.dingtalk.com/gettoken?appkey=" + appKey + "&appsecret=" + appSecret; FhJson = ToolsClass.ApiFun("GET", url, ""); TokenClass tokenClass = new TokenClass(); tokenClass = (TokenClass)JsonConvert.DeserializeObject(FhJson, typeof(TokenClass)); access_token = tokenClass.access_token; errcode = tokenClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取ACCESS_TOKEN报错(DD0004)\",\"errcode\":1}"); return; } #endregion #region 获取用户详情 url = "https://oapi.dingtalk.com/user/get?access_token=" + access_token + "&userid=" + traApprClass.DDAuditingId; FhJson = ToolsClass.ApiFun("GET", url, ""); GetUserXq userXqClass = new GetUserXq(); userXqClass = (GetUserXq)JsonConvert.DeserializeObject(FhJson, typeof(GetUserXq)); errcode = userXqClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取审批人详细信息报错(DD6003)\",\"errcode\":1}"); return; } audiName = userXqClass.name; #endregion #region 获取用户guid Sql = "select top 1 a.guid,b.StartDate,b.EndDate from FlowEmployee a left join (select convert(varchar(20), min(b.StartDate), 23) StartDate,convert(varchar(20), max(EndDate), 23) EndDate from TravelReq a left join TravelReqDetail b on a.billno = b.billno where a.billno = '" + traApprClass.BillNo + "' group by a.billno) b on 1 = 1 where a.employeecode = '" + userXqClass.jobnumber + "'"; obj = da.GetDataTable(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"用户不存在(DD9002)\",\"errcode\":1}"); return; } dt = obj as DataTable; if (dt.Rows.Count == 0) { context.Response.Write("{\"errmsg\":\"申请信息不存在(DD9003)\",\"errcode\":1}"); return; } AuditingGuid = dt.Rows[0]["guid"].ToString(); #endregion #region 发送工作通知消息 CsJson = "{\"agent_id\":\"" + agentId + "\",\"userid_list\":\"" + traApprClass.DDAuditingId + "," + traApprClass.CopyPerson + "," + traApprClass.DDOperatorId + "\",\"msg\":{\"msgtype\":\"link\",\"link\":{\"messageUrl\":\"" + ddUrl + "/shenpi/index.html?billno=" + traApprClass.BillNo + "\",\"picUrl\":\"@\",\"title\":\"已" + audiIdea + "【" + audiName + "】\",\"text\":\"出发日期: " + dt.Rows[0]["StartDate"].ToString() + "\r\n申请人: " + traApprClass.OperatorName + "【出差】\r\n审批意见: " + traApprClass.AuditingIdea + "\"}}}"; url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; FhJson = ToolsClass.ApiFun("POST", url, CsJson); if (isWrite == "1") { ToolsClass.TxtLog("DDLog", "\r\nProInfo=>CsJson:" + CsJson + "FhJson\r\n:" + FhJson); } XXTZ xxtzClass2 = new XXTZ(); xxtzClass2 = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); errcode = xxtzClass2.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"您的出差申请消息通知失败(DD6004)\",\"errcode\":1}"); return; } #endregion #region 发送普通会话消息 //if (traApprClass.Cid != "" && traApprClass.Cid != null) //{ // CsJson = "{\"cid\":\"" + traApprClass.Cid + "\",\"sender\":\"" + traApprClass.DDOperatorId + "\",\"msg\":{\"msgtype\":\"link\",\"link\":{\"messageUrl\":\"http://oa.romens.cn:8090/shenpi/index.html?billno=" + traApprClass.BillNo + "\",\"picUrl\":\"@\",\"title\":\"已" + audiIdea + "\",\"text\":\"" + audiName + audiIdea + "了审批\"}}}"; // url = "https://oapi.dingtalk.com/message/send_to_conversation?access_token=" + access_token; // FhJson = ToolsClass.ApiFun("POST", url, CsJson); // if (isWrite == "1") // { // ToolsClass.TxtLog("DDLog", "\r\nProInfo=>CsJson:" + CsJson + "FhJson\r\n:" + FhJson); // } // XXTZ xxtzClass = new XXTZ(); // xxtzClass = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); // errcode = xxtzClass.errcode; // if (errcode != 0) // { // context.Response.Write("{\"errmsg\":\"您的出差申请消息通知失败(DD6004)\",\"errcode\":1}"); // return; // } //} #endregion #region 更新审批信息 //更新单据消息id与返回内容 Sql = "update TravelReq set isauditing='" + traApprClass.IsAuditing + "',auditingdate=getdate(),auditingidea='" + traApprClass.AuditingIdea + "',DDAuditingId='" + traApprClass.DDAuditingId + "',auditingguid='" + AuditingGuid + "',auditingname='" + audiName + "' where billno='" + traApprClass.BillNo + "'"; if (isWrite == "1") { ToolsClass.TxtLog("DDLog", "\r\nProInfo=>update:" + Sql.ToString() + "\r\n"); } obj = da.ExecSql(Sql); if (obj == null) { if (isWrite == "1") { ToolsClass.TxtLog("DDLog", "\r\nProInfo=>update:" + Sql.ToString() + "\r\n"); } context.Response.Write("{\"errmsg\":\"更新审批信息出错(DD6006)\",\"errcode\":1}"); return; } #endregion context.Response.Write("{\"errmsg\":\"ok\",\"errcode\":0}"); return; } catch (Exception ex) { context.Response.Write("{\"errmsg\":\"提交的信息有误(DD0005)\",\"errcode\":1}"); context.Response.End(); } }
/// <summary> /// 保存意见,判断单据状态 /// </summary> /// <returns></returns> public static bool SaveComments(TravelApprovalMul traApprClass, GetUserXq userXqClass, string nodeNumber, HttpContext context, string ddUrl, string logType, out string result) { string connectionString = ToolsClass.GetConfig("DataOnLine"); SqlHelper SqlHelper = new SqlHelper("SqlServer", connectionString); result = string.Empty; string IsLocalHost = traApprClass.IsLocalHost == null ? "0" : traApprClass.IsLocalHost; string ymadk = System.Configuration.ConfigurationManager.AppSettings["ymadk"].ToString() + "/"; GetMulParams getMulParams = new GetMulParams(); //将意见及日期保存到ApprovalComments表,并改变状态 string Sql = $"update ApprovalComments set ApprovalComments='{traApprClass.AuditingIdea}',Urls='{JsonConvert.SerializeObject(traApprClass.Urls)}',ApprovalStatus='{traApprClass.IsSp}',ApprovalDate='{DateTime.Now}' where BillNo ='{traApprClass.BillNo}' and ApprovalID='{userXqClass.jobnumber}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and BillClassId='{traApprClass.BillClassId}'"; SqlHelper.ExecSql(Sql); ToolsClass.TxtLog(logType, "\r\n操作ApprovalComments表:" + Sql + "\r\n"); bool processIsEnd = false; //判断当前节点是领导还是非领导 Sql = ""; // 1 2 3 null Sql = $"select distinct IsLeader IsLeader, IsAndOr IsAndOr from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and BillClassId='{traApprClass.BillClassId}'"; DataTable IsLeader = SqlHelper.GetDataTable(Sql); if (IsLeader.Rows[0]["IsLeader"].ToString() == "1") { //领导为一次审批或者会签 if (IsLeader.Rows[0]["IsAndOr"].ToString() == "1" || IsLeader.Rows[0]["IsAndOr"].ToString() == "2") { Sql = ""; // 1 2 3 null Sql = $"select count(*) from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and ApprovalStatus='0' and BillClassId='{traApprClass.BillClassId}'"; //当前节点未完成 if (SqlHelper.GetValue(Sql).ToString() != "0") { if (IsLocalHost == "0") { processIsEnd = false; result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog(logType, "\r\n返回前端信息:" + result + "\r\n"); // context.Response.Write(result); } else { processIsEnd = false; result = JsonConvert.SerializeObject(new ResultGetMulParams { errcode = "0", errmsg = "", NextUrl = "" }); ToolsClass.TxtLog(logType, "\r\n返回前端信息:" + result + "\r\n"); // context.Response.Write(result); } return(processIsEnd); } else { processIsEnd = true; } } //领导为或签 else if (IsLeader.Rows[0]["IsAndOr"].ToString() == "3") { processIsEnd = true; Sql = ""; // 1 2 3 null Sql = $"select count(*) from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and ApprovalStatus='0' and BillClassId='{traApprClass.BillClassId}'"; //当前节点未完成 if (SqlHelper.GetValue(Sql).ToString() != "0") { if (IsLocalHost == "0") { processIsEnd = false; result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog(logType, "\r\n返回前端信息:" + result + "\r\n"); //context.Response.Write(result); } else { processIsEnd = false; result = JsonConvert.SerializeObject(new ResultGetMulParams { errcode = "0", errmsg = "", NextUrl = "" }); ToolsClass.TxtLog(logType, "\r\n返回前端信息:" + result + "\r\n"); // context.Response.Write(result); } return(processIsEnd); } else { Sql = ""; Sql = $"update ApprovalComments set ApprovalStatus='1',ApprovalComments='工号为{userXqClass.jobnumber}的审批人已签',ApprovalDate='{DateTime.Now}' where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and BillClassId='{traApprClass.BillClassId}' and ApprovalStatus='0'"; SqlHelper.ExecSql(Sql); } ToolsClass.TxtLog(logType, "\r\n操作ApprovalComments表:" + Sql + "\r\n"); } } //如果不是领导 if (IsLeader.Rows[0]["IsLeader"].ToString() != "1") { if (IsLeader.Rows[0]["IsAndOr"].ToString() == "1" || IsLeader.Rows[0]["IsAndOr"].ToString() == "2") { Sql = ""; // 1 2 3 null Sql = $"select count(*) from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and ApprovalStatus='0' and BillClassId='{traApprClass.BillClassId}'"; //当前节点未完成 if (SqlHelper.GetValue(Sql).ToString() != "0") { if (IsLocalHost == "0") { processIsEnd = false; result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog(logType, "\r\n返回前端信息:" + result + "\r\n"); //context.Response.Write(result); } else { processIsEnd = false; result = JsonConvert.SerializeObject(new ResultGetMulParams { errcode = "0", errmsg = "", NextUrl = "" }); ToolsClass.TxtLog(logType, "\r\n返回前端信息:" + result + "\r\n"); //context.Response.Write(result); } return(processIsEnd); } else { processIsEnd = true; } } else if (IsLeader.Rows[0]["IsAndOr"].ToString() == "3") { processIsEnd = true; Sql = ""; // 1 2 3 null Sql = $"select count(*) from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and ApprovalStatus='0' and BillClassId='{traApprClass.BillClassId}'"; //当前节点未完成 if (SqlHelper.GetValue(Sql).ToString() != "0") { if (IsLocalHost == "0") { processIsEnd = false; result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog(logType, "\r\n返回前端信息:" + result + "\r\n"); // context.Response.Write(result); } else { processIsEnd = false; result = JsonConvert.SerializeObject(new ResultGetMulParams { errcode = "0", errmsg = "", NextUrl = "" }); ToolsClass.TxtLog(logType, "\r\n返回前端信息:" + result + "\r\n"); // context.Response.Write(result); } return(processIsEnd); } else { Sql = ""; Sql = $"update ApprovalComments set ApprovalStatus='1',ApprovalComments='工号为{userXqClass.jobnumber}的审批人已签',ApprovalDate='{DateTime.Now}' where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and BillClassId='{traApprClass.BillClassId}' and ApprovalStatus='0'"; SqlHelper.ExecSql(Sql); } ToolsClass.TxtLog(logType, "\r\n操作ApprovalComments表:" + Sql + "\r\n"); } else { processIsEnd = true; } } return(processIsEnd); }
private string ddUrl = ""; //钉钉前端地址 public void ProcessRequest(HttpContext context) { //判断客户端请求是否为post方法 if (context.Request.HttpMethod.ToUpper() != "POST") { context.Response.Write("{\"errmsg\":\"请求方式不允许,请使用POST方式(DD0001)\",\"errcode\":1}"); return; } string ymadk = System.Configuration.ConfigurationManager.AppSettings["ymadk"].ToString() + "/"; //数据库链接 connectionString = ToolsClass.GetConfig("DataOnLine"); //sqlServer da = new DbHelper.SqlHelper("SqlServer", connectionString); SqlHelper = new BankDbHelper.SqlHelper("SqlServer", connectionString); string signUrl = ToolsClass.GetConfig("signUrl"); context.Response.ContentType = "text/plain"; //获取请求json using (var reader = new StreamReader(context.Request.InputStream, Encoding.UTF8)) { CsJson = reader.ReadToEnd(); } GetMulParams getMulParams = new GetMulParams(); string result = string.Empty; if (CsJson == "") { context.Response.Write("{\"errmsg\":\"报文格式错误(DD0003)\",\"errcode\":1}"); return; } CsJson = Regex.Replace(CsJson, @"[\n\r]", "").Replace(@"\n", ",").Replace("'", "‘").Replace("\t", ":").Replace("\r", ",").Replace("\n", ","); //#微应用ID:agentId #企业ID:corpId #应用的唯一标识:appKey #应用的密钥:appSecret AppWyy = ToolsClass.GetConfig("AppWyy"); ScList = AppWyy.Split('$'); agentId = ScList[0].ToString(); corpId = ScList[1].ToString(); appKey = ScList[2].ToString(); appSecret = ScList[3].ToString(); isWrite = ToolsClass.GetConfig("isWrite"); ddUrl = ToolsClass.GetConfig("ddUrl"); if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n申请审批入参:" + CsJson + "\r\n"); } //前端传入数据 TravelApprovalMul traApprClass = new TravelApprovalMul(); traApprClass = (TravelApprovalMul)JsonConvert.DeserializeObject(CsJson, typeof(TravelApprovalMul)); string path = context.Request.Path.Replace("Approval/TSPM.ashx", "tasp"); //验证请求sign string sign = ToolsClass.md5(signUrl + path + "Romens1/DingDing2" + path, 32); ToolsClass.TxtLog("生成的sign", "生成的" + sign + "传入的sign" + traApprClass.Sign + "\r\n 后台字符串:" + signUrl + path + "Romens1/DingDing2" + path); if (sign != traApprClass.Sign) { context.Response.Write("{\"errmsg\":\"认证信息Sign不存在或者不正确!\",\"errcode\":1}"); return; } try { #region 获取access_token url = "https://oapi.dingtalk.com/gettoken?appkey=" + appKey + "&appsecret=" + appSecret; FhJson = ToolsClass.ApiFun("GET", url, ""); TokenClass tokenClass = new TokenClass(); tokenClass = (TokenClass)JsonConvert.DeserializeObject(FhJson, typeof(TokenClass)); access_token = tokenClass.access_token; errcode = tokenClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取ACCESS_TOKEN报错(DD0004)\",\"errcode\":1}"); return; } #endregion 获取access_token #region 获取用户详情 url = "https://oapi.dingtalk.com/user/get?access_token=" + access_token + "&userid=" + traApprClass.DDAuditingId; FhJson = ToolsClass.ApiFun("GET", url, ""); GetUserXq userXqClass = new GetUserXq(); userXqClass = (GetUserXq)JsonConvert.DeserializeObject(FhJson, typeof(GetUserXq)); errcode = userXqClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取审批人详细信息报错(DD6003)\",\"errcode\":1}"); return; } audiName = userXqClass.name; #endregion 获取用户详情 #region 获取用户guid Sql = "select top 1 a.guid,b.StartDate,b.EndDate from FlowEmployee a left join (select convert(varchar(20), min(b.StartDate), 23) StartDate,convert(varchar(20), max(EndDate), 23) EndDate from TravelReq a left join TravelReqDetail b on a.billno = b.billno where a.billno = '" + traApprClass.BillNo + "' group by a.billno) b on 1 = 1 where a.employeecode = '" + userXqClass.jobnumber + "'"; obj = da.GetDataTable(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"用户不存在(DD9002)\",\"errcode\":1}"); return; } dt = obj as DataTable; if (dt.Rows.Count == 0) { context.Response.Write("{\"errmsg\":\"申请信息不存在(DD9003)\",\"errcode\":1}"); return; } AuditingGuid = dt.Rows[0]["guid"].ToString(); #endregion 获取用户guid //判断当前是流程节点中的哪个流程 Sql = $"select count( DISTINCT NodeNumber) NodeNumber from ApprovalComments where BillNo ='{traApprClass.BillNo}'"; //得到当前流程节点的数量 string nodeNumber = da.GetValue(Sql).ToString(); //得到当前流程信息 NodeInfo[] NodeInfo = (NodeInfo[])JsonConvert.DeserializeObject(da.GetValue($"select ProcessNodeInfo from TravelReq where BillNo='{traApprClass.BillNo}'").ToString(), typeof(NodeInfo[])); XXTZ xxtzClass2 = new XXTZ(); StringBuilder piddept = new StringBuilder(); string sql = ""; DataTable logComments = new DataTable(); StringBuilder logcoments = new StringBuilder(); if (traApprClass.IsAuditing == "1") { audiIdea = "同意"; } else if (traApprClass.IsAuditing == "2") { audiIdea = "驳回"; } else { audiIdea = "抄送"; } //如果审批人意见为同意 if (audiIdea == "同意" || audiIdea == "抄送") { //将意见及日期保存到ApprovalComments表,并改变状态 Sql = ""; Sql = $"update ApprovalComments set ApprovalComments='{traApprClass.AuditingIdea}',Urls='{JsonConvert.SerializeObject(traApprClass.Urls)}',ApprovalStatus='{traApprClass.IsAuditing}',ApprovalDate='{DateTime.Now}' where BillNo ='{traApprClass.BillNo}' and ApprovalID='{userXqClass.jobnumber}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and BillClassId='{traApprClass.BillClassId}'"; da.ExecSql(Sql); if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n操作ApprovalComments表:" + Sql + "\r\n"); } bool processIsEnd = false; //判断当前节点是领导还是非领导 Sql = ""; // 1 2 3 null Sql = $"select distinct IsLeader IsLeader, IsAndOr IsAndOr from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and BillClassId='{traApprClass.BillClassId}'"; DataTable IsLeader = da.GetDataTable(Sql); if (IsLeader.Rows[0]["IsLeader"].ToString() == "1") { //领导为一次审批或者会签 if (IsLeader.Rows[0]["IsAndOr"].ToString() == "1" || IsLeader.Rows[0]["IsAndOr"].ToString() == "2") { Sql = ""; // 1 2 3 null Sql = $"select count(*) from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and ApprovalStatus='0' and BillClassId='{traApprClass.BillClassId}'"; //当前节点未完成 if (da.GetValue(Sql).ToString() != "0") { processIsEnd = false; result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); return; } else { processIsEnd = true; } } //领导为或签 else if (IsLeader.Rows[0]["IsAndOr"].ToString() == "3") { processIsEnd = true; Sql = ""; // 1 2 3 null Sql = $"select count(*) from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and ApprovalStatus='0' and BillClassId='{traApprClass.BillClassId}'"; //当前节点未完成 if (da.GetValue(Sql).ToString() != "0") { processIsEnd = false; result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); return; } else { Sql = ""; Sql = $"update ApprovalComments set ApprovalStatus='1',ApprovalComments='工号为{userXqClass.jobnumber}的审批人已签',ApprovalDate='{DateTime.Now}' where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and BillClassId='{traApprClass.BillClassId}' and ApprovalStatus='0'"; da.ExecSql(Sql); } if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n操作ApprovalComments表:" + Sql + "\r\n"); } } } //如果不是领导 if (IsLeader.Rows[0]["IsLeader"].ToString() != "1") { if (IsLeader.Rows[0]["IsAndOr"].ToString() == "1" || IsLeader.Rows[0]["IsAndOr"].ToString() == "2") { Sql = ""; // 1 2 3 null Sql = $"select count(*) from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and ApprovalStatus='0' and BillClassId='{traApprClass.BillClassId}'"; //当前节点未完成 if (da.GetValue(Sql).ToString() != "0") { processIsEnd = false; result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); return; } else { processIsEnd = true; } } else if (IsLeader.Rows[0]["IsAndOr"].ToString() == "3") { processIsEnd = true; Sql = ""; // 1 2 3 null Sql = $"select count(*) from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and ApprovalStatus='0' and BillClassId='{traApprClass.BillClassId}'"; //当前节点未完成 if (da.GetValue(Sql).ToString() != "0") { processIsEnd = false; result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); return; } else { Sql = ""; Sql = $"update ApprovalComments set ApprovalStatus='1',ApprovalComments='工号为{userXqClass.jobnumber}的审批人已签',ApprovalDate='{DateTime.Now}' where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and BillClassId='{traApprClass.BillClassId}' and ApprovalStatus='0'"; da.ExecSql(Sql); } if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n操作ApprovalComments表:" + Sql + "\r\n"); } } else { processIsEnd = true; } } //可以给下个人发送消息 if (processIsEnd) //如果当前流程节点走完 { //判断当前单号是否已经结束 sql = ""; sql = $"select IsAuditing from TravelReq where BillNo ='{traApprClass.BillNo}'"; if (da.GetValue(sql).ToString() != "0") { result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); return; } //判断是否是根结点,判断数量(去重)是否小于流程的长度 //是否是最后一个流程 // if (int.Parse(nodeNumber) < NodeInfo.Length && da.GetValue($"select count(*) from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and ApprovalStatus='0' and BillClassId='{traApprClass.BillClassId}'").ToString() != "0") if (int.Parse(nodeNumber) < NodeInfo.Length) { //获取下个节点的人员信息 NodeInfoDetailPerson[] NodeInfodetailPeople = NodeInfo[int.Parse(nodeNumber)].NodeInfoDetails[0].Persons; for (int i = 0; i < NodeInfodetailPeople.Length; i++) { if (i > 0) { piddept.Append(","); } //判断传空 if (NodeInfodetailPeople[i].PersonId != "") { sql = ""; sql = $"select distinct DDId from FlowEmployee where EmployeeCode ='{NodeInfodetailPeople[i].PersonId}'"; piddept.Append(da.GetValue(sql).ToString()); } } //插入相应的信息到comments表中 sqlList.Clear(); for (int i = 0; i < NodeInfodetailPeople.Length; i++) { sqlTou.Clear(); sqlTou.Append("insert into ApprovalComments(CommentsId,BillClassId,BillNo,ApprovalID,ApprovalName,ApprovalComments,ApprovalStatus,AType,ApprovalDate,IsAndOr,IsLeader,PersonType,NodeNumber) values('") .Append(Guid.NewGuid().ToString()).Append("','") .Append(traApprClass.BillClassId).Append("','") .Append(traApprClass.BillNo).Append("','") .Append(NodeInfodetailPeople[i].PersonId).Append("','") .Append(NodeInfodetailPeople[i].PersonName).Append("','")//内部数据库用户GUID .Append("").Append("','") .Append("0").Append("','") .Append(NodeInfodetailPeople[i].AType).Append("','") .Append(DateTime.Now).Append("','") .Append(NodeInfo[int.Parse(nodeNumber)].NodeInfoDetails[0].IsAndOr).Append("','") .Append(NodeInfo[int.Parse(nodeNumber)].NodeInfoDetails[0].IsLeader).Append("','") .Append(NodeInfo[int.Parse(nodeNumber)].NodeInfoType).Append("','") .Append(int.Parse(nodeNumber) + 2).Append("')"); sqlList.Add(sqlTou.ToString()); if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n操作ApprovalComments表:" + sqlTou.ToString() + "\r\n"); } } //执行SQL语句Insert obj = da.ExecSql(sqlList); if (obj == null) { context.Response.Write("{\"errmsg\":\"保存出差申请节点信息出错(DD6002)\",\"errcode\":1}"); return; } //给申请人发送审批意见 给下个节点的人员发送目前为止的审批状态及意见,给之前的人也发 //获取现在的审批意见 sql = ""; sql = $"select ApprovalComments,ApprovalName,ApprovalID from ApprovalComments where BillNo ='{traApprClass.BillNo}' and BillClassId='{traApprClass.BillClassId}'"; logComments = da.GetDataTable(sql); //"【出差】\r\n审批意见: " + traApprClass.AuditingIdea + "\"}}}"; for (int i = 0; i < logComments.Rows.Count; i++) { if (i > 0) { logcoments.Append(","); } //piddept.Append(","); sql = ""; sql = $"select distinct DDId from FlowEmployee where EmployeeCode ='{logComments.Rows[i]["ApprovalID"].ToString()}'"; //piddept.Append(da.GetValue(sql).ToString()); logcoments.Append(logComments.Rows[i]["ApprovalName"].ToString() + ":" + logComments.Rows[i]["ApprovalComments"].ToString()); } urlcsjson = ddUrl + $"/shenpi/index.html?billno={traApprClass.BillNo}&BillClassId={traApprClass.BillClassId}&showmenu=false"; urlcsjson = HttpUtility.UrlEncode(urlcsjson, System.Text.Encoding.UTF8); CsJson = "{\"agent_id\":\"" + agentId + "\",\"userid_list\":\"" + piddept.ToString() + "," + traApprClass.DDOperatorId + "\",\"msg\":{\"msgtype\":\"link\",\"link\":{\"messageUrl\":\"" + "dingtalk://dingtalkclient/page/link?url=" + urlcsjson + "&pc_slide=true\",\"picUrl\":\"@\",\"title\":\"已" + audiIdea + "【" + audiName + "】\",\"text\":\"出发日期: " + dt.Rows[0]["StartDate"].ToString() + "\r\n申请人: " + traApprClass.OperatorName + "【出差】\r\n审批意见: " + logcoments.ToString() + "\"}}}"; url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; FhJson = ToolsClass.ApiFun("POST", url, CsJson); if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n发送通知出入参:" + CsJson + "\r\n出参:" + FhJson); } xxtzClass2 = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); errcode = xxtzClass2.errcode; if (errcode != 0) { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n多级流程出差审批发送通知失败" + "钉钉id不正确!"); context.Response.Write("{\"errmsg\":\"您的出差申请消息通知失败(DD6004)\",\"errcode\":1}"); return; } TaskFactory taskFactory = new TaskFactory(); //如果下个是抄送人 if (NodeInfo[int.Parse(nodeNumber)].NodeInfoType == "3") { //根据数据开启多个线程调用审批接口 taskFactory.StartNew(() => { for (int i = 0; i < NodeInfodetailPeople.Length; i++) { HttpWebRequest webrequest = (HttpWebRequest)WebRequest.Create(ymadk + "tasp"); webrequest.Method = "post"; new Action(() => { fasongqingqiu ad = new fasongqingqiu { BillNo = traApprClass.BillNo, DDAuditingId = da.GetValue($"select distinct ddid from FlowEmployee where employeecode='{NodeInfodetailPeople[i].PersonId}'").ToString(), IsAuditing = "3", DDOperatorId = traApprClass.DDOperatorId, OperatorName = traApprClass.OperatorName, BillClassId = traApprClass.BillClassId , Sign = sign }; byte[] postdatabyte = Encoding.UTF8.GetBytes(JsonConvert.SerializeObject(ad)); webrequest.ContentLength = postdatabyte.Length; Stream stream; stream = webrequest.GetRequestStream(); stream.Write(postdatabyte, 0, postdatabyte.Length); stream.Close(); using (var httpWebResponse = webrequest.GetResponse()) using (StreamReader responseStream = new StreamReader(httpWebResponse.GetResponseStream())) { String ret = responseStream.ReadToEnd(); } }).Invoke(); } }); } if (NodeInfo[int.Parse(nodeNumber)].NodeInfoType == "2") { DataRow[] dataRows = null; sql = ""; sql = $"select ApprovalComments,ApprovalName,ApprovalID from ApprovalComments where BillNo ='{traApprClass.BillNo}' and BillClassId='{traApprClass.BillClassId}' and ApprovalStatus ='1'"; logComments = da.GetDataTable(sql); //如果下个环节中的人在之前已同意,自动调用此接口同意完成审批 taskFactory.StartNew(() => { for (int i = 0; i < NodeInfodetailPeople.Length; i++) { dataRows = logComments.Select("ApprovalID ='" + NodeInfodetailPeople[i].PersonId + "'"); if (dataRows.Length != 0 || da.GetValue($"select distinct DDId from FlowEmployee where EmployeeCode ='{NodeInfodetailPeople[i].PersonId}'").ToString() == traApprClass.DDOperatorId) { HttpWebRequest webrequest = (HttpWebRequest)WebRequest.Create(ymadk + "tasp"); webrequest.Method = "post"; new Action(() => { fasongqingqiu ad = new fasongqingqiu { BillNo = traApprClass.BillNo, DDAuditingId = da.GetValue($"select distinct ddid from FlowEmployee where employeecode='{NodeInfodetailPeople[i].PersonId}'").ToString(), IsAuditing = "1", DDOperatorId = traApprClass.DDOperatorId, OperatorName = traApprClass.OperatorName, BillClassId = traApprClass.BillClassId, AuditingIdea = "同意", Sign = sign }; byte[] postdatabyte = Encoding.UTF8.GetBytes(JsonConvert.SerializeObject(ad)); webrequest.ContentLength = postdatabyte.Length; Stream stream; stream = webrequest.GetRequestStream(); stream.Write(postdatabyte, 0, postdatabyte.Length); stream.Close(); using (var httpWebResponse = webrequest.GetResponse()) using (StreamReader responseStream = new StreamReader(httpWebResponse.GetResponseStream())) { String ret = responseStream.ReadToEnd(); } }).Invoke(); } } }); } } //如果是最后一级 //给申请人发送审批意见 给之前的人发 //获取现在的审批意见 else { //更新单据消息id与返回内容 Sql = "update TravelReq set isauditing='1',auditingdate=getdate() where billno='" + traApprClass.BillNo + "'"; if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n操作TravelReq表:" + Sql.ToString() + "\r\n"); } obj = da.ExecSql(Sql); sql = $"select ApprovalComments,ApprovalName,ApprovalID from ApprovalComments where BillNo ='{traApprClass.BillNo}' and BillClassId='{traApprClass.BillClassId}'"; logComments = da.GetDataTable(sql); //"【出差】\r\n审批意见: " + traApprClass.AuditingIdea + "\"}}}"; for (int i = 0; i < logComments.Rows.Count; i++) { if (i > 0) { logcoments.Append(","); //piddept.Append(","); } sql = ""; sql = $"select distinct DDId from FlowEmployee where EmployeeCode ='{logComments.Rows[i]["ApprovalID"].ToString()}'"; //piddept.Append(da.GetValue(sql).ToString()); logcoments.Append(logComments.Rows[i]["ApprovalName"].ToString() + ":" + logComments.Rows[i]["ApprovalComments"].ToString()); } urlcsjson = ddUrl + $"/shenpi/index.html?billno={traApprClass.BillNo}&BillClassId={traApprClass.BillClassId}&showmenu=false"; urlcsjson = HttpUtility.UrlEncode(urlcsjson, System.Text.Encoding.UTF8); CsJson = "{\"agent_id\":\"" + agentId + "\",\"userid_list\":\"" + piddept.ToString() + "," + traApprClass.DDOperatorId + "\",\"msg\":{\"msgtype\":\"link\",\"link\":{\"messageUrl\":\"" + "dingtalk://dingtalkclient/page/link?url=" + urlcsjson + "&pc_slide=true\",\"picUrl\":\"@\",\"title\":\"已" + audiIdea + "【" + audiName + "】\",\"text\":\"出发日期: " + dt.Rows[0]["StartDate"].ToString() + "\r\n申请人: " + traApprClass.OperatorName + "【出差】\r\n审批意见: " + logcoments.ToString() + "\"}}}"; url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; FhJson = ToolsClass.ApiFun("POST", url, CsJson); if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n发送通知出入参=>CsJson:" + CsJson + "\r\n出参:" + FhJson); } xxtzClass2 = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); errcode = xxtzClass2.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"您的出差申请消息通知失败(DD6004)\",\"errcode\":1}"); return; } } } result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); return; } //如果是已驳回,给操作人发送通知,将意见及日期保存到ApprovalComments表,并改变状态,,改变出差申请表中的状态,改为2,代表已驳回 if (audiIdea == "驳回") { //将意见及日期保存到ApprovalComments表,并改变状态 Sql = ""; Sql = $"update ApprovalComments set ApprovalComments='{traApprClass.AuditingIdea}',Urls='{JsonConvert.SerializeObject(traApprClass.Urls)}',ApprovalStatus='{traApprClass.IsAuditing}',ApprovalDate='{DateTime.Now}' where BillNo ='{traApprClass.BillNo}' and ApprovalID='{userXqClass.jobnumber}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and BillClassId='{traApprClass.BillClassId}'"; da.ExecSql(Sql); if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n操作ApprovalComments表:" + Sql + "\r\n"); } bool processIsEnd = false; //判断当前节点是领导还是非领导 Sql = ""; // 1 2 3 null Sql = $"select distinct IsLeader IsLeader, IsAndOr IsAndOr from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and BillClassId='{traApprClass.BillClassId}'"; DataTable IsLeader = da.GetDataTable(Sql); if (IsLeader.Rows[0]["IsLeader"].ToString() == "1") { //领导为依次审批或者会签 if (IsLeader.Rows[0]["IsAndOr"].ToString() == "1" || IsLeader.Rows[0]["IsAndOr"].ToString() == "2") { processIsEnd = true; } //领导为或签 else { Sql = ""; // 1 2 3 null Sql = $"select count(*) from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and ApprovalStatus='0' and BillClassId='{traApprClass.BillClassId}'"; //当前节点未完成 if (da.GetValue(Sql).ToString() != "0") { processIsEnd = false; result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); return; } else { processIsEnd = true; } if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n操作ApprovalComments表:" + Sql + "\r\n"); } } } //如果不是领导 if (IsLeader.Rows[0]["IsLeader"].ToString() != "1") { if (IsLeader.Rows[0]["IsAndOr"].ToString() == "1" || IsLeader.Rows[0]["IsAndOr"].ToString() == "2") { processIsEnd = true; } else { Sql = ""; // 1 2 3 null Sql = $"select count(*) from ApprovalComments where BillNo ='{traApprClass.BillNo}' and NodeNumber ='{int.Parse(nodeNumber) + 1}' and ApprovalStatus='0' and BillClassId='{traApprClass.BillClassId}'"; //当前节点未完成 if (da.GetValue(Sql).ToString() != "0") { processIsEnd = false; result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); return; } else { processIsEnd = true; } if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n操作ApprovalComments表:" + Sql + "\r\n"); } } } if (processIsEnd) { //更新单据消息id与返回内容 Sql = "update TravelReq set isauditing='2',auditingdate=getdate() where billno='" + traApprClass.BillNo + "'"; if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n操作TravelReq表:" + Sql.ToString() + "\r\n"); } obj = da.ExecSql(Sql); //给当前节点以前的人及申请人发送通知,通知已驳回,并改变出差申请表中的状态 sql = ""; sql = $"select ApprovalComments,ApprovalName,ApprovalID from ApprovalComments where BillNo ='{traApprClass.BillNo}' and BillClassId='{traApprClass.BillClassId}'"; logComments = da.GetDataTable(sql); //"【出差】\r\n审批意见: " + traApprClass.AuditingIdea + "\"}}}"; for (int i = 0; i < logComments.Rows.Count; i++) { if (i > 0) { logcoments.Append(","); //piddept.Append(","); } sql = ""; sql = $"select distinct DDId from FlowEmployee where EmployeeCode ='{logComments.Rows[i]["ApprovalID"].ToString()}'"; //piddept.Append(da.GetValue(sql).ToString()); logcoments.Append(logComments.Rows[i]["ApprovalName"].ToString() + ":" + logComments.Rows[i]["ApprovalComments"].ToString()); } urlcsjson = ddUrl + $"/shenpi/index.html?billno={traApprClass.BillNo}&BillClassId={traApprClass.BillClassId}&showmenu=false"; urlcsjson = HttpUtility.UrlEncode(urlcsjson, System.Text.Encoding.UTF8); CsJson = "{\"agent_id\":\"" + agentId + "\",\"userid_list\":\"" + piddept.ToString() + "," + traApprClass.DDOperatorId + "\",\"msg\":{\"msgtype\":\"link\",\"link\":{\"messageUrl\":\"" + "dingtalk://dingtalkclient/page/link?url=" + urlcsjson + "&pc_slide=true\",\"picUrl\":\"@\",\"title\":\"已" + audiIdea + "【" + audiName + "】\",\"text\":\"出发日期: " + dt.Rows[0]["StartDate"].ToString() + "\r\n申请人: " + traApprClass.OperatorName + "【出差】\r\n审批意见: " + logcoments.ToString() + "\"}}}"; url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; FhJson = ToolsClass.ApiFun("POST", url, CsJson); if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n发送通知出入参=>CsJson:" + CsJson + "\r\n出参:" + FhJson); } xxtzClass2 = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); errcode = xxtzClass2.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"您的出差申请消息通知失败(DD6004)\",\"errcode\":1}"); return; } result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); return; } } } catch (Exception ex) { context.Response.Write("{\"errmsg\":\"" + ex.Message + "(DD0005)\",\"errcode\":1}"); context.Response.End(); } }
private string ddUrl = ""; //钉钉前端地址 public void ProcessRequest(HttpContext context) { //判断客户端请求是否为post方法 if (context.Request.HttpMethod.ToUpper() != "POST") { context.Response.Write("{\"errmsg\":\"请求方式不允许,请使用POST方式(DD0001)\",\"errcode\":1}"); return; } string signUrl = ToolsClass.GetConfig("signUrl"); context.Response.ContentType = "text/plain"; string ymadk = System.Configuration.ConfigurationManager.AppSettings["ymadk"].ToString() + "/"; //数据库链接 connectionString = ToolsClass.GetConfig("DataOnLine"); //sqlServer da = new DbHelper.SqlHelper("SqlServer", connectionString); //获取请求json using (var reader = new StreamReader(context.Request.InputStream, Encoding.UTF8)) { CsJson = reader.ReadToEnd(); } if (CsJson == "") { context.Response.Write("{\"errmsg\":\"报文格式错误(DD0003)\",\"errcode\":1}"); return; } CsJson = Regex.Replace(CsJson, @"[\n\r]", "").Replace(@"\n", ",").Replace("'", "‘").Replace("\t", ":").Replace("\r", ",").Replace("\n", ","); string JsonData = CsJson; //#微应用ID:agentId #企业ID:corpId #应用的唯一标识:appKey #应用的密钥:appSecret AppWyy = ToolsClass.GetConfig("AppWyy"); ScList = AppWyy.Split('$'); agentId = ScList[0].ToString(); corpId = ScList[1].ToString(); appKey = ScList[2].ToString(); appSecret = ScList[3].ToString(); isWrite = ToolsClass.GetConfig("isWrite"); ddUrl = ToolsClass.GetConfig("ddUrl"); if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请日志", "\r\n申请入参:" + CsJson + "\r\n"); } TAMcs tAMcs = new TAMcs(); tAMcs = (TAMcs)JsonConvert.DeserializeObject(CsJson, typeof(TAMcs)); string path = context.Request.Path.Replace("Approval/TAMultistage.ashx", "tam"); //验证请求sign string sign = ToolsClass.md5(signUrl + path + "Romens1/DingDing2" + path, 32); ToolsClass.TxtLog("生成的sign", "生成的" + sign + "传入的sign" + tAMcs.Sign + "\r\n 后台字符串:" + signUrl + path + "Romens1/DingDing2" + path); if (sign != tAMcs.Sign) { context.Response.Write("{\"errmsg\":\"认证信息Sign不存在或者不正确!\",\"errcode\":1}"); return; } //string s = JsonConvert.SerializeObject(tAMcs.NodeInfo); string NodeInfo = JsonConvert.SerializeObject(tAMcs.NodeInfo).Replace(",{\"AType\":\"\",\"PersonId\":\"select\",\"PersonName\":\"请选择\"}", ""); if (tAMcs.Detail.Length <= 0) { context.Response.Write("{\"errmsg\":\"行程不允许为空,请添加行程(DD6001)\",\"errcode\":1}"); return; } try { #region 获取access_token url = "https://oapi.dingtalk.com/gettoken?appkey=" + appKey + "&appsecret=" + appSecret; FhJson = ToolsClass.ApiFun("GET", url, ""); TokenClass tokenClass = new TokenClass(); tokenClass = (TokenClass)JsonConvert.DeserializeObject(FhJson, typeof(TokenClass)); access_token = tokenClass.access_token; errcode = tokenClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取ACCESS_TOKEN报错(DD0004)\",\"errcode\":1}"); return; } #endregion 获取access_token #region 获取用户详情 url = "https://oapi.dingtalk.com/user/get?access_token=" + access_token + "&userid=" + tAMcs.DDOperatorId; FhJson = ToolsClass.ApiFun("GET", url, ""); GetUserXq userXqClass = new GetUserXq(); userXqClass = (GetUserXq)JsonConvert.DeserializeObject(FhJson, typeof(GetUserXq)); errcode = userXqClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取申请人详细信息报错(DD6003)\",\"errcode\":1}"); return; } operatorName = userXqClass.name; #endregion 获取用户详情 #region 获取用户guid Sql = "select top 1 guid from FlowEmployee where employeecode='" + userXqClass.jobnumber + $"' and orgcode='{tAMcs.DeptCode}'"; obj = da.GetValue(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"用户不存在(DD6000)\",\"errcode\":1}"); return; } operatorGuid = obj.ToString(); #endregion 获取用户guid #region 获取申请流水号 Sql = "select dbo.GetBillNo('DDTrvelReq','" + userXqClass.jobnumber + "',getdate())"; obj = da.GetValue(Sql); billno = obj.ToString(); if (billno == "1") { billno = "CL" + userXqClass.jobnumber + DateTime.Now.ToString("yyyyMMdd") + "0001"; Sql = "update BillNumber set MaxNum=1,BillDate=convert(varchar(20),GETDATE(),120) where BillGuid='DDTrvelReq' and BillDate<>convert(varchar(20),GETDATE(),120)"; } else { Sql = "update BillNumber set MaxNum=MaxNum+1,BillDate=convert(varchar(20),GETDATE(),120) where BillGuid='DDTrvelReq'"; } obj = da.ExecSql(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"更新审批信息出错(DD6006)\",\"errcode\":1}"); return; } if (tAMcs.NodeInfo.Length == 0) { //自动同意 #region 保存行程信息 sqlList.Clear(); sqlTou.Clear(); sqlTou.Append("insert into TravelReq(BillNo,TravelReason,Notes,DeptName,DeptCode,DDOperatorId,OperatorGuid,Urls,ProcessNodeInfo,BillDate,IsAuditing,OperatorName,AppendixUrl,PictureUrl) values('").Append(billno).Append("','") .Append(tAMcs.TravelReason).Append("','") .Append(tAMcs.Notes).Append("','") .Append(tAMcs.DeptName).Append("','") .Append(tAMcs.DeptCode).Append("','") .Append(tAMcs.DDOperatorId).Append("','") .Append(operatorGuid).Append("','") //内部数据库用户GUID .Append(JsonConvert.SerializeObject(tAMcs.Urls)).Append("','") .Append(NodeInfo).Append("','") .Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("','") .Append("0").Append("','") .Append(operatorName).Append("','"); if (string.IsNullOrEmpty(tAMcs.AppendixUrl)) { sqlTou.Append("未传").Append("','"); } else { sqlTou.Append(tAMcs.AppendixUrl).Append("','"); } if (string.IsNullOrEmpty(tAMcs.PictureUrl)) { sqlTou.Append("未传").Append("')"); } else { sqlTou.Append(tAMcs.PictureUrl).Append("')"); } sqlList.Add(sqlTou.ToString()); if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请日志", "\r\n操作TravelReq表:" + sqlTou.ToString() + "\r\n"); } sqlTou.Clear(); sqlTou.Append("insert into TravelReqDetail(BillNo,Guid,TranMode,OtherTranMode,IsReturn,DepaCity,DepaCity1,DepaCity2,DestCity,DestCity1,DestCity2,StartDate,EndDate,Hours,Days,BearOrga,CustCode,CustName,Peers,PeersName) values('"); for (int i = 0; i < tAMcs.Detail.Length; i++) { sqlTi.Clear(); sqlTi.Append(sqlTou.ToString()).Append(billno).Append("','") .Append(Guid.NewGuid().ToString()).Append("','") .Append(tAMcs.Detail[i].TranMode).Append("','") .Append(tAMcs.Detail[i].OtherTranMode).Append("','") .Append(tAMcs.Detail[i].IsReturn).Append("','") .Append(tAMcs.Detail[i].DepaCity).Append("','") .Append(tAMcs.Detail[i].DepaCity1).Append("','") .Append(tAMcs.Detail[i].DepaCity2).Append("','") .Append(tAMcs.Detail[i].DestCity).Append("','") .Append(tAMcs.Detail[i].DestCity1).Append("','") .Append(tAMcs.Detail[i].DestCity2).Append("','") .Append(tAMcs.Detail[i].StartDate).Append(":01','") .Append(tAMcs.Detail[i].EndDate).Append(":01','") .Append(tAMcs.Detail[i].Hours).Append("','") .Append(tAMcs.Detail[i].Days).Append("','") .Append(tAMcs.Detail[i].BearOrga).Append("','") .Append(tAMcs.Detail[i].CustCode).Append("','") .Append(tAMcs.Detail[i].CustName).Append("','") .Append(tAMcs.Detail[i].Peers).Append("','") .Append(tAMcs.Detail[i].PeersName).Append("')"); sqlList.Add(sqlTi.ToString()); if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请日志", "操作TravelReq表:" + sqlTi.ToString() + "\r\n"); } } //执行SQL语句Insert obj = da.ExecSql(sqlList); if (obj == null) { context.Response.Write("{\"errmsg\":\"保存出差申请信息出错(DD6002)\",\"errcode\":1}"); return; } #endregion 保存行程信息 Sql = "update TravelReq set isauditing='1',auditingdate=getdate() where billno='" + billno + "'"; if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请审批日志", "\r\n操作TravelReq表:" + Sql.ToString() + "\r\n"); } obj = da.ExecSql(Sql); urlcsjson = ddUrl + $"/shenpi/index.html?billno={billno}&BillClassId={tAMcs.BillClassId}&showmenu=false"; urlcsjson = HttpUtility.UrlEncode(urlcsjson, System.Text.Encoding.UTF8); url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; CsJson = "{\"agent_id\":\"" + agentId + "\",\"userid_list\":\"" + tAMcs.DDOperatorId + "\",\"msg\":{\"msgtype\":\"link\",\"link\":{\"messageUrl\":\"" + "dingtalk://dingtalkclient/page/link?url=" + urlcsjson + "&pc_slide=true\",\"picUrl\":\"@\",\"title\":\"" + operatorName + "的【出差】申请\",\"text\":\"出发日期: " + tAMcs.Detail[0].StartDate.Substring(0, 10) + "\r\n返程日期: " + tAMcs.Detail[0].EndDate.Substring(0, 10) + "\r\n事由: " + tAMcs.TravelReason + "\"}}}"; FhJson = ToolsClass.ApiFun("POST", url, CsJson); context.Response.Write("{\"errmsg\":\"ok\",\"errcode\":0}"); return; } #endregion 获取申请流水号 //获取第一级流程的人员信息 NodeInfoDetailPerson[] NodeInfodetailPeople = tAMcs.NodeInfo[0].NodeInfoDetails[0].Persons; //从入参中得到审批人及抄送人的信息 //指定人员的id列表 StringBuilder piddept = new StringBuilder(); string sql = ""; for (int i = 0; i < NodeInfodetailPeople.Length; i++) { if (i > 0) { piddept.Append(","); } //判断传空 if (NodeInfodetailPeople[i].PersonId != "select" && NodeInfodetailPeople[i].PersonId != "") { sql = $"select distinct DDId from FlowEmployee where EmployeeCode ='{NodeInfodetailPeople[i].PersonId}'"; piddept.Append(da.GetValue(sql).ToString()); } } #region 保存行程信息 sqlList.Clear(); sqlTou.Clear(); sqlTou.Append("insert into TravelReq(BillNo,TravelReason,Notes,DeptName,DeptCode,DDOperatorId,OperatorGuid,JsonData,Urls,ProcessNodeInfo,BillDate,IsAuditing,OperatorName,AppendixUrl,PictureUrl) values('").Append(billno).Append("','") .Append(tAMcs.TravelReason).Append("','") .Append(tAMcs.Notes).Append("','") .Append(tAMcs.DeptName).Append("','") .Append(tAMcs.DeptCode).Append("','") .Append(tAMcs.DDOperatorId).Append("','") .Append(operatorGuid).Append("','") //内部数据库用户GUID .Append(JsonData).Append("','") .Append(JsonConvert.SerializeObject(tAMcs.Urls)).Append("','") .Append(NodeInfo).Append("','") .Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")).Append("','") .Append("0").Append("','") .Append(operatorName).Append("','"); if (string.IsNullOrEmpty(tAMcs.AppendixUrl)) { sqlTou.Append("未传").Append("','"); } else { sqlTou.Append(tAMcs.AppendixUrl).Append("','"); } if (string.IsNullOrEmpty(tAMcs.PictureUrl)) { sqlTou.Append("未传").Append("')"); } else { sqlTou.Append(tAMcs.PictureUrl).Append("')"); } sqlList.Add(sqlTou.ToString()); if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请日志", "\r\n操作TravelReq表:" + sqlTou.ToString() + "\r\n"); } sqlTou.Clear(); sqlTou.Append("insert into TravelReqDetail(BillNo,Guid,TranMode,OtherTranMode,IsReturn,DepaCity,DepaCity1,DepaCity2,DestCity,DestCity1,DestCity2,StartDate,EndDate,Hours,Days,BearOrga,CustCode,CustName,Peers,PeersName) values('"); for (int i = 0; i < tAMcs.Detail.Length; i++) { sqlTi.Clear(); sqlTi.Append(sqlTou.ToString()).Append(billno).Append("','") .Append(Guid.NewGuid().ToString()).Append("','") .Append(tAMcs.Detail[i].TranMode).Append("','") .Append(tAMcs.Detail[i].OtherTranMode).Append("','") .Append(tAMcs.Detail[i].IsReturn).Append("','") .Append(tAMcs.Detail[i].DepaCity).Append("','") .Append(tAMcs.Detail[i].DepaCity1).Append("','") .Append(tAMcs.Detail[i].DepaCity2).Append("','") .Append(tAMcs.Detail[i].DestCity).Append("','") .Append(tAMcs.Detail[i].DestCity1).Append("','") .Append(tAMcs.Detail[i].DestCity2).Append("','") .Append(tAMcs.Detail[i].StartDate).Append(":01','") .Append(tAMcs.Detail[i].EndDate).Append(":01','") .Append(tAMcs.Detail[i].Hours).Append("','") .Append(tAMcs.Detail[i].Days).Append("','") .Append(tAMcs.Detail[i].BearOrga).Append("','") .Append(tAMcs.Detail[i].CustCode).Append("','") .Append(tAMcs.Detail[i].CustName).Append("','") .Append(tAMcs.Detail[i].Peers).Append("','") .Append(tAMcs.Detail[i].PeersName).Append("')"); sqlList.Add(sqlTi.ToString()); if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请日志", "操作TravelReq表:" + sqlTi.ToString() + "\r\n"); } } //执行SQL语句Insert obj = da.ExecSql(sqlList); if (obj == null) { context.Response.Write("{\"errmsg\":\"保存出差申请信息出错(DD6002)\",\"errcode\":1}"); return; } #endregion 保存行程信息 //保存流程信息到comments表 sqlList.Clear(); for (int i = 0; i < NodeInfodetailPeople.Length; i++) { sqlTou.Clear(); if (NodeInfodetailPeople[i].PersonId != "select") { sqlTou.Append("insert into ApprovalComments(CommentsId,BillClassId,BillNo,ApprovalID,ApprovalName,ApprovalComments,ApprovalStatus,AType,ApprovalDate,IsAndOr,IsLeader,PersonType,NodeNumber) values('").Append(Guid.NewGuid().ToString()).Append("','") .Append(tAMcs.BillClassId).Append("','") .Append(billno).Append("','") .Append(NodeInfodetailPeople[i].PersonId).Append("','") .Append(NodeInfodetailPeople[i].PersonName).Append("','")//内部数据库用户GUID .Append("").Append("','") .Append("0").Append("','") .Append(NodeInfodetailPeople[i].AType).Append("','") .Append(DateTime.Now).Append("','") .Append(tAMcs.NodeInfo[0].NodeInfoDetails[0].IsAndOr).Append("','") .Append(tAMcs.NodeInfo[0].NodeInfoDetails[0].IsLeader).Append("','") .Append(tAMcs.NodeInfo[0].NodeInfoType).Append("','") .Append("2").Append("')"); sqlList.Add(sqlTou.ToString()); if (isWrite == "1") { ToolsClass.TxtLog("多级审批出差申请日志", "\r\n操作ApprovalComments表:" + sqlTou.ToString() + "\r\n"); } } } //执行SQL语句Insert obj = da.ExecSql(sqlList); if (obj == null) { context.Response.Write("{\"errmsg\":\"保存出差申请节点信息出错(DD6002)\",\"errcode\":1}"); return; } #region 发送工作通知消息 url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; urlcsjson = ddUrl + $"/shenpi/index.html?billno={billno}&BillClassId={tAMcs.BillClassId}&showmenu=false"; urlcsjson = HttpUtility.UrlEncode(urlcsjson, System.Text.Encoding.UTF8); CsJson = "{\"agent_id\":\"" + agentId + "\",\"userid_list\":\"" + piddept.ToString() + "," + tAMcs.DDOperatorId + "\",\"msg\":{\"msgtype\":\"link\",\"link\":{\"messageUrl\":\"" + "dingtalk://dingtalkclient/page/link?url=" + urlcsjson + "&pc_slide=true\",\"picUrl\":\"@\",\"title\":\"" + operatorName + "的【出差】申请\",\"text\":\"出发日期: " + tAMcs.Detail[0].StartDate.Substring(0, 10) + "\r\n返程日期: " + tAMcs.Detail[0].EndDate.Substring(0, 10) + "\r\n事由: " + tAMcs.TravelReason + "\"}}}"; FhJson = ToolsClass.ApiFun("POST", url, CsJson); ToolsClass.TxtLog("多级审批出差申请日志", "发起申请" + CsJson.ToString() + "\r\n"); XXTZ xxtzClass = new XXTZ(); xxtzClass = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); errcode = xxtzClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"您的出差申请消息通知失败(DD6004)\",\"errcode\":1}"); return; } #endregion 发送工作通知消息 path = context.Request.Path.Replace("Approval/TAMultistage.ashx", "tasp"); //验证请求sign sign = ToolsClass.md5(signUrl + path + "Romens1/DingDing2" + path, 32); TaskFactory taskFactory = new TaskFactory(); if (tAMcs.NodeInfo[0].NodeInfoType == "3") { //根据数据开启多个线程调用审批接口 taskFactory.StartNew(() => { for (int i = 0; i < NodeInfodetailPeople.Length; i++) { HttpWebRequest webrequest = (HttpWebRequest)WebRequest.Create(ymadk + "tasp"); webrequest.Method = "post"; new Action(() => { fasongqingqiu ad = new fasongqingqiu { BillNo = billno, DDAuditingId = da.GetValue($"select distinct ddid from FlowEmployee where employeecode='{NodeInfodetailPeople[i].PersonId}'").ToString(), IsAuditing = "3", DDOperatorId = tAMcs.DDOperatorId, OperatorName = operatorName, BillClassId = tAMcs.BillClassId, Sign = sign }; byte[] postdatabyte = Encoding.UTF8.GetBytes(JsonConvert.SerializeObject(ad)); webrequest.ContentLength = postdatabyte.Length; Stream stream; stream = webrequest.GetRequestStream(); stream.Write(postdatabyte, 0, postdatabyte.Length); stream.Close(); using (var httpWebResponse = webrequest.GetResponse()) using (StreamReader responseStream = new StreamReader(httpWebResponse.GetResponseStream())) { String ret = responseStream.ReadToEnd(); } }).Invoke(); } }); } if (tAMcs.NodeInfo[0].NodeInfoType == "2") { DataRow[] dataRows = null; sql = ""; sql = $"select ApprovalComments,ApprovalName,ApprovalID from ApprovalComments where BillNo ='{billno}' and BillClassId='{tAMcs.BillClassId}' and ApprovalStatus ='1'"; DataTable logComments = da.GetDataTable(sql); //如果下个环节中的人在之前已同意,自动调用此接口同意完成审批 taskFactory.StartNew(() => { for (int i = 0; i < NodeInfodetailPeople.Length; i++) { dataRows = logComments.Select("ApprovalID ='" + NodeInfodetailPeople[i].PersonId + "'"); //如果之前已经同意或者是发起人 if (dataRows.Length != 0 || da.GetValue($"select distinct DDId from FlowEmployee where EmployeeCode ='{NodeInfodetailPeople[i].PersonId}'").ToString() == tAMcs.DDOperatorId) { HttpWebRequest webrequest = (HttpWebRequest)WebRequest.Create(ymadk + "tasp"); webrequest.Method = "post"; new Action(() => { fasongqingqiu ad = new fasongqingqiu { BillNo = billno, DDAuditingId = da.GetValue($"select distinct ddid from FlowEmployee where employeecode='{NodeInfodetailPeople[i].PersonId}'").ToString(), IsAuditing = "1", DDOperatorId = tAMcs.DDOperatorId, OperatorName = operatorName, BillClassId = tAMcs.BillClassId, AuditingIdea = "同意", Sign = sign }; byte[] postdatabyte = Encoding.UTF8.GetBytes(JsonConvert.SerializeObject(ad)); webrequest.ContentLength = postdatabyte.Length; Stream stream; stream = webrequest.GetRequestStream(); stream.Write(postdatabyte, 0, postdatabyte.Length); stream.Close(); using (var httpWebResponse = webrequest.GetResponse()) using (StreamReader responseStream = new StreamReader(httpWebResponse.GetResponseStream())) { String ret = responseStream.ReadToEnd(); } }).Invoke(); } } }); } context.Response.Write("{\"errmsg\":\"ok\",\"errcode\":0}"); return; } catch (Exception ex) { context.Response.Write("{\"errmsg\":\"" + ex.Message + "\",\"errcode\":1}"); context.Response.End(); } }
private string ddUrl = ""; //钉钉前端地址 public void ProcessRequest(HttpContext context) { //判断客户端请求是否为post方法 if (context.Request.HttpMethod.ToUpper() != "POST") { context.Response.Write("{\"errmsg\":\"请求方式不允许,请使用POST方式(DD0001)\",\"errcode\":1}"); return; } string FileUrl = ToolsClass.GetConfig("FileUrl"); GetMulParams getMulParams = new GetMulParams(); string ymadk = System.Configuration.ConfigurationManager.AppSettings["ymadk"].ToString() + "/"; //数据库链接 connectionString = ToolsClass.GetConfig("DataOnLine"); SqlHelper = new BankDbHelper.SqlHelper("SqlServer", connectionString); //获取请求json using (var reader = new StreamReader(context.Request.InputStream, Encoding.UTF8)) { CsJson = reader.ReadToEnd(); } string result = string.Empty; string signUrl = ToolsClass.GetConfig("signUrl"); context.Response.ContentType = "text/plain"; if (CsJson == "") { context.Response.Write("{\"errmsg\":\"报文格式错误(DD0003)\",\"errcode\":1}"); return; } CsJson = Regex.Replace(CsJson, @"[\n\r]", "").Replace(@"\n", ",").Replace("'", "‘").Replace("\t", ":").Replace("\r", ",").Replace("\n", ","); //#微应用ID:agentId #企业ID:corpId #应用的唯一标识:appKey #应用的密钥:appSecret AppWyy = ToolsClass.GetConfig("AppWyy"); ScList = AppWyy.Split('$'); agentId = ScList[0].ToString(); corpId = ScList[1].ToString(); appKey = ScList[2].ToString(); appSecret = ScList[3].ToString(); isWrite = ToolsClass.GetConfig("isWrite"); ddUrl = ToolsClass.GetConfig("ddUrl"); if (isWrite == "1") { ToolsClass.TxtLog("医保及三方授权审批日志", "\r\n申请审批入参:" + CsJson + "\r\n"); } string IsLocalHost = "0"; //前端传入数据 TravelApprovalMul traApprClass = new TravelApprovalMul(); traApprClass = (TravelApprovalMul)JsonConvert.DeserializeObject(CsJson, typeof(TravelApprovalMul)); IsLocalHost = traApprClass.IsLocalHost == null ? "0" : traApprClass.IsLocalHost; string path1 = context.Request.Path.Replace("Approval/MedConfigAuditing.ashx", "medconfigauditing"); //验证请求sign string sign = ToolsClass.md5(signUrl + path1 + "Romens1/DingDing2" + path1, 32); ToolsClass.TxtLog("生成的sign", "生成的" + "sign1:" + sign + "传入的sign" + traApprClass.Sign + "\r\n 后台字符串:" + signUrl + path1 + "Romens1/DingDing2" + path1); if (sign != traApprClass.Sign) { context.Response.Write("{\"errmsg\":\"认证信息Sign不存在或者不正确!\",\"errcode\":1}"); return; } try { if (traApprClass.IsSp == "1") { audiIdea = "同意"; } else if (traApprClass.IsSp == "2") { audiIdea = "驳回"; } else { audiIdea = "抄送"; } billTypeNo = "2018121301"; ProName = "MedConfigAuditing"; typeUrl = ddUrl + "/yibao/shenpi/index.html?billno="; //获取当前单号的发起人和待报销人 string fqrall = traApprClass.DDOperatorId; var fqr = SqlHelper.GetDataTable($"select OperatorGuid,REFERGUID,IsSp from MedConfig where BillNo = '{traApprClass.BillNo}'"); if (traApprClass.DDOperatorId != traApprClass.ReferDDID) { fqrall = fqrall + "," + traApprClass.ReferDDID; } #region 获取access_token url = "https://oapi.dingtalk.com/gettoken?appkey=" + appKey + "&appsecret=" + appSecret; FhJson = ToolsClass.ApiFun("GET", url, ""); TokenClass tokenClass = new TokenClass(); tokenClass = (TokenClass)JsonConvert.DeserializeObject(FhJson, typeof(TokenClass)); access_token = tokenClass.access_token; errcode = tokenClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取ACCESS_TOKEN报错(DD0004)\",\"errcode\":1}"); return; } #endregion 获取access_token #region 获取用户详情 url = "https://oapi.dingtalk.com/user/get?access_token=" + access_token + "&userid=" + traApprClass.DDAuditingId; FhJson = ToolsClass.ApiFun("GET", url, ""); GetUserXq userXqClass = new GetUserXq(); userXqClass = (GetUserXq)JsonConvert.DeserializeObject(FhJson, typeof(GetUserXq)); errcode = userXqClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取审批人详细信息报错(DD6003)\",\"errcode\":1}"); return; } audiName = userXqClass.name; #endregion 获取用户详情 #region 获取用户guid Sql = $"select Guid from operators where code = '[工号]'"; Sql = Sql.Replace("[申请号]", traApprClass.BillNo).Replace("[工号]", userXqClass.jobnumber); obj = SqlHelper.GetDataTable(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"用户不存在(DD6000)\",\"errcode\":1}"); return; } dt = obj as DataTable; AuditingGuid = dt.Rows[0]["Guid"].ToString(); #endregion 获取用户guid if (SqlHelper.GetValue($"select issp from medconfig where billno ='{traApprClass.BillNo}'").ToString() != "0") { context.Response.Write("{\"errmsg\":\"当前单据已经审核,不允许重复审核!\",\"errcode\":1}"); return; } XXTZ xxtzClass2 = new XXTZ(); if (audiIdea == "同意" || audiIdea == "抄送") { bool processIsEnd = true; // processIsEnd = CommonHelper.SaveComments(traApprClass, userXqClass, nodeNumber, context, ddUrl, "医保及三方授权审批日志", out result); //可以给下个人发送消息 if (processIsEnd) //如果当前流程节点走完 { billno = traApprClass.BillNo; keyValuePairs = CommonHelper.sqlPro(SqlHelper.GetValue($"select guid from MedConfig where billno = '{billno}'").ToString(), billTypeNo, AuditingGuid, ProName); if (keyValuePairs["ReturnValue"].ToString() != "0") { ToolsClass.TxtLog("医保及三方授权审批日志", "\r\n调用存储过程失败:" + keyValuePairs["ReturnMsg"].ToString() + "\r\n"); Sql = "update MedConfig set IsSp='0' where billno='" + traApprClass.BillNo + "'"; obj = SqlHelper.ExecSql(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"更新审批状态出错(DD6006)\",\"errcode\":1}"); return; } context.Response.Write("{\"errmsg\":\"" + keyValuePairs["ReturnMsg"].ToString() + "(DD9003)\",\"errcode\":1}"); return; } Sql = $"update MedConfig set IsSp='1',AuditingReason = '{traApprClass.AuditingIdea}' where billno='{traApprClass.BillNo}'"; FhJson = ToolsClass.ApiFun("POST", ymadk + "SetSignFile", "{\"BillNo\":\"" + traApprClass.BillNo + "\"}").Replace(@"\", "/"); FileLocationJson jgobj = (FileLocationJson)JsonConvert.DeserializeObject(FhJson, typeof(FileLocationJson)); ToolsClass.TxtLog("医保及三方授权审批日志", "\r\n操作MedConfig表:" + Sql.ToString() + "\r\n"); obj = SqlHelper.ExecSql(Sql); urlcsjson = typeUrl + traApprClass.BillNo + $"&BillClassId={traApprClass.BillClassId}&showmenu=false"; urlcsjson = HttpUtility.UrlEncode(urlcsjson, System.Text.Encoding.UTF8); DDMsgModelLink link = new DDMsgModelLink { messageUrl = $"dingtalk://dingtalkclient/page/link?url={ urlcsjson}&pc_slide=true", picUrl = "@", text = $"\r\n单号为[{billno}]的单据已同意", title = $"已{audiIdea }【{ audiName }】" }; DDMsgModelLinkMsg dDMsg = new DDMsgModelLinkMsg { link = link, msgtype = "link" }; string ddmsgModel = JsonConvert.SerializeObject(new DDMsgModel { agent_id = agentId, userid_list = fqrall, msg = dDMsg }); url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; FhJson = ToolsClass.ApiFun("POST", url, ddmsgModel); if (isWrite == "1") { ToolsClass.TxtLog("医保及三方授权审批日志", "\r\n审批发送通知Json:" + ddmsgModel + "\r\n返回json:\r\n" + FhJson); } xxtzClass2 = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); errcode = xxtzClass2.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"您的申请消息通知失败(DD6004)\",\"errcode\":1}"); return; } string sqlm = CommonHelper.CreateRandomCode(5); string nowdownurl = FileUrl + jgobj.fileurl; string xzdzqd = ddUrl + "/yibao/download/index.html"; Sql = $"update MedConfig set DownUrlInfo = '{sqlm},{nowdownurl}' where billno='{traApprClass.BillNo}'"; SqlHelper.ExecSql(Sql); DDMsgModelText dDMsgModelText = new DDMsgModelText { agent_id = agentId, userid_list = fqrall, msg = new DDMsgModelTextMsg { msgtype = "text", text = new text { content = "授权文件下载地址,请点击下载:\r\n" + xzdzqd + "\r\n提取验证码: " + sqlm } } }; ddmsgModel = JsonConvert.SerializeObject(dDMsgModelText); url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; FhJson = ToolsClass.ApiFun("POST", url, ddmsgModel); } else { ToolsClass.TxtLog("医保及三方授权审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); return; } //if (IsLocalHost == "0") //{ // result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); // ToolsClass.TxtLog("医保及三方授权审批日志", "\r\n返回前端信息:" + result + "\r\n"); // context.Response.Write(result); //} //else //{ // result = JsonConvert.SerializeObject(new ResultGetMulParams { errcode = "0", errmsg = "", NextUrl = "" }); // ToolsClass.TxtLog("医保及三方授权审批日志", "\r\n返回前端信息:" + result + "\r\n"); // context.Response.Write(result); //} result = JsonConvert.SerializeObject(new ResultGetMulParams { errcode = "0", errmsg = "", NextUrl = "" }); ToolsClass.TxtLog("医保及三方授权审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); return; } if (audiIdea == "驳回") { Sql = $"update MedConfig set IsSp='2',auditingdate=getdate(),AuditingGuid = '{AuditingGuid}',AuditingReason = '{traApprClass.AuditingIdea}' where billno='{traApprClass.BillNo }'"; obj = SqlHelper.ExecSql(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"更新审批信息出错(DD6006)\",\"errcode\":1}"); return; } ToolsClass.TxtLog("医保及三方授权审批日志", "\r\n操作MedConfig表:" + Sql); //给当前节点以前的人及申请人发送通知,通知已驳回 urlcsjson = typeUrl + traApprClass.BillNo + $"&BillClassId={traApprClass.BillClassId}&showmenu=false"; urlcsjson = HttpUtility.UrlEncode(urlcsjson, System.Text.Encoding.UTF8); DDMsgModelLink link = new DDMsgModelLink { messageUrl = $"dingtalk://dingtalkclient/page/link?url={urlcsjson}&pc_slide=true", picUrl = "@", text = $"\r\n单号为【{traApprClass.BillNo}】的单据没有审核通过。\r\n 拒绝原因:{traApprClass.AuditingIdea}。", title = $"已{audiIdea }【{ audiName }】" }; DDMsgModelLinkMsg dDMsg = new DDMsgModelLinkMsg { link = link, msgtype = "link" }; string ddmsgModel = JsonConvert.SerializeObject(new DDMsgModel { agent_id = agentId, userid_list = fqrall, msg = dDMsg }); url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; FhJson = ToolsClass.ApiFun("POST", url, ddmsgModel); if (isWrite == "1") { ToolsClass.TxtLog("医保及三方授权审批日志", "\r\n发送通知出入参Json:" + ddmsgModel); } xxtzClass2 = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); errcode = xxtzClass2.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"您的医保及三方授权消息通知失败(DD6004)\",\"errcode\":1}"); return; } } result = JsonConvert.SerializeObject(new ResultGetMulParams { errcode = "0", errmsg = "", NextUrl = "" }); ToolsClass.TxtLog("医保及三方授权审批日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); //if (IsLocalHost == "0") //{ // result = JsonConvert.SerializeObject(getMulParams.resultGetMulParams(ymadk, traApprClass.DDAuditingId, ddUrl, SqlHelper)); // ToolsClass.TxtLog("医保及三方授权审批日志", "\r\n返回前端信息:" + result + "\r\n"); // context.Response.Write(result); //} //else //{ // result = JsonConvert.SerializeObject(new ResultGetMulParams { errcode = "0", errmsg = "", NextUrl = "" }); // ToolsClass.TxtLog("医保及三方授权审批日志", "\r\n返回前端信息:" + result + "\r\n"); // context.Response.Write(result); //} return; } catch (Exception ex) { context.Response.Write("{\"errmsg\":\"" + ex.Message + "\",\"errcode\":1}"); context.Response.End(); } }
private string ddUrl = ""; //钉钉前端地址 public void ProcessRequest(HttpContext context) { //判断客户端请求是否为post方法 if (context.Request.HttpMethod.ToUpper() != "POST") { context.Response.Write("{\"errmsg\":\"请求方式不允许,请使用POST方式(DD0001)\",\"errcode\":1}"); return; } try { string signUrl = ToolsClass.GetConfig("signUrl"); context.Response.ContentType = "text/plain"; //数据库链接 connectionString = ToolsClass.GetConfig("DataOnLine"); //sqlServer da = new DbHelper.SqlHelper("SqlServer", connectionString); //获取请求json using (var reader = new StreamReader(context.Request.InputStream, Encoding.UTF8)) { CsJson = reader.ReadToEnd(); } if (CsJson == "") { context.Response.Write("{\"errmsg\":\"报文格式错误(DD0003)\",\"errcode\":1}"); return; } CsJson = Regex.Replace(CsJson, @"[\n\r]", "").Replace(@"\n", ",").Replace("'", "‘").Replace("\t", ":").Replace("\r", ",").Replace("\n", ","); //json转Hashtable ToolsClass.TxtLog("GetUser入参", "\r\nGetUser入参:" + CsJson); Object jgobj = ToolsClass.DeserializeObject(CsJson); Hashtable returnhash = jgobj as Hashtable; if (returnhash == null) { context.Response.Write("{\"errmsg\":\"报文格式错误(DD0003)\",\"errcode\":1}"); return; } string path1 = context.Request.Path.Replace("GetUser.ashx", "getuser"); string path2 = context.Request.Path.Replace("GetUser.ashx", "getdepart"); //验证请求sign string sign1 = ToolsClass.md5(signUrl + path1 + "Romens1/DingDing2" + path1, 32); string sign2 = ToolsClass.md5(signUrl + path2 + "Romens1/DingDing2" + path2, 32); ToolsClass.TxtLog("生成的sign", "生成的" + "sign1:" + sign1 + "sign2:" + sign2 + "传入的sign" + returnhash["Sign"].ToString() + "\r\n 后台字符串:" + signUrl + path2 + "Romens1/DingDing2" + path2); if (sign1 != returnhash["Sign"].ToString() && sign2 != returnhash["Sign"].ToString()) { context.Response.Write("{\"errmsg\":\"认证信息Sign不存在或者不正确!\",\"errcode\":1}"); return; } selType = returnhash["TypeId"].ToString(); if (returnhash.Contains("id")) { selId = returnhash["id"].ToString(); if (selId == "") { context.Response.Write("{\"errmsg\":\"ID不允许为空(DD2001)\",\"errcode\":1}"); return; } } //#微应用ID:agentId #企业ID:corpId #应用的唯一标识:appKey #应用的密钥:appSecret AppWyy = ToolsClass.GetConfig("AppWyy"); ScList = AppWyy.Split('$'); agentId = ScList[0].ToString(); corpId = ScList[1].ToString(); appKey = ScList[2].ToString(); appSecret = ScList[3].ToString(); isWrite = ToolsClass.GetConfig("isWrite"); ddUrl = ToolsClass.GetConfig("ddUrl"); //获取access_token url = "https://oapi.dingtalk.com/gettoken?appkey=" + appKey + "&appsecret=" + appSecret; FhJson = ToolsClass.ApiFun("GET", url, ""); TokenClass tokenClass = new TokenClass(); tokenClass = (TokenClass)JsonConvert.DeserializeObject(FhJson, typeof(TokenClass)); access_token = tokenClass.access_token; errcode = tokenClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取ACCESS_TOKEN报错(DD0004)\",\"errcode\":1}"); return; } //取用户信息 if (selType == "SelUser01") { url = "https://oapi.dingtalk.com/user/getuserinfo?access_token=" + access_token + "&code=" + selId; FhJson = ToolsClass.ApiFun("GET", url, ""); //免登授权码 获取用户userid GetUserId userClass = new GetUserId(); userClass = (GetUserId)JsonConvert.DeserializeObject(FhJson, typeof(GetUserId)); errcode = userClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"" + userClass.errmsg + "\",\"errcode\":1}"); return; } //获取用户详情 url = "https://oapi.dingtalk.com/user/get?access_token=" + access_token + "&userid=" + userClass.userid; FhJson = ToolsClass.ApiFun("GET", url, ""); GetUserXq userXqClass = new GetUserXq(); userXqClass = (GetUserXq)JsonConvert.DeserializeObject(FhJson, typeof(GetUserXq)); errcode = userXqClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"" + userClass.errmsg + "\",\"errcode\":1}"); return; } //查询用户信息 sql = "select Top 1 A.GUID OperatorGuid,A.EmployeeCode JobNumber,A.EmployeeName OperatorName,A.OrgCode,b.Name OrgName from FlowEmployee a left join ORGANIZATION b on a.OrgCode=b.Code where a.EmployeeCode='" + userXqClass.jobnumber + "'"; obj = da.GetDataTable(sql); dt = obj as DataTable; if (dt.Rows.Count > 0) { FhJson = "{\"errmsg\":\"ok\",\"errcode\":0,\"userid\":\"" + userClass.userid + "\",\"OperatorGuid\":\"" + dt.Rows[0]["OperatorGuid"].ToString() + "\",\"OperatorName\":\"" + dt.Rows[0]["OperatorName"].ToString() + "\",\"Avatar\":\"" + userXqClass.avatar + "\",\"JobNumber\":\"" + dt.Rows[0]["JobNumber"].ToString() + "\",\"OrgCode\":\"" + dt.Rows[0]["OrgCode"].ToString() + "\",\"OrgName\":\"" + dt.Rows[0]["OrgName"].ToString() + "\"}"; } else { FhJson = "{\"errmsg\":\"当前用户不存在\",\"errcode\":1}"; } } //获取用户详情 else if (selType == "SelUser02") { url = "https://oapi.dingtalk.com/user/get?access_token=" + access_token + "&userid=" + selId; FhJson = ToolsClass.ApiFun("GET", url, ""); } //获取部门用户userid列表 else if (selType == "SelUser03") { url = "https://oapi.dingtalk.com/user/getDeptMember?access_token=" + access_token + "&deptId=" + selId; FhJson = ToolsClass.ApiFun("GET", url, ""); } //获取部门用户列表 else if (selType == "SelUser04") { url = "https://oapi.dingtalk.com/user/simplelist?access_token=" + access_token + "&department_id=" + selId; FhJson = ToolsClass.ApiFun("GET", url, ""); } //获取部门用户详情 else if (selType == "SelUser05") { url = "https://oapi.dingtalk.com/user/listbypage?access_token=" + access_token + "&department_id=" + selId + "&offset=0&size=10"; FhJson = ToolsClass.ApiFun("GET", url, ""); } //获取管理员列表 else if (selType == "SelUser06") { url = "https://oapi.dingtalk.com/user/get_admin?access_token=" + access_token; FhJson = ToolsClass.ApiFun("GET", url, ""); } //获取管理员通讯录权限范围 else if (selType == "SelUser07") { url = "https://oapi.dingtalk.com/topapi/user/get_admin_scope?access_token=" + access_token + "&userid=" + selId; FhJson = ToolsClass.ApiFun("GET", url, ""); } //获取子部门ID列表 else if (selType == "SelDepart01") { url = "https://oapi.dingtalk.com/department/list_ids?access_token=" + access_token + "&id=" + selId; FhJson = ToolsClass.ApiFun("GET", url, ""); } //获取部门列表 else if (selType == "SelDepart02") { url = "https://oapi.dingtalk.com/department/list?access_token=" + access_token + "&id=" + selId; FhJson = ToolsClass.ApiFun("GET", url, ""); } //获取部门详情 else if (selType == "SelDepart03") { url = "https://oapi.dingtalk.com/department/get?access_token=" + access_token + "&id=" + selId; FhJson = ToolsClass.ApiFun("GET", url, ""); } //查询部门的所有上级父部门 else if (selType == "SelDepart04") { url = "https://oapi.dingtalk.com/department/list_parent_depts_by_dept?access_token=" + access_token + "&id=" + selId; FhJson = ToolsClass.ApiFun("GET", url, ""); } //获取企业员工人数 else if (selType == "SelDepart05") { //onlyActive 0:包含未激活钉钉的人员数量 1:不包含未激活钉钉的人员数量 url = "https://oapi.dingtalk.com/user/get_org_user_count?access_token=" + access_token + "&onlyActive=" + selId; FhJson = ToolsClass.ApiFun("GET", url, ""); } else { context.Response.Write("{\"errmsg\":\"查询其他信息请关机(DD1003)\",\"errcode\":1}"); return; } ToolsClass.TxtLog("GetUser", "\r\n返给前端json:" + FhJson); context.Response.Write(FhJson); return; } catch (Exception ex) { context.Response.Write("{\"errmsg\":\"" + ex.Message + "\",\"errcode\":1}"); return; } }
public void ProcessRequest(HttpContext context) { //判断客户端请求是否为post方法 if (context.Request.HttpMethod.ToUpper() != "POST") { context.Response.Write("{\"errmsg\":\"请求方式不允许,请使用POST方式(DD0001)\",\"errcode\":1}"); return; } string ymadk = System.Configuration.ConfigurationManager.AppSettings["ymadk"].ToString() + "/"; string result = string.Empty; //数据库链接 connectionString = ToolsClass.GetConfig("DataOnLine"); //sqlServer SqlHelper = new BankDbHelper.SqlHelper("SqlServer", connectionString); string signUrl = ToolsClass.GetConfig("signUrl"); context.Response.ContentType = "text/plain"; //获取请求json using (var reader = new StreamReader(context.Request.InputStream, Encoding.UTF8)) { CsJson = reader.ReadToEnd(); } if (CsJson == "") { result = JsonConvert.SerializeObject(new PublicResult { errcode = "1", errmsg = "报文格式错误!" }); context.Response.Write(result); return; } CsJson = Regex.Replace(CsJson, @"[\n\r]", "").Replace(@"\n", ",").Replace("'", "‘").Replace("\t", ":").Replace("\r", ",").Replace("\n", ","); //#微应用ID:agentId #企业ID:corpId #应用的唯一标识:appKey #应用的密钥:appSecret AppWyy = ToolsClass.GetConfig("AppWyy"); ScList = AppWyy.Split('$'); agentId = ScList[0].ToString(); corpId = ScList[1].ToString(); appKey = ScList[2].ToString(); appSecret = ScList[3].ToString(); isWrite = ToolsClass.GetConfig("isWrite"); ddUrl = ToolsClass.GetConfig("ddUrl"); if (isWrite == "1") { ToolsClass.TxtLog("单据付款日志", $"\r\n单据付款入参:{CsJson}\r\n"); } string IsLocalHost = "0"; //前端传入数据 CashierPayModel payModel = new CashierPayModel(); payModel = (CashierPayModel)JsonConvert.DeserializeObject(CsJson, typeof(CashierPayModel)); IsLocalHost = payModel.IsLocalHost == null ? "0" : payModel.IsLocalHost; string path = context.Request.Path.Replace("Approval/CashierPay.ashx", "cashierpay"); //验证请求sign string sign = ToolsClass.md5(signUrl + path + "Romens1/DingDing2" + path, 32); if (sign != payModel.Sign) { context.Response.Write("{\"errmsg\":\"认证信息Sign不存在或者不正确!\",\"errcode\":1}"); return; } GetMulParams getMulParams = new GetMulParams(); try { #region 获取access_token url = "https://oapi.dingtalk.com/gettoken?appkey=" + appKey + "&appsecret=" + appSecret; FhJson = ToolsClass.ApiFun("GET", url, ""); TokenClass tokenClass = new TokenClass(); tokenClass = (TokenClass)JsonConvert.DeserializeObject(FhJson, typeof(TokenClass)); access_token = tokenClass.access_token; errcode = tokenClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取ACCESS_TOKEN报错(DD0004)\",\"errcode\":1}"); return; } #endregion 获取access_token #region 获取用户详情 url = "https://oapi.dingtalk.com/user/get?access_token=" + access_token + "&userid=" + payModel.DDOperatorId; FhJson = ToolsClass.ApiFun("GET", url, ""); GetUserXq userXqClass = new GetUserXq(); userXqClass = (GetUserXq)JsonConvert.DeserializeObject(FhJson, typeof(GetUserXq)); errcode = userXqClass.errcode; if (errcode != 0) { context.Response.Write("{\"errmsg\":\"获取审批人详细信息报错(DD6003)\",\"errcode\":1}"); return; } #endregion 获取用户详情 #region 获取用户guid Sql = $"select top 1 a.GUID,b.TotalAmount,b.OffDay from operators a left join (select sum(TotalAmount) TotalAmount, sum(OffDay) OffDay from ExpetravDetail where billno = '[申请号]' group by billno) b on 1 = 1 where a.code = '[工号]'"; Sql = Sql.Replace("[申请号]", payModel.BillNo).Replace("[工号]", userXqClass.jobnumber); obj = SqlHelper.GetDataTable(Sql); if (obj == null) { context.Response.Write("{\"errmsg\":\"用户不存在(DD6000)\",\"errcode\":1}"); return; } dt = obj as DataTable; operatorGuid = dt.Rows[0]["GUID"].ToString(); #endregion 获取用户guid XXTZ xxtzClass2 = new XXTZ(); StringBuilder piddept = new StringBuilder(); string sql = string.Empty; string uiPro = string.Empty; DataTable logComments = new DataTable(); StringBuilder logcoments = new StringBuilder(); switch (payModel.FeeType) { case "00": uiPro = "/zdfui"; billTypeNo = "100520005010"; break; case "01": uiPro = "/jtfui"; billTypeNo = "100520005015"; break; case "02": uiPro = "/txfui"; billTypeNo = "100520005020"; break; case "12": uiPro = "/clfui"; billTypeNo = "100520005005"; break; case "07": uiPro = "/qtfyui"; billTypeNo = "100520005055"; break; default: break; } //获取当前单号的发起人和待报销人 billno = payModel.BillNo; keyValuePairs = CommonHelper.sqlPro(billno, billTypeNo, operatorGuid, ProName); if (keyValuePairs["ReturnValue"].ToString() != "0") { ToolsClass.TxtLog("单据付款日志", "\r\n调用存储过程失败:" + keyValuePairs["ReturnMsg"].ToString() + "\r\n"); context.Response.Write("{\"errmsg\":\"" + keyValuePairs["ReturnMsg"].ToString() + "\",\"errcode\":1}"); return; } urlcsjson = ddUrl + $"{uiPro}/shenpi/index.html?billno={payModel.BillNo}&BillClassId={payModel.BillClassId}&showmenu=false"; urlcsjson = HttpUtility.UrlEncode(urlcsjson, System.Text.Encoding.UTF8); DDMsgModel dDMsgModel = new DDMsgModel { agent_id = agentId, userid_list = payModel.DDOperatorId + "," + payModel.DDPayId, msg = new DDMsgModelLinkMsg { msgtype = "link", link = new DDMsgModelLink { messageUrl = $"dingtalk://dingtalkclient/page/link?url={urlcsjson}&pc_slide=true", picUrl = "@", text = $"单据{payModel.BillNo}已付款", title = $"已付款{payModel.OperatorName}" } } }; string ddjsonmsgModel = JsonConvert.SerializeObject(dDMsgModel); url = "https://oapi.dingtalk.com/topapi/message/corpconversation/asyncsend_v2?access_token=" + access_token; FhJson = ToolsClass.ApiFun("POST", url, ddjsonmsgModel); if (isWrite == "1") { ToolsClass.TxtLog("单据付款日志", "\r\n发送通知调用钉钉api入参:" + ddjsonmsgModel + "\r\n出参:" + FhJson); } xxtzClass2 = (XXTZ)JsonConvert.DeserializeObject(FhJson, typeof(XXTZ)); errcode = xxtzClass2.errcode; if (errcode != 0) { switch (payModel.FeeType) { case "00": SqlHelper.ExecSql($"update EXPEENTEMENT set ISACCOUNT=0,ACCOUNTGUID='',ACCOUNTDate=null where BillNo = '{billno}' "); break; case "12": SqlHelper.ExecSql($"update ExpeTrav set ISACCOUNT=0,ACCOUNTGUID='',ACCOUNTDate=null where BillNo = '{billno}' "); break; default: SqlHelper.ExecSql($"update ExpeOther set ISACCOUNT=0,ACCOUNTGUID='',ACCOUNTDate=null where BillNo = '{billno}' "); break; } context.Response.Write("{\"errmsg\":\"您的单据付款消息通知失败(DD6004)\",\"errcode\":1}"); return; } result = JsonConvert.SerializeObject(new ResultGetMulParams { errcode = "0", errmsg = "", NextUrl = "" }); ToolsClass.TxtLog("单据付款日志", "\r\n返回前端信息:" + result + "\r\n"); context.Response.Write(result); return; } catch (Exception ex) { context.Response.Write("{\"errmsg\":\"" + ex.Message + ex.StackTrace + "\",\"errcode\":1}"); context.Response.End(); } }