22

schangxiang@126.com

2024-11-30 a108e2c9fd3e80b8301313215b15afce96d969b5

 LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsCommonnQuery/WmsCommonnQueryService.cs

@@ -13,6 +13,7 @@
/// 通用查询服务
/// </summary>
[ApiDescriptionSettings(ApplicationConst.WmsCommonnQueryGroupName, Order = 100)]
[AllowAnonymous]
public class WmsCommonnQueryService : IDynamicApiController, ITransient
{
    private readonly SqlSugarRepository<WmsRbLineTask> _rep;
@@ -57,5 +58,63 @@

        return list; // 结果
    }


    /// <summary>
    /// 查询 历史生产订单记录 （大屏使用）
    /// </summary>
    /// <returns></returns>
    [HttpGet]
    [ApiDescriptionSettings(Name = "QueryHistoryOrderList")]
    [Description("WmsCommonnQuery/QueryHistoryOrderList")]
    public async Task<List<Mes_Order_Gather>> QueryHistoryOrderList()
    {
        //获取上班时间。
        var sysConfig_wms_unline_time = await _sysConfigRep.GetFirstAsync(x => x.Code == CommonConst.wms_unline_time);
        if (sysConfig_wms_unline_time == null || sysConfig_wms_unline_time.Value == "无")
        {
            return null;
        }
        var unLineTime = Convert.ToDateTime(sysConfig_wms_unline_time.Value);

        var list = await _mesOrderGatherRep.AsQueryable()
            .Where(x => x.UnlineTime >= unLineTime)
            .Where(x => x.IsUnline == true)
            .OrderByDescending(g => g.Id)
            .ToListAsync(); // 确保获取结果为 List

        return list; // 结果
    }


    /// <summary>
    /// 查询 当前生产订单记录 （大屏使用）
    /// </summary>
    /// <returns></returns>
    [HttpGet]
    [ApiDescriptionSettings(Name = "QueryCurrentOrder")]
    [Description("WmsCommonnQuery/QueryCurrentOrder")]
    public async Task<Mes_Order_Gather> QueryCurrentOrder()
    {
        //获取上班时间。
        var sysConfig_wms_wms_unline_oper = await _sysConfigRep.GetFirstAsync(x => x.Code == CommonConst.wms_unline_oper);
        if (sysConfig_wms_wms_unline_oper == null || sysConfig_wms_wms_unline_oper.Value == "无")
        {
            return null;
        }
        var arr = sysConfig_wms_wms_unline_oper.Value.Split('|');
        var packagecode = arr[0];
        var packObj = await _mesPackageGatherRep.AsQueryable().FirstAsync(x => x.PackageCode == packagecode);
        if (packObj == null)
        {
            throw Oops.Oh($"没有找到包{packagecode}的汇总数据");
        }

        var list = await _mesOrderGatherRep.AsQueryable()
            .Where(x => x.Info5 == packObj.Info5)
            .FirstAsync(); // 确保获取结果为 List

        return list; // 结果
    }
}