Esempio n. 1
0
        public TableData Load(PageReq pageRequest, OrderAlert entity)
        {
            var result = new TableData();
            var data   = _app.Find(EntityToExpression <OrderAlert> .GetExpressions(entity));

            data = data.Where(u => u.Flag != 1);

            GetData(data, result, pageRequest);
            result.count = data.Count();

            return(result);
        }
        public TableData DistinctLoad(PageReq pageRequest, ProductHeader entity)
        {
            var result = new TableData();
            var data   = _app.Find(EntityToExpression <ProductHeader> .GetExpressions(entity));

            data = data.GroupBy(p => new { p.MachineType }).Select(g => g.First());

            GetData(data, result, pageRequest);
            result.count = data.Count();

            return(result);
        }
Esempio n. 3
0
        public Response GetCurrentStock(InventoryModel inventoryModel)
        {
            Response <List <InventoryModel> > Response = new Response <List <InventoryModel> >();

            if (!CheckLogin())
            {
                Response.Code    = 500;
                Response.Status  = false;
                Response.Message = "请先登录!";
                return(Response);
            }

            try
            {
                Inventory inventory = new Inventory
                {
                    WarehouseCode = inventoryModel.WarehouseType,
                    LocationCode  = inventoryModel.LocationCode,
                    ContainerCode = inventoryModel.ContainerCode,
                    MaterialCode  = inventoryModel.MaterialCode,
                    Lot           = inventoryModel.Lot,
                    Status        = inventoryModel.Status,
                    Qty           = null,
                };

                Response.Result = _unitWork.Find(EntityToExpression <Inventory> .GetExpressions(inventory)).MapToList <InventoryModel>();
            }
            catch (Exception ex)
            {
                Response.Code    = 500;
                Response.Status  = false;
                Response.Message = ex.Message;
            }

            return(Response);
        }