public ActionResult 工作日誌()
{
if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] != null)
{
MotaiDataEntities dbContext = new MotaiDataEntities();
tEmployee emp = Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] as tEmployee;
var dlist = dbContext.tDiaries.OrderBy(c => c.dEmployeeId).ToList();
List <DiaryViewModel> DSaw = new List <DiaryViewModel>();
foreach (var item in dlist)
{
tWarehouseName warename = dbContext.tWarehouseNames.Where(w => w.WarehouseNameId.Equals(item.dWarehouseNameId)).FirstOrDefault();
DiaryViewModel show = new DiaryViewModel();
show.eName = item.tEmployee.eName;
show.dDate = item.dDate;
show.dWeather = item.dWeather;
show.dDiaryNote = item.dDiaryNote;
show.dWarehouseNameId = item.dWarehouseNameId;
show.dWarehouseName = warename.WarehouseName;
DSaw.Add(show);
}
return(View(DSaw));
}
return(RedirectToAction("員工登入"));
}
public JsonResult WareOutSearch(int ProductId)
{
MotaiDataEntities dbContext = new MotaiDataEntities();
List <tWarehouse> warehouseOut = dbContext.tWarehouses.Where(w => w.wProductId == ProductId && w.wPQty != 0).ToList();
List <WarehouseOutList> outLists = new List <WarehouseOutList>();
foreach (var item in warehouseOut)
{
tWarehouseName name = dbContext.tWarehouseNames.Where(wn => wn.WarehouseNameId.Equals(item.WarehouseNameId)).FirstOrDefault();
WarehouseOutList outList = new WarehouseOutList();
outList.WarehouseIdOut = item.WarehouseNameId;
outList.WarehouseNameOut = name.WarehouseName;
outLists.Add(outList);
}
return(Json(outLists));
}
public ActionResult 進貨單查詢()
{
if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] == null)
{
return(RedirectToAction("員工登入", "Employee"));
}
MotaiDataEntities dbContext = new MotaiDataEntities();
List <tStockList> tStockLists = dbContext.tStockLists.OrderByDescending(s => s.sStockDate).ToList();
List <StockSelectViewModel> stockSelects = new List <StockSelectViewModel>();
foreach (var item in tStockLists)
{
List <tStockDetail> tStockDetails = dbContext.tStockDetails.Where(sd => sd.sStockId.Equals(item.StockId)).ToList();
StockSelectViewModel select = new StockSelectViewModel();
List <StockSelectDetailModel> details = new List <StockSelectDetailModel>();
int totalCost = 0;
foreach (var itemdetail in tStockDetails)
{
tProduct product = dbContext.tProducts.Where(p => p.ProductId.Equals(itemdetail.sProductId)).FirstOrDefault();
tWarehouseName warehouseName = dbContext.tWarehouseNames.Where(w => w.WarehouseNameId.Equals(itemdetail.sWarehouseNameId)).FirstOrDefault();
StockSelectDetailModel selectDetail = new StockSelectDetailModel();
selectDetail.ProductNum = product.pNumber;
selectDetail.ProductName = product.pName;
selectDetail.sCost = itemdetail.sCost;
selectDetail.sQuantity = itemdetail.sQuantity;
selectDetail.WareHouseName = warehouseName.WarehouseName;
selectDetail.sNote = itemdetail.sNote;
totalCost += (int)itemdetail.sCost * itemdetail.sQuantity;
details.Add(selectDetail);
}
tEmployee employee = dbContext.tEmployees.Where(e => e.EmployeeId.Equals(item.sEmployeeId)).FirstOrDefault();
select.EmployeeName = employee.eName;
select.sStockSerialValue = item.sStockSerialValue;
select.sVendor = item.sVendor;
select.sVendorTel = item.sVendorTel;
select.sStockDate = item.sStockDate;
select.sStockNote = item.sStockNote;
select.sTotalCost = totalCost;
select.StockDetails = details;
stockSelects.Add(select);
}
return(View(stockSelects));
}
public ActionResult 出貨單查詢()
{
if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] == null)
{
return(RedirectToAction("員工登入", "Employee"));
}
MotaiDataEntities dbContext = new MotaiDataEntities();
List <tShipList> tShipLists = dbContext.tShipLists.OrderByDescending(s => s.sShipDate).ToList();
List <ShipSelectViewModel> shipSelects = new List <ShipSelectViewModel>();
foreach (var item in tShipLists)
{
List <tShipDetail> tShipDetails = dbContext.tShipDetails.Where(sd => sd.ShipId.Equals(item.ShipId)).ToList();
ShipSelectViewModel select = new ShipSelectViewModel();
List <ShipSelectDetailModel> details = new List <ShipSelectDetailModel>();
foreach (var itemdetail in tShipDetails)
{
tProduct product = dbContext.tProducts.Where(p => p.ProductId.Equals(itemdetail.sProductId)).FirstOrDefault();
tWarehouseName warehouseName = dbContext.tWarehouseNames.Where(w => w.WarehouseNameId.Equals(itemdetail.sWarehouseNameId)).FirstOrDefault();
tOrderDetail orderd = dbContext.tOrderDetails.Where(o => o.oOrderDetailId.Equals(itemdetail.sOrderDetailId)).FirstOrDefault();
ShipSelectDetailModel selectDetail = new ShipSelectDetailModel();
selectDetail.ProductNum = product.pNumber;
selectDetail.ProductName = product.pName;
selectDetail.OrderId = orderd.oOrderId;
selectDetail.sQuantity = itemdetail.sQuantity;
selectDetail.WareHouseName = warehouseName.WarehouseName;
details.Add(selectDetail);
}
tEmployee employee = dbContext.tEmployees.Where(e => e.EmployeeId.Equals(item.sEmployeeId)).FirstOrDefault();
select.EmployeeName = employee.eName;
select.ShipSerialValue = item.sShipSerialValue;
select.ShipDate = item.sShipDate;
select.ShipNote = item.sShipNote;
select.ShipDetails = details;
shipSelects.Add(select);
}
return(View(shipSelects));
}
