Пример #1
0
        public async Task <IActionResult> GatPagerListByWhere(string keyword, int rows, int page, string sidx, string sord, string Id)
        {
            if (string.IsNullOrEmpty(sidx))
            {
                sidx = "SortCode";
            }
            if (string.IsNullOrEmpty(sord))
            {
                sord = "ASC";
            }

            PagerEntity <InStockHeadGetDto> entity = await _service.QueryByPagesAsync(rows, page,
                                                                                      t => t.OrderNo.Contains((keyword ?? t.OrderNo)),
                                                                                      _service.Expression(sidx), sord.ToUpper().Equals("ASC"));

            List <InStockHeadGetDto> list = await _service.QueryAsync();


            if (entity.Entity != null && entity.Entity.Count() > 0)
            {
                foreach (var item in entity.Entity)
                {
                    var customer = await _customerService.QueryByIdAsync(item.CustomId);

                    var warehouse = await _warehouseService.QueryByIdAsync(item.WarehouseId);

                    var owner = await _ownerService.QueryByIdAsync(item.OwnerId);

                    var receivetype = await _receivetypeService.QueryByIdAsync(item.SrTypeId);

                    //item.WarehouseCode = warehouse == null ? "" : warehouse.EnCode;
                    //item.WarehouseName = warehouse == null ? "" : warehouse.FullName;
                    //item.CustomerCode = customer == null ? "" : customer.EnCode;
                    //item.CustomerName = customer == null ? "" : customer.FullName;
                    //item.OwnnerCode = owner == null ? "" : owner.EnCode;
                    //item.OwnnerName = owner == null ? "" : owner.FullName;
                    //item.StrTypeCode = receivetype == null ? "" : receivetype.EnCode;
                    //item.StrTypeName = receivetype == null ? "" : receivetype.FullName;
                }
            }

            //设置返回格式
            ReturnEntity RtEntity = new ReturnEntity();

            RtEntity.rows    = entity.Entity;
            RtEntity.page    = page;
            RtEntity.records = entity.Total;
            int Count = entity.Total / rows; //获取除数
            int yu    = entity.Total % rows; //获取余数

            if (yu > 0)                      //如果余数大于0则加一页,否则不加
            {
                RtEntity.total = Count + 1;
            }
            else
            {
                RtEntity.total = Count + 0;
            }
            return(Ok(Extensions.ToJson(RtEntity)));
        }
Пример #2
0
        public void TestTrueReturn()
        {
            ReturnEntity e = (ReturnEntity)TypeAccessor.CreateInstance(typeof(ReturnEntity));

            bool b = ((IReturnTrueInterface)e).IsDirty;

            Assert.AreEqual(100, e.Value1);
            Assert.AreEqual(100M, e.Value2);
            Assert.AreEqual(null, e.Value3);
        }
Пример #3
0
        public void TestNullReturn()
        {
            ReturnEntity e = (ReturnEntity)TypeAccessor.CreateInstance(typeof(ReturnEntity));

            ((IReturnNullInterface)e).DoNull();

            Assert.AreEqual(300, e.Value1);
            Assert.AreEqual(0M, e.Value2);
            Assert.AreEqual(null, e.Value3);
        }
Пример #4
0
        public void TestFalseReturn()
        {
            ReturnEntity e = (ReturnEntity)TypeAccessor.CreateInstance(typeof(ReturnEntity));

            ((IReturnFalseInterface)e).DoFalse();

            Assert.AreEqual(200, e.Value1);
            Assert.AreEqual(200M, e.Value2);
            Assert.AreEqual("200", e.Value3);
        }
Пример #5
0
        ///// <summary>
        ///// 返回信息构建
        ///// </summary>
        ///// <param name="isSuccess">是否成功</param>
        ///// <param name="msg">信息</param>
        ///// <param name="data">返回数据</param>
        ///// <returns></returns>
        private ReturnEntity GetResultInfo(bool isSuccess, String msg, AccountEntity Accountdata, List <ProfitEntity> profitlist, decimal sumStatistics)
        {
            ReturnEntity resultInfo = new ReturnEntity();

            resultInfo.ResultCode    = isSuccess ? EmResultDescribe.OK : EmResultDescribe.系统错误;
            resultInfo.Message       = msg;
            resultInfo.AccountData   = Accountdata;
            resultInfo.ProfitsData   = profitlist;
            resultInfo.SumStatistics = sumStatistics;
            return(resultInfo);
        }
