From 16f03da99d2d58b1f71227ff727ee826359a9785 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 22 十一月 2022 18:48:05 +0800
Subject: [PATCH] 富尔达看板接口开发

---
 VueWebApi/obj/Release/VueWebApi.pdb                             |    0 
 VueWebApi/bin/VueWebApi.dll.config                              |    2 
 VueWebApi/obj/Release/TransformWebConfig/transformed/Web.config |    2 
 VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.dll      |    0 
 VueWebApi/Controllers/KanBanManagerentController.cs             |   76 ++++++++++
 .vs/VueWebApi/v16/.suo                                          |    0 
 VueWebApi/obj/Release/TransformWebConfig/original/Web.config    |    2 
 VueWebApi/bin/VueWebApi.dll                                     |    0 
 VueWebApi/Properties/PublishProfiles/FolderProfile1.pubxml.user |   10 
 VueWebApi/DLL/BLL/KanBanManagerentBLL.cs                        |   36 +++++
 VueWebApi/bin/VueWebApi.xml                                     |   13 +
 VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache  |    0 
 VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.pdb      |    0 
 VueWebApi/obj/Release/VueWebApi.dll                             |    0 
 VueWebApi/DLL/DAL/KanBanManagerentDAL.cs                        |  210 ++++++++++++++++++++++++++++-
 VueWebApi/obj/Release/Package/PackageTmp/Web.config             |    2 
 VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.xml      |   13 +
 VueWebApi/bin/VueWebApi.pdb                                     |    0 
 18 files changed, 351 insertions(+), 15 deletions(-)

diff --git a/.vs/VueWebApi/v16/.suo b/.vs/VueWebApi/v16/.suo
index 5cbb710..254cb2c 100644
--- a/.vs/VueWebApi/v16/.suo
+++ b/.vs/VueWebApi/v16/.suo
Binary files differ
diff --git a/VueWebApi/Controllers/KanBanManagerentController.cs b/VueWebApi/Controllers/KanBanManagerentController.cs
index 93409e1..c962bf2 100644
--- a/VueWebApi/Controllers/KanBanManagerentController.cs
+++ b/VueWebApi/Controllers/KanBanManagerentController.cs
@@ -240,5 +240,81 @@
             return TJson.toJson(mes);
         }
         #endregion
+
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,top5涓嶈壇]
+        /// <summary>
+        /// 瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,top5涓嶈壇
+        /// </summary>
+        /// <param name="StepCode">宸ュ簭缂栫爜(璐ㄦ宸ュ簭)</param>
+        /// <returns></returns>
+        [Route(template: "BadTop5")]
+        [HttpGet]
+        public HttpResponseMessage BadTop5(string StepCode)
+        {
+            mes = KanBanManagerentBLL.BadTop5(StepCode);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鍛ㄤ笉鑹秼鍔縘
+        /// <summary>
+        /// 瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鍛ㄤ笉鑹秼鍔�
+        /// </summary>
+        /// <param name="StepCode">宸ュ簭缂栫爜(璐ㄦ宸ュ簭)</param>
+        /// <returns></returns>
+        [Route(template: "BadWeek")]
+        [HttpGet]
+        public HttpResponseMessage BadWeek(string StepCode)
+        {
+            mes = KanBanManagerentBLL.BadWeek(StepCode);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鏃ヤ笉鑹垎甯僝
+        /// <summary>
+        /// 瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鏃ヤ笉鑹垎甯�
+        /// </summary>
+        /// <param name="StepCode">宸ュ簭缂栫爜(璐ㄦ宸ュ簭)</param>
+        /// <returns></returns>
+        [Route(template: "BadDayDistriBute")]
+        [HttpGet]
+        public HttpResponseMessage BadDayDistriBute(string StepCode)
+        {
+            mes = KanBanManagerentBLL.BadDayDistriBute(StepCode);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鍛ㄤ笉鑹垎甯僝
+        /// <summary>
+        /// 瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鍛ㄤ笉鑹垎甯�
+        /// </summary>
+        /// <param name="StepCode">宸ュ簭缂栫爜(璐ㄦ宸ュ簭)</param>
+        /// <returns></returns>
+        [Route(template: "BadWeekDistriBute")]
+        [HttpGet]
+        public HttpResponseMessage BadWeekDistriBute(string StepCode)
+        {
+            mes = KanBanManagerentBLL.BadWeekDistriBute(StepCode);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,涓嶈壇鏄庣粏]
+        /// <summary>
+        /// 瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,涓嶈壇鏄庣粏
+        /// </summary>
+        /// <param name="StepCode">宸ュ簭缂栫爜(璐ㄦ宸ュ簭)</param>
+        /// <returns></returns>
+        [Route(template: "BadContManger")]
+        [HttpGet]
+        public HttpResponseMessage BadContManger(string StepCode)
+        {
+            mes = KanBanManagerentBLL.BadContManger(StepCode);
+            return TJson.toJson(mes);
+        }
+        #endregion
     }
 }
diff --git a/VueWebApi/DLL/BLL/KanBanManagerentBLL.cs b/VueWebApi/DLL/BLL/KanBanManagerentBLL.cs
index c645d9a..bc6332d 100644
--- a/VueWebApi/DLL/BLL/KanBanManagerentBLL.cs
+++ b/VueWebApi/DLL/BLL/KanBanManagerentBLL.cs
@@ -120,5 +120,41 @@
             return KanBanManagerentDAL.WkshpContentData();
         }
         #endregion
