From ce12a541680abb5604b7c90a3130c819848cb973 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 06 六月 2023 19:09:35 +0800
Subject: [PATCH] 1.生产进度报表开发 2.T+对接回调地址信息接口开发

---
 VueWebApi/Controllers/MessageController.cs |   88 +++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 78 insertions(+), 10 deletions(-)

diff --git a/VueWebApi/Controllers/MessageController.cs b/VueWebApi/Controllers/MessageController.cs
index 850841f..329f298 100644
--- a/VueWebApi/Controllers/MessageController.cs
+++ b/VueWebApi/Controllers/MessageController.cs
@@ -1,9 +1,13 @@
-锘縰sing Newtonsoft.Json;
+锘縰sing Dapper;
+using Newtonsoft.Json;
 using System;
 using System.Collections.Generic;
+using System.IO;
 using System.Linq;
 using System.Net;
 using System.Net.Http;
+using System.Net.Http.Headers;
+using System.Text;
 using System.Web.Http;
 using VueWebApi.Models;
 using VueWebApi.Tools;
@@ -15,6 +19,8 @@
     [ControllerGroup("T8鎺堟潈绠$悊", "鍦ㄧ嚎鎺ュ彛")]
     public class MessageController : ApiController
     {
+        public static ToMessage mes = new ToMessage(); //瀹氫箟鍏ㄥ眬杩斿洖淇℃伅瀵硅薄
+
         [Route(template: "OAuth")]
         [HttpGet]
         public string OAuth(string code, string state)
@@ -30,10 +36,8 @@
         {
             string enMsg = encryptMsg.GetEncryptMsg();
             LogHelper.WriteLogData("瑙e瘑鍓嶇殑娑堟伅enMsg:" + enMsg);
-            Console.WriteLine($"瑙e瘑鍓嶇殑娑堟伅{enMsg}");
             String decryptMsg = OpenapiHelper.AesDecrypt(enMsg, config.Key_encryptKey);
-            LogHelper.WriteLogData2("瑙e瘑鍚庢秷鎭�:" +decryptMsg);
-            Console.WriteLine($"瑙e瘑鍚庢秷鎭瘂decryptMsg}");
+            LogHelper.WriteLogData2("瑙e瘑鍚庢秷鎭�:" + decryptMsg);
 
             MessageBase message = JsonConvert.DeserializeObject<MessageBase>(decryptMsg);
             object retObj = null;
@@ -70,7 +74,12 @@
 
         private object DealOrderPayMsg(MessageBase message)
         {
-            throw new NotImplementedException();
+            //throw new NotImplementedException();
+            Dictionary<string, string> dic = new Dictionary<string, string>
+            {
+                { "result","success"}
+            };
+            return dic;
         }
 
         private object DealOrgTempAuthMsg(MessageBase message)
@@ -84,11 +93,31 @@
 
         private object DealTicketMsg(MessageBase message)
         {
-            LogHelper.WriteLogData("寮�濮婣ppTicket");
             AppTicketContent content = JsonConvert.DeserializeObject<AppTicketContent>(message.bizContent.ToString());
-            Console.WriteLine($"AppTicket:{content.appTicket}");
-            LogHelper.WriteLogData("缁撴潫AppTicket");
-            return $"AppTicket:{content.appTicket}";
+            LogHelper.WriteLogData($"AppTicket:{content.appTicket}");
+            var dynamicParams = new DynamicParameters();
+
+
+            var sql = @"update T_AppTicket set AppTicket=@AppTicket,lm_date=@lm_date";
+            dynamicParams.Add("@AppTicket", content.appTicket);
+            dynamicParams.Add("@lm_date", DateTime.Now.ToString());
+            int cont = DapperHelper.SQL(sql, dynamicParams);
+            if (cont > 0)
+            {
+                Dictionary<string, string> dic = new Dictionary<string, string>
+                {
+                   { "result","success"}
+                };
+                return dic;
+            }
+            else
+            {
+                Dictionary<string, string> dic = new Dictionary<string, string>
+                {
+                   { "result","success"}
+                };
+                return dic;
+            }
         }
 
         private object DealTestMsg(MessageBase message)
@@ -98,7 +127,46 @@
                 { "result","success"}
             };
             LogHelper.WriteLogData1(JsonConvert.SerializeObject(dic));
-            return JsonConvert.SerializeObject(dic);
+            return dic;
         }
+
+        /// <summary>
+        /// 鑾峰彇AppTicket
+        /// </summary>
+        /// <returns></returns>
+        [Route(template: "AppTicketSelect")]
+        [HttpGet]
+        public HttpResponseMessage AppTicketSelect()
+        {
+            string sql = "";
+            var dynamicParams = new DynamicParameters();
+            try
+            {
+                //鑾峰彇杞﹂棿涓嬫媺妗嗘暟鎹�
+                sql = @"select *   from T_AppTicket ";
+                var data = DapperHelper.selecttable(sql);
+                if (data.Rows.Count > 0)
+                {
+                    mes.code = "200";
+                    mes.Message = "鏌ヨ鎴愬姛!";
+                    mes.data = data;
+                }
+                else
+                {
+                    mes.code = "300";
+                    mes.Message = "鏌ヨ澶辫触!";
+                    mes.data = null;
+                }
+            }
+            catch (Exception e)
+            {
+                mes.code = "300";
+                mes.count = 0;
+                mes.Message = e.Message;
+                mes.data = null;
+            }
+            return TJson.toJson(mes);
+        }
+
     }
 }
\ No newline at end of file

--
Gitblit v1.9.3