EntityFrameWork 动态 sql 查询

最新推荐文章于 2024-07-13 18:02:33 发布

@lovely

最新推荐文章于 2024-07-13 18:02:33 发布

阅读量152

点赞数 5

文章标签： sql java windows

本文链接：https://blog.csdn.net/weixin_58458148/article/details/138719062

版权

 BizWorkDbContext b = new BizWorkDbContext();
            string sql = "select * from t_business_trip where 1 = 1";

            //拼接 出差理由
            if ( query.Reason !=null && !query.Reason.Trim().Equals(""))
            {
                sql += " and reason like '%" + query.Reason + "%'";
            }
            //拼接出差目的地
            if (query.Destination!=null && !query.Destination.Trim().Equals(""))
            {
                sql += " and destination like '%" + query.Destination + "%'";
            }
            //拼接申请用户
            if (query.ApplyUserName!=null && query.ApplyUserName.Trim().Equals(""))
            {
                sql += " and apply_user_name like '%" + query.ApplyUserName + "%'";
            }
            //拼接开始时间
            if (query.StartTime!=DateTime.MinValue)
            {
                sql += " and FORMAT(end_time,'yyyy-MM-dd') >=" + "FORMAT(" + query.EndTime +")";
            }
            //拼接结束时间
            if (query.EndTime!=DateTime.MinValue)
            {
                sql += " and FORMAT(end_time,'yyyy-MM-dd') >=" + "FORMAT(" + query.EndTime.ToString("yyyy-MM-dd") +")";
            }
            //拼接 分页
            sql += " ORDER BY create_time desc offset " + (query.Page - 1) * query.Size + " rows FETCH NEXT " + query.Size +
                   " ROWS ONLY";
            //将动态拼接好的sql 进行执行
            List<TBusinessTrip> businessTrips = b.TBusinessTrips.FromSqlRaw(sql).ToList();
            return businessTrips;