Пример #6
0
        public async Task <IActionResult> GatPagerListByWhere(string keyword, string sidx, int rows = 20, int page = 1, string sord = "ASC", string Id = "")
        {
            bool isAsc = false;

            if (sord.ToUpper() == "ASC")
            {
                isAsc = true;
            }
            if (string.IsNullOrEmpty(sidx))
            {
                sidx = "SordCode";
            }
            //UserGetDto user = await _userService.QueryByIdAsync(Id);
            //RoleGetDto role = await _roleService.QueryByIdAsync(user.RoleId);
            //PagerEntity<CustomerGetDto> entity = null;
            //if (role.IsAdmin)
            //{

            PagerEntity <InventoryClassGetDto> entity = await _service.QueryByPagesAsync(rows, page,
                                                                                         t => t.EnCode.Contains((keyword ?? t.EnCode)) ||
                                                                                         t.FullName.Contains(keyword ?? t.FullName),
                                                                                         _service.Expression(sidx), isAsc);

            //}
            //else
            //{
            //    entity = await _service.QueryByPagesAsync(rows, page,
            //        t => t.EnCode.Contains((keyword ?? t.EnCode)) ||
            //        t.FullName.Contains(keyword ?? t.FullName) &&
            //        t.UserId==Id,
            //        _service.Expression(sidx), isAsc);
            //}

            //设置返回格式
            ReturnEntity RtEntity = new ReturnEntity();

            RtEntity.rows    = entity.Entity;
            RtEntity.page    = page;
            RtEntity.records = entity.Total;
            int Count = entity.Total / rows; //获取除数
            int yu    = entity.Total % rows; //获取余数

            if (yu > 0)                      //如果余数大于0则加一页,否则不加
            {
                yu = 1;
            }
            else
            {
                yu = 0;
            }
            RtEntity.total = Count + yu;
            return(Ok(Extensions.ToJson(RtEntity)));
        }
Пример #7
0
        public ActionResult RegisterMember(RegisterEntity model)
        {
            BaseUserService     userService = new BaseUserService();
            ReturnEntity <bool> data        = new ReturnEntity <bool>
            {
                Status = false
            };

            if (string.IsNullOrWhiteSpace(model.Account))
            {
                data.Msg = "帐号未填写";
            }
            else if (string.IsNullOrWhiteSpace(model.Pwd))
            {
                data.Msg = "密码未填写";
            }
            else if (userService.GetAccoutExistCheck(model.Account))
            {
                data.Msg = "该帐号已存在!";
            }
            else
            {
                BaseUser user = new BaseUser
                {
                    Account      = model.Account,
                    Pwd          = EncryptionHelper.Md5(model.Pwd),
                    RoleType     = 0,
                    ProfessionId = 0
                };
                bool flag = userService.Add(user);
                if (flag)
                {
                    //记录session
                    MemberEntity member = new MemberEntity
                    {
                        UserId       = user.Id,
                        Account      = user.Account,
                        ProfessionId = user.ProfessionId.GetValueOrDefault()
                    };
                    SessionData.Member.LoginedUser = member;
                    data.Msg    = "注册成功!";
                    data.Status = true;
                }
            }

            return(JsonCResult(data));
        }