+
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,top5涓嶈壇]
+        public static ToMessage BadTop5(string StepCode)
+        {
+            return KanBanManagerentDAL.BadTop5(StepCode);
+        }
+        #endregion
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鍛ㄤ笉鑹秼鍔縘
+        public static ToMessage BadWeek(string StepCode)
+        {
+            return KanBanManagerentDAL.BadWeek(StepCode);
+        }
+        #endregion
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鏃ヤ笉鑹垎甯僝
+        public static ToMessage BadDayDistriBute(string StepCode)
+        {
+            return KanBanManagerentDAL.BadDayDistriBute(StepCode);
+        }
+        #endregion
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鍛ㄤ笉鑹垎甯僝
+        public static ToMessage BadWeekDistriBute(string StepCode)
+        {
+            return KanBanManagerentDAL.BadWeekDistriBute(StepCode);
+        }
+        #endregion
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,涓嶈壇鏄庣粏]
+        public static ToMessage BadContManger(string StepCode)
+        {
+            return KanBanManagerentDAL.BadContManger(StepCode);
+        }
+        #endregion
     }
 }
\ No newline at end of file
diff --git a/VueWebApi/DLL/DAL/KanBanManagerentDAL.cs b/VueWebApi/DLL/DAL/KanBanManagerentDAL.cs
index aa240b5..09e8f25 100644
--- a/VueWebApi/DLL/DAL/KanBanManagerentDAL.cs
+++ b/VueWebApi/DLL/DAL/KanBanManagerentDAL.cs
@@ -147,7 +147,7 @@
             mes.data = list;
             return mes;
         }
-        #endregion\
+        #endregion
 
         #region[澶у矝杞﹂棿缁煎悎鐪嬫澘,宸︿笅鍒楄〃鎺ュ彛]
         public static ToMessage LineSearchBottomLeftData(string shopcode)
@@ -462,15 +462,17 @@
             try
             {
                 //鑾峰彇浜х嚎閿�鍞鍗曟姤宸ヤ俊鎭�,鎶ュ伐鏁伴噺>0  涓斿伐鍗曠姸鎬佷负闈炲叧闂姸鎬�  涓斿伐搴忎负鏈亾宸ュ簭 锛�--and (S.good_qty+S.ng_qty+S.bad_qty)<S.plan_qty)
-                sql = @"select A.saleOrderCode,A.materiel_code,M.partname,
-                        isnull(sum(S.good_qty),0) as good_qty
+                sql = @"select AA.saleOrderCode,AA.materiel_code,AA.partname,sum(AA.good_qty) as good_qty   from (
+                        select distinct A.saleOrderCode,A.materiel_code,M.partname,isnull(S.good_qty,0) as good_qty
                         from TKimp_Ewo A
-                        inner join TK_Wrk_Man B on A.wo=B.m_po 
-                        inner join TK_Wrk_Step S on B.wo_code=S.wo_code 
-                        inner join TFlw_Rteqp R on S.step_code=R.step_code
+                        left join TK_Wrk_Man B on A.wo=B.m_po and A.materiel_code=B.materiel_code 
+                        left join TK_Wrk_Step S on B.wo_code=S.wo_code and S.isend='Y' 
+                        left join TFlw_Rteqp R on S.step_code=R.step_code
                         left  join TMateriel_Info M on A.materiel_code=M.partcode
-                        where S.good_qty>0  and S.isend='Y' and R.eqp_code=@lineCode and B.status<>'CLOSED' 
-                        group by A.saleOrderCode,A.materiel_code,M.partname";
+                        where A.saleOrderCode is not null and A.saleOrderCode<>'' 
+                        and R.eqp_code=@lineCode and B.status<>'CLOSED' 
+                        ) as AA
+                        group by AA.saleOrderCode,AA.materiel_code,AA.partname";
                 dynamicParams.Add("@lineCode", lineCode);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
                 mes.code = "200";
