From 799a463b41e84aa265f109035c08892614ea9fd8 Mon Sep 17 00:00:00 2001
From: kyy <3283105747@qq.com>
Date: 星期四, 24 七月 2025 21:12:32 +0800
Subject: [PATCH] 首检排序
---
MES.Service/service/PLM/PLMManager.cs | 107 ++++++++++++++++++++++++++---------------------------
1 files changed, 53 insertions(+), 54 deletions(-)
diff --git a/MES.Service/service/PLM/PLMManager.cs b/MES.Service/service/PLM/PLMManager.cs
index b5cbe06..499c38f 100644
--- a/MES.Service/service/PLM/PLMManager.cs
+++ b/MES.Service/service/PLM/PLMManager.cs
@@ -1,55 +1,49 @@
-锘縰sing Kingdee.CDP.WebApi.SDK;
+锘縰sing System.Text;
+using Kingdee.CDP.WebApi.SDK;
using MES.Service.Dto.webApi.PLM;
-using System.Text;
-using System.Text.RegularExpressions;
-using Oracle.ManagedDataAccess.Client;
-using PdfiumViewer;
-
namespace MES.Service.service.PLM;
-
public class PLMManager
{
public List<StdDocument> RetrieveDrawings(string ItemNo)
{
- List<BaseObject> baseObjects = GetPlmCfgBase(ItemNo);
+ var baseObjects = GetPlmCfgBase(ItemNo);
- List<RelatedObject> relatedObjects = GetPlmCfgRelatedObject(baseObjects[0].FID);
+ var relatedObjects = GetPlmCfgRelatedObject(baseObjects[0].FID);
// 妫�鏌ヨ繑鍥炵粨鏋滄槸鍚︿负绌�
if (relatedObjects == null || !relatedObjects.Any())
- {
throw new NotImplementedException("杩斿洖缁撴灉涓虹┖");
- }
- List<StdDocument> stdDocuments = GetPlmStdDocument(relatedObjects);
+ var stdDocuments = GetPlmStdDocument(relatedObjects);
return stdDocuments;
}
#region 1.閫氳繃鐗╂枡缂栫爜锛堥渶瑕佸敮涓�锛夎幏鍙栫墿鏂檌d
+
public List<BaseObject> GetPlmCfgBase(string ItemNo)
{
//娉ㄦ剰 1锛氭澶勪笉鍐嶄娇鐢ㄥ弬鏁板舰寮忎紶鍏ョ敤鎴峰悕鍙婂瘑鐮佺瓑鏁忔劅淇℃伅锛屾敼涓哄湪鐧诲綍閰嶇疆鏂囦欢涓缃��
//娉ㄦ剰 2锛氬繀椤诲厛閰嶇疆绗笁鏂圭郴缁熺櫥褰曟巿鏉冧俊鎭悗锛屽啀杩涜涓氬姟鎿嶄綔锛岃鎯呭弬鑰冨悇璇█鐗堟湰SDK浠嬬粛涓殑鐧诲綍閰嶇疆鏂囦欢璇存槑銆�
//璇诲彇閰嶇疆锛屽垵濮嬪寲SDK
- K3CloudApi client = new K3CloudApi();
+ var client = new K3CloudApi();
//鐢ㄤ簬璁板綍缁撴灉
- StringBuilder Info = new StringBuilder();
+ var Info = new StringBuilder();
//涓氬姟瀵硅薄鏍囪瘑
//string formId = "PLM_STD_DOCUMENT";
- string formId = "PLM_CFG_BASE";
- DateTime dt = DateTime.Now;
+ var formId = "PLM_CFG_BASE";
+ var dt = DateTime.Now;
//鏌ヨ瀛楁闆嗗悎锛屽嵆杩斿洖鍝簺鏁版嵁锛屼笉鑳戒负绌猴紝鏍规嵁涓嶅悓涓氬姟鍗曟嵁濉啓涓嶅悓鐨勫瓧娈靛悕锛屼互涓嬩粎涓虹ず渚�
//string fieldKeys = "FCode,FFileId,FRelevantObject";
//string FilterString = "FID='-2146304'";
- string fieldKeys = "FID,FCode,FName";
- string FilterString = string.Format(@"FCode='{0}'", ItemNo);
- string OrderString = "";
- int TopRowCount = 0;
- int StartRow = 0;
- int Limit = 0;
+ var fieldKeys = "FID,FCode,FName";
+ var FilterString = string.Format(@"FCode='{0}'", ItemNo);
+ var OrderString = "";
+ var TopRowCount = 0;
+ var StartRow = 0;
+ var Limit = 0;
- var param = new QueryParam()
+ var param = new QueryParam
{
FormId = formId,
FieldKeys = fieldKeys,
@@ -68,37 +62,40 @@
{
FID = (long)s[0],
FCode = (string)s[1],
- FName = (string)s[2],
+ FName = (string)s[2]
};
return entity;
}).ToList();
}
+
#endregion
#region 2.閫氳繃鐗╂枡id鑾峰彇鐩稿叧瀵硅薄銆愪笅杞介渶瑕佺殑鏂囨。銆戠殑id
+
public List<RelatedObject> GetPlmCfgRelatedObject(long? FRelatedObject)
{
//娉ㄦ剰 1锛氭澶勪笉鍐嶄娇鐢ㄥ弬鏁板舰寮忎紶鍏ョ敤鎴峰悕鍙婂瘑鐮佺瓑鏁忔劅淇℃伅锛屾敼涓哄湪鐧诲綍閰嶇疆鏂囦欢涓缃��
//娉ㄦ剰 2锛氬繀椤诲厛閰嶇疆绗笁鏂圭郴缁熺櫥褰曟巿鏉冧俊鎭悗锛屽啀杩涜涓氬姟鎿嶄綔锛岃鎯呭弬鑰冨悇璇█鐗堟湰SDK浠嬬粛涓殑鐧诲綍閰嶇疆鏂囦欢璇存槑銆�
//璇诲彇閰嶇疆锛屽垵濮嬪寲SDK
- K3CloudApi client = new K3CloudApi();
+ var client = new K3CloudApi();
//鐢ㄤ簬璁板綍缁撴灉
- StringBuilder Info = new StringBuilder();
+ var Info = new StringBuilder();
//涓氬姟瀵硅薄鏍囪瘑
//string formId = "PLM_STD_DOCUMENT";
- string formId = "PLM_CFG_RELATEDOBJECT";
- DateTime dt = DateTime.Now;
+ var formId = "PLM_CFG_RELATEDOBJECT";
+ var dt = DateTime.Now;
//鏌ヨ瀛楁闆嗗悎锛屽嵆杩斿洖鍝簺鏁版嵁锛屼笉鑳戒负绌猴紝鏍规嵁涓嶅悓涓氬姟鍗曟嵁濉啓涓嶅悓鐨勫瓧娈靛悕锛屼互涓嬩粎涓虹ず渚�
//string fieldKeys = "FCode,FFileId,FRelevantObject";
//string FilterString = "FID='-2146304'";
- string fieldKeys = "FID,FRE_FCode,FRelatedObject";
- string FilterString = string.Format(@"FRelatedObject='{0}'", FRelatedObject);
- string OrderString = "";
- int TopRowCount = 0;
- int StartRow = 0;
- int Limit = 0;
+ var fieldKeys = "FID,FRE_FCode,FRelatedObject";
+ var FilterString =
+ string.Format(@"FRelatedObject='{0}'", FRelatedObject);
+ var OrderString = "";
+ var TopRowCount = 0;
+ var StartRow = 0;
+ var Limit = 0;
- var param = new QueryParam()
+ var param = new QueryParam
{
FormId = formId,
FieldKeys = fieldKeys,
@@ -117,39 +114,43 @@
{
FID = (long)s[0],
FRE_FCode = (string)s[1],
- FRelatedObject = (long)s[2],
+ FRelatedObject = (long)s[2]
};
return entity;
}).ToList();
}
+
#endregion
#region 3.鏍规嵁鏂囨。id鑾峰彇鏂囨。鐗╃悊鏂囦欢id
- public List<StdDocument> GetPlmStdDocument(List<RelatedObject> relatedObjects)
+
+ public List<StdDocument> GetPlmStdDocument(
+ List<RelatedObject> relatedObjects)
{
//娉ㄦ剰 1锛氭澶勪笉鍐嶄娇鐢ㄥ弬鏁板舰寮忎紶鍏ョ敤鎴峰悕鍙婂瘑鐮佺瓑鏁忔劅淇℃伅锛屾敼涓哄湪鐧诲綍閰嶇疆鏂囦欢涓缃��
//娉ㄦ剰 2锛氬繀椤诲厛閰嶇疆绗笁鏂圭郴缁熺櫥褰曟巿鏉冧俊鎭悗锛屽啀杩涜涓氬姟鎿嶄綔锛岃鎯呭弬鑰冨悇璇█鐗堟湰SDK浠嬬粛涓殑鐧诲綍閰嶇疆鏂囦欢璇存槑銆�
//璇诲彇閰嶇疆锛屽垵濮嬪寲SDK
- K3CloudApi client = new K3CloudApi();
+ var client = new K3CloudApi();
//鐢ㄤ簬璁板綍缁撴灉
- StringBuilder Info = new StringBuilder();
+ var Info = new StringBuilder();
//涓氬姟瀵硅薄鏍囪瘑
- string formId = "PLM_STD_DOCUMENT";
- DateTime dt = DateTime.Now;
+ var formId = "PLM_STD_DOCUMENT";
+ var dt = DateTime.Now;
//鏌ヨ瀛楁闆嗗悎锛屽嵆杩斿洖鍝簺鏁版嵁锛屼笉鑳戒负绌猴紝鏍规嵁涓嶅悓涓氬姟鍗曟嵁濉啓涓嶅悓鐨勫瓧娈靛悕锛屼互涓嬩粎涓虹ず渚�
- string fieldKeys = "FID,FCode,FName,FPhysicalFileName,FFileId,FRelevantObject";
+ var fieldKeys =
+ "FID,FCode,FName,FPhysicalFileName,FFileId,FRelevantObject";
// 鎻愬彇 FID 鍊�
var fidList = relatedObjects.Select(obj => obj.FID.ToString()).ToList();
// 灏� FID 鍊肩敤閫楀彿鍒嗛殧锛屽苟鍖呰９鍦ㄥ崟寮曞彿涓�
- string fids = string.Join(",", fidList.Select(fid => $"'{fid}'"));
+ var fids = string.Join(",", fidList.Select(fid => $"'{fid}'"));
// 鏋勫缓 FilterString
- string FilterString = $"FID in ({fids})";
- string OrderString = "";
- int TopRowCount = 0;
- int StartRow = 0;
- int Limit = 0;
+ var FilterString = $"FID in ({fids})";
+ var OrderString = "";
+ var TopRowCount = 0;
+ var StartRow = 0;
+ var Limit = 0;
- var param = new QueryParam()
+ var param = new QueryParam
{
FormId = formId,
FieldKeys = fieldKeys,
@@ -171,13 +172,11 @@
FName = (string)s[2],
FPhysicalFileName = (string)s[3],
FFileId = (string)s[4],
- FRelevantObject = (string)s[5],
+ FRelevantObject = (string)s[5]
};
return entity;
}).ToList();
}
+
#endregion
-
-
-
-}
+}
\ No newline at end of file
--
Gitblit v1.9.3