Пример #8
0
        public async Task <IActionResult> GatPagerListByWhere(string keyword, int rows, int page, string sidx, string sord, string Id)
        {
            if (string.IsNullOrEmpty(sidx))
            {
                sidx = "SortCode";
            }
            if (string.IsNullOrEmpty(sord))
            {
                sord = "asc";
            }
            PagerEntity <StockGetDto> entity = new PagerEntity <StockGetDto>();

            entity = await _service.QueryByPagesAsync(rows, page,
                                                      t => t.CustomerId.Contains((keyword ?? t.CustomerId)) ||
                                                      t.ProductSKU.Contains(keyword ?? t.ProductSKU),
                                                      _service.Expression(sidx), sord.ToUpper().Equals("ASC"));

            //设置返回格式
            ReturnEntity RtEntity = new ReturnEntity();

            RtEntity.rows    = entity.Entity;
            RtEntity.page    = page;
            RtEntity.records = entity.Total;
            int Count = entity.Total / rows; //获取除数
            int yu    = entity.Total % rows; //获取余数

            if (yu > 0)                      //如q果余数大于0则加一页,否则不加
            {
                RtEntity.total = Count + 1;
            }
            else
            {
                RtEntity.total = Count + 0;
            }
            if (entity.Entity != null && entity.Entity.Count() > 0)
            {
                foreach (var item in entity.Entity)
                {
                    var product = await _productService.QueryByIdAsync(item.ProductId);

                    item.ProductName = product == null ? "" : product.FullName;
                }
            }
            return(Ok(Extensions.ToJson(RtEntity)));
        }
Пример #9
0
        public ActionResult SubmitLogin(string account, string pwd)
        {
            ReturnEntity <string> data = new ReturnEntity <string>
            {
                Status = false
            };

            if (string.IsNullOrWhiteSpace(pwd))
            {
                data.Msg = "未输入密码!";
                return(JsonCResult(data));
            }
            if (string.IsNullOrWhiteSpace(account))
            {
                data.Msg = "未输入帐号!";
                return(JsonCResult(data));
            }

            var user = new BaseUserService().GetUserInfoByAccount(account, 0);

            if (user == null)
            {
                data.Msg = "帐号不存在!";
                return(JsonCResult(data));
            }
            pwd = EncryptionHelper.Md5(pwd);
            if (user.Pwd.ToLower() != pwd.ToLower())
            {
                data.Msg = "密码错误!";
                return(JsonCResult(data));
            }

            //记录session
            MemberEntity member = new MemberEntity
            {
                UserId       = user.Id,
                Account      = user.Account,
                ProfessionId = user.ProfessionId.GetValueOrDefault()
            };

            SessionData.Member.LoginedUser = member;
            data.Status = true;
            return(JsonCResult(data));
        }
Пример #10
0
        public ActionResult GetProductInfo(long productId)
        {
            ReturnEntity <object> data = new ReturnEntity <object>
            {
                Status = false
            };
            BookService service = new BookService();
            var         book    = service.GetBookDetailInfo(productId);

            if (book != null)
            {
                if (!string.IsNullOrWhiteSpace(book.TOC))
                {
                    book.TOC = Server.HtmlDecode(book.TOC);
                }
                if (!string.IsNullOrWhiteSpace(book.ContentDescription))
                {
                    book.ContentDescription = Server.HtmlDecode(book.ContentDescription);
                }
                if (!string.IsNullOrWhiteSpace(book.EditorComment))
                {
                    book.EditorComment = Server.HtmlDecode(book.EditorComment);
                }
                if (!string.IsNullOrWhiteSpace(book.AurhorDescription))
                {
                    book.AurhorDescription = Server.HtmlDecode(book.AurhorDescription);
                }

                var imgList    = new UploadService().GetFileList(FlagMgr.Upload.SourceType.Book.ToInt(), productId.ToString());
                int monthSales = service.GetSaleCountByMonth(productId);
                int sales      = service.GetSaleCount(productId);
                int count      = service.GetCommentCount(productId);
                data.Status = true;
                var retrunData = new { Product = book, Sales = sales, MonthSales = monthSales, CommentCount = count, ImgList = imgList };
                data.Data = retrunData;
            }
            else
            {
                data.Msg = "未获取到商品详情!";
            }
            return(JsonCResult(data));
        }
