From 986bbf207ec3ecab9dfbf3fed50b565d2a2676fc Mon Sep 17 00:00:00 2001
From: xwt <2740516069@qq.com>
Date: 星期六, 19 七月 2025 14:48:27 +0800
Subject: [PATCH] 来料检上传附件
---
StandardInterface/MES.Service/service/QC/RKJService.cs | 14 ++++++++------
1 files changed, 8 insertions(+), 6 deletions(-)
diff --git a/StandardInterface/MES.Service/service/QC/RKJService.cs b/StandardInterface/MES.Service/service/QC/RKJService.cs
index d7a9df3..f103adf 100644
--- a/StandardInterface/MES.Service/service/QC/RKJService.cs
+++ b/StandardInterface/MES.Service/service/QC/RKJService.cs
@@ -17,7 +17,7 @@
var db = SqlSugarHelper.GetInstance();
var date = DateTime.Now.ToString("yyyy-MM-dd");
var sql =
- "select max(RELEASE_NO) from QS_ITEM_OQC_REQ where RELEASE_NO like 'RKJN%' and to_char(CREATE_DATE,'yyyy-mm-dd') ='" +
+ "select max(RELEASE_NO) from QS_ITEM_OQC_REQ where RELEASE_NO like 'RKJY%' and to_char(CREATE_DATE,'yyyy-mm-dd') ='" +
date + "'";
var maxBillNo = db.Ado.SqlQuerySingle<string>(sql);
@@ -31,7 +31,7 @@
number = no.ToString().PadLeft(4, '0');
}
- return "RKJN" + date.Replace("-", "") + number;
+ return "RKJY" + date.Replace("-", "") + number;
}
//閫夋嫨浜х嚎
@@ -54,8 +54,8 @@
{
var db = SqlSugarHelper.GetInstance();
return db.Queryable<RKJDaa001>()
- .Where(t => t.Daa020 == lineNo)
- .OrderBy(t => t.ItemInId, OrderByType.Desc)
+ .Where(t => t.Daa015 == lineNo)
+ .OrderBy(t => t.BillNo, OrderByType.Desc)
.ToList();
//return null;
}
@@ -228,6 +228,9 @@
xj.CreateBy = userNo;
xj.CreateDate = DateTime.Now;
+ // 鏂板锛氫繚瀛橀�佹鎵规
+ if (!string.IsNullOrEmpty(rkjDto.RbillNo))
+ xj.RbillNo = rkjDto.RbillNo;
var pid = db.Insertable(xj).ExecuteReturnIdentity();
@@ -479,9 +482,8 @@
FcheckBy = a.FcheckBy,
FcheckDate = a.FcheckDate,
ReleaseNo = a.ReleaseNo,
+ RbillNo = a.RbillNo,
// 娣诲姞鍏朵粬瀛楁
- // 濡傛灉鍦� QsItemOqcReq 涓畾涔変簡棰濆瀛楁锛屽垯闇�瑕佸皢瀹冧滑璧嬪��
- // 渚嬪:
ItemName = b.ItemName,
ItemModel = b.ItemModel,
TaskNo = c.TaskNo,
--
Gitblit v1.9.3