public ActionResult ShowCustomerBoardingStates() { List <CustomerBoardingState> list = new List <CustomerBoardingState>(); //航班号(根据航班号查找C_ID) <乘客ID,姓名,性别,电话号码>(根据C_ID查找customer),状态(根据F_ID,C_ID,来查找seat) String Flight_ID = Request.Params["a"]; /*******///找乘客 var ids = db.Queryable <SEAT>().Where(it => it.F_ID == Flight_ID).ToList(); foreach (var id in ids) { // var customer = db.Queryable <CUSTOMER>().Where(it => it.ID == id.C_ID).ToList(); var state = db.Queryable <SEAT>().Where(it => it.F_ID == Flight_ID & it.C_ID == id.C_ID).ToList(); CustomerBoardingState cbs = new CustomerBoardingState(customer[0].ID, customer[0].NAME, customer[0].GENDER, customer[0].PHONE_NUMBER, Flight_ID, state[0].STATE, id.SEAT_NUMBER); list.Add(cbs); } CustomerBoardingState tail = new CustomerBoardingState(); list.Add(tail); /***********************************/ //MessageBox.Show(list.Count.ToString()); // /***********************************/ return(View("CustomerBoardingStates", list)); }
public ActionResult ReturnToShowCustomerBoardingStates() { string fid = Request.Params["f_id"]; fid = fid.Trim(); int cid = int.Parse(Request.Params["c_id"]); string seat = Request.Params["seat"]; seat = seat.Trim(); string cur_state = Request.Params["s"]; cur_state = cur_state.Trim(); if (cur_state == "已登机") { MessageBox.Show("该乘客已经登机啦!"); } else if (cur_state == "已购票") { MessageBox.Show("该乘客还未办理登机牌"); } else { //更新座位 SEAT objs = new SEAT() { F_ID = fid, C_ID = cid, SEAT_NUMBER = seat, STATE = "已登机" }; db.Updateable(objs).ExecuteCommand(); /**********************/ //在这里将已登机人数加1 var fstate = db.Queryable <FLIGHT>().Where(it => it.F_ID == fid).ToList(); foreach (var i in fstate) { i.BOARD++; db.Updateable(i).ExecuteCommand(); } } // List <CustomerBoardingState> list = new List <CustomerBoardingState>(); //航班号(根据航班号查找C_ID) <乘客ID,姓名,性别,电话号码>(根据C_ID查找customer),状态(根据F_ID,C_ID,来查找seat) String Flight_ID = fid; /*******///找乘客 var ids = db.Queryable <SEAT>().Where(it => it.F_ID == Flight_ID).ToList(); foreach (var id in ids) { // var customer = db.Queryable <CUSTOMER>().Where(it => it.ID == id.C_ID).ToList(); var state = db.Queryable <SEAT>().Where(it => it.F_ID == Flight_ID & it.C_ID == id.C_ID).ToList(); CustomerBoardingState cbs = new CustomerBoardingState(Convert.ToInt32(customer[0].ID), customer[0].NAME, customer[0].GENDER, Convert.ToInt32(customer[0].PHONE_NUMBER), Flight_ID, state[0].STATE, id.SEAT_NUMBER); list.Add(cbs); } CustomerBoardingState tail = new CustomerBoardingState(); list.Add(tail); // return(View("CustomerBoardingStates", list)); }