// GET: User
public ActionResult U_Search(string search = "")
{
Park_Database.Service.Park_Time_Service dt = new Park_Database.Service.Park_Time_Service();
List <Park_Database.Model.Park_Time> pt = new List <Park_Database.Model.Park_Time>();
List <Park_Database.Model.Park_Time> p = new List <Park_Database.Model.Park_Time>();
if (!string.IsNullOrEmpty(search))
{
if (search != "")
{
pt = dt.LoadAll();
/*
* pt = pt
* .Where(x =>
* x.Time_Carname.Contains(search))
* .ToList();*/
pt.ForEach(x => {
if (x.Time_Carname == search)
{
p.Add(x);
}
});
}
}
ViewBag.Search = search;
return(View(p));
}
public ActionResult Update(string id)
{
Park_Database.Service.Park_Time_Service dt = new Park_Database.Service.Park_Time_Service();
var model = dt.GetParkByID(id);
return(View(model));
}
public ActionResult Phome(Park_Web.Models.Park_Rootweb PRW)
{
Park_Database.Service.Park_Time_Service dt = new Park_Database.Service.Park_Time_Service();
List <Park_Database.Model.Park_Time> PT = new List <Park_Database.Model.Park_Time>();
PT = dt.LoadAll();
ViewBag.Authority = PRW.Rootweb_Authority;
return(View(PT));
}
public ActionResult Create(Park_Database.Model.Park_User Pget, string s, string d, string t)
{
Park_Database.Service.Park_User_Service dbu = new Park_Database.Service.Park_User_Service();
Park_Database.Service.Park_Time_Service dbt = new Park_Database.Service.Park_Time_Service();
Park_Database.Model.Park_User PU = new Park_Database.Model.Park_User();
Park_Database.Model.Park_Time PT = new Park_Database.Model.Park_Time();
Park_Web.Models.Park_Ok PK = new Park_Web.Models.Park_Ok();
DateTime da;
da = DateTime.Parse(d);
if (t == "1") //月租
{
da = da.AddMonths(1);
}
else if (t == "2") //年租
{
da = da.AddYears(1);
}
Pget.User_Createtime = DateTime.Now;
dbu.Create(Pget);
PT.Time_Carname = Pget.User_Carname;
PT.Time_Seat = s;
PT.Time_Start = d;
PT.Time_End = da.ToString("yyyy-MM-dd HH:mm");
PT.Time_Createtime = DateTime.Now;
dbt.Create(PT);
if (t == "0")
{
PK.Ok_Type = "日租型";
}
else if (t == "1")
{
PK.Ok_Type = "月租型";
}
else if (t == "2")
{
PK.Ok_Type = "年租型";
}
PK.Ok_Seat = s;
PK.Ok_Carname = Pget.User_Carname;
PK.Ok_Name = Pget.User_Name;
PK.Ok_Password = Pget.User_Password;
PK.Ok_Start = d;
PK.Ok_End = da.ToString("yyyy-MM-dd HH:mm");
return(RedirectToAction("ok", "Park", PK));
}
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 ActionResult Search(string search = "")
{
Park_Database.Service.Park_Time_Service dt = new Park_Database.Service.Park_Time_Service();
var s = dt.LoadAll();
if (!string.IsNullOrEmpty(search))
{
s = s
.Where(x =>
x.Time_Carname.Contains(search) ||
x.Time_Seat.Contains(search) ||
x.Time_Start.Contains(search) ||
x.Time_End.Contains(search))
.ToList();
}
ViewBag.Search = search;
return(View(s));
}
public static void Create_Time(Park_Database.Service.Park_Time_Service db)
{
Park_Database.Model.Park_Time PT = new Park_Database.Model.Park_Time();
var carname = "MAX-7222";
var seats = "A02";
var start = "2017-01-01";
var end = "2017-01-01";
var Createtime = DateTime.Now;
PT.Time_Carname = carname;
PT.Time_Seat = seats;
PT.Time_Start = start;
PT.Time_End = end;
PT.Time_Createtime = (Createtime);
db.Create(PT);
Console.WriteLine("區域資料創建完成");
}
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();
}
public RedirectToRouteResult Update(Park_Database.Model.Park_Time P)
{
//if (Request.Files.Count > 0 && Request.Files[0].ContentLength > 0)
//{
// var File = Request.Files[0];
// string dir = string.Format("~/Content/Image/");
// var TrueDir = System.Web.Hosting.HostingEnvironment.MapPath(dir);
// if (!System.IO.Directory.Exists(TrueDir))
// {
// System.IO.Directory.CreateDirectory(TrueDir);
// }
// var SaveDir = System.IO.Path.Combine(TrueDir, File.FileName);
// File.SaveAs(SaveDir);
// P.area = this.Url.Content(System.IO.Path.Combine(dir, File.FileName));
// //System.Drawing.Image image = System.Drawing.Image.FromStream(File.InputStream);
//}
Park_Database.Service.Park_Time_Service dt = new Park_Database.Service.Park_Time_Service();
dt.Update(P);
return(RedirectToAction("Phome"));
}
public ActionResult Delete(string id)
{
Park_Database.Service.Park_Time_Service dt = new Park_Database.Service.Park_Time_Service();
dt.Delete(id);
return(RedirectToAction("PHome"));
}
