From 22af5bed0da8a5852bd824a1e21e6fc43df6df2a Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 11 十二月 2023 19:20:43 +0800
Subject: [PATCH] 1.App 智能分析，生产进度看板接口 2.PC端设备点检项目、保养项目、点检标准、保养标准、点检记录、保养记录、维修记录 3.工序检验扫码添加判断(条码任务是否存在、工单是否关闭) 4.添加App图标图片文件
---
VueWebCoreApi/Tools/TOrganizationRecursion.cs | 55 +++++++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 53 insertions(+), 2 deletions(-)
diff --git a/VueWebCoreApi/Tools/TOrganizationRecursion.cs b/VueWebCoreApi/Tools/TOrganizationRecursion.cs
index c5d7706..b805175 100644
--- a/VueWebCoreApi/Tools/TOrganizationRecursion.cs
+++ b/VueWebCoreApi/Tools/TOrganizationRecursion.cs
@@ -10,9 +10,9 @@
{
public static ToMessage mes = new ToMessage(); //瀹氫箟鍏ㄥ眬杩斿洖淇℃伅瀵硅薄
- #region [鏍规嵁褰撳墠缁勭粐缂栫爜鑾峰彇鎵�鏈夊瓙鑺傜偣缁勭粐(鍖呭惈鑷韩)]
+ #region [鏍规嵁褰撳墠缁勭粐缂栫爜鑾峰彇鎵�鏈夊瓙鑺傜偣缁勭粐(鍖呭惈鑷韩,甯﹀崟寮曞彿)]
/// <summary>
- /// 鏍规嵁褰撳墠缁勭粐缂栫爜鑾峰彇鎵�鏈夊瓙鑺傜偣缁勭粐(鍖呭惈鑷韩)
+ /// 鏍规嵁褰撳墠缁勭粐缂栫爜鑾峰彇鎵�鏈夊瓙鑺傜偣缁勭粐(鍖呭惈鑷韩,甯﹀崟寮曞彿)
/// </summary>
/// <param name="torg_code">缁勭粐缂栫爜</param>
/// <returns></returns>
@@ -60,5 +60,56 @@
return mes;
}
#endregion
+
+ #region [鏍规嵁褰撳墠缁勭粐缂栫爜鑾峰彇鎵�鏈夊瓙鑺傜偣缁勭粐(鍖呭惈鑷韩,涓嶅甫鍗曞紩鍙�)]
+ /// <summary>
+ /// 鏍规嵁褰撳墠缁勭粐缂栫爜鑾峰彇鎵�鏈夊瓙鑺傜偣缁勭粐(鍖呭惈鑷韩,涓嶅甫鍗曞紩鍙�)
+ /// </summary>
+ /// <param name="torg_code">缁勭粐缂栫爜</param>
+ /// <returns></returns>
+ public static ToMessage TOrgCodeSeachNo(string torg_code)
+ {
+ string sql;
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ sql = @" WITH RecursiveCTE AS (
+ SELECT id, parent_id, torg_code, torg_name, status, leve, torg_seq
+ FROM TOrganization
+ WHERE torg_code = @torg_code
+ UNION ALL
+ SELECT o.id, o.parent_id, o.torg_code, o.torg_name, o.status, o.leve, o.torg_seq
+ FROM TOrganization o
+ INNER JOIN RecursiveCTE r ON r.torg_code = o.parent_id
+ )
+ SELECT STUFF((SELECT ',' + torg_code FROM RecursiveCTE
+ FOR XML PATH('')), 1, 1, '') AS torg_codelist";
+ dynamicParams.Add("@torg_code", torg_code);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0 && data.Rows[0]["torg_codelist"].ToString() != null)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = data.Rows[0]["torg_codelist"].ToString();
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = "褰撳墠鐢ㄦ埛鎵�灞炵粍缁囩紪鐮併��" + torg_code + "銆戜笉瀛樺湪!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
}
}
--
Gitblit v1.9.3