// 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
}
}
