From 695f61f39ad983df2b381402829cbfec2319bf63 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 28 十一月 2022 17:29:57 +0800
Subject: [PATCH] SOP接口开发

---
 VueWebApi/obj/Release/VueWebApi.pdb                             |    0 
 VueWebApi/Controllers/SystemSettingController.cs                |  162 ++++++++++++++++++
 VueWebApi/DLL/DAL/SystemSettingDAL.cs                           |  223 ++++++++++++++++++++++++
 VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.dll      |    0 
 VueWebApi/obj/Release/VueWebApi.csproj.FileListAbsolute.txt     |    1 
 .vs/VueWebApi/v16/.suo                                          |    0 
 VueWebApi/bin/VueWebApi.dll                                     |    0 
 VueWebApi/Properties/PublishProfiles/FolderProfile1.pubxml.user |   10 
 VueWebApi/bin/VueWebApi.xml                                     |   49 +++++
 VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache  |    0 
 VueWebApi/VueWebApi.csproj                                      |    1 
 VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.pdb      |    0 
 VueWebApi/obj/Release/VueWebApi.dll                             |    0 
 VueWebApi/DLL/BLL/SystemSettingBLL.cs                           |   36 ++++
 VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.xml      |   49 +++++
 VueWebApi/bin/VueWebApi.pdb                                     |    0 
 16 files changed, 520 insertions(+), 11 deletions(-)

diff --git a/.vs/VueWebApi/v16/.suo b/.vs/VueWebApi/v16/.suo
index 00feb9e..d3b74a7 100644
--- a/.vs/VueWebApi/v16/.suo
+++ b/.vs/VueWebApi/v16/.suo
Binary files differ
diff --git a/VueWebApi/Controllers/SystemSettingController.cs b/VueWebApi/Controllers/SystemSettingController.cs
index 4c266d6..d303ade 100644
--- a/VueWebApi/Controllers/SystemSettingController.cs
+++ b/VueWebApi/Controllers/SystemSettingController.cs
@@ -2,6 +2,8 @@
 using System;
 using System.Collections.Generic;
 using System.Data;
+using System.Globalization;
+using System.IO;
 using System.Linq;
 using System.Net;
 using System.Net.Http;
@@ -20,6 +22,7 @@
         //瀹氫箟鍏ㄥ眬淇℃伅杩斿洖鍙橀噺
         ToMessage mes = new ToMessage();
         RedisHelper redis = new RedisHelper();
+        string FileIP = System.Configuration.ConfigurationManager.AppSettings["FileIP"];
 
         #region[缂栫爜瑙勫垯鏌ヨ]
         /// <summary>
@@ -142,5 +145,164 @@
             return TJson.toJson(mes);
         }
         #endregion
