public ActionResult MonthP(Park_Web.Models.Park_DateArea PMA)
{
Park_Database.Service.Park_Area_Service da = new Park_Database.Service.Park_Area_Service();
Park_Database.Service.Park_Seats_Service ds = new Park_Database.Service.Park_Seats_Service();
Park_Database.Service.Park_Time_Service dt = new Park_Database.Service.Park_Time_Service();
List <Park_Database.Model.Park_Area> PA = new List <Park_Database.Model.Park_Area>();
List <Park_Database.Model.Park_Seats> PS = new List <Park_Database.Model.Park_Seats>();
List <Park_Database.Model.Park_Time> PT = new List <Park_Database.Model.Park_Time>();
List <Park_Web.Models.Park_SeatsStatus> PWS = new List <Park_Web.Models.Park_SeatsStatus>();
PA = da.LoadAll();
PS = ds.LoadAll();
PT = dt.LoadAll();
PS.ForEach(x => {
Park_Web.Models.Park_SeatsStatus item = new Park_Web.Models.Park_SeatsStatus();
if (PA[int.Parse(PMA.Park_DateArea_Area)].Area_Name == x.Seats_Area)
{
item.Park_SeatsStatus_Seat = x.Seats_Num;
PWS.Add(item);
}
});
bool PTf = false;
for (int i = 0; i < PWS.Count; i++)
{
PTf = false;
for (int j = 0; j < PT.Count; j++)
{
if (PWS[i].Park_SeatsStatus_Seat == PT[j].Time_Seat)
{
if (((DateTime.Parse(PT[j].Time_End) >= DateTime.Parse(PMA.Park_DateArea_Date))) && ((DateTime.Parse(PT[j].Time_Start) <= DateTime.Parse(PMA.Park_DateArea_Date))))
{
PWS[i].Park_SeatsStatus_Status = "1";
PTf = true;
break;
}
}
}
if (!PTf)
{
PWS[i].Park_SeatsStatus_Status = "0";
}
}
ViewBag.Date = PMA.Park_DateArea_Date;
ViewBag.Area = PA[int.Parse(PMA.Park_DateArea_Area)].Area_Name;
ViewBag.type = "1"; //0 日租型 1 月租型
return(View(PWS));
}
public static void Create_Area(Park_Database.Service.Park_Area_Service db)
{
Park_Database.Model.Park_Area PA = new Park_Database.Model.Park_Area();
var Name = "D";
var Num = "5";
var Createtime = DateTime.Now;
PA.Area_Name = Name;
PA.Area_Num = Num;
PA.Area_Createtime = (Createtime);
db.Create(PA);
Console.WriteLine("區域資料創建完成");
}
public static void Show_Area(Park_Database.Service.Park_Area_Service db)
{
List <Park_Database.Model.Park_Area> PA = new List <Park_Database.Model.Park_Area>();
PA = db.LoadAll();
int count = 1;
Console.WriteLine("共有" + PA.Count + "筆區域資料");
PA.ForEach(x =>
{
Console.WriteLine("\t第" + (count++) + "筆資料");
Console.WriteLine("\t區域名稱:" + x.Area_Name);
Console.WriteLine("\t區域數量:" + x.Area_Num);
Console.WriteLine("\t建立時間:" + x.Area_Createtime.ToString("yyyy-MM-dd HH:mm:ss"));
Console.WriteLine();
});
}
public ActionResult Month()
{
Park_Database.Service.Park_Area_Service db = new Park_Database.Service.Park_Area_Service();
var list = db.LoadAll();
List <SelectListItem> items = new List <SelectListItem>();
int i = 0;
foreach (var item in list)
{
items.Add(new SelectListItem()
{
Text = item.Area_Name,
Value = (i++).ToString(),
});
}
ViewBag.Map_area = items;
return(View());
}
public static void Main(string[] args)
{
List <Park_Database.Model.Park_User> PU = new List <Park_Database.Model.Park_User>();
var dbu = new Park_Database.Service.Park_User_Service();
var dba = new Park_Database.Service.Park_Area_Service();
var dbs = new Park_Database.Service.Park_Seats_Service();
var dbt = new Park_Database.Service.Park_Time_Service();
var dbr = new Park_Database.Service.Park_Root_Service();
// Create_User(dbu);
//Show_User(dbu);
//Create_Area(dba);
//Show_Area(dba);
//Create_Seats(dbs);
//Show_Seats(dbs);
// Create_Time(dbt);
//Show_Time(dbt);
Create_Root(dbr);
Show_Root(dbr);
Console.ReadKey();
}