public ActionResult Detail(string id, string ptype = "id")
{
if (string.IsNullOrEmpty(id))
{
return(View("Error"));
}
var model = new ProductDetailModel();
var entity = new PROD_MASTER();
if (ptype == "id")
{
entity = PROD_MASTERService.PROD_MASTERList.FirstOrDefault(t => t.ID == id);
}
else
{
entity = PROD_MASTERService.PROD_MASTERList.FirstOrDefault(t => t.ProductNo == id);
}
if (null != entity)
{
var photos = PROD_PHOTOService.PROD_PHOTOList.Where(t => t.EntityID == entity.ID)
.AsEnumerable()
.Select(t => new PROD_PHOTOModel
{
ID = t.ID,
PhotoTitle = t.PhotoTitle,
FilePath = t.FilePath,
IsDefault = t.IsDefault,
PhotoType = t.PhotoType,
EntityID = t.EntityID,
SmallPic = Common.Util.GetProductImgUrl(t.SmallPic),
BigPic = Common.Util.GetProductImgUrl(t.BigPic),
MiddlePic = t.MiddlePic,
CreateDate = t.CreateDate,
ModiDate = t.ModiDate,
Creator = t.Creator,
Modifier = t.Modifier,
DisplayOrder = t.DisplayOrder,
Status = t.Status,
Item01 = t.Item01,
Item02 = t.Item02,
Item03 = t.Item03,
Item04 = t.Item04,
Item05 = t.Item05,
}).Take(4);
var commonItems = PROD_MASTERCOMMONService.PROD_MASTERCOMMONList.Where(t => t.ProductNo == entity.ProductNo)
.Select(t => new PROD_MASTERCOMMONModel
{
ID = t.ID,
ProductNo = t.ProductNo,
CommTitle = t.CommTitle,
CommSummary = t.CommSummary,
CommContent = t.CommContent,
Creator = t.Creator,
CreateDate = t.CreateDate,
Modifier = t.Modifier,
ModiDate = t.ModiDate,
Status = t.Status,
Item01 = t.Item01,
Item02 = t.Item02,
Item03 = t.Item03,
Item04 = t.Item04,
Item05 = t.Item05,
});
var subItems = PROD_PROPERTIESService.PROD_PROPERTIESList.Where(t => t.ProductNo == entity.ProductNo)
.Select(t => new PROD_PROPERTIESModel
{
ID = t.ID,
ProductNo = t.ProductNo,
PropertyID = t.PropertyID,
PropertyValue = t.PropertyValue,
PLevel = t.PLevel,
ParentID = t.ParentID,
RelationCode = t.RelationCode,
RowID = t.RowID,
RealProductNo = t.RealProductNo,
DisplayOrder = t.DisplayOrder,
Remark = t.Remark,
Status = t.Status,
});
var recommonItems = PROD_RELATEDITEMService.PROD_RELATEDITEM_MASTERList.Where(t => t.ProductNo == entity.ProductNo)
.AsEnumerable()
.Select(t => new ProductModel
{
ProductNo = t.ProductNo,
ProductName = t.ProductName,
BigPic = Common.Util.GetProductImgUrl(t.BigPic, false),
SmallPic = Common.Util.GetProductImgUrl(t.SmallPic),
ProdCategoryCode = t.CategoryCode,
BaseUOFM = t.BaseUOFM,
ListPrice = Common.Util.TransformObjToDou(t.ListPrice),
SellPrice = PROD_MASTERService.GetSellPrice(t.ProductNo, Common.Util.TransformObjToDou(t.ListPrice), (double)t.SpecialPrice),
}).Take(10);
model = new ProductDetailModel
{
ID = entity.ID,
ProductNo = entity.ProductNo,
ProductName = entity.ProductName,
Description = entity.Description,
ProductType = entity.ProductType,
StndCost = entity.StndCost,
CurrCost = entity.CurrCost,
ListPrice = entity.ListPrice,
SpecialPrice = entity.SpecialPrice,
ClearPrice = entity.ClearPrice,
ProdCategoryID = entity.ProdCategoryID,
CategoryCode = entity.CategoryCode,
SchdlUOM = entity.SchdlUOM,
PriceShed = entity.PriceShed,
BaseUOFM = entity.BaseUOFM,
AvailableQTY = entity.AvailableQTY,
ProdGroupID = entity.ProdGroupID,
ProdSubclassID = entity.ProdSubclassID,
LeadTime = entity.LeadTime,
QtySales = entity.QtySales,
QtyMin = entity.QtyMin,
QtyMax = entity.QtyMax,
CustomerID = entity.CustomerID,
StockType = entity.StockType,
SalesRepID = entity.SalesRepID,
PriceBookItem = entity.PriceBookItem,
PriceLevel = entity.PriceLevel,
BarCode = entity.BarCode,
Ranking = entity.Ranking,
Notes = entity.Notes,
Substitute1 = entity.Substitute1,
Substitute2 = entity.Substitute2,
Qty1 = entity.Qty1,
Qty3 = entity.Qty3,
Qty6 = entity.Qty6,
Qty12 = entity.Qty12,
Sales1 = entity.Sales1,
Sales3 = entity.Sales3,
Sales6 = entity.Sales6,
Sales12 = entity.Sales12,
GPD1 = entity.GPD1,
GPD3 = entity.GPD3,
GPD6 = entity.GPD6,
GPD12 = entity.GPD12,
LastDate = entity.LastDate,
CreateDate = entity.CreateDate,
Creator = entity.Creator,
Modifier = entity.Modifier,
ModiDate = entity.ModiDate,
Status = entity.Status,
P01 = entity.P01,
P02 = entity.P02,
P03 = entity.P03,
P04 = entity.P04,
P05 = entity.P05,
P06 = entity.P06,
P07 = entity.P07,
P08 = entity.P08,
P09 = entity.P09,
P10 = entity.P10,
IsCommend = entity.IsCommend,
IsHot = entity.IsHot,
ExteriorPart = entity.ExteriorPart,
ExteriorPartPrice = entity.ExteriorPartPrice,
ViewTimes = entity.ViewTimes,
BigPic = Common.Util.GetProductImgUrl(entity.BigPic, false),
SmallPic = Common.Util.GetProductImgUrl(entity.SmallPic),
LocationStocks1 = entity.LocationStocks1,
LocationStocks2 = entity.LocationStocks2,
LocationStocks3 = entity.LocationStocks3,
LocationStocks4 = entity.LocationStocks4,
LocationStocks5 = entity.LocationStocks5,
LocationStocks6 = entity.LocationStocks6,
LocationStocks7 = entity.LocationStocks7,
LocationStocks8 = entity.LocationStocks8,
LocationStocks9 = entity.LocationStocks9,
LocationStocks10 = entity.LocationStocks10,
LocationStocks11 = entity.LocationStocks11,
LocationStocks12 = entity.LocationStocks12,
LocationStocks13 = entity.LocationStocks13,
LocationStocks14 = entity.LocationStocks14,
LocationStocks15 = entity.LocationStocks15,
LocationAllocate1 = entity.LocationAllocate1,
LocationAllocate2 = entity.LocationAllocate2,
LocationAllocate3 = entity.LocationAllocate3,
LocationAllocate4 = entity.LocationAllocate4,
LocationAllocate5 = entity.LocationAllocate5,
LocationAllocate6 = entity.LocationAllocate6,
LocationAllocate7 = entity.LocationAllocate7,
LocationAllocate8 = entity.LocationAllocate8,
LocationAllocate9 = entity.LocationAllocate9,
LocationAllocate10 = entity.LocationAllocate10,
LocationAllocate11 = entity.LocationAllocate11,
LocationAllocate12 = entity.LocationAllocate12,
LocationAllocate13 = entity.LocationAllocate13,
LocationAllocate14 = entity.LocationAllocate14,
LocationAllocate15 = entity.LocationAllocate15,
Introduction = entity.Introduction,
Brand = entity.Brand,
Item01 = entity.Item01,
Item02 = entity.Item02,
Item03 = entity.Item03,
Item04 = entity.Item04,
Item05 = entity.Item05,
PhotoList = photos.ToList(),
CommonItems = commonItems.ToList(),
SubItems = subItems.ToList(),
RecommonItems = recommonItems.ToList(),
PDF_file = BindPDF(entity.Introduction),
};
}
GetProductPrice(model);
BindInformation(model);
BindRecommend(model);
BindDefalultPic(model);
ViewBag.ProductDetailModel = model;
var barChart = new BarChart();
if (CurrentUser != null)
{
Chart("Your most recently purchased quantities", model.ProductNo, barChart);
}
ViewBag.Chart = barChart;
return(View());
}
public OperationResult Insert(PROD_MASTERModel model)
{
var entity = new PROD_MASTER
{
ID = model.ID,
ProductNo = model.ProductNo,
ProductName = model.ProductName,
Description = model.Description,
ProductType = model.ProductType,
StndCost = model.StndCost,
CurrCost = model.CurrCost,
ListPrice = model.ListPrice,
SpecialPrice = model.SpecialPrice,
ClearPrice = model.ClearPrice,
ProdCategoryID = model.ProdCategoryID,
CategoryCode = model.CategoryCode,
SchdlUOM = model.SchdlUOM,
PriceShed = model.PriceShed,
BaseUOFM = model.BaseUOFM,
AvailableQTY = model.AvailableQTY,
ProdGroupID = model.ProdGroupID,
ProdSubclassID = model.ProdSubclassID,
LeadTime = model.LeadTime,
QtySales = model.QtySales,
QtyMin = model.QtyMin,
QtyMax = model.QtyMax,
CustomerID = model.CustomerID,
StockType = model.StockType,
SalesRepID = model.SalesRepID,
PriceBookItem = model.PriceBookItem,
PriceLevel = model.PriceLevel,
BarCode = model.BarCode,
Ranking = model.Ranking,
Notes = model.Notes,
Substitute1 = model.Substitute1,
Substitute2 = model.Substitute2,
Qty1 = model.Qty1,
Qty3 = model.Qty3,
Qty6 = model.Qty6,
Qty12 = model.Qty12,
Sales1 = model.Sales1,
Sales3 = model.Sales3,
Sales6 = model.Sales6,
Sales12 = model.Sales12,
GPD1 = model.GPD1,
GPD3 = model.GPD3,
GPD6 = model.GPD6,
GPD12 = model.GPD12,
LastDate = model.LastDate,
CreateDate = model.CreateDate,
Creator = model.Creator,
Modifier = model.Modifier,
ModiDate = model.ModiDate,
Status = model.Status,
P01 = model.P01,
P02 = model.P02,
P03 = model.P03,
P04 = model.P04,
P05 = model.P05,
P06 = model.P06,
P07 = model.P07,
P08 = model.P08,
P09 = model.P09,
P10 = model.P10,
IsCommend = model.IsCommend,
IsHot = model.IsHot,
ExteriorPart = model.ExteriorPart,
ExteriorPartPrice = model.ExteriorPartPrice,
ViewTimes = model.ViewTimes,
SmallPic = model.SmallPic,
BigPic = model.BigPic,
LocationStocks1 = model.LocationStocks1,
LocationStocks2 = model.LocationStocks2,
LocationStocks3 = model.LocationStocks3,
LocationStocks4 = model.LocationStocks4,
LocationStocks5 = model.LocationStocks5,
LocationStocks6 = model.LocationStocks6,
LocationStocks7 = model.LocationStocks7,
LocationStocks8 = model.LocationStocks8,
LocationStocks9 = model.LocationStocks9,
LocationStocks10 = model.LocationStocks10,
LocationStocks11 = model.LocationStocks11,
LocationStocks12 = model.LocationStocks12,
LocationStocks13 = model.LocationStocks13,
LocationStocks14 = model.LocationStocks14,
LocationStocks15 = model.LocationStocks15,
LocationAllocate1 = model.LocationAllocate1,
LocationAllocate2 = model.LocationAllocate2,
LocationAllocate3 = model.LocationAllocate3,
LocationAllocate4 = model.LocationAllocate4,
LocationAllocate5 = model.LocationAllocate5,
LocationAllocate6 = model.LocationAllocate6,
LocationAllocate7 = model.LocationAllocate7,
LocationAllocate8 = model.LocationAllocate8,
LocationAllocate9 = model.LocationAllocate9,
LocationAllocate10 = model.LocationAllocate10,
LocationAllocate11 = model.LocationAllocate11,
LocationAllocate12 = model.LocationAllocate12,
LocationAllocate13 = model.LocationAllocate13,
LocationAllocate14 = model.LocationAllocate14,
LocationAllocate15 = model.LocationAllocate15,
Introduction = model.Introduction,
Brand = model.Brand,
Item01 = model.Item01,
Item02 = model.Item02,
Item03 = model.Item03,
Item04 = model.Item04,
Item05 = model.Item05,
};
PROD_MASTERRepository.Insert(entity);
return(new OperationResult(OperationResultType.Success, "Added successfully"));
}
