50 lines
1.2 KiB
C#
50 lines
1.2 KiB
C#
|
using WcsMain.Common;
|
|||
|
|
using WcsMain.DataBase.TableEntity;
|
|||
|
|
using WcsMain.WcsAttribute.AutoFacAttribute;
|
|||
|
|
|
|||
|
|
namespace WcsMain.DataBase.Dao;
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// tbl_bs_pick_stand 的操作类
|
|||
|
|
/// </summary>
|
|||
|
|
[Component]
|
|||
|
|
public class BsPickStandDao
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 查询所有数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public List<BsPickStand>? Query() => Query(new BsPickStand());
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 根据条件查询数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="queryEntity"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public List<BsPickStand>? Query(BsPickStand queryEntity)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
var sqlFUc = CommonTool.DbServe.Queryable<BsPickStand>()
|
|||
|
|
.WhereIF(!string.IsNullOrEmpty(queryEntity.PickStand), w => w.PickStand == queryEntity.PickStand)
|
|||
|
|
.WhereIF(queryEntity.StandType != default, w => w.StandType == queryEntity.StandType)
|
|||
|
|
.WhereIF(queryEntity.StandStatus != default, w => w.StandStatus == queryEntity.StandStatus)
|
|||
|
|
.OrderBy(o => o.PickStand);
|
|||
|
|
return sqlFUc.ToList();
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
_ = ex;
|
|||
|
|
return default;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|