服务端的TigerApi 框架,基于.NET6 2024 版本
Rodney Chen
2 天以前 2c60540518b5f2071987dcbe6aa237af4b97c77a
Tiger.Business.WMS/Transaction/Yada/Print_BIZ_U9_ASN.cs
@@ -55,8 +55,7 @@
        {
            var _Sns = MainDB.Queryable<BIZ_U9_ASN_SN>().Where(q => q.ORDER_NO == SqlFunc.Subqueryable<BIZ_U9_ASN_DTL>().Where(s => SqlFunc.StartsWith(s.UPDATE_USER, $"GenerateASN_{UserCode}")).Select(s => s.ORDER_NO)).ToList();
            CurSn.AddRange(_Sns);
            OrderList = MainDB.Queryable<BIZ_U9_ASN_SN>().Where(q => q.RECEIVER == $"{UserCode}_NoSource" && SqlFunc.Subqueryable<BIZ_U9_ASN>().Where(s => s.ORDER_NO == q.ORDER_NO && s.STATUS == BIZ_U9_ASN.STATUSs.Counting.GetValue()).Any()).Select(q => q.ORDER_NO).ToList();
        }
             }
        /// <summary>
        ///  获取当前所有单据信息
@@ -65,6 +64,7 @@
        public async Task<ApiAction<List<BIZ_U9_ASN>>> GetOrderList()
        {
            var action = new ApiAction<List<BIZ_U9_ASN>>();
            OrderList = MainDB.Queryable<BIZ_U9_ASN_SN>().Where(q => q.RECEIVER == $"{UserCode}_NoSource" && SqlFunc.Subqueryable<BIZ_U9_ASN>().Where(s => s.ORDER_NO == q.ORDER_NO && s.STATUS == BIZ_U9_ASN.STATUSs.Counting.GetValue()).Any()).Select(q => q.ORDER_NO).ToList();
            action.Data = await Biz.Db.Queryable<BIZ_U9_ASN>().Where(q => OrderList.Contains(q.ORDER_NO)).Includes(q => q.Details, d => d._ItemInfos).IncludesAllFirstLayer().ToListAsync();
            if (!action.Data.IsNullOrEmpty())
            {
@@ -359,7 +359,18 @@
                var reqType = input.Options["reqType"].ToString();
                var dtl = input.Options["record"].ToString().JsonToObject<BIZ_U9_ASN_DTL>();
                action.LocaleMsg = Biz.L($"成功提交ASN单[{dtl.ORDER_NO}]行数据,请点击打印按钮打印标签");
                if (snlist.Count == 0)
                {
                    action.IsSuccessed = false;
                    action.LocaleMsg = Biz.L($"数据不存在!");
                    return action;
                }
                if (CurOrder.IsNullOrEmpty())
                {
                    action.IsSuccessed = false;
                    action.LocaleMsg = Biz.L($"数据不存在!");
                    return action;
                }
                var asnSn = MainDB.Queryable<BIZ_U9_ASN_SN>().Where(q => q.ORDER_NO == dtl.ORDER_NO && q.LINE_NO == dtl.LINE_NO && (q.STATUS == WMS_ITEM.STATUSs.Counted.GetValue() || q.STATUS == WMS_ITEM.STATUSs.Rejected.GetValue())).ToList();
                if (asnSn.Count > 0 && asnSn.Sum(q => q.QTY) == dtl.QTY)
                {