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);
}