@@ -495,10 +497,16 @@
             try
             {
                 //鑾峰彇宸ュ崟鎶ュ伐淇℃伅,鎶ュ伐鏁伴噺>0  涓斿伐鍗曠姸鎬佷负闈炲叧闂姸鎬�  
-                sql = @"select A.wo_code,M.partname,B.seq,T.stepname,B.plan_qty,B.good_qty,B.ng_qty,B.bad_qty  from TK_Wrk_Man A
+                sql = @"select A.wo_code,E.name as eqp_name,M.partname,B.plan_qty,A.plan_startdate,A.plan_enddate,T.stepname,B.good_qty
+                        from TK_Wrk_Man A
                         inner join TK_Wrk_Step B on A.wo_code=B.wo_code
-                        left join TMateriel_Info M on A.materiel_code=M.partcode
+                        inner join(
+                          select wo_code,step_code,materiel_code,eqp_code, sum(good_qty) as  good_qty  
+                          from TK_Wrk_Record where style='B' group by wo_code,step_code,materiel_code,eqp_code
+                          ) as S on A.wo_code=S.wo_code and A.materiel_code=S.materiel_code and B.step_code=S.step_code
                         left join TStep T on B.step_code=T.stepcode
+                        left join TMateriel_Info M on A.materiel_code=M.partcode
+                        left join TEqpInfo E on S.eqp_code=E.code
                         where   A.status<>'CLOSED'
                         order by A.wo_code,B.seq";
                 var data = DapperHelper.selecttable(sql);
@@ -517,6 +525,188 @@
         }
         #endregion
 
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,top5涓嶈壇]
+        public static ToMessage BadTop5(string StepCode)
+        {
+            string sql = "";
+            var dynamicParams = new DynamicParameters();
+            try
+            {
+                //瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,top5涓嶈壇(鍙栬川妫�宸ュ簭)
+                sql = @"select T.name,count(*) as cont   from CSR_WorkRecord_Defect A
+                        inner join TDefect T on A.defect_code=T.code
+                        where step_code=@StepCode and datediff(day,GETDATE(),A.lm_date)=0
+                        group by T.name order by cont desc";
+                dynamicParams.Add("@StepCode", StepCode);
+                var data = DapperHelper.selectdata(sql, dynamicParams);
+                mes.code = "200";
+                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.data = data;
+            }
+            catch (Exception e)
+            {
+                mes.code = "300";
+                mes.count = 0;
+                mes.Message = e.Message;
+                mes.data = null;
+            }
+            return mes;
+        }
+        #endregion
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鍛ㄤ笉鑹秼鍔縘
+        public static ToMessage BadWeek(string StepCode)
+        {
+            string sql = "";
+            var dynamicParams = new DynamicParameters();
+            try
+            {
+                //瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鍛ㄤ笉鑹秼鍔�(鍙栬川妫�宸ュ簭褰撳墠鏃堕棿寰�鍓嶄竴鍛�)
+                sql = @"select 
+                        case when datepart(weekday,a.click_date)=2 then '鍛ㄤ竴'  
+                        when datepart(weekday,a.click_date)=3 then '鍛ㄤ簩' 
+                        when datepart(weekday,a.click_date)=3 then '鍛ㄤ簩' 
+                        when datepart(weekday,a.click_date)=4 then '鍛ㄤ笁' 
+                        when datepart(weekday,a.click_date)=5 then '鍛ㄥ洓' 
+                        when datepart(weekday,a.click_date)=6 then '鍛ㄤ簲'
+                        when datepart(weekday,a.click_date)=7 then '鍛ㄥ叚'
+                        when datepart(weekday,a.click_date)=1 then '鍛ㄦ棩' end as click_date,
+                        ISNULL(b.count,0) as count
+                        from (
+                        SELECT convert(varchar(10),getdate()-6,120) as click_date
+                        union all
+                        SELECT convert(varchar(10),getdate()-5,120) as click_date
+                        union all
+                        SELECT convert(varchar(10),getdate()-4,120) as click_date
+                        union all
+                        SELECT convert(varchar(10),getdate()-3,120) as click_date
+                        union all
+                        SELECT convert(varchar(10),getdate()-2,120) as click_date
+                        union all
+                        SELECT convert(varchar(10),getdate()-1,120) as click_date
+                        union all
+                        SELECT convert(varchar(10),getdate(),120) as click_date
+                        ) a left join (
+                        select convert(varchar(10),lm_date,120) as datetime, count(*) as count
+                        from CSR_WorkRecord_Defect where step_code=@StepCode
+                        group by convert(varchar(10),lm_date,120)
+                        ) b on a.click_date = b.datetime;";
+                dynamicParams.Add("@StepCode", StepCode);
+                var data = DapperHelper.selectdata(sql, dynamicParams);
+                mes.code = "200";
+                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.data = data;
+            }
+            catch (Exception e)
+            {
+                mes.code = "300";
+                mes.count = 0;
+                mes.Message = e.Message;
+                mes.data = null;
+            }
+            return mes;
+        }
+        #endregion
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鏃ヤ笉鑹垎甯僝
+        public static ToMessage BadDayDistriBute(string StepCode)
+        {
+            string sql = "";
+            var dynamicParams = new DynamicParameters();
+            try
+            {
+                //瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鏃ヤ笉鑹垎甯�(鍙栬川妫�宸ュ簭,鎸変骇绾跨粺璁�)
+                sql = @"select A.eqp_code,E.name as eqp_name,count(*) as cont   from TK_Wrk_Record A
+                        inner join CSR_WorkRecord_Defect B on A.id=B.record_id
+                        left  join TEqpInfo E on A.eqp_code=E.code
+                        where B.step_code=@StepCode and datediff(day,GETDATE(),B.lm_date)=0
+                        group by A.eqp_code,E.name order by cont desc";
+                dynamicParams.Add("@StepCode", StepCode);
+                var data = DapperHelper.selectdata(sql, dynamicParams);
+                mes.code = "200";
+                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.data = data;
+            }
+            catch (Exception e)
+            {
+                mes.code = "300";
+                mes.count = 0;
+                mes.Message = e.Message;
+                mes.data = null;
+            }
+            return mes;
+        }
+        #endregion
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鍛ㄤ笉鑹垎甯僝
+        public static ToMessage BadWeekDistriBute(string StepCode)
+        {
+            string sql = "";
+            var dynamicParams = new DynamicParameters();
+            try
+            {
+                //瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鍛ㄤ笉鑹垎甯�(鍙栬川妫�宸ュ簭,鎸変骇绾跨粺璁�)
+                sql = @"select A.eqp_code,E.name as eqp_name,count(*) as cont   from TK_Wrk_Record A
+                        inner join CSR_WorkRecord_Defect B on A.id=B.record_id
+                        left  join TEqpInfo E on A.eqp_code=E.code
+                        where B.step_code=@StepCode and  DateDiff(dd,B.lm_date,getdate())<=7
+                        group by A.eqp_code,E.name order by cont desc";
+                dynamicParams.Add("@StepCode", StepCode);
+                var data = DapperHelper.selectdata(sql, dynamicParams);
+                mes.code = "200";
+                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.data = data;
+            }
+            catch (Exception e)
+            {
+                mes.code = "300";
+                mes.count = 0;
+                mes.Message = e.Message;
+                mes.data = null;
+            }
+            return mes;
+        }
+        #endregion
+
+        #region[瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,涓嶈壇鏄庣粏]
+        public static ToMessage BadContManger(string StepCode)
+        {
+            string sql = "";
+            var dynamicParams = new DynamicParameters();
+            try
+            {
+                //瀵屽皵杈捐溅闂磋川閲忔暟瀛楀寲鐪嬫澘,涓嶈壇鏄庣粏(鍙栬川妫�宸ュ簭,鎸変骇绾跨粺璁�)
+                sql = @"select MM.lm_date,MM.wo_code,A.materiel_code,MM.step_code,T.stepname,A.good_qty as report_qty,A.ng_qty,
+                       defect_name=( STUFF(( SELECT  ',' + B.name
+                                                 FROM  CSR_WorkRecord_Defect N
+                       						  inner join TDefect B on N.defect_code=B.code
+                       						  where record_id=MM.record_id
+                                               FOR
+                                                 XML PATH('')
+                                               ), 1, 1, '') )
+                       from CSR_WorkRecord_Defect as MM
+                       inner join TK_Wrk_Record A on MM.record_id=a.id
+                       inner join TK_Wrk_Step S on A.wo_code=S.wo_code and A.step_code=S.step_code
+                       inner join TStep T on MM.step_code=T.stepcode
+                       where  MM.step_code='Step02' and MM.style='B' and A.style='B' and A.ng_qty>0 and S.status<>'CLOSED' 
+                       group by MM.lm_date,MM.record_id,MM.wo_code,A.materiel_code,MM.step_code,T.stepname,A.good_qty,A.ng_qty";
+                dynamicParams.Add("@StepCode", StepCode);
+                var data = DapperHelper.selectdata(sql, dynamicParams);
+                mes.code = "200";
+                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.data = data;
+            }
+            catch (Exception e)
+            {
+                mes.code = "300";
+                mes.count = 0;
+                mes.Message = e.Message;
+                mes.data = null;
+            }
+            return mes;
+        }
+        #endregion
     }
 }
 
