wcs_server_kate_suzhou/WcsMain/DataBase/Dao/AppBaseErrDao.cs

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());
}