Пример #11
0
        public ActionResult SubmitLogin(string account, string pwd)
        {
            ReturnEntity <string> data = new ReturnEntity <string>
            {
                Status = false
            };

            if (string.IsNullOrWhiteSpace(pwd))
            {
                data.Msg = "未输入密码!";
                return(JsonCResult(data));
            }
            if (string.IsNullOrWhiteSpace(account))
            {
                data.Msg = "未输入帐号!";
                return(JsonCResult(data));
            }

            var user = new BaseUserService().GetUserInfoByAccount(account, 1);

            if (user == null)
            {
                data.Msg = "帐号不存在!";
                return(JsonCResult(data));
            }
            pwd = EncryptionHelper.Md5(pwd);
            if (user.Pwd.ToLower() != pwd.ToLower())
            {
                data.Msg = "密码错误!";
                return(JsonCResult(data));
            }

            //记录session
            SessionData.Admin.LoginedUser = new LoginEntity {
                Account = user.Account,
                UserId  = user.Id
            };
            data.Status = true;
            return(JsonCResult(data));
        }
Пример #12
0
        public ActionResult GetEditInfo(long productId)
        {
            var book = new BookService().GetBookInfo(productId);
            ReturnEntity <object> data = new ReturnEntity <object>
            {
                Status = false
            };

            if (book != null)
            {
                var imgList = new UploadService().GetFileList(FlagMgr.Upload.SourceType.Book.ToInt(), productId.ToString());
                if (!string.IsNullOrWhiteSpace(book.TOC))
                {
                    book.TOC = Server.HtmlDecode(book.TOC);
                }
                if (!string.IsNullOrWhiteSpace(book.ContentDescription))
                {
                    book.ContentDescription = Server.HtmlDecode(book.ContentDescription);
                }
                if (!string.IsNullOrWhiteSpace(book.EditorComment))
                {
                    book.EditorComment = Server.HtmlDecode(book.EditorComment);
                }
                if (!string.IsNullOrWhiteSpace(book.AurhorDescription))
                {
                    book.AurhorDescription = Server.HtmlDecode(book.AurhorDescription);
                }

                var returnData = new {
                    Book    = book,
                    ImgList = imgList
                };

                data.Status = true;
                data.Data   = returnData;
            }

            data.Msg = "未获取到商品信息";
            return(JsonCResult(data));
        }
Пример #13
0
        public string Read([FromBody] string value)
        {
            ReturnEntity <ErrorListEntity_Order, Order> checkList = null;

            try
            {
                checkList = purchaseOrderBLL.Read(value);
                if (checkList != null)
                {
                    return(JsonConvert.SerializeObject(new { ResultCode = 1, ResultMsg = "Success", ResultData = checkList }));
                }
                else
                {
                    return(JsonConvert.SerializeObject(new { ResultCode = 0, ResultMsg = "Fail", ResultData = checkList }));
                }
            }
            catch (Exception ex)
            {
                FlashLogger.Error(string.Format("api/order/read\r\n{0}\r\n{1}", ex.Message, value));
                return(JsonConvert.SerializeObject(new { ResultCode = 0, ResultMsg = string.Format("Error:{0}", ex.Message), ResultData = checkList }));
            }
        }
Пример #14
0
        public string Maintenance([FromBody] string value)
        {
            ReturnEntity <ErrorListEntity_Return, Return> checkList = null;

            try
            {
                checkList = returnBLL.Response(value);
                if (checkList != null)
                {
                    return(JsonConvert.SerializeObject(new { ResultCode = 1, ResultMsg = "Success", ResultData = checkList }));
                }
                else
                {
                    return(JsonConvert.SerializeObject(new { ResultCode = 0, ResultMsg = "Fail", ResultData = checkList }));
                }
            }
            catch (Exception ex)
            {
                FlashLogger.Error(string.Format("api/return/maintenance\r\n{0}\r\n{1}", ex.Message, value));
                return(JsonConvert.SerializeObject(new { ResultCode = 0, ResultMsg = string.Format("Error:{0}", ex.Message), ResultData = checkList }));
            }
        }
