public Park_Database.Model.Park_Time GetParkByID(string id) { Park_Database.Model.Park_Time result = new Park_Database.Model.Park_Time(); var connection = new System.Data.SqlClient.SqlConnection(_connection); connection.Open(); var command = new System.Data.SqlClient.SqlCommand("", connection); command.CommandText = string.Format(@" Select * from Park_Time Where Time_Carname='{0}'", id); var reader = command.ExecuteReader(); while (reader.Read()) { Park_Database.Model.Park_Time item = new Park_Database.Model.Park_Time(); item.Time_Carname = reader["Time_Carname"].ToString(); item.Time_Seat = reader["Time_Seat"].ToString(); item.Time_Start = reader["Time_Start"].ToString(); item.Time_End = reader["Time_End"].ToString(); item.Time_Createtime = DateTime.Parse(reader["Time_Createtime"].ToString()); result = item; } connection.Close(); return result; }
public List<Park_Database.Model.Park_Time> LoadAll() { List<Park_Database.Model.Park_Time> result = new List<Park_Database.Model.Park_Time>(); var connection = new System.Data.SqlClient.SqlConnection(_connection); connection.Open(); var command = new System.Data.SqlClient.SqlCommand("", connection); command.CommandText = "Select * from Park_Time"; var reader = command.ExecuteReader(); while (reader.Read()) { Park_Database.Model.Park_Time item = new Park_Database.Model.Park_Time(); item.Time_Carname = reader["Time_Carname"].ToString(); item.Time_Seat = reader["Time_Seat"].ToString(); item.Time_Start = reader["Time_Start"].ToString(); item.Time_End = reader["Time_End"].ToString(); item.Time_Createtime = DateTime.Parse(reader["Time_Createtime"].ToString()); result.Add(item); } connection.Close(); return result; }
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 void Update(Park_Database.Model.Park_Time updatePark) { var connection = new System.Data.SqlClient.SqlConnection(_connection); connection.Open(); var command = new System.Data.SqlClient.SqlCommand("", connection); command.CommandText = string.Format(@" UPDATE Park_Time SET Time_Seat=N'{1}',Time_Start=N'{2}',Time_End=N'{3}' Where Time_Carname=N'{0}' ", updatePark.Time_Carname, updatePark.Time_Seat, updatePark.Time_Start, updatePark.Time_End); command.ExecuteNonQuery(); connection.Close(); }
public void Create(Park_Database.Model.Park_Time CP) { var connection = new System.Data.SqlClient.SqlConnection(_connection); connection.Open(); var command = new System.Data.SqlClient.SqlCommand("", connection); command.CommandText = string.Format(@" INSERT INTO Park_Time(Time_Carname,Time_Seat, Time_Start, Time_End,Time_Createtime) VALUES (N'{0}',N'{1}',N'{2}',N'{3}',N'{4}') ", CP.Time_Carname, CP.Time_Seat, CP.Time_Start, CP.Time_End, CP.Time_Createtime.ToString("yyyy-MM-dd HH:mm")); command.ExecuteNonQuery(); connection.Close(); }
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 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")); }