增加出库合格判断

zhaowc

2024-07-04 6ed99bd95c09fc24a28a260014a95e022b050941

增加出库合格判断

 Wms/WMS.BLL/BllTransServer/RcsServer.cs

@@ -86,9 +86,9 @@
                            throw new Exception("该批次没有对应的出库单");
                        }
                        noticeno = bllSo.Id.ToString();
                        //查找库存中是否有此批次的下料桶
                        //查找库存中是否有此批次的合格下料桶
                        sql = $@"select PalletNo,LocatNo from DataStockDetail where LotNo = '{pallnetmsg.LotNo}'and AreaNo like '%03' 
                                    and WareHouseNo = '{house}' and status = '0' and PalletStatus = '2' order by CompleteTime desc";
                                    and WareHouseNo = '{house}' and status = '0' and PalletStatus = '2' and InspectStatus = '1' order by CompleteTime desc";
                        pallet = Db.Ado.SqlQuery<DataStockDetail>(sql).FirstOrDefault();
                        if (pallet == null)
                        {
@@ -482,7 +482,7 @@
                {
                    ordertype = "1";
                    sql = $"UPDATE BllExportNotice SET Status ='1' " +
                        $"where asnno = (select ASNNO from BllExportNoticeDetail where id = {taskDetial.Noticedetailno})";
                        $"where SoNO = (select SoNO from BllExportNoticeDetail where id = {taskDetial.Noticedetailno})";
                    Db.Ado.ExecuteCommand(sql);
                }
                else if(taskDetial.Type =="2" && taskDetial.Crtype == "0")//半成品入库
@@ -495,6 +495,12 @@
                    //库存中添加此托盘物料编码和编码名称
                    sql2 = $"UPDATE DataStockDetail SET SkuNo = '{ArrivalMsg.SkuNo}',SkuName = '{ArrivalMsg.SkuName}' " +
                        $"where PalletNo = '{taskDetial.Pallno}'and LotNo = '{taskDetial.LotNo}'";
                    Db.Ado.ExecuteCommand(sql2);
                }
                else if (taskDetial.Type == "1" && taskDetial.Crtype == "0")//预混桶入库
                {
                    //预混桶入库时添加到库存中此托盘的批次信息
                    sql2 = $"UPDATE DataStockDetail SET LotNo =  '{taskDetial.LotNo}' where PalletNo = '{taskDetial.Pallno}'";
                    Db.Ado.ExecuteCommand(sql2);
                }
                
@@ -550,7 +556,7 @@
                    sql = $"UPDATE SysStorageLocat SET Status = '2' where LocatNo = '{taskDetial.Endport}'";
                    if (taskDetial.Type == "2")
                    {
                        sql2 = $"UPDATE DataStockDetail SET PalletStatus = '{taskDetial.Type}',LotNo = '{taskDetial.LotNo}' " +
                        sql2 = $"UPDATE DataStockDetail SET PalletStatus = '{taskDetial.Type}'" +
                        $"where PalletNo = '{taskDetial.Pallno}'";
                        Db.Ado.ExecuteCommand(sql2);
                    }