//Post回新增廠別資料
public ActionResult newStartPlace(ViewModel_StartFac data)
{
//宣告一個action變數，接收是新增還是刪除啟動作業下的廠別
int action = Convert.ToInt32(Request["AddorRemove"].ToString());
//宣告一個變數接啟動作業ID
int Start_id = Convert.ToInt32(Request["Start_id"].ToString());
//宣告一個變數接廠別編號
string factoryid = Request["factoryId"];
try
{
//action為時，新增啟動作業廠別
if (action == 0)
{
//創新資料行
StartPlace star = new StartPlace()
{
startplace_startId = Start_id,
startPlace_factoryId = factoryid
};
db.StartPlace.Add(star);
//存回資料庫
db.SaveChanges();
}
//action為1，表示刪除資料行
if (action == 1)
{
//先查詢該筆資料
var query = (from o in db.StartPlace
where o.startplace_startId == Start_id && o.startPlace_factoryId == factoryid
select o).FirstOrDefault();
//把該筆資料標記為刪除
db.StartPlace.Remove(query);
//存回資料庫，並刪除該筆
db.SaveChanges();
}
}
catch (Exception ex) { return(Content(ex.ToString())); } //如果資料庫寫入錯誤，拋出錯誤
//重新查詢廠別資料
var q1 = from o in db.Factory
select o;
//把啟動作業ID給data的StartId
data.StartId = Start_id;
//把廠別資料給data的Factory
data.Factory = q1.ToList();
//把啟動作業的表丟給data的Start
data.Start = (from o in db.StartPlace
select o).ToList();
return(View(data));
}
public ActionResult newStartPlace(int Start_id)
{
//宣告一個ViewModel_StartFac類別
ViewModel_StartFac data = new ViewModel_StartFac();
//查詢Factory資料
var q1 = from o in db.Factory
select o;
//把StartId丟入ViewModel_StartFac下StartId中
data.StartId = Start_id;
//創一個新的啟動作業跟廠別對應資料表
List <StartPlace> startPlace = new List <StartPlace>();
//把Factory與StartPlace資料丟入ViewModel_startPlace
data.Factory = q1.ToList();
data.Start = startPlace;
return(View(data));
}
