From 8ca02a908efb8bb42b19b1447c3d7ae506befe48 Mon Sep 17 00:00:00 2001
From: yuyou_x <2336760928@qq.com>
Date: 星期五, 15 三月 2024 08:23:01 +0800
Subject: [PATCH] 重新编写质检结果信息
---
Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs | 55 ++++++++++++++++++---------
Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs | 36 +++++++++---------
2 files changed, 55 insertions(+), 36 deletions(-)
diff --git a/Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs b/Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs
index 4e5e8b7..a83afed 100644
--- a/Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs
+++ b/Wms/WMS.BLL/BllAsnServer/PalletBindServer.cs
@@ -1603,7 +1603,7 @@
}
//鑾峰彇璇ユ壒娆℃渶缁堣川妫�缁撴灉
- //var quality = Db.Queryable<BllQualityInspect>().Where(a => a.LotNo == noticeDetail.LotNo && a.IsDel == "0").OrderByDescending(a => a.CreateTime).ToList();
+ var quality = Db.Queryable<BllQualityInspect>().Where(a => a.IsDel == "0" && a.ASNNo == noticeDetail.ASNNo && a.LotNo == noticeDetail.LotNo).OrderByDescending(a => a.CreateTime).First();
#region 搴撳瓨鏄庣粏
var sd = new DataStockDetail()
{
@@ -1655,23 +1655,23 @@
sd.SupplierName = notice.CustomerName;//渚涘簲鍟嗗悕绉�
}
- //if (quality.Count() > 0)
- //{
- // //淇敼鍚堟牸涓嶅悎鏍兼暟閲�
- // if (quality[0].IsQualified == "1") //鍚堟牸
- // {
- // //澧炲姞鍚堟牸鏁伴噺
- // quality[0].PassQty += item.Qty;
- // sd.InspectStatus = "1";
- // }
- // else if (quality[0].IsQualified == "0") //涓嶅悎鏍�
- // {
- // //澧炲姞涓嶅悎鏍兼暟閲�
- // quality[0].FailQty += item.Qty;
- // sd.InspectStatus = "2";
- // }
- // Db.Updateable(quality[0]).ExecuteCommand(); //淇敼璐ㄦ淇℃伅
- //}
+ if (quality != null)
+ {
+ //淇敼鍚堟牸涓嶅悎鏍兼暟閲�
+ if (quality.IsQualified == "1") //鍚堟牸
+ {
+ //澧炲姞鍚堟牸鏁伴噺
+ quality.PassQty += item.Qty;
+ sd.InspectStatus = "1";
+ }
+ else if (quality.IsQualified == "0") //涓嶅悎鏍�
+ {
+ //澧炲姞涓嶅悎鏍兼暟閲�
+ quality.FailQty += item.Qty;
+ sd.InspectStatus = "2";
+ }
+ Db.Updateable(quality).ExecuteCommand(); //淇敼璐ㄦ淇℃伅
+ }
var sdId = Db.Insertable(sd).ExecuteReturnIdentity(); //鏂板搴撳瓨鏄庣粏淇℃伅
diff --git a/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs b/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs
index 7a04fe9..89172ff 100644
--- a/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs
+++ b/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs
@@ -62,7 +62,7 @@
{
isdel = "0", //鏄惁鍒犻櫎
asnno = model.ASNNo, //鍏ュ簱鍗曞彿
- skuno = "%" + model.SkuNo+ "%", //鐗╂枡鍙�
+ skuno = "%" + model.SkuNo + "%", //鐗╂枡鍙�
skuname = "%" + model.SkuName + "%", //鐗╂枡鍚嶇О
lotno = model.LotNo, //鎵规鍙�
isqualified = model.IsQualified //鏄惁鍚堟牸
@@ -78,39 +78,60 @@
/// <returns></returns>
public int InsertQuality(BllQualityInspect model)
{
+
+ //鍒涘缓璐ㄦ淇℃伅 闇�瑕� 璐ㄦ鍙枫�佸叆搴撳崟鍙枫�佺墿鏂欏彿銆佹壒娆″彿銆佹槸鍚﹀悎鏍�
//string str = "insert into BllQualityInspect values(@inspectno,@asnno,@lotno,@supplierlot,@skuno,@skuname,,@standard,@passqty,@failqty,@origin,@inspecttime,@isout,@isqualified,@isdel,@createtime,@createuser,@updatetime,@updateuser);";
+ //楠岃瘉璐ㄦ鍙锋槸鍚︿负绌�
+ if (string.IsNullOrEmpty(model.InspectNo))
+ {
+ throw new Exception("璐ㄦ鍙蜂笉鍙负绌猴紝璇锋牳鏌ワ紒");
+ }
+ //楠岃瘉鍏ュ簱鍗曞彿鏄惁涓虹┖
+ if (string.IsNullOrEmpty(model.ASNNo))
+ {
+ throw new Exception("鍏ュ簱鍗曞彿涓嶅彲涓虹┖锛岃鏍告煡锛�");
+ }
+ //楠岃瘉鐗╂枡鍙锋槸鍚︿负绌�
+ if (string.IsNullOrEmpty(model.SkuNo))
+ {
+ throw new Exception("鐗╂枡鍙蜂笉鍙负绌猴紝璇锋牳鏌ワ紒");
+ }
+ //楠岃瘉鎵规鍙锋槸鍚︿负绌�
+ if (string.IsNullOrEmpty(model.LotNo))
+ {
+ throw new Exception("鎵规鍙蜂笉鍙负绌猴紝璇锋牳鏌ワ紒");
+ }
+
+
//鏌ユ壘璐ㄦ淇℃伅涓槸鍚﹀瓨鍦ㄥ悓鎵规璐ㄦ褰曞叆璁板綍
- //BllQualityInspect quality = Db.Queryable<BllQualityInspect>().First(m => m.LotNo == model.LotNo && m.IsDel == "0");
- //if (quality != null)
- //{
- // throw new Exception("褰撳墠鎵规宸茶繘琛岃川妫�锛岃鏍告煡锛�");
- //}
+ BllQualityInspect quality = Db.Queryable<BllQualityInspect>().First(m => m.IsDel == "0" && m.ASNNo == model.ASNNo && m.SkuNo == model.SkuNo && m.LotNo == model.LotNo);
+ if (quality != null)
+ {
+ throw new Exception("褰撳墠鎵规宸茶繘琛岃川妫�锛岃鏍告煡锛�");
+ }
//鏌ユ壘鍚屾壒娆� 鍚屽崟鎹� 鍏ュ簱鍗曚俊鎭��
- BllArrivalNoticeDetail arrival = Db.Queryable<BllArrivalNoticeDetail>().First(m => m.LotNo == model.LotNo && m.IsDel == "0");
+ BllArrivalNoticeDetail arrivalDetail = Db.Queryable<BllArrivalNoticeDetail>().First(m => m.IsDel == "0" && m.ASNNo == model.ASNNo && m.LotNo == model.LotNo);
model.Origin = "WMS"; //鏉ユ簮
model.CreateTime = Db.GetDate(); //鍒涘缓鏃ユ湡
- model.SkuNo = arrival.SkuNo; //鐗╂枡鍙�
- model.SkuName = arrival.SkuName; //鐗╂枡鍚嶇О
- //model.ASNNo = arrival.ASNNo; //鍏ュ簱鍗曞彿
+ model.SkuNo = arrivalDetail.SkuNo; //鐗╂枡鍙�
+ model.SkuName = arrivalDetail.SkuName; //鐗╂枡鍚嶇О
model.PassQty = 0; //鍚堟牸鏁伴噺
model.FailQty = 0; //涓嶅悎鏍兼暟閲�
- model.Standard = arrival.Standard; //瑙勬牸
- model.SupplierLot = arrival.SupplierLot; //渚涜揣鎵规
+ model.Standard = arrivalDetail.Standard; //瑙勬牸
+ model.SupplierLot = arrivalDetail.SupplierLot; //渚涜揣鎵规
//鏌ユ壘搴撳瓨鏄庣粏淇℃伅
- List<DataStockDetail> detail = Db.Queryable<DataStockDetail>().Where(m => m.SkuNo == model.SkuNo && m.LotNo == model.LotNo && m.IsDel == "0").ToList();
+ List<DataStockDetail> detail = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.ASNNo == model.ASNNo && m.SkuNo == model.SkuNo && m.LotNo == model.LotNo).ToList();
foreach (var item in detail)
{
- List<BllBoxInfo> box = Db.Queryable<BllBoxInfo>().Where(a => a.SkuNo == model.SkuNo && a.LotNo == model.LotNo && a.IsDel == "0").ToList();
+ List<BllBoxInfo> box = Db.Queryable<BllBoxInfo>().Where(a => a.IsDel == "0" && a.ASNNo == model.ASNNo && a.SkuNo == model.SkuNo && a.LotNo == model.LotNo).ToList();
//鍒ゆ柇鍚堟牸鐘舵�佹槸鍚﹀悎鏍�
if (model.IsQualified == "1")
{
//鍚堟牸 鐩稿悓鎵规搴撳瓨淇℃伅鍏ㄩ儴鏀逛负鍚堟牸鐘舵�� 涓斿悎鏍兼暟閲忓鍔犱负鍚屾壒娆″悓鍗曞彿璇ョ墿鏂欏叏閮ㄦ暟閲忎箣鍜�
- //涓嶅悎鏍兼暟閲忎负0
- model.FailQty = 0;
model.PassQty += item.Qty;
//淇敼搴撳瓨鏄庣粏鍚堟牸鐘舵��
item.InspectStatus = "1"; //1鍚堟牸
@@ -122,8 +143,6 @@
else //涓嶅悎鏍�
{
//涓嶅悎鏍� 鐩稿悓鎵规銆佸叆搴撳崟搴撳瓨淇℃伅鍏ㄩ儴鏀逛负涓嶅悎鏍肩墿鏂� 涓斾笉鍚堟牸鏁伴噺澧炲姞涓哄悓鎵规鍚屽崟鍙疯鐗╂枡鍏ㄩ儴鏁伴噺涔嬪拰
- //鍚堟牸鏁伴噺涓�0
- model.PassQty = 0;
model.FailQty += item.Qty;
item.InspectStatus = "2"; //2涓嶅悎鏍�
foreach (var b1 in box)
--
Gitblit v1.8.0