物料管理页面修改

zhaowc

12 小时以前 71d1dcdf796f08fa01cbc2d3faab86eea28b295b

 Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs

@@ -96,6 +96,11 @@
                throw new Exception("质检号不可为空，请核查！");
            }
            //验证批次号是否为空
            if (string.IsNullOrEmpty(model.SkuNo))
            {
                throw new Exception("物料编码不可为空，请核查！");
            }
            //验证批次号是否为空
            if (string.IsNullOrEmpty(model.LotNo))
            {
                throw new Exception("批次号不可为空，请核查！");
@@ -103,14 +108,17 @@

            model.Origin = "WMS"; //来源
            model.CreateTime = Db.GetDate(); //创建日期
            model.SkuNo = ""; //物料号
            model.SkuName = ""; //物料名称
            model.PassQty = 0; //合格数量
            model.FailQty = 0; //不合格数量
            model.Standard = ""; //规格

            //查找库存明细信息
            List<DataStockDetail> detail = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.LotNo == model.LotNo).ToList();
            List<DataStockDetail> detail = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.SkuNo == model.SkuNo && m.LotNo == model.LotNo).ToList();
            if (detail.Count == 0)
            {
                throw new Exception("未找到当前物料当前批次的库存");
            }
            foreach (var item in detail)
            {
                //判断合格状态是否合格
@@ -151,6 +159,34 @@
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 获取库存批次号集合
        /// </summary>
        /// <returns></returns>
        /// <exception cref="Exception"></exception>
        public List<DataStockDetail> GetLotNoList(string skuNo)
        {
            try
            {
                string str = "select skuNo from DataStockDetail where isDel = '0'";
                if (!string.IsNullOrEmpty(skuNo))
                {
                    str += " and skuNo = @skuNo";
                }

                str += " group by skuNo";
                List<DataStockDetail> skulist = Db.Ado.SqlQuery<DataStockDetail>(str, new
                {
                    SkuNo = "%" + skuNo + "%", //物料号
                });
                return skulist;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        #endregion

    }