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