+
+
+        #region[SOP鍒楄〃鏌ヨ]
+        /// <summary>
+        /// SOP鍒楄〃鏌ヨ
+        /// </summary>
+        /// <param name="search">鎼滅储鍏抽敭瀛�</param>
+        /// <param name="check">鏄惁閫変腑鏈�楂樼増鏈�</param>
+        /// <param name="page">椤电爜</param>
+        /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+        /// <param name="prop">鎺掑簭瀛楁</param>
+        /// <param name="order">鎺掑簭瑙勫垯</param>
+        /// <returns></returns>
+        [Route(template: "SystemSopSearch")]
+        [HttpGet]
+        public HttpResponseMessage SystemSopSearch(string search = null, string check = null,int page = 0, int rows = 0, string prop = null, string order = null)
+        {
+            int startNum = rows * (page - 1) + 1;  //璧峰璁板綍rowNum
+            int endNum = rows * page;   //缁撴潫璁板綍 rowNum
+            mes = SystemSettingBLL.SystemSopSearch(search, check, startNum, endNum, prop, order);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[SOP鏂囦欢涓婁紶鏌ユ壘璁惧绫诲瀷鏁版嵁]
+        /// <summary>
+        /// SOP鏂囦欢涓婁紶鏌ユ壘璁惧绫诲瀷鏁版嵁
+        /// </summary>
+        /// <returns></returns>
+        [Route(template: "SystemSopDeviceSearch")]
+        [HttpGet]
+        public HttpResponseMessage SystemSopDeviceSearch()
+        {
+            mes = SystemSettingBLL.SystemSopDeviceSearch();
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[SOP鏂囦欢浣滀笟鏂囦欢涓婁紶鑾峰彇鏈�澶х増鏈彿]
+        /// <summary>
+        /// SOP鏂囦欢浣滀笟鏂囦欢涓婁紶鑾峰彇鏈�澶х増鏈彿
+        /// </summary>
+        /// <param name="devicetypecode">璁惧绫诲瀷缂栧彿</param>
+        /// <param name="filetypecode">鏂囦欢绫诲瀷缂栧彿</param>
+        /// <param name="partcode">鐗╂枡缂栫爜</param>
+        /// <returns></returns>
+        [Route(template: "SystemSopMaxVersion")]
+        [HttpGet]
+        public HttpResponseMessage SystemSopMaxVersion(string devicetypecode,string filetypecode,string partcode)
+        {
+            mes = SystemSettingBLL.SystemSopMaxVersion(devicetypecode, filetypecode, partcode);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[SOP鏂囦欢涓婁紶鎻愪氦]
+        /// <summary>
+        /// SOP鏂囦欢涓婁紶鎻愪氦
+        /// </summary>
+        /// <returns></returns>
+        [Route(template: "SystemSopSava")]
+        [HttpPost]
+        public HttpResponseMessage SystemSopSava()
+        {
+            string savePath = "";
+            HttpPostedFile files = HttpContext.Current.Request.Files[0];//鑾峰彇涓婁紶鐨勬枃浠�
+            string devicetypecode = HttpContext.Current.Request["devicetypecode"].ToString();//璁惧绫诲瀷缂栫爜
+            string partcode = HttpContext.Current.Request["partcode"].ToString();//鐗╂枡缂栫爜
+            string filetypecode = HttpContext.Current.Request["filetypecode"].ToString();//鏂囦欢绫诲瀷缂栫爜
+            string fileversion = HttpContext.Current.Request["fileversion"].ToString();//鏂囦欢鐗堟湰鍙�
+            string defilename = HttpContext.Current.Request["defilename"].ToString();//鏂囦欢鍚嶇О
+            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //鎿嶄綔浜哄憳
+            if (files == null || files.ContentLength <= 0)
+            {
+                mes.code = "300";
+                mes.Message = "鏂囦欢涓嶈兘涓虹┖锛�";
+            }
+            else
+            {
+
+                string file_name = DateTime.Now.ToString("yyyyMMddHHmmss", DateTimeFormatInfo.InvariantInfo) + Path.GetFileName(files.FileName); //鏃堕棿鎴冲姞鏂囦欢鍚�
+                int filesize = files.ContentLength;//鑾峰彇涓婁紶鏂囦欢鐨勫ぇ灏忓崟浣嶄负瀛楄妭byte
+                string fileEx = System.IO.Path.GetExtension(file_name);//鑾峰彇涓婁紶鏂囦欢鐨勬墿灞曞悕
+                int Maxsize = 40000 * 1024;//瀹氫箟涓婁紶鏂囦欢鐨勬渶澶х┖闂村ぇ灏忎负40M
+                string FileType = ".pdf";//瀹氫箟涓婁紶鏂囦欢鐨勭被鍨嬪瓧绗︿覆
+                string FileType1 = ".mp4";//瀹氫箟涓婁紶鏂囦欢鐨勭被鍨嬪瓧绗︿覆
+
+                if (!FileType.Contains(fileEx) && !FileType1.Contains(fileEx))
+                {
+                    mes.code = "300";
+                    mes.Message = "鏂囦欢绫诲瀷涓嶅锛屽彧鑳藉鍏df鏍煎紡鐨勬枃浠跺拰mp4鏍煎紡鏂囦欢锛�";
+                }
+                else
+                {
+                    if (filesize >= Maxsize)
+                    {
+                        mes.code = "300";
+                        mes.Message = "涓婁紶鏂囦欢瓒呰繃40M锛屼笉鑳戒笂浼�!";
+                    }
+                    else
+                    {
+                        string path = System.Web.HttpContext.Current.Server.MapPath("/File/DeviceFile/");
+
+                        if (Directory.Exists(path) == false)//濡傛灉涓嶅瓨鍦ㄥ氨鍒涘缓file鏂囦欢澶�
+                        {
+                            Directory.CreateDirectory(path); //娣诲姞鏂囦欢澶�
+                        }
+                        savePath = Path.Combine(path, file_name);
+                        if (Directory.Exists(savePath) == true)  //濡傛灉瀛樺湪閲嶅悕鏂囦欢灏辨彁绀�
+                        {
+                            mes.code = "300";
+                            mes.Message = "宸插瓨鍦ㄥ悓鍚嶆枃浠�!";
+                        }
+                        else
+                        {
+                            files.SaveAs(savePath);    //灏嗛�夋嫨鐨勬枃浠朵繚瀛樺埌鎸囧畾鏂囦欢澶逛笅
+                            string FilesName = System.Web.HttpContext.Current.Server.MapPath("/File/DeviceFile/" + file_name);
+                            string StrPath = "/File/DeviceFile/" + file_name;
+                            mes = SystemSettingBLL.SystemSopSava(devicetypecode, filetypecode, partcode,fileversion,file_name,defilename,username, StrPath);
+                        }
+                    }
+                }
+            }
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[SOP鏂囦欢鍒犻櫎]
+        /// <summary>
+        /// SOP鏂囦欢鍒犻櫎
+        /// </summary>
+        /// <param name="id">鏂囦欢id</param>
+        /// <param name="filepath">鏂囦欢鍦板潃</param>
+        /// <returns></returns>
+        [Route(template: "SystemSopDelete")]
+        [HttpPost]
+        public HttpResponseMessage SystemSopDelete(string id,string filepath)
+        {
+            mes = SystemSettingBLL.SystemSopDelete(id,filepath);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[SOP鏂囦欢棰勮]
+        /// <summary>
+        /// SOP鏂囦欢棰勮
+        /// </summary>
+        /// <param name="id">鏂囦欢id</param>
+        /// <param name="filepath">鏂囦欢鍦板潃</param>
+        /// <returns></returns>
+        [Route(template: "SystemSopView")]
+        [HttpPost]
+        public HttpResponseMessage SystemSopView(string id, string filepath)
+        {
+            mes.code = "200";
+            mes.data = Url.Content(FileIP + filepath);
+            return TJson.toJson(mes);
+        }
+        #endregion
     }
 }
diff --git a/VueWebApi/DLL/BLL/SystemSettingBLL.cs b/VueWebApi/DLL/BLL/SystemSettingBLL.cs
index c9a6d26..4a63375 100644
--- a/VueWebApi/DLL/BLL/SystemSettingBLL.cs
+++ b/VueWebApi/DLL/BLL/SystemSettingBLL.cs
@@ -52,5 +52,41 @@
             return SystemSettingDAL.SystemAnnouncementDelete(id);
         }
         #endregion
+
+
+        #region[SOP鍒楄〃鏌ヨ]
+        public static ToMessage SystemSopSearch(string search, string check, int startNum, int endNum, string prop, string order)
+        {
+            return SystemSettingDAL.SystemSopSearch(search,check,startNum,endNum,prop,order);
+        }
+        #endregion
+
+        #region[SOP鏂囦欢涓婁紶鏌ユ壘璁惧绫诲瀷鏁版嵁]
+        public static ToMessage SystemSopDeviceSearch()
+        {
+            return SystemSettingDAL.SystemSopDeviceSearch();
+        }
+        #endregion
+
+        #region[SOP鏂囦欢浣滀笟鏂囦欢涓婁紶鑾峰彇鏈�澶х増鏈彿]
+        public static ToMessage SystemSopMaxVersion(string devicetypecode, string filetypecode, string partcode)
+        {
+            return SystemSettingDAL.SystemSopMaxVersion(devicetypecode,filetypecode,partcode);
+        }
+        #endregion
+
+        #region[SOP鏂囦欢涓婁紶鎻愪氦]
+        public static ToMessage SystemSopSava(string devicetypecode, string filetypecode, string partcode, string fileversion,string file_name, string defilename, string username, string strPath)
+        {
+            return SystemSettingDAL.SystemSopSava(devicetypecode, filetypecode, partcode,fileversion, file_name,defilename, username,strPath);
+        }
+        #endregion
+
+        #region[SOP鏂囦欢鍒犻櫎]
+        public static ToMessage SystemSopDelete(string id, string filepath)
+        {
+            return SystemSettingDAL.SystemSopDelete(id,filepath);
+        }
+        #endregion
     }
 }
