예제 #1
0
        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;
        }