| | |
| | | try |
| | | { |
| | | //model.Type:单据类型 在这里代表前端页签类型:即标签页签:贴标物料; 数量页签:不贴表物料,原因:懒得加参数 |
| | | var data = Db.Queryable<BllArrivalNotice>().Where(m => m.IsDel == "0" && m.Status != "3" && m.Status != "4").Select(m => m.ASNNo).ToList(); |
| | | var data = Db.Queryable<BllArrivalNotice>().Where(m => m.IsDel == "0" && m.Status !="2" && m.Status != "3" && m.Status != "4").Select(m => m.ASNNo).ToList(); |
| | | var list = new List<ArrivalNoticeDetailDto>(); |
| | | if (model.Type.Contains("0"))//0贴标 |
| | | { |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 验证地码是否存在 |
| | | /// </summary> |
| | | /// <param name="locatNo">地码</param> |
| | | /// <returns>"":可使用 -1:不可使用(原因)</returns> |
| | | public string IsEnableLocatNo(string locatNo) |
| | | { |
| | | string sqlMsg = ""; |
| | | string sqlString = string.Empty; |
| | | try |
| | | { |
| | | sqlString = $"select * from SysStorageLocat where LocatNo = '{locatNo}' and WareHouseNo = 'W02' and isdel = '0';"; |
| | | var models = Db.Ado.SqlQuery<PalletBindVm>(sqlString); |
| | | |
| | | if (models.Count > 0) |
| | | { |
| | | if (models[0].Status != "0") |
| | | { |
| | | sqlMsg = "-1:此库位使用中,请在库内请核实!"; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sqlMsg = "-1:库位不存在!"; |
| | | } |
| | | |
| | | return sqlMsg; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw ex; |
| | | } |
| | | } |
| | | |
| | | // 根据箱码或托盘号获取箱支信息 liudl |
| | | public List<BoxInfoDto> GetBoxInfos(BoxInfoVm model) |
| | | { |