diff --git a/VueWebApi/Properties/PublishProfiles/FolderProfile1.pubxml.user b/VueWebApi/Properties/PublishProfiles/FolderProfile1.pubxml.user
index b8bb13a..6c3978c 100644
--- a/VueWebApi/Properties/PublishProfiles/FolderProfile1.pubxml.user
+++ b/VueWebApi/Properties/PublishProfiles/FolderProfile1.pubxml.user
@@ -5,7 +5,7 @@
 <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
   <PropertyGroup>
     <_PublishTargetUrl>D:\缃戠珯鍙戝竷\MES瀵屽皵杈�</_PublishTargetUrl>
-    <History>True|2022-11-16T02:29:41.2258924Z;True|2022-11-16T09:54:23.4213778+08:00;</History>
+    <History>True|2022-11-21T07:13:10.4385853Z;True|2022-11-16T10:29:41.2258924+08:00;True|2022-11-16T09:54:23.4213778+08:00;</History>
   </PropertyGroup>
   <ItemGroup>
     <File Include="Areas/HelpPage/HelpPage.css">
@@ -705,13 +705,13 @@
       <publishTime>12/24/2021 15:38:29</publishTime>
     </File>
     <File Include="bin/VueWebApi.dll">
-      <publishTime>11/16/2022 10:29:40</publishTime>
+      <publishTime>11/21/2022 15:13:03</publishTime>
     </File>
     <File Include="bin/VueWebApi.pdb">
