public ActionResult ProUpdateClass(FormCollection formCollection) { // 1. 取得formCollection資訊 System.Diagnostics.Debug.WriteLine(" >>>> ProUpdateClass -------------------------->>>> "); System.Diagnostics.Debug.WriteLine(" >>>> ProUpdateClass app_ser: " + formCollection["app_ser"]); System.Diagnostics.Debug.WriteLine(" >>>> ProUpdateClass clasee_No: " + formCollection["pro_class_no"]); System.Diagnostics.Debug.WriteLine(" >>>> ProUpdateClass clasee_Name: " + formCollection["pro_class_name"]); System.Diagnostics.Debug.WriteLine(" >>>> ProUpdateClass clasee_desc: " + formCollection["pro_class_desc"]); System.Diagnostics.Debug.WriteLine(" >>>> ProUpdateClass class_active: " + formCollection["class_active"]); Models.ShopCarDatasetTableAdapters.Product_ClassTableAdapter classadp = new Models.ShopCarDatasetTableAdapters.Product_ClassTableAdapter(); // 2. 將欄位存到資料庫 classadp.UpdateClassData(formCollection["pro_class_no"], formCollection["pro_class_name"], formCollection["pro_class_desc"], formCollection["class_active"], Convert.ToInt32(formCollection["app_ser"])); // 3. Redirect ProClass return RedirectToAction("ProClass"); }
public ActionResult ProCreateClass(FormCollection formCollection) { // 1. 取得formCollection資訊 // 1. 取得前端 form 的欄位資料 System.Diagnostics.Debug.WriteLine(" >>>> ProCreateClass -------------------------->>>> "); System.Diagnostics.Debug.WriteLine(" >>>> ProCreateClass clasee_No: " + formCollection["pro_class_no"]); System.Diagnostics.Debug.WriteLine(" >>>> ProCreateClass clasee_Name: " + formCollection["pro_class_name"]); System.Diagnostics.Debug.WriteLine(" >>>> ProCreateClass clasee_desc: " + formCollection["pro_class_desc"]); // 因為是新增calss, 故將class_active預設為on Models.ShopCarDatasetTableAdapters.Product_ClassTableAdapter classadp = new Models.ShopCarDatasetTableAdapters.Product_ClassTableAdapter(); // 2. 將欄位存到資料庫 classadp.InsertProClass(formCollection["pro_class_no"], formCollection["pro_class_name"], formCollection["pro_class_desc"], "on"); // 3. Redirect ProClass return RedirectToAction("ProClass"); }
// 產品分類資料 public ActionResult GetProClassList() { // 1. 取得所有分類 //-----> Models.ShopCarDatasetTableAdapters.Product_ClassTableAdapter classadp = new Models.ShopCarDatasetTableAdapters.Product_ClassTableAdapter(); DataTable dt = classadp.GetData(); // 2. 將資料塞到 arraylist ArrayList list = new ArrayList(); foreach (DataRow drow in dt.Rows) { var prodClass = new { app_ser = wf.tos(drow["app_ser"]), pro_class_no = wf.tos(drow["pro_class_no"]), pro_class_name = wf.tos(drow["pro_class_name"]), pro_class_desc = wf.tos(drow["pro_class_desc"]), class_active = wf.tos(drow["class_active"]) }; list.Add(prodClass); } // 3. 將 arraylist 放到Hashtable Hashtable myHT = new Hashtable(); myHT.Add("classList", list); // 3. 回傳json return Json(myHT, JsonRequestBehavior.AllowGet); }
public ActionResult ProClasDelete(FormCollection formCollection) { System.Diagnostics.Debug.WriteLine(" >>>> ProClasDelete -------------------------->>>> "); System.Diagnostics.Debug.WriteLine(" >>>> ProClasDelete app_ser: " + formCollection["app_ser"]); Int32 appser = Convert.ToInt32(formCollection["app_ser"]); // 1. 刪除該appser產品 //----> 程式碼 Models.ShopCarDatasetTableAdapters.Product_ClassTableAdapter classadp = new Models.ShopCarDatasetTableAdapters.Product_ClassTableAdapter(); classadp.DeleteClassData(appser); // 2. Return pro_list return RedirectToAction("ProClass"); }
// 取得單一產品分類資料 public ActionResult GetProClassItem(string app_ser) { System.Diagnostics.Debug.WriteLine(" >>>> GetProClassItem -------------------------->>>> "); System.Diagnostics.Debug.WriteLine(" >>>> app_serxxx : " + app_ser); Models.ShopCarDatasetTableAdapters.Product_ClassTableAdapter classadp = new Models.ShopCarDatasetTableAdapters.Product_ClassTableAdapter(); DataTable dt = classadp.GetOneClassData(Convert.ToInt32(app_ser)); ArrayList list = new ArrayList(); foreach (DataRow drow in dt.Rows) { var prodClass = new { app_ser = wf.tos(drow["app_ser"]), pro_class_no = wf.tos(drow["pro_class_no"]), pro_class_name = wf.tos(drow["pro_class_name"]), pro_class_desc = wf.tos(drow["pro_class_desc"]), class_active = wf.tos(drow["class_active"]) }; System.Diagnostics.Debug.WriteLine(" >>>> class name: : " + prodClass.pro_class_name); list.Add(prodClass); } Hashtable myHT = new Hashtable(); myHT.Add("classItem", list); //return Json(myHT); return Json(myHT, JsonRequestBehavior.AllowGet); }