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))); }
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); }
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); }
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); }
///// <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); }
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))); }
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)); }
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))); }
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)); }
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)); }
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)); }
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)); }
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 })); } }
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 })); } }
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)); }
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)); } }
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)); } }
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))); }