/// <summary>
/// 退货报表
/// </summary>
/// <param name="pro">商品对象</param>
/// <param name="pagesize">每页数量</param>
/// <param name="pageindex">页码</param>
/// <returns></returns>
public static Model.WST.pagelist PagelistComeback(Probaict pro, int pagesize, int pageindex)
{
CangChuEntities1 entity = new CangChuEntities1();
Model.WST.pagelist pagelist = new Model.WST.pagelist();
var obj = from p in entity.Probaict
where p.ProTuihuo != 0
orderby p.ProTuihuo
select new {
ProId = p.ProId,
ProName = p.ProName,
ProTuihuo = p.ProTuihuo,
Sum = (p.ProTuihuo * p.ProPrice),
ProNumber = p.ProNumber,
};
var row = 0;
if (!string.IsNullOrEmpty(pro.ProName))
{
obj = obj.Where(p => p.ProName.Contains(pro.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 Comebacks(string name, int pagesize, int pageindex)
{
Probaict pro = new Probaict();
pro.ProName = name;
return(Json(BLL.WstBLL.StatementBLL.PagelistComeback(pro, pagesize, pageindex)));
}
/// <summary>
/// 修改
/// </summary>
/// <returns></returns>
public static int Update(Probaict r)
{
var obj = (from p in entity.Probaict where p.ProId == r.ProId select p).First();
obj.ProId = r.ProId;
obj.ProName = r.ProName;
obj.ProPrice = r.ProPrice;
obj.PorGuiGe = r.PorGuiGe;
obj.ProCId = r.ProCId;
obj.UnId = r.UnId;
obj.CreateTime = r.CreateTime;
obj.IsDelete = r.IsDelete;
obj.ProNumber = r.ProNumber;
obj.ProJinhuo = r.ProJinhuo;
obj.ProChuhuo = r.ProChuhuo;
obj.ProBaosun = r.ProBaosun;
obj.Remake = r.Remake;
return(entity.SaveChanges());
}
/// <summary>
/// 分页查询货品统计
/// </summary>
/// <param name="pagesize">每页数据行</param>
/// <param name="pageindex">页码</param>
/// <returns></returns>
public static Model.WST.pagelist PageListHuo(Probaict pro, int pagesize, int pageindex)
{
CangChuEntities1 entity = new CangChuEntities1();
Model.WST.pagelist pagelist = new Model.WST.pagelist();
var obj = from p in entity.Probaict
orderby p.ProId
select new
{
ProId = p.ProId,
ProName = p.ProName,
ProCName = p.ProbaictCatagory.ProCName,
PorGuiGe = p.PorGuiGe,
ProPrice = p.ProPrice,
ProCount = (from pp in entity.ProbaictStorage where pp.ProId == p.ProId select pp.Num).Sum(),
ProBaoSun = p.ProBaosun,
ProJinh = p.ProJinhuo,
ProChuh = p.ProChuhuo,
};
var row = 0;
if (!string.IsNullOrEmpty(pro.ProId))
{
obj = obj.Where(p => p.ProId.Contains(pro.ProId));
//row = (obj.Where(p => p.ProId.Contains(pro.ProId))).Count();
}
if (!string.IsNullOrEmpty(pro.ProName))
{
obj = obj.Where(p => p.ProName.Contains(pro.ProName));
// row = (obj.Where(p => p.ProId.Contains(pro.ProId))).Count();
}
row = obj.Count();
pagelist.DataList = obj.Skip((pageindex - 1) * pagesize).Take(pagesize);
pagelist.PageCount = row % pagesize == 0 ? row / pagesize : row / pagesize + 1;
return(pagelist);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="pr"></param>
/// <returns></returns>
public static int Update(Probaict pr)
{
return(ProbaictSerivce.Update(pr));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public static int Add(Probaict p)
{
return(ProbaictSerivce.Add(p));
}
/// <summary>
/// 新增
/// </summary>
/// <returns></returns>
public static int Add(Probaict pr)
{
entity.Probaict.Add(pr);
return(entity.SaveChanges());
}
/// <summary>
/// 分页查询货品统计
/// </summary>
/// <param name="pagesize">每页数据行</param>
/// <param name="pageindex">页码</param>
/// <returns></returns>
public static Model.WST.pagelist PageListHuo(Probaict pro, int pagesize, int pageindex)
{
return(DAL.WstDAL.StatementDAL.PageListHuo(pro, pagesize, pageindex));
}
/// <summary>
/// 产品修改
/// </summary>
/// <returns></returns>
public ActionResult GetUpdateProbaict(Probaict pr)
{
return(Json(ProbaictManager.Update(pr), JsonRequestBehavior.AllowGet));
}
public ActionResult GoodsStatisticss(Probaict pro, int pagesize, int pageindex)
{
return(Json(BLL.WstBLL.StatementBLL.PageListHuo(pro, pagesize, pageindex), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 新增
/// </summary>
/// <returns></returns>
public ActionResult Add(Probaict pr)
{
return(Json(ProbaictManager.Add(pr), JsonRequestBehavior.AllowGet));
}
