sqlsugar查询条件组装

最新推荐文章于 2024-01-10 11:27:55 发布

Kevin M

最新推荐文章于 2024-01-10 11:27:55 发布

阅读量583

点赞数

文章标签： sqlsugar

本文链接：https://blog.csdn.net/qq_39072819/article/details/129875933

版权

 Expressionable<Brl_SideWall_HistoryEntity> expWhere = new Expressionable<Brl_SideWall_HistoryEntity>();

            expWhere.AndIF(param.affiliatedFactoryID.HasValue, x => x.affiliatedFactoryID == param.affiliatedFactoryID);
            expWhere.AndIF(param.batchID.HasValue, x => x.batchID == param.batchID);
            expWhere.AndIF(param.deviceID.HasValue, x => x.deviceID == param.deviceID);
            expWhere.AndIF(param.startTime.HasValue, x => x.enterTime >= param.startTime.Value);
            expWhere.AndIF(param.endTime.HasValue, x => x.enterTime <= param.endTime.Value);
            expWhere.AndIF(param.userID.HasValue, x => x.userID == param.userID);
            return expWhere;

关注博主即可阅读全文