From 8aad6ba8e082d1fb63bfdd947f7e9da1bc133611 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 24 六月 2022 23:47:19 +0800
Subject: [PATCH] 工序定义接口开发、节拍工价接口开发

---
 VueWebApi/DLL/DAL/BasicSettingDAL.cs |  261 ++++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 232 insertions(+), 29 deletions(-)

diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index 8875edf..49a4858 100644
--- a/VueWebApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
@@ -75,7 +75,9 @@
             catch (Exception e)
             {
                 mes.code = "300";
+                mes.count = 0;
                 mes.Message = e.Message;
+                mes.data = null;
             }
             return mes;
         }
@@ -134,7 +136,9 @@
             catch (Exception e)
             {
                 mes.code = "300";
+                mes.count = 0;
                 mes.Message = e.Message;
+                mes.data = null;
             }
             return mes;
         }
@@ -160,12 +164,16 @@
                     if (cont > 0)
                     {
                         mes.code = "200";
+                        mes.count = 0;
                         mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+                        mes.data = null;
                     }
                     else
                     {
                         mes.code = "300";
+                        mes.count = 0;
                         mes.Message = "鏂板鎿嶄綔澶辫触!";
+                        mes.data = null;
                     }
                 }
                 if (operType == "Update")
@@ -181,19 +189,25 @@
                     if (cont > 0)
                     {
                         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;
         }
@@ -223,19 +237,25 @@
                     if (cont > 0)
                     {
                         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;
         }
@@ -294,7 +314,9 @@
             catch (Exception e)
             {
                 mes.code = "300";
+                mes.count = 0;
                 mes.Message = e.Message;
+                mes.data = null;
             }
             return mes;
         }
@@ -330,7 +352,9 @@
             catch (Exception e)
             {
                 mes.code = "300";
+                mes.count = 0;
                 mes.data = e.Message;
+                mes.data = null;
             }
             return mes;
         }
@@ -386,12 +410,16 @@
                     if (cont > 0)
                     {
                         mes.code = "200";
+                        mes.count = 0;
                         mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+                        mes.data = null;
                     }
                     else
                     {
                         mes.code = "300";
+                        mes.count = 0;
                         mes.Message = "鏂板鎿嶄綔澶辫触!";
+                        mes.data = null;
                     }
                 }
                 if (OperType == "Update")
@@ -411,19 +439,25 @@
                     if (cont > 0)
                     {
                         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;
         }
@@ -442,7 +476,7 @@
                 dynamicParams.Add("@userid", userid);
                 var data = DapperHelper.selectdata(sql, dynamicParams);
 
-                sql = @"update TUserRoleRelation set is_delete='1'  where user_code=@usercode";
+                sql = @"delete TUserRoleRelation  where user_code=@usercode";
                 list.Add(new { str = sql, parm = new { usercode = data.Rows[0]["USERCODE"].ToString() } });
 
                 sql = @"update TUser set is_delete='1'  where id=@userid";
@@ -451,18 +485,24 @@
                 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;
         }
@@ -505,7 +545,9 @@
             catch (Exception e)
             {
                 mes.code = "300";
+                mes.count = 0;
                 mes.Message = e.Message;
+                mes.data = null;
             }
             return mes;
         }
@@ -552,18 +594,24 @@
                 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;
         }
@@ -583,7 +631,9 @@
                 if (rowsnum == 0)
                 {
                     mes.code = "300";
+                    mes.count = 0;
                     mes.Message = "Excel琛ㄦ牸涓虹┖,鏃犳暟鎹紒";
+                    mes.data = null;
                 }
                 else
                 {
@@ -614,19 +664,25 @@
                     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;
         }
@@ -644,7 +700,7 @@
                 var total = 0; //鎬绘潯鏁�
                 var sql = @"select roletype_code,roletype_name 
                             from TRoleType 
-                            where  A.is_delete<>'1' ";
+                            where  is_delete<>'1' ";
                 var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                 mes.code = "200";
                 mes.Message = "鏌ヨ鎴愬姛!";
@@ -654,7 +710,9 @@
             catch (Exception e)
             {
                 mes.code = "300";
+                mes.count = 0;
                 mes.Message = e.Message;
+                mes.data = null;
             }
             return mes;
         }
