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