private void FormProduct_Load(object sender, EventArgs e)
{
if (id.HasValue)
{
try
{
CommodityViewModel view = service.GetElement(id.Value);
if (view != null)
{
textBoxName.Text = view.CommodityName;
textBoxPrice.Text = view.Price.ToString();
productComponents = view.CommodityIngridients;
LoadData();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
productComponents = new List <ProductComponentView>();
}
}
public ActionResult Edit(int id, Commodity commodity)
{
var commodityToEdit = _commodityRepository.GetNullableById(id);
if (commodityToEdit == null)
{
return(RedirectToAction("Index"));
}
TransferValues(commodity, commodityToEdit);
if (ModelState.IsValid)
{
_commodityRepository.EnsurePersistent(commodityToEdit);
Message = "Commodity Edited Successfully";
return(RedirectToAction("Index"));
}
else
{
var viewModel = CommodityViewModel.Create(Repository);
viewModel.Commodity = commodity;
return(View(viewModel));
}
}
public ActionResult Template(Guid?id)
{
var model = new CommodityViewModel();
if (id != null)
{
model.Commodity = Ioc.Get <ICommodityService>().Get(id.Value);
}
model.CategoryList = Ioc.Get <ICategoryService>().GetList();
return(View(model));
}
public static Commodity BindCommodity(CommodityViewModel commodityViewModel, Commodity commodity = null)
{
return(commodity ?? new Commodity()
{
CommodityID = commodityViewModel.CommodityID,
Name = commodityViewModel.Name,
CommodityCode = commodityViewModel.CommodityCode,
NameAM = commodityViewModel.NameAM,
LongName = commodityViewModel.LongName,
CommodityTypeID = commodityViewModel.CommodityTypeID,
ParentID = commodityViewModel.CommodityTypeID
});
}
public Commodities()
: base()
{
InitializeComponent();
this.toolstripChild = this.toolStripChildForm;
this.fastListIndex = this.fastCommodityIndex;
this.commodityAPIs = new CommodityAPIs(CommonNinject.Kernel.Get <ICommodityAPIRepository>());
this.commodityViewModel = CommonNinject.Kernel.Get <CommodityViewModel>();
this.commodityViewModel.PropertyChanged += new PropertyChangedEventHandler(ModelDTO_PropertyChanged);
this.baseDTO = this.commodityViewModel;
}
//
// GET: /Commodity/Edit/5
public ActionResult Edit(int id)
{
var commodity = _commodityRepository.GetNullableById(id);
if (commodity == null)
{
return(RedirectToAction("Index"));
}
var viewModel = CommodityViewModel.Create(Repository);
viewModel.Commodity = commodity;
return(View(viewModel));
}
public IActionResult Index()
{
var commodities = _commodityService.GetAllCommodities();
var viewModel = new CommodityViewModel
{
Rows = commodities.Select(commodity => new CommodityRow
{
Id = commodity.Id,
Title = commodity.Title,
Price = commodity.Price
}).OrderBy(commodity => commodity.Id).ToList()
};
return(View("Index", viewModel));
}
private void CalcSum()
{
if (comboBoxCommodity.SelectedValue != null && !string.IsNullOrEmpty(textBoxCount.Text))
{
try
{
int id = Convert.ToInt32(comboBoxCommodity.SelectedValue);
CommodityViewModel commodity = serviceP.GetElement(id);
int count = Convert.ToInt32(textBoxCount.Text);
textBoxSum.Text = (count * commodity.Price).ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
//倉儲
public ActionResult 儲查詢()
{
if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] == null)
{
return(RedirectToAction("員工登入", "Employee"));
}
else
{
MotaiDataEntities dbContext = new MotaiDataEntities();
CommodityViewModel model = new CommodityViewModel();
List <tWarehouse> Warehouses = dbContext.tWarehouses.OrderBy(w => w.WarehouseNameId).ToList();
List <WareInventorySelectViewModel> InventoryList = new List <WareInventorySelectViewModel>();
List <WarningQuantityViewModel> WarningList = new List <WarningQuantityViewModel>();
foreach (var item in Warehouses)
{
WareInventorySelectViewModel wareInventory = new WareInventorySelectViewModel();
wareInventory.WarehouseName = dbContext.tWarehouseNames.Where(wn => wn.WarehouseNameId.Equals(item.WarehouseNameId)).FirstOrDefault().WarehouseName;
wareInventory.ProductName = dbContext.tProducts.Where(pn => pn.ProductId.Equals(item.wProductId)).FirstOrDefault().pName;
wareInventory.ProductQty = item.wPQty;
InventoryList.Add(wareInventory);
}
var productInventories = dbContext.tWarehouses.GroupBy(p => p.wProductId, p => p.wPQty);
foreach (var warnitem in productInventories)
{
WarningQuantityViewModel warningQuantity = new WarningQuantityViewModel();
tProduct product = dbContext.tProducts.Where(p => p.ProductId == warnitem.Key).FirstOrDefault();
int ProductQty = 0;
foreach (var qty in warnitem)
{
ProductQty += qty;
}
if (ProductQty < 3)
{
warningQuantity.ProductName = product.pName;
warningQuantity.underStock = ProductQty;
WarningList.Add(warningQuantity);
}
}
model.InventorySelect = InventoryList;
model.InventoryWaring = WarningList;
return(View(model));
}
}
public async Task <IActionResult> DeleteFarmerCommodity([FromBody] CommodityViewModel commodityViewModel)
{
try
{
var _serviceEndPoint = new ServicesEndPoint(_unitOfWork, _emailService);
var commodity = _Mapper.Map <Commodity>(commodityViewModel);
var result = await _serviceEndPoint.DeleteFarmerCommodity(commodity);
if (!result)
{
return(NotFound(commodity));
}
return(Ok(new { message = "Succesfully Deleted!", result = result }));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
//Commodities
public async Task <IActionResult> GetFarmerCommodityById(int commodityId)
{
try
{
var _serviceEndPoint = new ServicesEndPoint(_unitOfWork, _emailService);
Commodity res = await _serviceEndPoint.GetCommodityById(commodityId);
CommodityViewModel results = _Mapper.Map <CommodityViewModel>(res);
if (results == null)
{
return(NotFound(results));
}
return(Ok(results));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public ActionResult Create(Commodity commodity)
{
var commodityToCreate = new Commodity();
TransferValues(commodity, commodityToCreate);
if (ModelState.IsValid)
{
_commodityRepository.EnsurePersistent(commodityToCreate);
Message = "Commodity Created Successfully";
return(RedirectToAction("Index"));
}
else
{
var viewModel = CommodityViewModel.Create(Repository);
viewModel.Commodity = commodity;
return(View(viewModel));
}
}
/// <summary>
/// 获取所有商品
/// </summary>
/// <param name="name">商品名称</param>
/// <param name="total">总数</param>
/// <param name="page">第几页</param>
/// <param name="rows">一页多少行</param>
/// <returns></returns>
public List <CommodityViewModel> GetAllCommodity(string name, out int total, int page, int rows)
{
if (page.Equals(0))
{
total = 0;
return(null);
}
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
var data = from c in db.Commodity
select new
{
c.Id,
c.Name,
c.UnitPrice,
c.Stock,
c.SeparableNum
};
if (!string.IsNullOrWhiteSpace(name))
{
data = data.Where(s => s.Name.Contains(name));
}
total = data.Count();
data = data.OrderBy(s => s.Id).Skip((page - 1) * rows).Take(rows);
List <CommodityViewModel> listV = new List <CommodityViewModel>();
foreach (var item in data)
{
CommodityViewModel commodityViewModel = new CommodityViewModel();
commodityViewModel.Id = item.Id;
commodityViewModel.Name = item.Name;
commodityViewModel.UnitPrice = item.UnitPrice ?? 0;
commodityViewModel.CommodityNum = item.Stock ?? 0;
commodityViewModel.SeparableNum = item.SeparableNum.ToString();
listV.Add(commodityViewModel);
}
return(listV);
}
}
/// <summary>
/// 获取所有进货记录
/// </summary>
/// <param name="name">商品名称</param>
/// <param name="total">总数</param>
/// <param name="page">第几页</param>
/// <param name="rows">一页多少行</param>
/// <returns></returns>
public List <CommodityViewModel> GetAllPurchase(string name, out int total, int page, int rows)
{
if (page.Equals(0))
{
total = 0;
return(null);
}
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
var data = from cp in db.Commodity_Purchase
join c in db.Commodity on cp.CommodityId equals c.Id
select new
{
cp.Id,
c.Name,
cp.CommodityNum,
cp.EstablishDate
};
if (!string.IsNullOrWhiteSpace(name))
{
data = data.Where(s => s.Name.Contains(name));
}
total = data.Count();
data = data.OrderBy(s => s.Id).Skip((page - 1) * rows).Take(rows);
List <CommodityViewModel> listV = new List <CommodityViewModel>();
foreach (var item in data)
{
CommodityViewModel commodityViewModel = new CommodityViewModel();
commodityViewModel.Id = item.Id;
commodityViewModel.Name = item.Name;
commodityViewModel.CommodityNum = item.CommodityNum ?? 0;
commodityViewModel.EstablishDate = item.EstablishDate.ToString("F");
listV.Add(commodityViewModel);
}
return(listV);
}
}
public static CommodityViewModel ReadArchiveCommodity()
{
var imported = Db.Trackings.Where(a => a.Name == _archiveCommodityTable).Any();
var commodities = new List <CommodityLink>();
var errors = new List <KeyValuePair <string, string> >();
ReadData("~/Assets/archived_Commodity.xls", imported, commodities, errors);
if (!imported)
{
var tracking = new Tracking()
{
Name = _archiveCommodityTable
};
Db.Trackings.Add(tracking);
Db.SaveChanges();
}
var viewModel = CommodityViewModel.Create(commodities, errors, imported);
return(viewModel);
}
public ActionResult Commodity_Update([DataSourceRequest] DataSourceRequest request, CommodityViewModel commodityViewModel)
{
if (commodityViewModel != null && ModelState.IsValid)
{
var target = _commodityService.FindById(commodityViewModel.CommodityID);
var commodity = CommodityViewModelBinder.BindCommodity(commodityViewModel, target);
_commodityService.EditCommodity(commodity);
}
return(Json(new[] { commodityViewModel }.ToDataSourceResult(request, ModelState)));
}
//
// GET: /Commodity/Create
public ActionResult Create()
{
var viewModel = CommodityViewModel.Create(Repository);
return(View(viewModel));
}
public bool ImportExcel(string fileName, string sheetName)
{
try
{
OleDbAPIs oleDbAPIs = new OleDbAPIs(CommonNinject.Kernel.Get <IOleDbAPIRepository>(), GlobalEnums.MappingTaskID.BatchMaster);
CommodityViewModel commodityViewModel = CommonNinject.Kernel.Get <CommodityViewModel>();
CommodityController commodityController = new CommodityController(CommonNinject.Kernel.Get <ICommodityService>(), commodityViewModel);
int intValue; decimal decimalValue; DateTime dateTimeValue;
ExceptionTable exceptionTable = new ExceptionTable(new string[2, 2] {
{ "ExceptionCategory", "System.String" }, { "Description", "System.String" }
});
//////////TimeSpan timeout = TimeSpan.FromMinutes(90);
//////////using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Required, timeout))
//////////{
//////////if (!this.Editable(this.)) throw new System.ArgumentException("Import", "Permission conflict");
DataTable excelDataTable = oleDbAPIs.OpenExcelSheet(fileName, sheetName);
if (excelDataTable != null && excelDataTable.Rows.Count > 0)
{
foreach (DataRow excelDataRow in excelDataTable.Rows)
{
exceptionTable.ClearDirty();
string code = excelDataRow["Code"].ToString().Trim();
if (code.Length < 5)
{
code = new String('0', 5 - code.Length) + code;
}
BatchMasterBase batchMasterBase = this.batchMasterAPIs.GetBatchMasterBase(code);
if (batchMasterBase == null)
{
this.batchMasterController.Create();
this.batchMasterViewModel.EntryDate = new DateTime(2000, 1, 1);
this.batchMasterViewModel.Code = code;
if (DateTime.TryParse(excelDataRow["PlannedDate"].ToString(), out dateTimeValue))
{
this.batchMasterViewModel.PlannedDate = dateTimeValue;
}
else
{
exceptionTable.AddException(new string[] { "Lỗi cột dữ liệu Plan start date", "Batch: " + code + ": " + excelDataRow["PlannedDate"].ToString() });
}
if (decimal.TryParse(excelDataRow["PlannedQuantity"].ToString(), out decimalValue))
{
this.batchMasterViewModel.PlannedQuantity = decimalValue;
}
else
{
exceptionTable.AddException(new string[] { "Lỗi cột dữ liệu SL Kế hoạch", "Batch: " + code + ": " + excelDataRow["PlannedQuantity"].ToString() });
}
CommodityBase commodityBase = this.commodityAPIs.GetCommodityBase(excelDataRow["CommodityCode"].ToString());
if (commodityBase != null)
{
this.batchMasterViewModel.CommodityID = commodityBase.CommodityID;
}
else
{
commodityController.Create();
commodityViewModel.Code = excelDataRow["CommodityCode"].ToString();
commodityViewModel.APICode = excelDataRow["CommodityAPICode"].ToString().Replace("'", "");
commodityViewModel.CartonCode = excelDataRow["CommodityCartonCode"].ToString().Replace("'", "");
commodityViewModel.Name = excelDataRow["CommodityName"].ToString();
commodityViewModel.OfficialName = excelDataRow["CommodityName"].ToString();
commodityViewModel.CommodityCategoryID = 2;
commodityViewModel.FillingLineIDs = "1,2";
if (decimal.TryParse(excelDataRow["Volume"].ToString(), out decimalValue))
{
commodityViewModel.Volume = decimalValue / 1000;
}
else
{
exceptionTable.AddException(new string[] { "Lỗi cột dữ liệu Trọng lượng", "Batch: " + code + ": " + excelDataRow["Volume"].ToString() });
}
if (int.TryParse(excelDataRow["PackPerCarton"].ToString(), out intValue))
{
commodityViewModel.PackPerCarton = intValue;
}
else
{
exceptionTable.AddException(new string[] { "Lỗi cột dữ liệu QC thùng", "Batch: " + code + ": " + excelDataRow["PackPerCarton"].ToString() });
}
if (int.TryParse(excelDataRow["CartonPerPallet"].ToString(), out intValue))
{
commodityViewModel.CartonPerPallet = intValue / commodityViewModel.PackPerCarton;
}
else
{
exceptionTable.AddException(new string[] { "Lỗi cột dữ liệu QC pallet", "Batch: " + code + ": " + excelDataRow["CartonPerPallet"].ToString() });
}
commodityViewModel.PackageSize = commodityViewModel.PackPerCarton.ToString("N0") + "x" + commodityViewModel.Volume.ToString("N2") + "kg";
if (int.TryParse(excelDataRow["Shelflife"].ToString(), out intValue))
{
commodityViewModel.Shelflife = intValue;
}
else
{
exceptionTable.AddException(new string[] { "Lỗi cột dữ liệu Expiration months", "Batch: " + code + ": " + excelDataRow["Shelflife"].ToString() });
}
if (!commodityViewModel.IsValid)
{
exceptionTable.AddException(new string[] { "Lỗi dữ liệu sản phẩm không hợp lệ", excelDataRow["CommodityCode"].ToString() + ": " + commodityViewModel.Error });
}
else
if (commodityViewModel.IsDirty)
{
if (commodityController.Save())
{
this.batchMasterViewModel.CommodityID = commodityViewModel.CommodityID;
}
else
{
exceptionTable.AddException(new string[] { "Lỗi lưu dữ liệu [thêm sản phẩm mới]", excelDataRow["CommodityCode"].ToString() + commodityController.BaseService.ServiceTag });
}
}
}
BatchStatusBase batchStatusBase = this.batchStatusAPIs.GetBatchStatusBase(excelDataRow["BatchStatusCode"].ToString());
if (batchStatusBase != null)
{
this.batchMasterViewModel.BatchStatusID = batchStatusBase.BatchStatusID;
}
else
{
exceptionTable.AddException(new string[] { "Lỗi cột dữ liệu Trạng thái", "Batch: " + code + ": " + excelDataRow["BatchStatusCode"].ToString() });
}
if (!this.batchMasterViewModel.IsValid)
{
exceptionTable.AddException(new string[] { "Lỗi dữ liệu Batch không hợp lệ", "Batch: " + code + ": " + this.batchMasterViewModel.Error });
}
;
if (!exceptionTable.IsDirty)
{
if (this.batchMasterViewModel.IsDirty && !this.batchMasterController.Save())
{
exceptionTable.AddException(new string[] { "Lỗi lưu dữ liệu [thêm batch mới]", code + this.batchMasterController.BaseService.ServiceTag });
}
}
}
else
{
exceptionTable.AddException(new string[] { "Batch không được import, do đã tồn tại trên hệ thống", "Batch: " + code });
}
}
}
if (exceptionTable.Table.Rows.Count <= 0)
{
return(true);
}
else
{
throw new CustomException("Lỗi import file excel. Vui lòng xem danh sách đính kèm. Click vào từng nội dung để xem chi tiết.", exceptionTable.Table);
}
}
catch (System.Exception exception)
{
throw exception;
}
}
public void Post(CommodityViewModel commodity)
{
_commodityService.CreateCommodity(commodity);
}
public ActionResult Commodity_Create([DataSourceRequest] DataSourceRequest request, CommodityViewModel commodityViewModel)
{
if (commodityViewModel != null && ModelState.IsValid)
{
var commodity = CommodityViewModelBinder.BindCommodity(commodityViewModel);
_commodityService.AddCommodity(commodity);
}
return(Json(new[] { commodityViewModel }.ToDataSourceResult(request, ModelState)));
}
public bool ImportExcel(string fileName, string sheetName)
{
try
{
Cursor.Current = Cursors.WaitCursor;
OleDbAPIs oleDbAPIs = new OleDbAPIs(CommonNinject.Kernel.Get <IOleDbAPIRepository>(), GlobalEnums.MappingTaskID.Lavie);
CommodityViewModel commodityViewModel = CommonNinject.Kernel.Get <CommodityViewModel>();
CommodityController commodityController = new CommodityController(CommonNinject.Kernel.Get <ICommodityService>(), commodityViewModel);
int intValue; decimal decimalValue; DateTime dateTimeValue;
ExceptionTable exceptionTable = new ExceptionTable(new string[2, 2] {
{ "ExceptionCategory", "System.String" }, { "Description", "System.String" }
});
//////////TimeSpan timeout = TimeSpan.FromMinutes(90);
//////////using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Required, timeout))
//////////{
//////////if (!this.Editable(this.)) throw new System.ArgumentException("Import", "Permission conflict");
DataTable excelDataTable = oleDbAPIs.OpenExcelSheet(fileName, sheetName);
if (excelDataTable != null && excelDataTable.Rows.Count > 0)
{
foreach (DataRow excelDataRow in excelDataTable.Rows)
{
exceptionTable.ClearDirty();
this.lavieController.Create();
this.lavieViewModel.EntryDate = new DateTime(2000, 1, 1);
this.lavieViewModel.PrintedTimes = 0;
if (int.TryParse(excelDataRow["SerialID"].ToString(), out intValue))
{
this.lavieViewModel.SerialID = intValue;
}
else
{
exceptionTable.AddException(new string[] { "Lỗi cột dữ liệu No", "No: " + excelDataRow["SerialID"].ToString() });
}
if (DateTime.TryParse(excelDataRow["ExpirationDate"].ToString(), out dateTimeValue))
{
this.lavieViewModel.ExpirationDate = dateTimeValue;
}
else
{
exceptionTable.AddException(new string[] { "Lỗi cột dữ liệu ExpirationDate", "No: " + this.lavieViewModel.SerialID + ": " + excelDataRow["ExpirationDate"].ToString() });
}
if (decimal.TryParse(excelDataRow["Qty"].ToString(), out decimalValue))
{
this.lavieViewModel.Qty = decimalValue;
}
else
{
exceptionTable.AddException(new string[] { "Lỗi cột dữ liệu Qty", "No: " + this.lavieViewModel.SerialID + ": " + excelDataRow["Qty"].ToString() });
}
if (decimal.TryParse(excelDataRow["Layers"].ToString(), out decimalValue))
{
this.lavieViewModel.Layers = decimalValue;
}
else
{
exceptionTable.AddException(new string[] { "Lỗi cột dữ liệu Layers", "No: " + this.lavieViewModel.SerialID + ": " + excelDataRow["Layers"].ToString() });
}
this.lavieViewModel.ItemNumber = excelDataRow["ItemNumber"].ToString();
this.lavieViewModel.ProductName = excelDataRow["ProductName"].ToString();
this.lavieViewModel.GTIN = excelDataRow["GTIN"].ToString();
this.lavieViewModel.PalletID = excelDataRow["PalletID"].ToString();
this.lavieViewModel.BatchNumber = excelDataRow["BatchNumber"].ToString();
this.lavieViewModel.GTINBarcode = excelDataRow["GTINBarcode"].ToString();
this.lavieViewModel.Barcode = excelDataRow["Barcode"].ToString();
if (!this.lavieViewModel.IsValid)
{
exceptionTable.AddException(new string[] { "Lỗi dữ liệu không hợp lệ, dòng No: ", this.lavieViewModel.SerialID + ": " + this.lavieViewModel.Error });
}
;
if (!exceptionTable.IsDirty)
{
if (this.lavieViewModel.IsDirty && !this.lavieController.Save())
{
exceptionTable.AddException(new string[] { "Lỗi lưu dữ liệu, dòng No: ", this.lavieViewModel.SerialID + this.lavieController.BaseService.ServiceTag });
}
}
}
}
Cursor.Current = Cursors.WaitCursor;
if (exceptionTable.Table.Rows.Count <= 0)
{
return(true);
}
else
{
throw new CustomException("Lỗi import file excel. Vui lòng xem danh sách đính kèm. Click vào từng nội dung để xem chi tiết.", exceptionTable.Table);
}
}
catch (System.Exception exception)
{
Cursor.Current = Cursors.WaitCursor;
throw exception;
}
}
public void Put(CommodityViewModel commodity)
{
_commodityService.UpdateCommodity(commodity);
}
public void BuildSelectLists(CommodityViewModel commodityViewModel)
{
commodityViewModel.CommodityCategoryDropDown = commodityCategorySelectListBuilder.BuildSelectListItemsForCommodityCategories(commodityCategoryRepository.GetAllCommodityCategories());
commodityViewModel.CommodityTypeDropDown = commodityTypeSelectListBuilder.BuildSelectListItemsForCommodityCategories(commodityTypeRepository.GetAllCommodityTypes());
commodityViewModel.SupplierDropDown = customerViewModelSelectListBuilder.BuildSelectListItemsSuppliers(customerRepository.GetAllSuppliers());
}
