44 lines
1.5 KiB
C#
44 lines
1.5 KiB
C#
using WcsMain.Common;
|
|
using WcsMain.DataBase.TableEntity;
|
|
using WcsMain.WcsAttribute.AutoFacAttribute;
|
|
|
|
namespace WcsMain.DataBase.Dao;
|
|
|
|
[Component]
|
|
public class AppBaseErrDao
|
|
{
|
|
|
|
/// <summary>
|
|
/// 条件查询
|
|
/// </summary>
|
|
/// <param name="appBaseErr"></param>
|
|
/// <returns></returns>
|
|
public List<AppBaseErr>? Select(AppBaseErr appBaseErr)
|
|
{
|
|
try
|
|
{
|
|
var sqlFuc = CommonTool.DbServe.Queryable<AppBaseErr>()
|
|
.WhereIF(appBaseErr.Area != default, w => w.Area == appBaseErr.Area)
|
|
.WhereIF(appBaseErr.ErrNo != default, w => w.ErrNo == appBaseErr.ErrNo)
|
|
.WhereIF(appBaseErr.ErrType != default, w => w.ErrType == appBaseErr.ErrType)
|
|
.WhereIF(appBaseErr.ErrLevel != default, w => w.ErrLevel == appBaseErr.ErrLevel)
|
|
.WhereIF(appBaseErr.ErrMsg != default, w => w.ErrMsg == appBaseErr.ErrMsg)
|
|
.WhereIF(appBaseErr.Suggest != default, w => w.Suggest == appBaseErr.Suggest)
|
|
.WhereIF(appBaseErr.Remark != default, w => w.Remark == appBaseErr.Remark)
|
|
.OrderBy(o => new { o.Area, o.ErrNo });
|
|
return sqlFuc.ToList();
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
_ = ex;
|
|
return default;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 查询全部
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public List<AppBaseErr>? Select() => Select(new AppBaseErr());
|
|
}
|