/// <summary>
/// 库存清单报表
/// </summary>
/// <param name="pagesize">每页数据行</param>
/// <param name="pageindex">页码</param>
/// <returns></returns>
public static Model.WST.pagelist PageLsitPro(ProbaictStorage proc, int pagesize, int pageindex)
{
CangChuEntities1 entity = new CangChuEntities1();
Model.WST.pagelist pagelist = new Model.WST.pagelist();
var obj = from p in entity.ProbaictStorage
orderby p.Num
select new
{
StoreName = p.Storehouse.StoreName,
StName = from pp in entity.Storehousetype where pp.StId == p.Storehouse.StId select pp.StName,
StId = from stid in entity.Storehousetype where stid.StId == p.Storehouse.StId select stid.StId,
ProId = p.Probaict.ProId,
ProName = p.Probaict.ProName,
ProCName = from type in entity.ProbaictCatagory where type.ProCId == p.Probaict.ProCId select type.ProCName,
PorGuiGe = p.Probaict.PorGuiGe,
Num = p.Num,
};
var row = 0;
if (!string.IsNullOrEmpty(proc.Storehouse.StoreName))
{
obj = obj.Where(p => p.StoreName.Contains(proc.Storehouse.StoreName));
}
if (!string.IsNullOrEmpty(proc.Probaict.ProName))
{
obj = obj.Where(p => p.ProName.Contains(proc.Probaict.ProName));
}
row = obj.Count();
pagelist.DataList = obj.Skip((pageindex - 1) * pagesize).Take(pagesize);
pagelist.PageCount = row % pagesize == 0 ? row / pagesize : row / pagesize + 1;
return(pagelist);
}
public ActionResult Inventorys(string aname, string bname, int pagesize, int pageindex)
{
ProbaictStorage proc = new ProbaictStorage();
proc.Storehouse = new Storehouse();
proc.Storehouse.StoreName = aname;
proc.Probaict = new Probaict();
proc.Probaict.ProName = bname;
return(Json(BLL.WstBLL.StatementBLL.PageLsitPro(proc, pagesize, pageindex), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 库存清单报表
/// </summary>
/// <param name="pagesize">每页数据行</param>
/// <param name="pageindex">页码</param>
/// <returns></returns>
public static Model.WST.pagelist PageLsitPro(ProbaictStorage proc, int pagesize, int pageindex)
{
return(DAL.WstDAL.StatementDAL.PageLsitPro(proc, pagesize, pageindex));
}
