public ActionResult Delete(string id)
{
string appdSer = id; // 取得前端傳來要刪除某一筆file的 app_ser
System.Diagnostics.Debug.WriteLine("[Get] Delete AppSer >>> " + appdSer);
// 1. 先撈資料庫 File Table 的資料 (SQL)
//----> 程式碼
Models.ShopCarDatasetTableAdapters.Product_PhotoTableAdapter photoadp = new Models.ShopCarDatasetTableAdapters.Product_PhotoTableAdapter();
DataTable dt = photoadp.GetOnePhotoData(Convert.ToInt32(appdSer));
// 2. 取得DataSet中的 DataTabe資訊
//----> 程式碼
// 3. 刪除一筆photo record
//----> 程式碼
photoadp.DeleteOnePhotoData(Convert.ToInt32(appdSer));
// 4. 刪除實體路徑檔案
var filename =wf.tos(dt.Rows[0]["file_name"]); // 透過資料表找到file Name
var filePath = Path.Combine(Server.MapPath("~/Files"), filename);
ArrayList list = new ArrayList();
var obj = new DeleteMesg();
if (System.IO.File.Exists(filePath))
{
System.IO.File.Delete(filePath);
obj.sussess = "true";
obj.message = "delete file " + id + " finish..";
}
else
{
obj.sussess = "false";
obj.message = "delete file " + id + " finish..";
}
list.Add(obj);
// 5. 回傳json 資訊
Hashtable myHT = new Hashtable();
myHT.Add("file", list);
return Json(myHT, JsonRequestBehavior.AllowGet);
}
