// GET: ST_Material/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ST_Material data = mST_MaterialDAO.FetchBySerno(id); data.item_name = data.item_name.Trim(); data.item_species = data.item_species.Trim(); data.item_unit = data.item_unit.Trim(); data.vendor_name = mST_VendorDAO.FetchByGuid(data.vendor_guid).vendor_name; ViewData["unit_Items"] = GetUnitItem(); ViewData["vendor_Items"] = GetVendorItems(); ViewData["user"] = Session["user"]; if (data == null) { return(HttpNotFound()); } return(View(data)); }
public int GetPurchase_Month(DateTime firstDay, DateTime lastDay, string itemType) { List <ST_Purchase> purchaseList = mST_PurcahseDAO.GetDataByDateRange(firstDay, lastDay); #region 移除非指定類別的資料 for (int i = 0; i < purchaseList.Count; i++) { ST_Material currMaterial = mST_MaterialDAO.FetchByGuid(purchaseList[i].material_guid); if (!currMaterial.item_species.Trim().Equals(itemType)) { purchaseList.RemoveAt(i); i--; } } #endregion #region 計算加總值 int total_Fee = 0; foreach (ST_Purchase data in purchaseList) { total_Fee += data.purchase_price; } #endregion return(total_Fee); }
public ActionResult DeleteConfirmed(int id) { ST_Material data = mST_MaterialDAO.FetchBySerno(id); mST_MaterialDAO.Soft_Delete(data); return(RedirectToAction("Index")); }
public ActionResult Edit(ST_Material data) { if (ModelState.IsValid) { data.vendor_guid = mST_VendorDAO.FetchByName(data.vendor_name).guid; mST_MaterialDAO.Update(data); return(RedirectToAction("Index")); } return(View(data)); }
public ActionResult Index() { List <ST_Collar> dataList = mST_CollarDAO.GetDataList_NotDel(); foreach (ST_Collar currCollar in dataList) { ST_Material currMaterial = mST_MaterialDAO.FetchByGuid(currCollar.material_guid); currCollar.material_name = currMaterial.item_name; ST_Emp currEmp = mST_EmpDAO.FetchByGuid(currCollar.emp_guid); currCollar.emp_name = currEmp.emp_name; } return(View(dataList)); }
public ActionResult Create(Purchase_DayAll data) { if (ModelState.IsValid && data.purchase_List != null) { List <ST_Purchase> prucahse_List = data.purchase_List.Cast <ST_Purchase>().ToList(); foreach (ST_Purchase currPurchase in prucahse_List) { currPurchase.guid = Guid.NewGuid(); currPurchase.purchase_date = data.rec_date; ST_Material currMaterial = mST_MaterialDAO.FetchByItemName(currPurchase.item_name); if (currMaterial != null) { currPurchase.material_guid = currMaterial.guid; } else { /*Material表非固定品項的Guid*/ currPurchase.material_guid = Guid.Parse("DF7E2E4F-F2F0-4232-8E10-665FA99048B1"); currPurchase.special_item = currPurchase.item_name; } currPurchase.emp_guid = mST_EmpDAO.FetchByAccount(User.Identity.Name).guid; mST_PurcahseDAO.Insert(currPurchase); } return(RedirectToAction("Index")); } ModelState.AddModelError("", "至少新增一筆採購項目"); ViewData["food_Items"] = GetMaterialItems("食材"); ViewData["supplies_Items"] = GetMaterialItems("耗材"); ViewData["other_Items"] = GetMaterialItems("其他"); ViewData["user"] = Session["user"]; return(View(data)); }
public ActionResult CheckUniItem(ST_Material data) { if (data.item_name != null) { if (mST_MaterialDAO.IsUniItem(data) == true) { return(Json(true, JsonRequestBehavior.AllowGet)); } else { return(Json(false, JsonRequestBehavior.AllowGet)); } } else { return(Json(false, JsonRequestBehavior.AllowGet)); } }
// GET: ST_Material/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ST_Material data = mST_MaterialDAO.FetchBySerno(id); if (data == null) { return(HttpNotFound()); } ViewData["user"] = Session["user"]; return(View(data)); }
public ActionResult Create(ST_Material data) { if (ModelState.IsValid) { data.guid = Guid.NewGuid(); ST_Vendor currVendor = mST_VendorDAO.FetchByName(data.vendor_name); data.vendor_guid = currVendor.guid; mST_MaterialDAO.Insert(data); /*不跟庫存連動*/ //ST_InStock new_Stock = new ST_InStock(data.guid); //mST_InStockDAO.Insert(new_Stock); return(RedirectToAction("Index")); } return(View(data)); }
public ActionResult Create(ST_Collar data) { if (ModelState.IsValid) { data.guid = Guid.NewGuid(); ST_Emp currUser = mST_EmpDAO.FetchByAccount(User.Identity.Name); ST_Material currMaterial = mST_MaterialDAO.FetchByItemName(data.material_name); data.emp_guid = currUser.guid; data.material_guid = currMaterial.guid; mST_CollarDAO.Insert(data); //mST_InStockDAO.DecreseStockCount(currMaterial.guid, data.collar_count); return(RedirectToAction("Index")); } return(View(data)); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ST_Collar data = mST_CollarDAO.FetchBySerno(id); ST_Material currMaterial = mST_MaterialDAO.FetchByGuid(data.material_guid); data.material_name = currMaterial.item_name; ST_Emp currEmp = mST_EmpDAO.FetchByGuid(data.emp_guid); data.emp_name = currEmp.emp_name; if (data == null) { return(HttpNotFound()); } return(View(data)); }
// GET: ST_Material/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ST_Material data = mST_MaterialDAO.FetchBySerno(id); if (data == null) { return(HttpNotFound()); } ST_Vendor currVendor = mST_VendorDAO.FetchByGuid(data.vendor_guid); data.vendor_name = currVendor.vendor_name; ViewData["user"] = Session["user"]; return(View(data)); }
private void SetOtherProperty(ref List <ST_Purchase> dataList) { foreach (ST_Purchase purchase in dataList) { #region 品項名稱 if (purchase.special_item != null) { purchase.item_name = purchase.special_item; } else { purchase.item_name = mST_MaterialDAO.FetchByGuid(purchase.material_guid).item_name; } #endregion #region 採購人員 purchase.emp_name = mST_EmpDAO.FetchByGuid(purchase.emp_guid).emp_name; #endregion #region 紅色文字標記 if (purchase.special_mark.Trim() == "是") { purchase.font_Color = "red"; } else { purchase.font_Color = "black"; } #endregion #region 供應商 ST_Material currMaterial = mST_MaterialDAO.FetchByGuid(purchase.material_guid); ST_Vendor currVendor = mST_VendorDAO.FetchByGuid(currMaterial.vendor_guid); purchase.vendor_name = currVendor.vendor_name; #endregion } }