/// <summary>
/// 所有条件查询
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="name"></param>
/// <param name="sname"></param>
/// <param name="sname2"></param>
/// <returns></returns>
public static ShuaiPageList YikuPageList2(int PageIndex, int PageSize, string name, DateTime sname, DateTime sname2)
{
CangChuEntities1 hh = new CangChuEntities1();
ShuaiPageList list = new ShuaiPageList();
var obj = from p in hh.GarageShift
where p.GarSType.Contains(name) && p.CreateTime >= sname && p.CreateTime <= sname2
orderby p.GarSId
select new
{
GarSId = p.GarSId,
AudiId = p.AudiId,
GarSType = p.GarSType,
GarSOrder = p.GarSOrder,
num = from jj in hh.GarageShiftStorage select jj.Num,
GarSPerson = p.GarSPerson,
IsDelete = p.IsDelete,
CreateTime = p.CreateTime,
};
list.DataList = obj.Skip((PageIndex - 1) * PageSize).Take(PageSize);
int rows = hh.Damage.Count();
list.PageCoun = rows % PageSize == 0 ? rows / PageSize : rows / PageSize + 1;
return(list);
}
public static ShuaiPageList GetPageList(int PageIndex, int PageSize)
{
CangChuEntities1 hh = new CangChuEntities1();
ShuaiPageList list = new ShuaiPageList();
var obj = from p in hh.Damage
where p.IsDelete == 0
orderby p.Damid
select new {
Damid = p.Damid,
DamType = p.DamType,
DamOrder = p.DamOrder,
DamPerson = p.DamPerson,
AudiId = p.AudiId,
ProId = from jj in hh.DamageStorage select jj.ProId,
CreateTime = p.CreateTime,
IsDelete = p.IsDelete,
Remake = p.Remake,
};
list.DataList = obj.Skip((PageIndex - 1) * PageSize).Take(PageSize);
int rows = hh.Damage.Count();
list.PageCoun = rows % PageSize == 0 ? rows / PageSize : rows / PageSize + 1;
return(list);
}
public static ShuaiPageList TuiHuoTongHuo(int PageIndex, int PageSize)
{
CangChuEntities1 hh = new CangChuEntities1();
ShuaiPageList list = new ShuaiPageList();
var obj = from p in hh.Comeback
where p.AudiId == 2
orderby p.CobId
select new
{
CobId = p.CobId,
CobType = p.CobType,
DeliId = from jj in hh.Deliver select jj.DeliId,
CobPerson = p.CobPerson,
AudiId = p.AudiId,
CreateTime = p.CreateTime,
IsDelete = p.IsDelete,
comNum = from kk in hh.CombackStorage select kk.ComNum,
};
list.DataList = obj.Skip((PageIndex - 1) * PageSize).Take(PageSize);
int rows = hh.Damage.Count();
list.PageCoun = rows % PageSize == 0 ? rows / PageSize : rows / PageSize + 1;
return(list);
}
public static ShuaiPageList Queryshibai(int PageIndex, int PageSize)
{
CangChuEntities1 hh = new CangChuEntities1();
ShuaiPageList list = new ShuaiPageList();
var obj = from p in hh.GarageShift
where p.AudiId == 3
orderby p.GarSId
select new
{
GarSId = p.GarSId,
AudiId = p.AudiId,
GarSType = p.GarSType,
GarSOrder = p.GarSOrder,
num = from jj in hh.GarageShiftStorage select jj.Num,
GarSPerson = p.GarSPerson,
ProId = from jj in hh.GarageShiftStorage select jj.ProId,
IsDelete = p.IsDelete,
Remake = p.Remake,
CreateTime = p.CreateTime,
};
list.DataList = obj.Skip((PageIndex - 1) * PageSize).Take(PageSize);
int rows = hh.Damage.Count();
list.PageCoun = rows % PageSize == 0 ? rows / PageSize : rows / PageSize + 1;
return(list);
}
