public bool Save(ProductSize productSize, out string strResult) { strResult = string.Empty; bool result = false; var pro = ProductSizeRepository.GetQueryable().FirstOrDefault(s => s.ID == productSize.ID); if (pro != null) { try { pro.ID = productSize.ID; pro.ProductCode = productSize.ProductCode; pro.SizeNo = productSize.SizeNo; pro.AreaNo = productSize.AreaNo; ProductSizeRepository.SaveChanges(); result = true; } catch (Exception ex) { strResult = "原因:" + ex.Message; } } else { strResult = "原因:未找到当前需要修改的数据!"; } return(result); }
public ProductServiceImpl() { this.imageRepository = new ImageRepositoryImpl(); this.productSizeRepository = new ProductSizeRepositoryImpl(); this.productRepository = new ProductRepositoryImpl(); this.productColorRepository = new ProductColorRepositoryImpl(); }
public ActionResult updatecart(int cartindex, int quantity, string sizename = "") { int v = 0; if (sizename.Contains('|')) { v = Convert.ToInt32(sizename.Split('|')[0]); } else if (sizename != "") { v = Convert.ToInt32(sizename); } ProductSizeRepository sizeRepository = new ProductSizeRepository(); if (v != 0 && sizeRepository.Get(v).Count < quantity) { return(RedirectToAction(Session["actionname"].ToString(), new { id = Session["reid"], categoryname = Session["catname"] })); } List <CartViewModel> cartviewlist = new List <CartViewModel>(); if (Session["cart"] != null) { cartviewlist = (List <CartViewModel>)Session["cart"]; } CartViewModel cartViewModel = new CartViewModel(); cartviewlist[cartindex].count = quantity; cartviewlist[cartindex].size = sizeRepository.Get(v); Session["cart"] = cartviewlist; return(RedirectToAction("Index", "Cart")); }
public object GetProductSize(int page, int rows, string queryString, string value) { string id = "", productCode = ""; if (queryString == "id") { id = value; } else { productCode = value; } IQueryable <ProductSize> productSizeQuery = ProductSizeRepository.GetQueryable(); int Id = Convert.ToInt32(id); var productSize = productSizeQuery.Where(p => p.ID == Id && p.ProductCode.Contains(productCode)) .OrderBy(p => p.ID).AsEnumerable(). Select(p => new { p.ID, p.ProductCode, p.SizeNo, p.AreaNo }); int total = productSize.Count(); productSize = productSize.Skip((page - 1) * rows).Take(rows); return(new { total, rows = productSize.ToArray() }); }
public bool Add(ProductSize productSize, out string strResult) { strResult = string.Empty; bool result = false; var pro = new ProductSize(); if (pro != null) { try { pro.ID = productSize.ID; pro.ProductCode = productSize.ProductCode; pro.SizeNo = productSize.SizeNo; pro.AreaNo = productSize.AreaNo; ProductSizeRepository.Add(pro); ProductSizeRepository.SaveChanges(); result = true; } catch (Exception ex) { strResult = "原因:" + ex.Message; } } else { strResult = "原因:找不到当前登陆用户!请重新登陆!"; } return(result); }
public System.Data.DataTable GetProductSize(int page, int rows, string productCode) { IQueryable <ProductSize> productSizeQuery = ProductSizeRepository.GetQueryable(); var productSize = productSizeQuery.Where(p => p.ProductCode.Contains(productCode)) .OrderBy(p => p.ID).AsEnumerable() .Select(p => new { p.ID, p.ProductCode, p.SizeNo, p.AreaNo }); System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add("商品ID", typeof(string)); dt.Columns.Add("商品代码", typeof(string)); dt.Columns.Add("件烟尺寸编号", typeof(string)); dt.Columns.Add("存储库区号", typeof(string)); foreach (var item in productSize) { dt.Rows.Add ( item.ID, item.ProductCode, item.SizeNo, item.AreaNo ); } return(dt); }
public bool Delete(int productSizeId, out string strResult) { strResult = string.Empty; bool result = false; var si = ProductSizeRepository.GetQueryable().FirstOrDefault(s => s.ID == productSizeId); if (si != null) { try { ProductSizeRepository.Delete(si); ProductSizeRepository.SaveChanges(); result = true; } catch (Exception) { strResult = "原因:已在使用"; } } else { strResult = "原因:未找到当前需要删除的数据!"; } return(result); }
public IHttpActionResult PostAddSize(SizeListVieModel sizeListViewModel) { HttpResponseMessage result = null; var name = HttpContext.Current.Request; ProductSizeRepository productSizeRP = new ProductSizeRepository(); ProductSize model = new ProductSize(); for (int i = 0; i < sizeListViewModel.counlist.Count; i++) { model.Count = Convert.ToInt32(sizeListViewModel.counlist.ElementAt(i)); model.ProductID = Convert.ToInt32(sizeListViewModel.id); model.SizeName = sizeListViewModel.sizelist.ElementAt(i); productSizeRP.Insert(model); ProductSizeHistory sizemodelhistory = new ProductSizeHistory(); sizemodelhistory.Count = model.Count; sizemodelhistory.ProductHistoryId = sizehistory.GetByProductNameCategory(productRepository.Get(Convert.ToInt32(sizeListViewModel.id)).Product_name, productRepository.Get(Convert.ToInt32(sizeListViewModel.id)).MainCategoryId).ProductHistoryId; sizemodelhistory.SizeName = model.SizeName; sizemodelhistory.Count = model.Count; sizehistory.Insert(sizemodelhistory); } return(StatusCode(HttpStatusCode.Created)); }
public ProductSizeBusiness(DatabaseFactory df = null, UnitOfWork uow = null) { DatabaseFactory dfactory = df == null ? new DatabaseFactory() : df; _unitOfWork = uow == null ? new UnitOfWork(dfactory) : uow; _productRepository = new ProductRepository(dfactory); _ProductSizesRepository = new ProductSizeRepository(dfactory); }
/// <summary> /// /// </summary> /// <param name="request"></param> /// <returns></returns> public List <ProductSizeModel> GetProductSizes() { var items = ProductSizeRepository.GetAll(); if (items != null) { return(items.Select(p => p.ToModel()).ToList()); } return(new List <ProductSizeModel>()); }
public System.Data.DataTable GetProductSize(int page, int rows, ProductSize productSize) { IQueryable <ProductSize> productSizeQuery = ProductSizeRepository.GetQueryable(); IQueryable <Product> productQuery = ProductRepository.GetQueryable(); var productSizeDetail = productSizeQuery.Where(p => p.ProductCode.Contains(productSize.ProductCode)) .OrderBy(p => p.ID); //var productSize_Detail = productSizeDetail.ToArray().Select(p => new // { // p.ID, // p.ProductCode, // p.ProductNo, // p.ProductName, // p.SizeNo, // p.AreaNo // }); var productSize_Detail = productSizeDetail.Join(productQuery, ps => ps.ProductCode, p => p.ProductCode, (ps, p) => new { ps.ID, ps.ProductCode, ps.ProductNo, ps.SizeNo, ps.AreaNo, p.ProductName }) .Where(p => p.ProductCode.Contains(productSize.ProductCode)) .OrderBy(p => p.ID).AsEnumerable().Select(p => new { p.ID, p.ProductCode, p.ProductName, p.ProductNo, p.SizeNo, p.AreaNo }); System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add("商品ID", typeof(string)); dt.Columns.Add("商品代码", typeof(string)); dt.Columns.Add("商品简码", typeof(string)); dt.Columns.Add("商品名称", typeof(string)); dt.Columns.Add("件烟尺寸编号", typeof(string)); dt.Columns.Add("存储库区号", typeof(string)); foreach (var item in productSize_Detail) { dt.Rows.Add ( item.ID, item.ProductCode, item.ProductNo, item.ProductName, item.SizeNo, item.AreaNo ); } return(dt); }
/// <summary> /// /// </summary> /// <param name="request"></param> /// <returns></returns> public DatatablesView <ProductSizeModel> GetProductSizesByPaging(DataTablesPaging request) { int total = 0; var pagingItems = ProductSizeRepository.GetItemsByPaging(request, out total); var items = new List <ProductSizeModel>(); foreach (var pagingItem in pagingItems) { var item = pagingItem.ToModel(); items.Add(item); } return(new DatatablesView <ProductSizeModel>(request.Draw, total, pagingItems.Count, items)); }
public bool Save(ProductSize productSize) { var pro = ProductSizeRepository.GetQueryable().FirstOrDefault(s => s.ID == productSize.ID); pro.ID = productSize.ID; pro.ProductCode = productSize.ProductCode; pro.ProductNo = productSize.ProductNo; pro.SizeNo = productSize.SizeNo; pro.AreaNo = productSize.AreaNo; ProductSizeRepository.SaveChanges(); return(true); }
public bool Add(ProductSize productSize) { var pro = new ProductSize(); pro.ID = productSize.ID; pro.ProductCode = productSize.ProductCode; pro.ProductNo = productSize.ProductNo; pro.SizeNo = productSize.SizeNo; pro.AreaNo = productSize.AreaNo; ProductSizeRepository.Add(pro); ProductSizeRepository.SaveChanges(); return(true); }
public bool Delete(int productSizeId) { var si = ProductSizeRepository.GetQueryable().FirstOrDefault(s => s.ID == productSizeId); if (si != null) { ProductSizeRepository.Delete(si); ProductSizeRepository.SaveChanges(); } else { return(false); } return(true); }
public object GetDetails(int page, int rows, string ProductCode, string SizeNo, string AreaNo) { IQueryable <ProductSize> productSizeQuery = ProductSizeRepository.GetQueryable(); var productSize = productSizeQuery.Where(p => p.ProductCode.Contains(ProductCode)) .OrderBy(p => p.ID).AsEnumerable() .Select(p => new { p.ID, p.ProductCode, p.SizeNo, p.AreaNo }); int sizeno = -1, areano = -1; if ((SizeNo != "" && SizeNo != null) && (AreaNo == "" || AreaNo == null)) { try { sizeno = Convert.ToInt32(SizeNo); } catch { sizeno = -1; } finally { productSize = productSize.Where(p => p.SizeNo == sizeno); } } if ((SizeNo == "" || SizeNo == null) && (AreaNo != "" && AreaNo != null)) { try { areano = Convert.ToInt32(AreaNo); } catch { areano = -1; } finally { productSize = productSize.Where(p => p.AreaNo == areano); } } if ((SizeNo != "" && SizeNo != null) && (AreaNo != "" && AreaNo != null)) { try { sizeno = Convert.ToInt32(SizeNo); areano = Convert.ToInt32(AreaNo); } catch { areano = -1; } finally { productSize = productSize.Where(p => p.SizeNo == sizeno && p.AreaNo == areano); } } productSize = productSize.OrderBy(p => p.ID).AsEnumerable() .Select(p => new { p.ID, p.ProductCode, p.SizeNo, p.AreaNo }); int total = productSize.Count(); productSize = productSize.Skip((page - 1) * rows).Take(rows); return(new { total, rows = productSize.ToArray() }); }
public object GetDetails(int page, int rows, ProductSize productSize) { IQueryable <ProductSize> productSizeQuery = ProductSizeRepository.GetQueryable(); IQueryable <Product> productQuery = ProductRepository.GetQueryable(); var productSizeDetail = productSizeQuery.Where(p => p.ProductCode.Contains(productSize.ProductCode)).OrderBy(p => p.ID); var productSizeDetail1 = productSizeDetail; if (productSize.SizeNo != null && productSize.SizeNo != 0) { productSizeDetail1 = productSizeDetail.Where(p => p.SizeNo == productSize.SizeNo).OrderBy(p => p.ID); } var productSizeDetail2 = productSizeDetail1; if (productSize.ProductNo != null && productSize.ProductNo != 0) { productSizeDetail2 = productSizeDetail1.Where(p => p.ProductNo == productSize.ProductNo).OrderBy(p => p.ID); } var productSizeDetail3 = productSizeDetail2; if (productSize.AreaNo != null && productSize.AreaNo != 0) { productSizeDetail3 = productSizeDetail2.Where(p => p.AreaNo == productSize.AreaNo).OrderBy(p => p.ID); } int total = productSizeDetail3.Count(); var productSizeDetails = productSizeDetail3.Skip((page - 1) * rows).Take(rows); var productSize_Detail = productSizeDetails.Join(productQuery, ps => ps.ProductCode, p => p.ProductCode, (ps, p) => new { ps.ID, ps.ProductCode, ps.ProductNo, ps.SizeNo, ps.AreaNo, p.ProductName }) .Where(p => p.ProductCode.Contains(productSize.ProductCode)) .OrderBy(p => p.ID).AsEnumerable().Select(p => new { p.ID, p.ProductCode, p.ProductName, p.ProductNo, p.SizeNo, p.AreaNo }); return(new { total, rows = productSize_Detail.ToArray() }); }
public ActionResult AddSize(SizeViewModel sizeViewModel, int id, List <int> Count) { ProductSizeRepository productSizeRP = new ProductSizeRepository(); var model = sizeViewModel.productSizes; //sizeViewModel.productSizes.ProductID = id; //sizeViewModel.productSizes.Count = sizeViewModel.product.Onhand; for (int i = 0; i < Count.Count; i++) { sizeViewModel.productSizes = model; sizeViewModel.productSizes.SizeName = sizeViewModel.Sizes.ElementAt(i); sizeViewModel.productSizes.Count = Count.ElementAt(i); productSizeRP.Insert(sizeViewModel.productSizes); ProductSizeHistory sizemodelhistory = new ProductSizeHistory(); sizemodelhistory.Count = sizeViewModel.productSizes.Count; sizemodelhistory.ProductID = sizehistory.GetByProductNameCategory(productRepository.Get(id).Product_name, productRepository.Get(id).CategoryID).Product_id; sizemodelhistory.SizeName = sizeViewModel.productSizes.SizeName; sizemodelhistory.Count = sizeViewModel.productSizes.Count; sizehistory.Insert(sizemodelhistory); } return(RedirectToAction("Index")); }
public IHttpActionResult Post(CartMethodViewModel cartMethodViewModel) { int v = 0; if (cartMethodViewModel.sizename.Contains('|')) { v = Convert.ToInt32(cartMethodViewModel.sizename.Split('|')[0]); } else if (cartMethodViewModel.sizename != "") { v = Convert.ToInt32(cartMethodViewModel.sizename); } ProductSizeRepository sizeRepository = new ProductSizeRepository(); for (int x = 0; x < cartviewlist.Count; x++) { if (product.Get(cartviewlist[x].product.ProductId) == null) { cartviewlist[x].outOfStock = "Out Of Stock"; } else { cartviewlist[x].outOfStock = ""; } } CartViewModel cartViewModel = new CartViewModel(); Product model = product.Get(cartMethodViewModel.productid); var i = false; foreach (var item in cartviewlist) { if ((v == 0 && item.name == model.Product_name) || (v > 0 && item.name == model.Product_name && item.size.ProductID == model.ProductId)) { cartviewlist[cartviewlist.IndexOf(item)].count = cartMethodViewModel.quantity; i = true; break; } } if (i) { return(Ok(cartviewlist)); } else { cartViewModel.product = model; cartViewModel.name = model.Product_name; cartViewModel.count = cartMethodViewModel.quantity;; if (v > 0) { cartViewModel.size = sizeRepository.Get(v); } cartviewlist.Add(cartViewModel); return(Ok(cartviewlist)); } }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public ProductSizeModel GetProductSize(int id) { var item = ProductSizeRepository.GetItem(id); return(item.ToModel()); }
public ActionResult addcart(int productid, int quantity, string sizename = "") { int v = 0; if (sizename.Contains('|')) { v = Convert.ToInt32(sizename.Split('|')[0]); } else if (sizename != "") { v = Convert.ToInt32(sizename); } ProductSizeRepository sizeRepository = new ProductSizeRepository(); if (v != 0 && sizeRepository.Get(v).Count < quantity) { return(RedirectToAction(Session["actionname"].ToString(), new { id = Session["reid"], categoryname = Session["catname"] })); } List <CartViewModel> cartviewlist = new List <CartViewModel>(); if (Session["cart"] != null) { cartviewlist = (List <CartViewModel>)Session["cart"]; for (int x = 0; x < cartviewlist.Count; x++) { if (product.Get(cartviewlist[x].product.Product_id) == null) { cartviewlist[x].outOfStock = "Out Of Stock"; } else { cartviewlist[x].outOfStock = ""; } } } CartViewModel cartViewModel = new CartViewModel(); Product model = product.Get(productid); var i = false; foreach (var item in cartviewlist) { if ((v == 0 && item.name == model.Product_name) || (v > 0 && item.name == model.Product_name && item.size.ProductID == model.Product_id)) { cartviewlist[cartviewlist.IndexOf(item)].count = quantity; i = true; break; } } if (i) { Session["cart"] = cartviewlist; return(RedirectToAction("Index", "Cart")); } else { cartViewModel.product = model; cartViewModel.name = model.Product_name; cartViewModel.count = quantity; if (v > 0) { cartViewModel.size = sizeRepository.Get(v); } cartviewlist.Add(cartViewModel); Session["cart"] = cartviewlist; return(RedirectToAction("Index", "Cart")); } }
/// <summary> /// /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Save(ProductSizeModel model) { return(ProductSizeRepository.Save(model.ToPO())); }