Пример #15
0
        public ActionResult SaveBook(Product book, List <FileUpload> imgList)
        {
            ReturnEntity <string> data = new ReturnEntity <string>
            {
                Status = false
            };

            if (!string.IsNullOrWhiteSpace(book.TOC))
            {
                book.TOC = Server.HtmlEncode(book.TOC);
            }
            if (!string.IsNullOrWhiteSpace(book.ContentDescription))
            {
                book.ContentDescription = Server.HtmlEncode(book.ContentDescription);
            }
            if (!string.IsNullOrWhiteSpace(book.EditorComment))
            {
                book.EditorComment = Server.HtmlEncode(book.EditorComment);
            }
            if (!string.IsNullOrWhiteSpace(book.AurhorDescription))
            {
                book.AurhorDescription = Server.HtmlEncode(book.AurhorDescription);
            }

            var service = new BookService();

            if (book.Id <= 0)//添加
            {
                data.Status = service.AddBook(book, imgList);
            }
            else//编辑
            {
                data.Status = service.UpdateBook(book, imgList);
            }
            return(JsonCResult(data));
        }
Пример #16
0
        public static string Save()
        {
            ReturnEntity ReturnObj = (ReturnEntity)HttpContext.Current.Session["MyObj"];

            InterfazDAL_ttisfc001 _idalttisfc001 = new InterfazDAL_ttisfc001();
            //JC 091221 Grabar las variables de sesion en variables tipo string

            string CWARG = "";
            string LOCAG = "";

            CWARG = HttpContext.Current.Session["CWAR"].ToString();
            LOCAG = HttpContext.Current.Session["LOCA"].ToString();

            string sqnb = ReturnObj.PAID;
            string pdno = ReturnObj.ORNO;
            var    pro1 = "2";

            var consultadata = _idalttisfc001.findByPdnoSqnbAndPro1(ref pdno, ref sqnb, ref pro1, ref strError);

            if (consultadata.Rows.Count > 0)
            {
                var STRQTY  = ReturnObj.QTDL;
                var QTYPEND = ReturnObj.QRDR;

                if (STRQTY > float.Parse(QTYPEND))
                {
                    ReturnObj.Msg   = String.Format(mensajes("confirmedquantity"), STRQTY, QTYPEND);
                    ReturnObj.Error = true;
                    return(JsonConvert.SerializeObject(ReturnObj));
                }

                if (STRQTY < 0)
                {
                    ReturnObj.Msg   = mensajes("quantitynegative");
                    ReturnObj.Error = true;
                    return(JsonConvert.SerializeObject(ReturnObj));
                }

                if (STRQTY == 0)
                {
                    ReturnObj.Msg   = mensajes("quantityzero");
                    ReturnObj.Error = true;
                    return(JsonConvert.SerializeObject(ReturnObj));
                }

                var consecutivo = _idaltticol025.consultarConsecutivoRegistro(ref pdno, ref strError);

                consecutivo = consecutivo + 1;

                string item = ReturnObj.MITM; // + "|" + lblValueArticulo.Text.Split('|')[1].Trim().ToUpper();
                string dsca = ReturnObj.DSCA;
                float  qtdl = STRQTY;
                string cuni = ReturnObj.CUNI;

                Ent_tticol025 data025 = new Ent_tticol025()
                {
                    pdno    = pdno,
                    sqnb    = consecutivo,
                    mitm    = item.Trim().ToUpper(),
                    dsca    = dsca,
                    qtdl    = qtdl,
                    cuni    = cuni,
                    mess    = " ",
                    user    = HttpContext.Current.Session["user"].ToString(),
                    refcntd = 0,
                    refcntu = 0
                };

                var validSave = _idaltticol025.insertarRegistro(ref data025, ref strError);

                if (validSave > 0)
                {
                    Ent_tticol022 data022 = new Ent_tticol022()
                    {
                        log1 = HttpContext.Current.Session["user"].ToString(),
                        qtd1 = Convert.ToInt32(data025.qtdl),
                        pdno = pdno,
                        sqnb = sqnb
                    };

                    var validateUpdate = _idaltticol022.actualizaRegistroConfirmReceipt(ref data022, ref strError);

                    if (validateUpdate)
                    {
                        ReturnObj.Msg   = mensajes("msjsave");
                        ReturnObj.Error = false;
                        _idaltticol022.ActualizarCantidadAlmacenRegistroTicol222(HttpContext.Current.Session["user"].ToString(), data022.qtd1, LOCAG, CWARG, data022.sqnb);
                        return(JsonConvert.SerializeObject(ReturnObj));
                    }
                    else
                    {
                        ReturnObj.Msg   = mensajes("errorupdt");
                        ReturnObj.Error = true;
                        return(JsonConvert.SerializeObject(ReturnObj));
                    }
                }
                else
                {
                    ReturnObj.Msg   = mensajes("errorsave");
                    ReturnObj.Error = true;
                    return(JsonConvert.SerializeObject(ReturnObj));
                }
            }
            else
            {
                ReturnObj.Msg   = mensajes("orderconfirmed");
                ReturnObj.Error = true;
                return(JsonConvert.SerializeObject(ReturnObj));
            }
        }
