public ActionResult NewsDelete(FormCollection formCollection)
{
Int32 appser = Convert.ToInt32(formCollection["app_Ser"]);
// 2. 刪除該appser產品
//----> 程式碼
Models.ShopCarDatasetTableAdapters.NewsTableAdapter newsadp = new Models.ShopCarDatasetTableAdapters.NewsTableAdapter();
newsadp.DeleteNewsData(appser);
// 3. Return pro_list
return RedirectToAction("NewsList");
}
// 後台消息修改畫面
public ActionResult NewsEdit(string appSer)
{
// 1. 取得Get 參數, app_Ser
// 2. 於資料庫搜尋此筆資料
//----> 程式碼
Models.ShopCarDatasetTableAdapters.NewsTableAdapter newsadp = new Models.ShopCarDatasetTableAdapters.NewsTableAdapter();
DataTable dt;
dt = newsadp.GetOneNewsData(Convert.ToInt32(appSer));
DataRow drow = dt.Rows[0];
var NewsItem = new
{
appSer = wf.tos(drow["app_ser"]),
News_Title = wf.tos(drow["News_Title"]),
News_Content = wf.tos(drow["News_Content"]),
Create_Date = wf.tos(drow["Create_Date"])
};
return View("NewsEdit", NewsItem);
}
public ActionResult NewsCreate(FormCollection formCollection)
{
// 2. 寫入資料表
//----> 程式碼
Models.ShopCarDatasetTableAdapters.NewsTableAdapter newsadp = new Models.ShopCarDatasetTableAdapters.NewsTableAdapter();
int ret_app_ser;
//ret_app_ser = Convert.ToInt32(proadp.InsertProductData(formCollection["proNo"], formCollection["proName"],price,special_price,formCollection["proClassId"],proactive,formCollection["prodFeature"],formCollection["prodDesc"]));
ret_app_ser = Convert.ToInt32(newsadp.InsertNewsData(formCollection["News_Title"], formCollection["News_Content"]));
// 3. 使用物件 儲存起來回丟給前端 ProEdit.cshtml
var NewsItem = new
{
appSer = ret_app_ser,
News_Title = formCollection["News_Title"].ToString(),
News_Content = formCollection["News_Content"].ToString()
};
return View("NewsEdit", NewsItem);
}
public ActionResult NewsUpdate(FormCollection formCollection)
{
// 1. 取得前端 form 的欄位資料
// 2. 更新產品資料表
//----> 程式碼
Models.ShopCarDatasetTableAdapters.NewsTableAdapter newsadp = new Models.ShopCarDatasetTableAdapters.NewsTableAdapter();
newsadp.UpdateNewsData(formCollection["News_Title"], formCollection["News_Content"], Convert.ToInt32(formCollection["app_ser"]));
var NewsItem = new
{
appSer = formCollection["app_ser"],
News_Title = formCollection["News_Title"],
News_Content = formCollection["News_Content"]
};
return View("NewsEdit", NewsItem);
}
//
// GET: /News/
public ActionResult NewsToJsonData()
{
Models.ShopCarDatasetTableAdapters.NewsTableAdapter newsadp = new Models.ShopCarDatasetTableAdapters.NewsTableAdapter();
DataTable dt = newsadp.GetData();
Hashtable myHT = new Hashtable();
myHT.Add("newsList", dt);
string obj_json = JsonConvert.SerializeObject(myHT);
return Content(obj_json, "application/json");
}
