public ActionResult ReturnToShowFlightState() { //在这里更改后返回 string nfid = Request.Params["a"]; //需要将这两项每一项拆分为两部分机场航站楼 string nt_a_t = Request.Params["b"]; string[] sArray1 = Regex.Split(nt_a_t, "-", RegexOptions.IgnoreCase); string nt_a = sArray1[0]; string nt_t = sArray1[1]; string nl_a_t = Request.Params["c"]; string[] sArray2 = Regex.Split(nl_a_t, "-", RegexOptions.IgnoreCase); string nl_a = sArray2[0]; string nl_t = sArray2[1]; // string ne_t_t = Request.Params["d"]; string ne_l_t = Request.Params["e"]; string nstate = Request.Params["f"]; // /*在这里修改数据库*/ FLIGHTIME objft = new FLIGHTIME() { F_ID = nfid, T_AIRPORT = nt_a, T_TERMINAL = nt_t, EX_TAKEOFF_TIME = Convert.ToDateTime(ne_t_t), EX_LAND_TIME = Convert.ToDateTime(ne_l_t), L_AIRPORT = nl_a, L_TERMNAL = nl_t }; db.Updateable(objft).ExecuteCommand(); FSTATE objstate = new FSTATE() { F_ID = nfid, STATE = nstate }; db.Updateable(objstate).ExecuteCommand(); /* * Fstate objstate = new Fstate(nfid, nstate); * DataBaseAccess.UpdateObject(objstate); */ // List <string> needs = new List <string>(); needs.Add("F_ID"); needs.Add("t_airport"); needs.Add("t_terminal"); needs.Add("l_airport"); needs.Add("l_termnal"); needs.Add("ex_takeoff_time"); needs.Add("ex_land_time"); needs.Add("state"); List <FlightStateReturn> res = DataBaseAccess.GetFlightsState(needs); // return(View("FlightState", res)); // }
public void FlightDepart() { Actions a = new Actions(); var systime = a.SystemTime; var DepartFlightimeList = a.searchDepartFlightimes(); List <FSTATE> DepartFlightsState = new List <FSTATE>(); foreach (var DepartFlightime in DepartFlightimeList) //起飞航班 { DepartFlightime.RE_TAKEOFF_TIME = systime; //实际起飞时间 FSTATE DepartFlightState = a.GetFstate(DepartFlightime.F_ID); DepartFlightState.STATE = "在空中"; //状态改为在空中 textBox1.Text += (DepartFlightState.F_ID + " 起飞!\r\n"); DepartFlightsState.Add(DepartFlightState); } if (DepartFlightimeList.ToArray().Length != 0) { a.updateFlightime(DepartFlightimeList); a.updateFstate(DepartFlightsState); } a.SystemTime = a.SystemTime.AddMinutes(30); label1.Text = a.SystemTime.ToString(); }
public void updateFstate(FSTATE fstate) { db.Updateable(fstate).ExecuteCommand(); }
public FSTATE GetFstate(string F_ID) { FSTATE fstate = db.Queryable <FSTATE>().Where(it => it.F_ID == F_ID).Single(); return(fstate); }