/// <summary>
/// 返回当前用户的待借出清单
/// </summary>
/// <param name="_user"></param>
/// <returns></returns>
public static object GetLendList(User _user)
{
using (SunginDataContext sc = new SunginDataContext())
{
//SampleLendout slo = sc.SampleLendouts.SingleOrDefault(p => p.DdId == _user.DdId && p.State == LendStats.草拟);
var lendlist = sc.LendRecords.Where(p => p.DdId == _user.DdId && p.State == LendRecordStats.草拟).ToList();
List <object> lo = new List <object>();
lendlist.ForEach(p =>
{
var obj = SampleHelper.GetDdLenOutObj(p);
if (obj != null)
{
lo.Add(obj);
}
});
return(lo);
}
}
/// <summary>
/// 当前用户的借出清单
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static object GetLendOutListDD(User _user)
{
using (SunginDataContext sc = new SunginDataContext())
{
var lendlist = sc.LendRecords.Where(p => p.DdId == _user.DdId && (p.State == LendRecordStats.借出审批 || p.State == LendRecordStats.已借出)).ToList();
List <object> lo = new List <object>();
lendlist.ForEach(p =>
{
var obj = SampleHelper.GetDdLenOutObj(p);
if (obj != null)
{
lo.Add(obj);
}
});
if (lo.Count == 0)
{
lo = null;
}
return(lo);
}
}
public static object GetLendOutListPC(User _user)
{
using (SunginDataContext sc = new SunginDataContext())
{
var lendlist = sc.LendRecords.Where(p => p.DdId == _user.DdId && (p.State == LendRecordStats.借出审批 || p.State == LendRecordStats.已借出)).ToList();
List <object> lo = new List <object>();
lendlist.ForEach(p =>
{
var sb = sc.SampleBaseInfos.SingleOrDefault(t => t.StyleId == p.StyleId);
if (sb != null)
{
lo.Add(SampleHelper.GetReturnObj(sb));
}
});
if (lo.Count == 0)
{
lo = null;
}
return(new { items = lo });
}
}
/// <summary>
/// 返回所有借用清单
/// </summary>
/// <param name="PageId"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public static object GetAllLendOutList(int PageId = 1, int PageSize = 20)
{
using (SunginDataContext sc = new SunginDataContext())
{
int count = sc.LendRecords.Count(p => !p.IsDelete && p.State == LendRecordStats.已借出);
List <LendRecord> lr = sc.LendRecords.Where(p => !p.IsDelete && p.State == LendRecordStats.已借出).OrderByDescending(p => p.DdId).Skip(PageSize * (PageId - 1)).Take(PageSize).ToList();
List <object> obj = new List <object>();;
lr.ForEach(p =>
{
var sb = sc.SampleBaseInfos.SingleOrDefault(t => t.StyleId == p.StyleId);
obj.Add(new { p.Id, p.StyleId, p.UserName, p.UserDept, sb.StyleNo, p.CreateDate, baseinfo = SampleHelper.GetReturnObj(sb) });
});
return(new { items = obj, total = count, current = PageId, pageSize = PageSize });
}
}