public List <Park_Database.Model.Park_User> LoadAll() { List <Park_Database.Model.Park_User> result = new List <Park_Database.Model.Park_User>(); var connection = new System.Data.SqlClient.SqlConnection(_connection); connection.Open(); var command = new System.Data.SqlClient.SqlCommand("", connection); command.CommandText = "Select * from Park_User"; var reader = command.ExecuteReader(); while (reader.Read()) { Park_Database.Model.Park_User item = new Park_Database.Model.Park_User(); item.User_Carname = reader["User_Carname"].ToString(); item.User_Name = reader["User_Name"].ToString(); item.User_Password = reader["User_Password"].ToString(); item.User_Createtime = DateTime.Parse(reader["User_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 static void Create_User(Park_Database.Service.Park_User_Service db) { var carname = "MAC-7122"; var name = "Li"; var password = "******"; var createtime = DateTime.Now; Park_Database.Model.Park_User PU = new Park_Database.Model.Park_User(); PU.User_Carname = carname; PU.User_Name = name; PU.User_Password = password; PU.User_Createtime = (createtime); db.Create(PU); Console.WriteLine("使用者資料創建完成"); }
public void Create(Park_Database.Model.Park_User 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_User(User_Carname,User_Name, User_Password, User_Createtime) VALUES (N'{0}',N'{1}',N'{2}',N'{3}') ", CP.User_Carname, CP.User_Name, CP.User_Password, CP.User_Createtime.ToString("yyyy-MM-dd HH:mm")); command.ExecuteNonQuery(); connection.Close(); }