Пример #17
0
        public static string ConsultPallet(string txtNumeroOrden)
        {
            ReturnEntity ReturnObj = new ReturnEntity();

            //JC 091221 Se Mueven estas variables al entorno locar y no dejarlas publicas
            HttpContext.Current.Session["CWAR"] = "";
            HttpContext.Current.Session["LOCA"] = "";
            string SLOC, LOCA, CWAR;


            if (txtNumeroOrden.Trim() != String.Empty)
            {
                string numeroOrdenPallet = txtNumeroOrden.Trim().ToUpper();
                string numeroOrden       = numeroOrdenPallet.Substring(0, 9);
                var    pro1 = true;

                var consultaOrden = _idalttisfc001.findByOrderNumberConfirmRecep(ref numeroOrden, ref numeroOrdenPallet, ref pro1, ref strError);

                if (consultaOrden.Rows.Count < 1)
                {
                    pro1          = false;
                    consultaOrden = _idalttisfc001.findByOrderNumberConfirmRecep(ref numeroOrden, ref numeroOrdenPallet, ref pro1, ref strError);
                }

                if (consultaOrden.Rows.Count > 0)
                {
                    var DELE = consultaOrden.Rows[0]["DELE"].ToString();
                    var QTDL = consultaOrden.Rows[0]["QTDL"].ToString();
                    var OSTA = consultaOrden.Rows[0]["OSTA"].ToString();
                    SLOC = consultaOrden.Rows[0]["SLOC"].ToString();
                    LOCA = consultaOrden.Rows[0]["LOCA"].ToString();
                    CWAR = consultaOrden.Rows[0]["CWAR"].ToString();
                    //JC 091221 Crear una variable de sesion para almacenar la bodega
                    HttpContext.Current.Session["CWAR"] = CWAR;
                    HttpContext.Current.Session["LOCA"] = LOCA;
                    //Validamos si el parametro de validar producción esta activo
                    var consultaPrdVl = _idalttisfc001.findProdValidation_Parameter(ref strError);
                    var PRVL          = consultaPrdVl.Rows[0]["PRVL"].ToString();
                    if (PRVL == "1")
                    {
                        if (DELE != "4")
                        {
                            ReturnObj.Msg   = mensajes("palletwrapped");
                            ReturnObj.Error = true;
                            return(JsonConvert.SerializeObject(ReturnObj));
                        }
                    }
                    if (DELE == "3")
                    {
                        ReturnObj.Msg   = mensajes("palletstatus");
                        ReturnObj.Error = true;
                        return(JsonConvert.SerializeObject(ReturnObj));
                    }
                    if (QTDL == "0")
                    {
                        ReturnObj.Msg   = mensajes("palletannounced");
                        ReturnObj.Error = true;
                        return(JsonConvert.SerializeObject(ReturnObj));
                    }
                    else if (!pro1)
                    {
                        ReturnObj.Msg   = mensajes("palletconfirmed");
                        ReturnObj.Error = true;
                        return(JsonConvert.SerializeObject(ReturnObj));
                    }

                    if (OSTA == "5" || OSTA == "7")
                    {
                    }
                    else
                    {
                        ReturnObj.Msg   = mensajes("ordernotactive");
                        ReturnObj.Error = true;
                        return(JsonConvert.SerializeObject(ReturnObj));
                    }

                    ReturnObj.PAID      = txtNumeroOrden;
                    ReturnObj.ORNO      = numeroOrden;
                    ReturnObj.MITM      = consultaOrden.Rows[0]["MITM"].ToString();
                    ReturnObj.DSCA      = consultaOrden.Rows[0]["DSCA"].ToString();
                    ReturnObj.CWAR      = consultaOrden.Rows[0]["CWAR"].ToString();
                    ReturnObj.DCWAR     = consultaOrden.Rows[0]["DSCACWAR"].ToString();
                    ReturnObj.QRDR      = consultaOrden.Rows[0]["QRDR"].ToString();
                    ReturnObj.TOTQTYENT = consultaOrden.Rows[0]["TOTQTYENT"].ToString();
                    ReturnObj.QTYPEND   = consultaOrden.Rows[0]["QTYPEND"].ToString();
                    ReturnObj.QTDL      = float.Parse(consultaOrden.Rows[0]["QTDL"].ToString());
                    ReturnObj.CUNI      = consultaOrden.Rows[0]["CUNI"].ToString();
                    ReturnObj.Msg       = String.Empty;
                    ReturnObj.Error     = false;
                    HttpContext.Current.Session["MyObj"] = ReturnObj;
                    return(JsonConvert.SerializeObject(ReturnObj));
                }
                else
                {
                    ReturnObj.Msg   = mensajes("palletannounced");
                    ReturnObj.Error = true;
                    return(JsonConvert.SerializeObject(ReturnObj));
                }
            }
            else
            {
                ReturnObj.Msg   = mensajes("numberempty");
                ReturnObj.Error = true;
                return(JsonConvert.SerializeObject(ReturnObj));
            }
        }