\ No newline at end of file
diff --git a/VueWebApi/DLL/DAL/SystemSettingDAL.cs b/VueWebApi/DLL/DAL/SystemSettingDAL.cs
index b350950..aafe25f 100644
--- a/VueWebApi/DLL/DAL/SystemSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/SystemSettingDAL.cs
@@ -35,7 +35,7 @@
                 {
                     search += "and B.prefix like '%'+@prefix+'%' ";
                     dynamicParams.Add("@prefix", prefix);
-                }             
+                }
                 if (search == "")
                 {
                     search = "and 1=1 ";
@@ -64,7 +64,7 @@
         #endregion
 
         #region[缂栫爜瑙勫垯缂栬緫淇濆瓨]
-        public static ToMessage SaveEncodingRules(string rightcode,string rightname, string prefix, string filingdate, string incbit, string lm_user)
+        public static ToMessage SaveEncodingRules(string rightcode, string rightname, string prefix, string filingdate, string incbit, string lm_user)
         {
             var sql = "";
             List<object> list = new List<object>();
@@ -99,7 +99,7 @@
                         mes.data = null;
                     }
                 }
-                else 
+                else
                 {
                     //棣栨鍐欏叆鍓嶆寜浣嶆暟琛ュ厖0
                     string value = "";
@@ -217,7 +217,7 @@
         #endregion
 
         #region[杞﹂棿鍏憡鏂板缂栬緫鎻愪氦]
-        public static ToMessage SystemAnnouncementAddUpdate(string id,DataTable dt, string ancetitle, string ancecont, string cancel, string level,string username, string opertype)
+        public static ToMessage SystemAnnouncementAddUpdate(string id, DataTable dt, string ancetitle, string ancecont, string cancel, string level, string username, string opertype)
         {
             var sql = "";
             var dynamicParams = new DynamicParameters();
@@ -277,7 +277,7 @@
                         str = sql,
                         parm = new
                         {
-                            id=id,
+                            id = id,
                             wksp_code = dt.Rows[0]["WKSP_CODE"].ToString(),
                             title = ancetitle,
                             contents = ancecont,
@@ -354,5 +354,218 @@
             return mes;
         }
         #endregion
+
+
+        #region[SOP鍒楄〃鏌ヨ]
+        public static ToMessage SystemSopSearch(string search, string check, int startNum, int endNum, string prop, string order)
+        {
+            var dynamicParams = new DynamicParameters();
+            string sech = "";
+            try
+            {
+                if (search != "" && search != null)
+                {
+                    sech += "and concat(isnull(AA.partcode,''),isnull(AA.partname,''),isnull(AA.partname,''),isnull(AA.eqptype_name,''),isnull(AA.filetype_name,''),isnull(AA.file_name,''),isnull(AA.file_version,''),isnull(AA.username,'')) like '%@search%' ";
+                    dynamicParams.Add("@search", search);
+                }
+                if (check == "Y")
+                {
+                    sech += "and AA.rn=1 ";
+                    dynamicParams.Add("@rn", 1);
+                }
+
+                if (search == "")
+                {
+                    sech = "and 1=1 ";
+                }
+                search = search.Substring(3);//鎴彇绱㈠紩2鍚庨潰鐨勫瓧绗�
+                // --------------鏌ヨ鎸囧畾鏁版嵁--------------
+                var total = 0; //鎬绘潯鏁�
+                var sql = @"select AA.id,AA.partcode,AA.partname,AA.partspec,AA.eqptype_code,AA.eqptype_name,AA.filetype_code,AA.filetype_name,AA.file_name,AA.file_version,AA.file_path,
+                            AA.username,AA.lm_date,AA.rn  from(
+                            select top 100  A.id,M.partcode,M.partname,M.partspec,A.eqptype_code,T.name as eqptype_name,A.filetype_code,
+                            (case when A.filetype_code='P001' then '浣滀笟鎸囧涔�' when A.filetype_code='P002' then '妫�楠屾寚瀵间功' when A.filetype_code='P003' then '鍥剧焊'  end) as filetype_name,
+                            A.file_name,A.file_version,A.file_path,U.username,A.lm_date,
+                            row_number() over(partition by A.materiel_code,A.filetype_code order by replace(A.file_version,'V','') desc) rn  
+                            from  TK_Sop_Matfile A
+                            left  join TMateriel_Info M on A.materiel_code=M.partcode
+                            left  join TEqpType T on A.eqptype_code=T.code
+                            left  join TUser U on A.lm_user=U.usercode
+                            ) as AA  where  " + sech + " order by AA.lm_date";
+                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
+                mes.code = "200";
+                mes.Message = "鏌ヨ鎴愬姛!";
+                mes.count = total;
+                mes.data = data.ToList();
+            }
+            catch (Exception e)
+            {
+                mes.code = "300";
+                mes.count = 0;
+                mes.Message = e.Message;
+                mes.data = null;
+            }
+            return mes;
+        }
+        #endregion
+
+        #region[SOP鏂囦欢涓婁紶鏌ユ壘璁惧绫诲瀷鏁版嵁]
+        public static ToMessage SystemSopDeviceSearch()
+        {
+            string sql = "";
+            try
+            {
+                //鑾峰彇璁惧绫诲瀷
+                sql = @"select code,name   from TEqpType order by code";
+                var data = DapperHelper.selecttable(sql);
+                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[SOP鏂囦欢浣滀笟鏂囦欢涓婁紶鑾峰彇鏈�澶х増鏈彿]
+        public static ToMessage SystemSopMaxVersion(string devicetypecode, string filetypecode, string partcode)
+        {
+            string sql = "";
+            var dynamicParams = new DynamicParameters();
+            try
+            {
+                //鑾峰彇SOP鏂囦欢浣滀笟鏂囦欢涓婁紶鑾峰彇鏈�澶х増鏈彿
+                sql = @"select isnull(max(substring(file_version,charindex('V',file_version)+1,len(file_version)-charindex('V',file_version))),0)+1 as file_version    
+                        from TK_Sop_Matfile where materiel_code=@partcode and eqptype_code=@devicetypecode and filetype_code=@filetypecode ";
+                dynamicParams.Add("@devicetypecode", devicetypecode);
+                dynamicParams.Add("@filetypecode", filetypecode);
+                dynamicParams.Add("@partcode", partcode);
+                var data = DapperHelper.selectdata(sql, dynamicParams);
+                if (data.Rows.Count > 0)
+                {
+                    mes.code = "200";
+                    mes.Message = "鑾峰彇鐗堟湰鍙锋垚鍔�!";
+                    mes.data = "V" + data.Rows[0]["version"].ToString();
+                }
+                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 mes;
+        }
+        #endregion
+
+        #region[SOP鏂囦欢涓婁紶鎻愪氦]
+        public static ToMessage SystemSopSava(string devicetypecode, string filetypecode, string partcode, string fileversion,string file_name, string defilename, string username, string strPath)
+        {
+            var sql = "";
+            List<object> list = new List<object>();
+            try
+            {
+                //鍐欏叆SOP鏂囦欢琛�
+                sql = @"insert into TK_Sop_Matfile(materiel_code,eqptype_code,filetype_code,file_name,define_name,file_version,file_path,lm_user,lm_date)
+                        values(@wksp_code,@title,@contents,@if_cancel,@cancel_date,@lm_user,@lm_date,@priority)";
+                list.Add(new
+                {
+                    str = sql,
+                    parm = new
+                    {
+                        materiel_code = partcode,
+                        eqptype_code = devicetypecode,
+                        filetype_code = filetypecode,
+                        file_name = file_name,
+                        define_name = defilename,
+                        file_version= fileversion,
+                        file_path= strPath,
+                        lm_user = username,
+                        lm_date = DateTime.Now.ToString()
+                    }
+                });
+                bool aa = DapperHelper.DoTransaction(list);
+                if (aa)
+                {
+                    mes.code = "200";
+                    mes.count = 0;
+                    mes.Message = "涓婁紶鎴愬姛!";
+                    mes.data = null;
+                }
+                else
+                {
+                    mes.code = "300";
+                    mes.count = 0;
+                    mes.Message = "涓婁紶澶辫触!";
+                    mes.data = null;
+                }
+
+            }
+            catch (Exception e)
+            {
+                mes.code = "300";
+                mes.count = 0;
+                mes.Message = e.Message;
+                mes.data = null;
+            }
+            return mes;
+        }
+        #endregion
+
+        #region[SOP鏂囦欢鍒犻櫎]
+        public static ToMessage SystemSopDelete(string id, string filepath)
+        {
+            var sql = "";
+            List<object> list = new List<object>();
+            try
+            {
+                list.Clear();
+                sql = @"delete TK_Sop_Matfile where id=@id";
+                list.Add(new { str = sql, parm = new { id = id } });
+                bool aa = DapperHelper.DoTransaction(list);
+                string FilePath = System.Web.HttpContext.Current.Server.MapPath(filepath);//鑾峰彇鏂囦欢璺緞
+                if (System.IO.File.Exists(FilePath))//鍒ゆ柇鏂囦欢鏄惁瀛樺湪
+                {
+                    System.IO.File.Delete(FilePath);//鎵цIO鏂囦欢鍒犻櫎,闇�寮曞叆鍛藉悕绌洪棿System.IO;
+                }
+                if (aa)
+                {
+                    mes.code = "200";
+                    mes.count = 0;
+                    mes.Message = "鍒犻櫎鎴愬姛!";
+                    mes.data = null;
+                }
+                else
+                {
+                    mes.code = "300";
+                    mes.count = 0;
+                    mes.Message = "鍒犻櫎澶辫触!";
+                    mes.data = null;
+                }
+            }
+            catch (Exception e)
+            {
+                mes.code = "300";
+                mes.count = 0;
+                mes.Message = e.Message;
+                mes.data = null;
+            }
+            return mes;
+        }
+        #endregion
+
     }
 }
\ No newline at end of file
diff --git a/VueWebApi/Properties/PublishProfiles/FolderProfile1.pubxml.user b/VueWebApi/Properties/PublishProfiles/FolderProfile1.pubxml.user
index fbcdc20..9c59805 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-21T07:13:51.4848378Z;True|2022-11-21T11:02:59.6984011+08:00;True|2022-11-21T10:55:50.7022834+08:00;True|2022-11-18T16:03:51.0449470+08:00;False|2022-11-18T16:03:09.4203709+08:00;True|2022-11-18T16:01:39.4591963+08:00;True|2022-11-18T15:18:55.9443587+08:00;True|2022-11-18T15:18:44.4492390+08:00;True|2022-11-18T13:29:22.9601475+08:00;True|2022-11-18T13:29:05.4108151+08:00;True|2022-11-18T13:25:30.9305617+08:00;True|2022-11-17T10:13:35.2543186+08:00;True|2022-11-16T11:50:20.8332089+08:00;True|2022-11-16T10:30:15.8662476+08:00;True|2022-11-16T09:54:50.9630719+08:00;True|2022-11-11T13:23:20.3484151+08:00;True|2022-11-09T13:07:34.9422662+08:00;True|2022-11-09T10:59:58.4912849+08:00;True|2022-11-09T10:11:04.4851324+08:00;True|2022-11-09T10:10:46.8698985+08:00;</History>
+    <History>True|2022-11-28T09:29:35.0448121Z;True|2022-11-21T15:13:51.4848378+08:00;True|2022-11-21T11:02:59.6984011+08:00;True|2022-11-21T10:55:50.7022834+08:00;True|2022-11-18T16:03:51.0449470+08:00;False|2022-11-18T16:03:09.4203709+08:00;True|2022-11-18T16:01:39.4591963+08:00;True|2022-11-18T15:18:55.9443587+08:00;True|2022-11-18T15:18:44.4492390+08:00;True|2022-11-18T13:29:22.9601475+08:00;True|2022-11-18T13:29:05.4108151+08:00;True|2022-11-18T13:25:30.9305617+08:00;True|2022-11-17T10:13:35.2543186+08:00;True|2022-11-16T11:50:20.8332089+08:00;True|2022-11-16T10:30:15.8662476+08:00;True|2022-11-16T09:54:50.9630719+08:00;True|2022-11-11T13:23:20.3484151+08:00;True|2022-11-09T13:07:34.9422662+08:00;True|2022-11-09T10:59:58.4912849+08:00;True|2022-11-09T10:11:04.4851324+08:00;True|2022-11-09T10:10:46.8698985+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/21/2022 15:13:44</publishTime>
+      <publishTime>11/28/2022 17:29:26</publishTime>
     </File>
     <File Include="bin/VueWebApi.pdb">
-      <publishTime>11/21/2022 15:13:44</publishTime>
+      <publishTime>11/28/2022 17:29:26</publishTime>
     </File>
     <File Include="bin/VueWebApi.xml">
-      <publishTime>11/21/2022 15:13:44</publishTime>
+      <publishTime>11/28/2022 17:29:26</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/21/2022 15:13:50</publishTime>
+      <publishTime>11/28/2022 17:29:34</publishTime>
     </File>
   </ItemGroup>
 </Project>
\ No newline at end of file
diff --git a/VueWebApi/VueWebApi.csproj b/VueWebApi/VueWebApi.csproj
index 7e8de84..d803fce 100644
--- a/VueWebApi/VueWebApi.csproj
+++ b/VueWebApi/VueWebApi.csproj
@@ -548,6 +548,7 @@
     <Folder Include="App_Data\" />
     <Folder Include="DeviceImage\image1\" />
     <Folder Include="DeviceImage\image2\" />
+    <Folder Include="File\DeviceFile\" />
     <Folder Include="File\excel\" />
     <Folder Include="File\newxls\" />
     <Folder Include="InExcel\" />
diff --git a/VueWebApi/bin/VueWebApi.dll b/VueWebApi/bin/VueWebApi.dll
index 34af274..b27acb1 100644
--- a/VueWebApi/bin/VueWebApi.dll
+++ b/VueWebApi/bin/VueWebApi.dll
Binary files differ
diff --git a/VueWebApi/bin/VueWebApi.pdb b/VueWebApi/bin/VueWebApi.pdb
index 1368420..3c2b2da 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 fe492d8..7546fb7 100644
--- a/VueWebApi/bin/VueWebApi.xml
+++ b/VueWebApi/bin/VueWebApi.xml
@@ -2806,6 +2806,55 @@
             <param name="id">id</param>
             <returns></returns>
         </member>
+        <member name="M:VueWebApi.Controllers.SystemSettingController.SystemSopSearch(System.String,System.String,System.Int32,System.Int32,System.String,System.String)">
+            <summary>
+            SOP鍒楄〃鏌ヨ
+            </summary>
+            <param name="search">鎼滅储鍏抽敭瀛�</param>
+            <param name="check">鏄惁閫変腑鏈�楂樼増鏈�</param>
+            <param name="page">椤电爜</param>
+            <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+            <param name="prop">鎺掑簭瀛楁</param>
+            <param name="order">鎺掑簭瑙勫垯</param>
+            <returns></returns>
+        </member>
+        <member name="M:VueWebApi.Controllers.SystemSettingController.SystemSopDeviceSearch">
+            <summary>
+            SOP鏂囦欢涓婁紶鏌ユ壘璁惧绫诲瀷鏁版嵁
+            </summary>
+            <returns></returns>
+        </member>
+        <member name="M:VueWebApi.Controllers.SystemSettingController.SystemSopMaxVersion(System.String,System.String,System.String)">
+            <summary>
+            SOP鏂囦欢浣滀笟鏂囦欢涓婁紶鑾峰彇鏈�澶х増鏈彿
+            </summary>
+            <param name="devicetypecode">璁惧绫诲瀷缂栧彿</param>
+            <param name="filetypecode">鏂囦欢绫诲瀷缂栧彿</param>
+            <param name="partcode">鐗╂枡缂栫爜</param>
+            <returns></returns>
+        </member>
+        <member name="M:VueWebApi.Controllers.SystemSettingController.SystemSopSava">
+            <summary>
+            SOP鏂囦欢涓婁紶鎻愪氦
+            </summary>
+            <returns></returns>
+        </member>
+        <member name="M:VueWebApi.Controllers.SystemSettingController.SystemSopDelete(System.String,System.String)">
+            <summary>
+            SOP鏂囦欢鍒犻櫎
+            </summary>
+            <param name="id">鏂囦欢id</param>
+            <param name="filepath">鏂囦欢鍦板潃</param>
+            <returns></returns>
+        </member>
+        <member name="M:VueWebApi.Controllers.SystemSettingController.SystemSopView(System.String,System.String)">
+            <summary>
+            SOP鏂囦欢棰勮
+            </summary>
+            <param name="id">鏂囦欢id</param>
+            <param name="filepath">鏂囦欢鍦板潃</param>
+            <returns></returns>
+        </member>
         <member name="F:VueWebApi.Hubs.ChatHub.userList">
             <summary>
             闈欐�佺敤鎴峰垪琛�
diff --git a/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.dll b/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.dll
index 34af274..b27acb1 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 1368420..3c2b2da 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 fe492d8..7546fb7 100644
--- a/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.xml
+++ b/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.xml
@@ -2806,6 +2806,55 @@
             <param name="id">id</param>
             <returns></returns>
         </member>
+        <member name="M:VueWebApi.Controllers.SystemSettingController.SystemSopSearch(System.String,System.String,System.Int32,System.Int32,System.String,System.String)">
+            <summary>
+            SOP鍒楄〃鏌ヨ
+            </summary>
+            <param name="search">鎼滅储鍏抽敭瀛�</param>
+            <param name="check">鏄惁閫変腑鏈�楂樼増鏈�</param>
+            <param name="page">椤电爜</param>
+            <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+            <param name="prop">鎺掑簭瀛楁</param>
+            <param name="order">鎺掑簭瑙勫垯</param>
+            <returns></returns>
+        </member>
+        <member name="M:VueWebApi.Controllers.SystemSettingController.SystemSopDeviceSearch">
+            <summary>
+            SOP鏂囦欢涓婁紶鏌ユ壘璁惧绫诲瀷鏁版嵁
+            </summary>
+            <returns></returns>
+        </member>
+        <member name="M:VueWebApi.Controllers.SystemSettingController.SystemSopMaxVersion(System.String,System.String,System.String)">
+            <summary>
+            SOP鏂囦欢浣滀笟鏂囦欢涓婁紶鑾峰彇鏈�澶х増鏈彿
+            </summary>
+            <param name="devicetypecode">璁惧绫诲瀷缂栧彿</param>
+            <param name="filetypecode">鏂囦欢绫诲瀷缂栧彿</param>
+            <param name="partcode">鐗╂枡缂栫爜</param>
+            <returns></returns>
+        </member>
+        <member name="M:VueWebApi.Controllers.SystemSettingController.SystemSopSava">
+            <summary>
+            SOP鏂囦欢涓婁紶鎻愪氦
+            </summary>
+            <returns></returns>
+        </member>
+        <member name="M:VueWebApi.Controllers.SystemSettingController.SystemSopDelete(System.String,System.String)">
+            <summary>
+            SOP鏂囦欢鍒犻櫎
+            </summary>
+            <param name="id">鏂囦欢id</param>
+            <param name="filepath">鏂囦欢鍦板潃</param>
+            <returns></returns>
+        </member>
+        <member name="M:VueWebApi.Controllers.SystemSettingController.SystemSopView(System.String,System.String)">
+            <summary>
+            SOP鏂囦欢棰勮
+            </summary>
+            <param name="id">鏂囦欢id</param>
+            <param name="filepath">鏂囦欢鍦板潃</param>
+            <returns></returns>
+        </member>
         <member name="F:VueWebApi.Hubs.ChatHub.userList">
             <summary>
             闈欐�佺敤鎴峰垪琛�
diff --git a/VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache b/VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache
index f6e035c..0ab6468 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.csproj.FileListAbsolute.txt b/VueWebApi/obj/Release/VueWebApi.csproj.FileListAbsolute.txt
index 522c540..44eea37 100644
--- a/VueWebApi/obj/Release/VueWebApi.csproj.FileListAbsolute.txt
+++ b/VueWebApi/obj/Release/VueWebApi.csproj.FileListAbsolute.txt
@@ -845,7 +845,6 @@
 D:\鏂板嚡杩狹ES\MES椤圭洰\MES鐏电繑\VueWebApi\VueWebApi\bin\zh-Hans\System.Web.WebPages.resources.dll
 D:\鏂板嚡杩狹ES\MES椤圭洰\MES鐏电繑\VueWebApi\VueWebApi\bin\zh-Hans\System.Web.WebPages.Deployment.resources.dll
 D:\鏂板嚡杩狹ES\MES椤圭洰\MES鐏电繑\VueWebApi\VueWebApi\bin\zh-Hans\System.Web.WebPages.Razor.resources.dll
-D:\鏂板嚡杩狹ES\MES椤圭洰\MES鐏电繑\VueWebApi\VueWebApi\obj\Release\VueWebApi.csproj.AssemblyReference.cache
 D:\鏂板嚡杩狹ES\MES椤圭洰\MES鐏电繑\VueWebApi\VueWebApi\obj\Release\VueWebApi.csproj.CoreCompileInputs.cache
 D:\鏂板嚡杩狹ES\MES椤圭洰\MES鐏电繑\VueWebApi\VueWebApi\obj\Release\VueWebApi.csproj.CopyComplete
 D:\鏂板嚡杩狹ES\MES椤圭洰\MES鐏电繑\VueWebApi\VueWebApi\obj\Release\VueWebApi.dll
diff --git a/VueWebApi/obj/Release/VueWebApi.dll b/VueWebApi/obj/Release/VueWebApi.dll
index 34af274..b27acb1 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 1368420..3c2b2da 100644
--- a/VueWebApi/obj/Release/VueWebApi.pdb
+++ b/VueWebApi/obj/Release/VueWebApi.pdb
Binary files differ

--
Gitblit v1.9.3