private void CleanData(ref ST_Vendor data)
{
data.vendor_name = data.vendor_name.Trim();
if (data.contact_person != null)
{
data.contact_person = data.contact_person.Trim();
}
data.vendor_tel1 = data.vendor_tel1.Trim();
if (data.vendor_tel2 != null)
{
data.vendor_tel2 = data.vendor_tel2.Trim();
}
if (data.address != null)
{
data.address = data.address.Trim();
}
if (data.uniform_num != null)
{
data.uniform_num = data.uniform_num.Trim();
}
data.payment_mathod = data.payment_mathod.Trim();
if (data.remark != null)
{
data.remark = data.remark.Trim();
}
}
public ActionResult Index_Food()
{
string account = User.Identity.Name;
List <ST_Material> material_List = mST_MaterialDAO.GetDataListBySpecies("食材");
foreach (ST_Material material in material_List)
{
ST_Vendor currVendor = mST_VendorDAO.FetchByGuid(material.vendor_guid);
material.vendor_name = currVendor.vendor_name;
}
List <string> query_Method = new List <string>();
query_Method.Add("食材");
query_Method.Add("耗材");
query_Method.Add("其他");
query_Method.Add("全部");
ViewData["query_Item"] = query_Method;
ViewData["user"] = Session["user"];
return(View(material_List));
}
public ActionResult Edit(ST_Vendor data)
{
if (ModelState.IsValid)
{
mST_VendorDAO.Update(data);
return(RedirectToAction("Index"));
}
return(View(data));
}
public ActionResult DeleteConfirmed(int id)
{
ST_Vendor data = mST_VendorDAO.FetchBySerno(id);
CleanData(ref data);
mST_VendorDAO.Soft_Delete(data);
return(RedirectToAction("Index"));
}
public ActionResult Create(ST_Vendor data)
{
if (ModelState.IsValid)
{
data.guid = Guid.NewGuid();
mST_VendorDAO.Insert(data);
return(RedirectToAction("Index"));
}
return(View(data));
}
// GET: ST_Vendor/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ST_Vendor sT_Vendor = mST_VendorDAO.FetchBySerno(id);
if (sT_Vendor == null)
{
return(HttpNotFound());
}
ViewData["user"] = Session["user"];
return(View(sT_Vendor));
}
public JsonResult CheckUniFormNum(ST_Vendor data)
{
if (data.uniform_num != null)
{
if (mST_VendorDAO.IsUniform_Num(data) == true)
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
}
// GET: ST_Vendor/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ST_Vendor data = mST_VendorDAO.FetchBySerno(id);
CleanData(ref data);
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));
}
// 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
}
}
public ActionResult Index(string query)
{
string account = User.Identity.Name;
List <ST_Material> material_List = new List <ST_Material>();
if (query != "")
{
material_List = mST_MaterialDAO.GetDataListByKeyWord(query);
}
else
{
material_List = mST_MaterialDAO.GetDataList_NotDel();
}
foreach (ST_Material material in material_List)
{
ST_Vendor currVendor = mST_VendorDAO.FetchByGuid(material.vendor_guid);
material.vendor_name = currVendor.vendor_name;
}
List <string> query_Method = new List <string>();
query_Method.Add("食材");
query_Method.Add("耗材");
query_Method.Add("其他");
query_Method.Add("全部");
ViewData["query_Item"] = query_Method;
ViewData["user"] = Session["user"];
return(View(material_List));
}
