public int getIndentQty_SumByItemShortItemNo(int shortItemNo)
{
int result = 0;
objF41021 = new F41021Repository();
var resultEntity = (from r in objF41021.GetAll(x => x.ShortItemNo.Equals(shortItemNo)).ToList()
group r by r.ShortItemNo into gr
select new
{
shortItemNo = gr.Key,
IndentQty_sum = gr.Sum(x => x.QtyIndentResv)
}).FirstOrDefault();
if (resultEntity != null)
result = resultEntity.IndentQty_sum;
return result;
}
public F41021Model getWHQtyByShortItemNo(int shortItemNo,string WHID)
{
Mapper.CreateMap<F41021, F41021Model>();
objF41021 = new F41021Repository();
F41021 objEntity = objF41021.GetSingle(x=>x.ShortItemNo.Equals(shortItemNo) && x.WHID.Equals(WHID));
F41021Model resultModel = new F41021Model();
resultModel = Mapper.Map(objEntity, resultModel);
return resultModel;
}
