From fbddf8270dffec0192fa40c8b78a714e72f64c6f Mon Sep 17 00:00:00 2001
From: tjx <t2856754968@163.com>
Date: 星期三, 10 十二月 2025 18:44:35 +0800
Subject: [PATCH] 11
---
StandardPda/MES.Service/service/QC/LljService.cs | 55 +++++++++++++++++++++++++++++++++++--------------------
1 files changed, 35 insertions(+), 20 deletions(-)
diff --git a/StandardPda/MES.Service/service/QC/LljService.cs b/StandardPda/MES.Service/service/QC/LljService.cs
index 397c4ef..5a1690c 100644
--- a/StandardPda/MES.Service/service/QC/LljService.cs
+++ b/StandardPda/MES.Service/service/QC/LljService.cs
@@ -1,12 +1,11 @@
-锘縰sing Masuit.Tools;
+锘縰sing System.Data;
+using Masuit.Tools;
using MES.Service.DB;
using MES.Service.Dto.service;
using MES.Service.Modes;
using MES.Service.util;
using Newtonsoft.Json;
using SqlSugar;
-using System.ComponentModel;
-using System.Data;
using DbType = System.Data.DbType;
@@ -53,7 +52,7 @@
// itemIds is { Length: > 0 },
// (a, b, c) => itemIds.Contains(a.ItemId))
.WhereIF(id > 0, (a, b, d) => a.Id == id)
- // .WhereIF(queryObj.createUser!="PL017"&& queryObj.UserIndex=="0", (a, b, d, e, f, g,h, i) => (g.Fcode == queryObj.createUser || i.Fcode == queryObj.createUser))//鍒ゆ柇姝ゅ崟鐨勬楠屽憳锛屾垨鑰呮楠屼负绌哄氨鏄剧ず姝ゅ崟鎹�
+ // .WhereIF(queryObj.createUser!="PL017"&& queryObj.UserIndex=="0", (a, b, d, e, f, g,h, i) => (g.Fcode == queryObj.createUser || i.Fcode == queryObj.createUser))//鍒ゆ柇姝ゅ崟鐨勬楠屽憳锛屾垨鑰呮楠屼负绌哄氨鏄剧ず姝ゅ崟鎹�
//鍔犵瓫閫夋潯浠�,鏍规嵁渚涘簲鍟嗭紝鐗╂枡缂栫爜锛岀墿鏂欏悕绉帮紝椤圭洰鎼滅储
//.WhereIF(queryObj.SearchValue != null && queryObj.SearchValue != "",
//(a, b, d) => (a.SuppName.ToLower().Contains(queryObj.SearchValue.ToLower())
@@ -69,11 +68,11 @@
.WhereIF(queryObj.SelectedIndex == "3" && queryObj.SearchValue != null && queryObj.SearchValue != "", (a, b, d) => (a.SuppName.ToLower().Contains(queryObj.SearchValue.ToLower())))
.WhereIF(queryObj.SelectedIndex == "4" && queryObj.SearchValue != null && queryObj.SearchValue != "", (a, b, d, e) => (e.Fname.ToLower().Contains(queryObj.SearchValue.ToLower())))
//.OrderByDescending((a, b, d) => a.Id)
- .Select((a, b, d, e, f, g,h,i) => new LtsLlj
+ .Select((a, b, d, e, f, g, h, i) => new LtsLlj
{
//UserName = g.Fname,
//UserName = (i.Fname!=null ||i.Fname!="") ? i.Fname : g.Fname,
- UserName = (i.Fname!=null ||i.Fname!="") ? i.Fname : g.Fname,
+ UserName = i.Fname != null || i.Fname != "" ? i.Fname : g.Fname,
FIRST = d.First,
CreateUserName = e.Fname,
NewFngDesc = d.NewFngDesc,
@@ -84,7 +83,7 @@
return (pageList, totalCount);
}
-
+
public DataTable getBlmsItem()
{
OracleSQLHelper SQLHelper = new();
@@ -92,6 +91,17 @@
var sql1 = @"select DEFECT_NAME
from MES_DEFECT_CODE A
left join MES_DEFECT_TYPE X ON X.TYPE_NO = A.DEFECT_SORT AND X.COMPANY = A.COMPANY AND X.FACTORY = A.FACTORY";
+
+ return SQLHelper.ExecuteQuery(sql1);
+ }
+
+ public DataTable getBlmsItem(string id)
+ {
+ OracleSQLHelper SQLHelper = new();
+ //鏌ヤ笉鑹弿杩�
+ var sql1 = string.Format(
+ @"select FCHECK_ITEM,FUNIT from mes_qa_items_detect_detail5 f where RELEASE_NO='" +
+ id + "' and FUNIT is not null order by FCHECK_ITEM");
return SQLHelper.ExecuteQuery(sql1);
}
@@ -893,7 +903,8 @@
var sql1 =
string.Format(
- @"select CASE WHEN max(MULTI_SELECT) is null THEN ''ELSE '銆�'||max(MULTI_SELECT)||'銆�' END as A,ITEMNAME as ITEMNAME from MES_IQC_CONSISTENCY_ck where PID='" + id + "' group by ITEMNAME order by ITEMNAME");
+ @"select CASE WHEN max(MULTI_SELECT) is null THEN ''ELSE '銆�'||max(MULTI_SELECT)||'銆�' END as A,ITEMNAME as ITEMNAME from MES_IQC_CONSISTENCY_ck where PID='" +
+ id + "' group by ITEMNAME order by ITEMNAME");
//鏌ユ槑缁�
var sql2 =
string.Format(@"select * from MES_IQC_CONSISTENCY_ck where PID='" +
@@ -936,18 +947,7 @@
return Components;
}
- /// <summary>
- /// 涓�鑷存�ч」鐩�
- /// </summary>
- public class Component
- {
- public string Name { get; set; }
- public List<string> Specs { get; set; }
- public List<string> Manufacturers { get; set; }
- public List<string> Id { get; set; }
- public int SelectedSpec { get; set; }
- public int SelectedMfg { get; set; }
- }
+
public void saveYzxBDlist(string id, DataTable DB)
{
OracleSQLHelper SQLHelper = new();
@@ -970,6 +970,7 @@
id + "'and id in(" + rowId + ") ");
SQLHelper.ExecuteQuery(sql2);
}
+
public string[] YzxImgVerify(string id)
{
var msgStr = new string[2];
@@ -1006,6 +1007,20 @@
return msgStr;
}
+
+ /// <summary>
+ /// 涓�鑷存�ч」鐩�
+ /// </summary>
+ public class Component
+ {
+ public string Name { get; set; }
+ public List<string> Specs { get; set; }
+ public List<string> Manufacturers { get; set; }
+ public List<string> Id { get; set; }
+ public int SelectedSpec { get; set; }
+ public int SelectedMfg { get; set; }
+ }
+
/// <summary>
/// 鏂欏彿鍥剧焊鎺ュ彛杩斿洖瀵硅薄
/// </summary>
--
Gitblit v1.9.3