Пример #18
0
        public async Task <IActionResult> GatPagerListByWhere(string keyword, int rows, int page, string sidx, string sord, string Id)
        {
            if (string.IsNullOrEmpty(sidx))
            {
                sidx = "SortCode";
            }
            //UserGetDto user = await _userservice.QueryByIdAsync(Id);
            //RoleGetDto role = await _roleservice.QueryByIdAsync(user.RoleId);
            //PagerEntity<ExpCompanyGetDto> entity = new PagerEntity<ExpCompanyGetDto>();
            //if (role.IsAdmin)
            //{
            PagerEntity <ExpCompanyGetDto> entity = await _service.QueryByPagesAsync(rows, page,
                                                                                     t => t.EnCode.Contains((keyword ?? t.EnCode)) ||
                                                                                     t.FullName.Contains(keyword ?? t.FullName),
                                                                                     _service.Expression(sidx), sord.ToUpper().Equals("ASC"));

            // }
            //  else
            //{
            //    entity = await _service.QueryByPagesAsync(rows, page,
            //         t => t.EnCode.Contains((keyword ?? t.EnCode)) ||
            //         t.FullName.Contains(keyword ?? t.FullName) &&
            //         t.UserId.Contains(Id ?? t.UserId),
            //         _service.Expression(sidx), sord.ToUpper().Equals("ASC"));
            //}

            if (entity.Entity != null)
            {
                foreach (var item in entity.Entity)
                {
                    if (item.KDAccout != "")
                    {
                        ItemsDetailGetDto dto = await _itemsDetailService.QueryByIdAsync(item.KDAccout);

                        WarehouseGetDto warehouse = await _warehouseService.QueryByIdAsync(item.WarehouseCode);

                        item.KDAccoutName  = dto == null ? "" : dto.ItemName;
                        item.WarehouseName = warehouse == null ? "" : warehouse.FullName;
                    }
                }
            }

            //设置返回格式
            ReturnEntity RtEntity = new ReturnEntity();

            RtEntity.rows    = entity.Entity;
            RtEntity.page    = page;
            RtEntity.records = entity.Total;
            int Count = entity.Total / rows; //获取除数
            int yu    = entity.Total % rows; //获取余数

            if (yu > 0)                      //如果余数大于0则加一页,否则不加
            {
                RtEntity.total = Count + 1;
            }
            else
            {
                RtEntity.total = Count + 0;
            }
            return(Ok(Extensions.ToJson(RtEntity)));
        }