@@ -672,7 +730,7 @@
                 //寰幆鍐欏叆瑙掕壊绫诲瀷琛�
                 for (int i = 0; i < json.Count; i++)
                 {
-                    sql = @"insert into TRoleType(roletypecode,roletypename) values(@roletypecode,@roletypename)";
+                    sql = @"insert into TRoleType(roletype_code,roletype_name) values(@roletypecode,@roletypename)";
                     list.Add(new
                     {
                         str = sql,
@@ -687,18 +745,24 @@
                 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;
         }
@@ -720,18 +784,48 @@
                 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[瑙掕壊绫诲瀷涓嬫媺鎺ュ彛]
+        public static ToMessage RoleTypeSelect()
+        {
+            string sql = "";
+            try
+            {
+                //鑾峰彇璁惧绫诲瀷鏁版嵁
+                sql = @"select roletype_code,roletype_name from TRoleType where is_delete<>'1' ";
+                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;
         }
@@ -771,7 +865,7 @@
                 //search = search.Substring(3);//鎴彇绱㈠紩2鍚庨潰鐨勫瓧绗�
                 // --------------鏌ヨ鎸囧畾鏁版嵁--------------
                 var total = 0; //鎬绘潯鏁�
-                var sql = @"select A.role_code,A.role_name,b.roletype_code,B.roletype_name,A.lm_user,A.lm_date,A.is_user,A.is_right  
+                var sql = @"select A.id,A.role_code,A.role_name,b.roletype_code,B.roletype_name,A.description,A.lm_user,A.lm_date,A.is_user,A.is_right  
                             from TRole A
                             left join TRoleType  B on A.roletype_code=B.roletype_code
                             where  A.is_delete<>'1' " + search;
@@ -784,7 +878,9 @@
             catch (Exception e)
             {
                 mes.code = "300";
+                mes.count = 0;
                 mes.Message = e.Message;
+                mes.data = null;
             }
             return mes;
         }
@@ -810,17 +906,21 @@
                     if (cont > 0)
                     {
                         mes.code = "200";
+                        mes.count = 0;
                         mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+                        mes.data = null;
                     }
                     else
                     {
                         mes.code = "300";
+                        mes.count = 0;
                         mes.Message = "鏂板鎿嶄綔澶辫触!";
+                        mes.data = null;
                     }
                 }
                 if (OperType == "Update")
                 {
-                    var sql = @"update TRole set role_name=@UserName,Usercode=@Usercode,CreateDate=@CreateDate,RoleTypeCode=@RoleTypeCode,description=@description where id=@RoleId";
+                    var sql = @"update TRole set role_name=@RoleName,lm_user=@Usercode,lm_date=@CreateDate,roletype_code=@RoleTypeCode,description=@description where id=@RoleId";
                     dynamicParams.Add("@RoleId", RoleId);
                     dynamicParams.Add("@RoleName", RoleName);
                     dynamicParams.Add("@Usercode", Usercode);
@@ -831,19 +931,25 @@
                     if (cont > 0)
                     {
                         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;
         }
@@ -860,27 +966,33 @@
                 sql = @"update TRole set is_user='N',is_right='N',is_delete='1'  where role_code=@RoleCode";
                 list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
                 //鏇存柊瑙掕壊鍏宠仈鐢ㄦ埛琛ㄣ�佽鑹插叧鑱旂敤鎴锋爣璇嗗強鍒犻櫎鐘舵��
-                sql = @"update TUserRoleRelation set is_delete='1'  where role_code=@RoleCode";
+                sql = @"delete TUserRoleRelation  where role_code=@RoleCode";
                 list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
                 //鍒犻櫎(鏇存柊鐘舵��)瑙掕壊鍔熻兘琛�
-                sql = @"update TRoleRightRelation set is_delete='1'  where user_code=@RoleCode";
+                sql = @"update TRoleRightRelation set is_delete='1'  where role_code=@RoleCode";
                 list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
                 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;
         }
@@ -895,12 +1007,12 @@
             {
                 if (usercode != "" && usercode != null)
                 {
-                    search += "and A.usercode like '%'+@RoleCode+'%' ";
+                    search += "and A.usercode like '%'+@usercode+'%' ";
                     dynamicParams.Add("@usercode", usercode);
                 }
                 if (username != "" && username != null)
                 {
-                    search += "and A.username like '%'+@RoleName+'%' ";
+                    search += "and A.username like '%'+@username+'%' ";
                     dynamicParams.Add("@username", username);
                 }
                 if (orgcode != "" && orgcode != null)
@@ -921,7 +1033,7 @@
                 }
                 if (search == "")
                 {
-                    search = "and 1=1 ";
+                    search = " and 1=1 ";
                 }
                 //search = search.Substring(3);//鎴彇绱㈠紩2鍚庨潰鐨勫瓧绗�
                 // --------------鏌ヨ鎸囧畾鏁版嵁--------------
@@ -931,7 +1043,8 @@
                              left join TOrganization B on A.stu_torgcode=B.org_code
                              left join (
                                 select distinct user_code  from TUserRoleRelation where role_code=@rolecode
-                             ) C on A.usercode=C.user_code" + search;
+                             ) C on A.usercode=C.user_code where A.is_delete<>'1' " + search;
+                dynamicParams.Add("@rolecode", rolecode);
                 var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                 mes.code = "200";
                 mes.Message = "鏌ヨ鎴愬姛!";
