using Tiger.Model;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq.Expressions;
|
using System.Text;
|
using System.Threading.Tasks;
|
using Rhea.Common;
|
using System.Net;
|
using System.Linq;
|
using Newtonsoft.Json;
|
using Tiger.IBusiness;
|
using static Tiger.Business.Biz;
|
using Microsoft.AspNetCore.Http;
|
using System.Collections;
|
|
namespace Tiger.Business
|
{
|
public partial class Biz
|
{
|
/// <summary>
|
/// 工具管理
|
/// </summary>
|
public partial class SmtTool : ISmtTool
|
{
|
/// <summary>
|
/// 获取未上料列表
|
/// </summary>
|
/// <param name="paras"></param>
|
/// <returns></returns>
|
public async Task<ApiAction<List<SMT_WO_TABLE>>> GetNotLoadingMaterial(smtWoTableParams paras)
|
{
|
var res = new ApiAction<List<SMT_WO_TABLE>>();
|
List<SMT_WO_TABLE> sList = new List<SMT_WO_TABLE>();
|
try
|
{
|
sList = Db.Queryable<SMT_WO_TABLE, SMT_LOADING>((t, l) =>
|
new JoinQueryInfos(
|
JoinType.Left,
|
t.WORK_ORDER == l.WORK_ORDER
|
&& t.PROD_CODE == l.PROD_CODE
|
&& t.PCB_SURFACE == l.PCB_SURFACE
|
&& t.LINE_CODE == l.LINE_CODE
|
&& t.SLOT_NO == l.SLOT_NO
|
))
|
.Where((t, l) => SqlFunc.IsNullOrEmpty(l.WORK_ORDER) && t.WORK_ORDER == paras.moCode && t.PROD_CODE == paras.prodCode && t.LINE_CODE == paras.lineCode && t.PCB_SURFACE == paras.pcbSurface)
|
.WhereIF(SqlFunc.IsNullOrEmpty(paras.machineCode), (t, l) => t.SMT_CODE == paras.machineCode)
|
.Select((t, l) => t)
|
.ToList();
|
}
|
catch (Exception ex)
|
{
|
res.CatchExceptionWithLog(ex, "查询异常");
|
}
|
res.Data = sList;
|
return await Task.FromResult(res);
|
}
|
}
|
}
|
}
|