-      <publishTime>11/16/2022 10:29:40</publishTime>
+      <publishTime>11/21/2022 15:13:03</publishTime>
     </File>
     <File Include="bin/VueWebApi.xml">
-      <publishTime>11/16/2022 10:29:40</publishTime>
+      <publishTime>11/21/2022 15:13:03</publishTime>
     </File>
     <File Include="bin/WebActivatorEx.dll">
       <publishTime>02/08/2013 16:42:28</publishTime>
@@ -1074,7 +1074,7 @@
       <publishTime>06/16/2022 13:39:23</publishTime>
     </File>
     <File Include="Web.config">
-      <publishTime>11/16/2022 09:54:22</publishTime>
+      <publishTime>11/21/2022 15:13:09</publishTime>
     </File>
   </ItemGroup>
 </Project>
\ No newline at end of file
diff --git a/VueWebApi/bin/VueWebApi.dll b/VueWebApi/bin/VueWebApi.dll
index f56f1d5..a9c775c 100644
--- a/VueWebApi/bin/VueWebApi.dll
+++ b/VueWebApi/bin/VueWebApi.dll
Binary files differ
diff --git a/VueWebApi/bin/VueWebApi.dll.config b/VueWebApi/bin/VueWebApi.dll.config
index db1cd82..1818056 100644
--- a/VueWebApi/bin/VueWebApi.dll.config
+++ b/VueWebApi/bin/VueWebApi.dll.config
@@ -18,6 +18,8 @@
 		<add key="DBServer" value="Data Source=121.196.36.24,1533;Initial Catalog=vmes_dd;User ID=sa;Password=xkd@20220602;pooling=false" />
 		<!--澶у矝鏈嶅姟鍣ㄧ幆澧�-->
 		<!--<add key="DBServer" value="Data Source=192.168.2.138;Initial Catalog=vmes;User ID=sa;Password=Dd@20220727;pooling=false" />-->