@@ -941,7 +1054,36 @@
             catch (Exception e)
             {
                 mes.code = "300";
+                mes.count = 0;
                 mes.Message = e.Message;
+                mes.data = null;
+            }
+            return mes;
+        }
+        #endregion
+
+        #region[鐢ㄦ埛娓呭崟鍏宠仈瑙掕壊鏌ヨ1]
+        public static ToMessage RoleAssociationUserTwo(string rolecode)
+        {
+            string sql = "";
+            var dynamicParams = new DynamicParameters();
+            List<TreeObejct> list = new List<TreeObejct>();
+            try
+            {
+                //鑾峰彇瑙掕壊绫诲瀷闆嗗悎(鍖呭惈缁戝畾鏍囪瘑)
+                dynamicParams.Add("@role_code", rolecode);
+                var data = DapperHelper.selectProcedure("h_p_T_RoleAssociationUserDisplay", 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;
         }
@@ -972,8 +1114,8 @@
                     //寰幆鍐欏叆鐢ㄦ埛鍏宠仈瑙掕壊琛�
                     for (int i = 0; i < json.Count; i++)
                     {
-                        sql = @"insert into TUserRoleRelation(usercode,role_code) values(@usercode,@role_code)";
-                        list.Add(new { str = sql, parm = new { usercode = json[i], role_code = rolecode } });
+                        sql = @"insert into TUserRoleRelation(user_code,role_code) values(@usercode,@role_code)";
+                        list.Add(new { str = sql, parm = new { usercode = json[i].code, role_code = rolecode } });
                     }
                     //鏍囪瑙掕壊琛ㄥ叧鑱旂敤鎴锋爣璇�
                     sql = @"update TRole set is_user='Y' where role_code=@rolecode";
@@ -983,18 +1125,24 @@
                 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;
         }
@@ -1003,8 +1151,6 @@
         #region[瑙掕壊娓呭崟鍏宠仈鍔熻兘鏌ヨ]
         public static ToMessage RoleAssociationRight(string rolecode,string type)
         {
-
-            Dictionary<object, object> dList = new Dictionary<object, object>();
             List<object> list=new List<object>();
             try
             {
@@ -1021,13 +1167,16 @@
                     list.Add(SeachEncode.RightLocation(rolecode, type));
                 }
                 mes.code = "200";
+                mes.count = list.Count;
                 mes.Message = "鏌ヨ鎴愬姛!";
                 mes.data = list;
             }
             catch (Exception e)
             {
                 mes.code = "300";
+                mes.count = 0;
                 mes.Message = e.Message;
+                mes.data = null;
             }
             return mes;
         }
@@ -1080,18 +1229,24 @@
                 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;
         }
@@ -1117,8 +1272,21 @@
                 }
                 if (unitAttr != "" && unitAttr != null)
                 {
-                    search += "and unitattribute=@unitAttr ";
-                    dynamicParams.Add("@unitAttr", unitAttr);
+                    switch (unitAttr)
+                    {
+                        case "WG":  //澶栬喘
+                            search += "and mtype=@unitAttr ";
+                            dynamicParams.Add("@unitAttr", unitAttr);
+                            break;
+                        case "WX":  //澶栧崗
+                            search += "and btype=@unitAttr ";
+                            dynamicParams.Add("@unitAttr", unitAttr);
+                            break;
+                        default:    //瀹㈡埛
+                            search += "and htype=@unitAttr ";
+                            dynamicParams.Add("@unitAttr", unitAttr);
+                            break;
+                    }
                 }
                 if (createUser != "" && createUser != null)
                 {
@@ -1131,7 +1299,7 @@
                 }
                 // --------------鏌ヨ鎸囧畾鏁版嵁--------------
                 var total = 0; //鎬绘潯鏁�
-                var sql = @"select id,code,name,unitattribute,conttacts,addr,lm_user,lm_date from TCustomer
+                var sql = @"select id,code,name,mtype,btype,htype,conttacts,conttphone,addr,lm_user,lm_date from TCustomer
                             where  is_delete<>'1' " + search;
                 var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                 mes.code = "200";
@@ -1142,25 +1310,29 @@
             catch (Exception e)
             {
                 mes.code = "300";
+                mes.count = 0;
                 mes.Message = e.Message;
+                mes.data = null;
             }
             return mes;
         }
         #endregion
 
         #region[寰�鏉ュ崟浣嶆柊澧炵紪杈慮
