QueryOver,连表查询，一个查询框多条件查询，PageData

最新推荐文章于 2023-06-13 15:23:45 发布

lemonemmm

最新推荐文章于 2023-06-13 15:23:45 发布

阅读量665

点赞数

文章标签： PageData DBHelper.CurrentSession.QueryO 连表查询

本文链接：https://blog.csdn.net/lemonemmm/article/details/82182229

版权

例如下图中的MachineModel



  public List<Purchaseorder> GetBomList(BOMListQueryArgs queryArgs)
        {
            var curSession = DBHelper.CurrentSession;
            try
            {
                Bomlist bomlist = null;
                Machinemodel machinemodel = null;
                var query = DBHelper.CurrentSession.QueryOver<Bomlist>(() => bomlist).JoinQueryOver(p => p.MachineModel,() => machinemodel);
                if (queryArgs != null)
                {
                    if (!string.IsNullOrEmpty(queryArgs.MachineModel))
                    {
                         query.Where(() => machinemodel.Modelname.IsLike(queryArgs.MachineModel, MatchMode.Anywhere));
                    }
                }
          
                return query.List().ToList();
            }
            catch (Exception ex)
            {
                NLogHelper.Error(ex);
                return null;
            }
            finally
            {
                if (curSession != null)
                {
                    curSession.Flush();
                    curSession.Close();
                }
            }
        }



 public PageData<Material> GetMaterialList(MaterialQueryArgs queryArgs)
        {
            PageData<Material> pageData = new PageData<Material>();
            try
            {
                Material mat = null;
                Vendor ven = null;
                var query = DBHelper.CurrentSession.QueryOver<Material>(() => mat).JoinQueryOver(p => p.Vendor, () => ven);
                if (query == null)
                {
                    return pageData;
                }
                if (queryArgs != null)
                {
                    query.Where(() => mat.Erpcode.IsLike(queryArgs.QueryValue, MatchMode.Start)
                            || mat.Materialname.IsLike(queryArgs.QueryValue, MatchMode.Anywhere)
                            || mat.Specification.IsLike(queryArgs.QueryValue, MatchMode.Anywhere)
                            || mat.RawMaterial.IsLike(queryArgs.QueryValue, MatchMode.Anywhere)
                            || mat.Alias.IsLike(queryArgs.QueryValue, MatchMode.Anywhere)
                            || ven.Vendorname.IsLike(queryArgs.QueryValue, MatchMode.Anywhere)
                    );
                }
                if (queryArgs.PageIndex <= 0)
                {
                    queryArgs.PageIndex = 1;
                }
                var totalCount = query.RowCount();
                pageData.PageIndex = queryArgs.PageIndex;
                var pageCount = totalCount / PageSize;
                if (totalCount % PageSize != 0)
                    pageCount = pageCount + 1;
                pageData.PageCount = pageCount;
                pageData.PageSize = PageSize;
                pageData.Data = query.Skip((queryArgs.PageIndex - 1) * PageSize).Take(PageSize).List().ToList();
                return pageData;
            }
            catch (Exception ex)
            {
                NLogHelper.Error(ex);
            }
            return pageData;
        }

query.AndRestrictionOn(p => p.BOMName).IsLike(queryArgs.BomName);