+		<!--redis浼佷笟閰嶇疆-->
+		<add key="Enterprise" value="FED" />
 		<!--redis鏁版嵁搴撻摼鎺ラ厤缃甶p-->
 		<add key="RedisConnIp" value="127.0.0.1" />
 		<!--redis鏁版嵁搴撻摼鎺ラ厤缃鍙e彿-->
diff --git a/VueWebApi/bin/VueWebApi.pdb b/VueWebApi/bin/VueWebApi.pdb
index 8781607..4fec910 100644
--- a/VueWebApi/bin/VueWebApi.pdb
+++ b/VueWebApi/bin/VueWebApi.pdb
Binary files differ
diff --git a/VueWebApi/bin/VueWebApi.xml b/VueWebApi/bin/VueWebApi.xml
index a6f38c0..67b8a70 100644
--- a/VueWebApi/bin/VueWebApi.xml
+++ b/VueWebApi/bin/VueWebApi.xml
@@ -1721,6 +1721,19 @@
             <param name="shopcode">杞﹂棿缂栫爜</param>
             <returns></returns>
         </member>
+        <member name="M:VueWebApi.Controllers.KanBanManagerentController.WkshpLineData(System.String)">
+            <summary>
+            瀵屽皵杈捐溅闂寸敓浜ф暟瀛楀寲鐪嬫澘锛屼骇绾挎暟鎹�
+            </summary>
+            <param name="LineCode">浜х嚎缂栫爜</param>
+            <returns></returns>
+        </member>
+        <member name="M:VueWebApi.Controllers.KanBanManagerentController.WkshpContentData">
+            <summary>
+            瀵屽皵杈捐溅闂寸敓浜ф暟瀛楀寲鐪嬫澘锛岀敓浜т俊鎭�
+            </summary>
+            <returns></returns>
+        </member>
         <member name="M:VueWebApi.Controllers.LoginController.LoginSave(System.String,System.String,System.String)">
             <summary>
             PC鐢ㄦ埛鐧诲綍
diff --git a/VueWebApi/obj/Release/Package/PackageTmp/Web.config b/VueWebApi/obj/Release/Package/PackageTmp/Web.config
index b50c103..a6b74b6 100644
--- a/VueWebApi/obj/Release/Package/PackageTmp/Web.config
+++ b/VueWebApi/obj/Release/Package/PackageTmp/Web.config
@@ -18,6 +18,8 @@
     <add key="DBServer" value="Data Source=121.196.36.24,1533;Initial Catalog=vmes_dd;User ID=sa;Password=xkd@20220602;pooling=false" />
     <!--澶у矝鏈嶅姟鍣ㄧ幆澧�-->
     <!--<add key="DBServer" value="Data Source=192.168.2.138;Initial Catalog=vmes;User ID=sa;Password=Dd@20220727;pooling=false" />-->
+    <!--redis浼佷笟閰嶇疆-->
+    <add key="Enterprise" value="FED" />
     <!--redis鏁版嵁搴撻摼鎺ラ厤缃甶p-->
     <add key="RedisConnIp" value="127.0.0.1" />
     <!--redis鏁版嵁搴撻摼鎺ラ厤缃鍙e彿-->
diff --git a/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.dll b/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.dll
index f56f1d5..a9c775c 100644
--- a/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.dll
+++ b/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.dll
Binary files differ
diff --git a/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.pdb b/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.pdb
index 8781607..4fec910 100644
--- a/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.pdb
+++ b/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.pdb
Binary files differ
diff --git a/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.xml b/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.xml
index a6f38c0..67b8a70 100644
--- a/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.xml
+++ b/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.xml
@@ -1721,6 +1721,19 @@
             <param name="shopcode">杞﹂棿缂栫爜</param>
             <returns></returns>
         </member>