-        public static ToMessage AddUpdateCurrentUnit(string unitid, string unitcode, string unitname, string unitattr, string person, string contact, string description, string usercode,string OperType)
+        public static ToMessage AddUpdateCurrentUnit(string unitid, string unitcode, string unitname, string mtypecode, string btypecode, string htypecode, string person, string contact, string description, string usercode,string OperType)
         {
             var dynamicParams = new DynamicParameters();
             try
             {
                 if (OperType == "Add")
                 {
-                    var sql = @"insert into TCustomer(code,name,unitattribute,conttacts,conttphone,addr,lm_user,lm_date) 
-                            values(@unitcode,@unitname,@unitattr,@person,@contact,@description,@usercode,@CreateDate)";
+                    var sql = @"insert into TCustomer(code,name,mtype,btype,htype,conttacts,conttphone,addr,lm_user,lm_date) 
+                            values(@unitcode,@unitname,@mtypecode,@btypecode,@htypecode,@person,@contact,@description,@usercode,@CreateDate)";
                     dynamicParams.Add("@unitcode", unitcode);
                     dynamicParams.Add("@unitname", unitname);
-                    dynamicParams.Add("@unitattr", unitattr);
+                    dynamicParams.Add("@mtypecode", mtypecode);
+                    dynamicParams.Add("@btypecode", btypecode);
+                    dynamicParams.Add("@htypecode", htypecode);
                     dynamicParams.Add("@person", person);
                     dynamicParams.Add("@contact", contact);
                     dynamicParams.Add("@description", description);
@@ -1170,20 +1342,26 @@
                     if (cont > 0)
                     {
                         mes.code = "200";
+                        mes.count = 0;
                         mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+                        mes.data = null;
                     }
                     else
                     {
                         mes.code = "300";
+                        mes.count = 0;
                         mes.Message = "鏂板鎿嶄綔澶辫触!";
+                        mes.data = null;
                     }
                 }
                 if (OperType == "Update")
                 {
-                    var sql = @"update TCustomer set name=@unitname,unitattribute=@unitattr,conttacts=@person,conttphone=@contact,addr=@description,lm_user=@usercode,lm_date=@CreateDate where id=@RoleId";
+                    var sql = @"update TCustomer set name=@unitname,mtype=@mtypecode,btype=@btypecode,htype=@htypecode,conttacts=@person,conttphone=@contact,addr=@description,lm_user=@usercode,lm_date=@CreateDate where id=@unitid";
                     dynamicParams.Add("@unitid", unitid);
                     dynamicParams.Add("@unitname", unitname);
-                    dynamicParams.Add("@unitattr", unitattr);
+                    dynamicParams.Add("@mtypecode", mtypecode);
+                    dynamicParams.Add("@btypecode", btypecode);
+                    dynamicParams.Add("@htypecode", htypecode);
                     dynamicParams.Add("@person", person);
                     dynamicParams.Add("@contact", contact);
                     dynamicParams.Add("@description", description);
@@ -1193,50 +1371,75 @@
                     if (cont > 0)
                     {
                         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[寰�鏉ュ崟浣嶅垹闄
-        public static ToMessage DeleteCurrentUnit(string unitid)
+        public static ToMessage DeleteCurrentUnit(string unitcode)
         {
             var sql = "";
             List<object> list = new List<object>();
+            var dynamicParams = new DynamicParameters();
             try
             {
+                list.Clear();
+                sql = @"select *  from TFlw_Rteqp where eqp_code=@unitcode";
+                dynamicParams.Add("@unitcode", unitcode);
+                var data = DapperHelper.selectdata(sql, dynamicParams);
+                if (data.Rows.Count > 0)
+                {
+                    mes.code = "300";
+                    mes.count = 0;
+                    mes.Message = "澶栧崗渚涙柟宸插叧鑱斿鍗忓伐搴�,涓嶅厑璁稿垹闄�!";
+                    mes.data = null;
+                    return mes;
+                }
                 //鍒犻櫎(鏇存柊鐘舵��)寰�鏉ュ崟浣嶈〃
-                sql = @"update TCustomer set is_delete='1'  where id=@unitid";
-                list.Add(new { str = sql, parm = new { unitid = unitid } });
+                sql = @"update TCustomer set is_delete='1'  where code=@unitcode";
+                list.Add(new { str = sql, parm = new { unitcode = unitcode } });
                 bool aa = DapperHelper.DoTransaction(list);
                 if (aa)
                 {
                     mes.code = "200";
-                    mes.Message = "鍒犻櫎鐢ㄦ埛鎴愬姛!";
+                    mes.count = 0;
+                    mes.Message = "鍒犻櫎鎴愬姛!";
+                    mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
-                    mes.Message = "鍒犻櫎鐢ㄦ埛澶辫触!";
+                    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;
         }

--
Gitblit v1.9.3