public IEnumerable <DrugStockOutEntity> GetStockOutList(string deptid, string name, string level) { var query = this.BaseRepository().IQueryable(); if (!string.IsNullOrEmpty(name)) { query = query.Where(x => x.DrugName.Contains(name)); } if (!string.IsNullOrEmpty(level)) { query = query.Where(x => x.DrugLevel == level); } //Operator user = OperatorProvider.Provider.Current(); if (deptid != null) { //string deptid = user.DeptId; //query = query.Where(x => x.BZId == deptid); var dpservice = new DepartmentService(); var dept = new DepartmentEntity(); var bzids = new WorkOrderService().GetWorkOrderGroup(deptid).Select(x => x.departmentid).ToList(); if (bzids.Count == 0) { query = query.Where(x => x.BZId == deptid); } else { query = query.Where(x => bzids.Contains(x.BZId)); } } return(query.OrderByDescending(x => x.CreateDate).ToList()); }
public IEnumerable <ToolBorrowEntity> GetListByUserId(string userid, string deptid, string tid, int page, int pagesize, out int total) { var query = this.BaseRepository().IQueryable(); if (!string.IsNullOrEmpty(userid)) { query = query.Where(x => x.BorrwoPersonId == userid); } else { //string deptid = OperatorProvider.Provider.Current().DeptId; //运行班组共享数据 var dpservice = new DepartmentService(); var dept = new DepartmentEntity(); var bzids = new WorkOrderService().GetWorkOrderGroup(deptid).Select(x => x.departmentid).ToList(); if (bzids.Count == 0) { query = query.Where(x => x.BZId == deptid); } else { query = query.Where(x => bzids.Contains(x.BZId)); } if (!string.IsNullOrEmpty(tid)) { query = query.Where(x => x.TypeId == tid); } } total = query.Count(); return(query.OrderByDescending(x => x.BorrwoDate).Skip(pagesize * (page - 1)).Take(pagesize).ToList()); }
/// <summary> /// 获取取用记录条数 /// </summary> /// <param name="from">起始时间</param> /// <param name="to">结束时间</param> /// <param name="DrugName">药品名称</param> /// <returns></returns> public int GetOutListCount(string deptid, DateTime?from, DateTime?to, string DrugName) { //string deptid = OperatorProvider.Provider.Current().DeptId; var query = this.BaseRepository().IQueryable(); var dpservice = new DepartmentService(); var dept = new DepartmentEntity(); var bzids = new WorkOrderService().GetWorkOrderGroup(deptid).Select(x => x.departmentid).ToList(); if (bzids.Count == 0) { query = query.Where(x => x.BZId == deptid); } else { query = query.Where(x => bzids.Contains(x.BZId)); } if (from != null) { query = query.Where(x => x.CreateDate >= from); } if (to != null) { to = to.Value.AddDays(1); query = query.Where(x => x.CreateDate < to); } if (!string.IsNullOrEmpty(DrugName)) { query = query.Where(x => x.DrugName.Contains(DrugName)); } return(query.Count()); }
/// <summary> /// 获取取用记录 /// </summary> /// <param name="from">起始时间</param> /// <param name="to">结束时间</param> /// <param name="DrugName">药品名称or创建人名称</param> /// <param name="page">当前页数</param> /// <param name="pagesize">一页显示条数</param> /// <param name="total">查询总数</param> /// <returns></returns> public IEnumerable <DrugOutEntity> GetOutList(string deptid, DateTime?from, DateTime?to, string DrugName, int page, int pagesize, out int total) { var query = this.BaseRepository().IQueryable(); //var user = OperatorProvider.Provider.Current(); if (deptid != null) { //var deptid = user.DeptId; //query = query.Where(x => x.BZId == user.DeptId); var dpservice = new DepartmentService(); var dept = new DepartmentEntity(); var bzids = new WorkOrderService().GetWorkOrderGroup(deptid).Select(x => x.departmentid).ToList(); if (bzids.Count == 0) { query = query.Where(x => x.BZId == deptid); } else { query = query.Where(x => bzids.Contains(x.BZId)); } } if (from != null) { query = query.Where(x => x.CreateDate >= from); } if (to != null) { to = to.Value.AddDays(1); query = query.Where(x => x.CreateDate < to); } if (!string.IsNullOrEmpty(DrugName)) { query = query.Where(x => x.DrugName.Contains(DrugName) || x.CreateUserName.Contains(DrugName)); } total = query.Count(); return(query.OrderByDescending(x => x.CreateDate).Skip(pagesize * (page - 1)).Take(pagesize).ToList()); }
/// <summary> /// 获取列表 /// </summary> /// <param name="queryJson">查询参数</param> /// <returns>返回列表</returns> public IEnumerable <ToolBorrowEntity> GetList(string userid, string deptid, DateTime?from, DateTime?to, string name) { //string deptid = OperatorProvider.Provider.Current().DeptId; //string userid = OperatorProvider.Provider.Current().UserId; PeopleEntity p = new PeopleService().GetEntity(userid); var query = this.BaseRepository().IQueryable(); //运行班组共享数据 var dpservice = new DepartmentService(); var dept = new DepartmentEntity(); var bzids = new WorkOrderService().GetWorkOrderGroup(deptid).Select(x => x.departmentid).ToList(); if (bzids.Count == 0) { query = query.Where(x => x.BZId == deptid); } else { query = query.Where(x => bzids.Contains(x.BZId)); } if (p != null && p.Quarters != "班长" && p.Quarters != "班组长") { query = query.Where(x => x.BorrwoPersonId == userid); } if (from != null) { query = query.Where(x => x.BorrwoDate >= from); } if (to != null) { to = to.Value.AddDays(1); query = query.Where(x => x.BorrwoDate < to); } if (!string.IsNullOrEmpty(name)) { query = query.Where(x => x.ToolName.Contains(name)); } return(query.OrderByDescending(x => x.CreateDate).ToList()); }
/// <summary> /// 获取列表 /// </summary> /// <param name="queryJson">查询参数</param> /// <returns>返回列表</returns> public IEnumerable <ToolTypeEntity> GetList(string deptid) { var query = this.BaseRepository().IQueryable(); //Operator user = OperatorProvider.Provider.Current(); if (deptid != null) { //string deptid = user.DeptId; var dpservice = new DepartmentService(); var dept = new DepartmentEntity(); var bzids = new WorkOrderService().GetWorkOrderGroup(deptid).Select(x => x.departmentid).ToList(); if (bzids.Count == 0) { query = query.Where(x => x.BZId == deptid); } else { query = query.Where(x => bzids.Contains(x.BZId)); } } return(query.OrderBy(x => x.CreateDate).ToList()); }
public IEnumerable <DrugEntity> GetPageList(string name, string deptid, int page, int pagesize, out int total) { var query = this.BaseRepository().IQueryable(); //query = query.Where(x => x.BZId == deptid); var dpservice = new DepartmentService(); var dept = new DepartmentEntity(); var bzids = new WorkOrderService().GetWorkOrderGroup(deptid).Select(x => x.departmentid).ToList(); if (bzids.Count == 0) { query = query.Where(x => x.BZId == deptid); } else { query = query.Where(x => bzids.Contains(x.BZId)); } if (!string.IsNullOrEmpty(name)) { query = query.Where(x => x.DrugName.Contains(name)); } total = query.Count(); return(query.OrderByDescending(x => x.CreateDate).Skip(pagesize * (page - 1)).Take(pagesize).ToList()); }
///// <summary> ///// 获取列表 ///// </summary> ///// <param name="deptId">部门Id</param> ///// <returns>返回列表</returns> //public IEnumerable<ToolTypeEntity> GetList(string deptId) //{ // var query = this.BaseRepository().IQueryable(); // //Operator user = OperatorProvider.Provider.Current(); // var bzids = new WorkOrderService().GetWorkOrderGroup(deptId).Select(x => x.departmentid).ToList(); // if (bzids.Count == 0) // { // query = query.Where(x => x.BZId == deptId); // } // else // { // query = query.Where(x => bzids.Contains(x.BZId)); // } // return query.OrderBy(x => x.CreateDate).ToList(); //} public IEnumerable <ToolTypeEntity> GetPageList(string name, string deptid, int page, int pagesize, out int total) { var db = new RepositoryFactory().BaseRepository(); var query = db.IQueryable <ToolTypeEntity>(); var dpservice = new DepartmentService(); var dept = new DepartmentEntity(); var bzids = new WorkOrderService().GetWorkOrderGroup(deptid).Select(x => x.departmentid).ToList(); if (bzids.Count == 0) { query = query.Where(x => x.BZId == deptid); } else { query = query.Where(x => bzids.Contains(x.BZId)); } if (!string.IsNullOrEmpty(name)) { query = query.Where(x => x.Name.Contains(name)); } var finalQuery = from q1 in query join q2 in db.IQueryable <ToolInventoryEntity>() on q1.InventoryId equals q2.ID into t from t1 in t.DefaultIfEmpty() select new { q1, t1.Type }; total = finalQuery.Count(); if (page < 0) { return(finalQuery.OrderByDescending(x => x.q1.CreateDate).ToList().Select(x => new ToolTypeEntity() { Type = x.Type, BZId = x.q1.BZId, CreateDate = x.q1.CreateDate, DeptId = x.q1.DeptId, ID = x.q1.ID, InventoryId = x.q1.InventoryId, Name = x.q1.Name, Numbers = x.q1.Numbers, Path = x.q1.Path, Remark = x.q1.Remark, Remind = x.q1.Remind, State = x.q1.State })); } return(finalQuery.OrderByDescending(x => x.q1.CreateDate).Skip(pagesize * (page - 1)).Take(pagesize).ToList().Select(x => new ToolTypeEntity() { Type = x.Type, BZId = x.q1.BZId, CreateDate = x.q1.CreateDate, DeptId = x.q1.DeptId, ID = x.q1.ID, InventoryId = x.q1.InventoryId, Name = x.q1.Name, Numbers = x.q1.Numbers, Path = x.q1.Path, Remark = x.q1.Remark, Remind = x.q1.Remind, State = x.q1.State })); }