+        <member name="M:VueWebApi.Controllers.KanBanManagerentController.WkshpLineData(System.String)">
+            <summary>
+            瀵屽皵杈捐溅闂寸敓浜ф暟瀛楀寲鐪嬫澘锛屼骇绾挎暟鎹�
+            </summary>
+            <param name="LineCode">浜х嚎缂栫爜</param>
+            <returns></returns>
+        </member>
+        <member name="M:VueWebApi.Controllers.KanBanManagerentController.WkshpContentData">
+            <summary>
+            瀵屽皵杈捐溅闂寸敓浜ф暟瀛楀寲鐪嬫澘锛岀敓浜т俊鎭�
+            </summary>
+            <returns></returns>
+        </member>
         <member name="M:VueWebApi.Controllers.LoginController.LoginSave(System.String,System.String,System.String)">
             <summary>
             PC鐢ㄦ埛鐧诲綍
diff --git a/VueWebApi/obj/Release/TransformWebConfig/original/Web.config b/VueWebApi/obj/Release/TransformWebConfig/original/Web.config
index db1cd82..1818056 100644
--- a/VueWebApi/obj/Release/TransformWebConfig/original/Web.config
+++ b/VueWebApi/obj/Release/TransformWebConfig/original/Web.config
@@ -18,6 +18,8 @@
 		<add key="DBServer" value="Data Source=121.196.36.24,1533;Initial Catalog=vmes_dd;User ID=sa;Password=xkd@20220602;pooling=false" />
 		<!--澶у矝鏈嶅姟鍣ㄧ幆澧�-->
 		<!--<add key="DBServer" value="Data Source=192.168.2.138;Initial Catalog=vmes;User ID=sa;Password=Dd@20220727;pooling=false" />-->
+		<!--redis浼佷笟閰嶇疆-->
+		<add key="Enterprise" value="FED" />
 		<!--redis鏁版嵁搴撻摼鎺ラ厤缃甶p-->
 		<add key="RedisConnIp" value="127.0.0.1" />
 		<!--redis鏁版嵁搴撻摼鎺ラ厤缃鍙e彿-->
diff --git a/VueWebApi/obj/Release/TransformWebConfig/transformed/Web.config b/VueWebApi/obj/Release/TransformWebConfig/transformed/Web.config
index b50c103..a6b74b6 100644
--- a/VueWebApi/obj/Release/TransformWebConfig/transformed/Web.config
+++ b/VueWebApi/obj/Release/TransformWebConfig/transformed/Web.config
@@ -18,6 +18,8 @@
     <add key="DBServer" value="Data Source=121.196.36.24,1533;Initial Catalog=vmes_dd;User ID=sa;Password=xkd@20220602;pooling=false" />
     <!--澶у矝鏈嶅姟鍣ㄧ幆澧�-->
     <!--<add key="DBServer" value="Data Source=192.168.2.138;Initial Catalog=vmes;User ID=sa;Password=Dd@20220727;pooling=false" />-->
+    <!--redis浼佷笟閰嶇疆-->
+    <add key="Enterprise" value="FED" />
     <!--redis鏁版嵁搴撻摼鎺ラ厤缃甶p-->
     <add key="RedisConnIp" value="127.0.0.1" />
     <!--redis鏁版嵁搴撻摼鎺ラ厤缃鍙e彿-->
diff --git a/VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache b/VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache
index 46b571b..ea91953 100644
--- a/VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache
+++ b/VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache
Binary files differ
diff --git a/VueWebApi/obj/Release/VueWebApi.dll b/VueWebApi/obj/Release/VueWebApi.dll
index f56f1d5..a9c775c 100644
--- a/VueWebApi/obj/Release/VueWebApi.dll
+++ b/VueWebApi/obj/Release/VueWebApi.dll
Binary files differ
diff --git a/VueWebApi/obj/Release/VueWebApi.pdb b/VueWebApi/obj/Release/VueWebApi.pdb
index 8781607..4fec910 100644
--- a/VueWebApi/obj/Release/VueWebApi.pdb
+++ b/VueWebApi/obj/Release/VueWebApi.pdb
Binary files differ

--
Gitblit v1.9.3