public List <Park_Database.Model.Park_Member> LoadAll() { List <Park_Database.Model.Park_Member> result = new List <Park_Database.Model.Park_Member>(); var connection = new System.Data.SqlClient.SqlConnection(_connection); connection.Open(); var command = new System.Data.SqlClient.SqlCommand("", connection); command.CommandText = "Select * from Park_Member"; var reader = command.ExecuteReader(); while (reader.Read()) { Park_Database.Model.Park_Member item = new Park_Database.Model.Park_Member(); item.Member_ID = reader["Member_ID"].ToString(); item.Member_Carname = reader["Member_Carname"].ToString(); item.Member_Name = reader["Member_Name"].ToString(); item.Member_Password = reader["Member_Password"].ToString(); item.Member_Createtime = DateTime.Parse(reader["Member_Createtime"].ToString()); result.Add(item); } connection.Close(); return(result); }
public void Create(Park_Database.Model.Park_Member 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_Member(Member_ID,Member_Carname,Member_Name, Member_Password, Member_Createtime) VALUES (N'{0}',N'{1}',N'{2}',N'{3}',N'{4}') ", CP.Member_ID, CP.Member_Carname, CP.Member_Name, CP.Member_Password, CP.Member_Createtime.ToString("yyyy-MM-dd HH:mm")); command.ExecuteNonQuery(); connection.Close(); }
//public static void Show_Time(Park_Database.Service.Park_Time_Service db) //{ // List<Park_Database.Model.Park_Time> PT = new List<Park_Database.Model.Park_Time>(); // PT = db.LoadAll(); // int count = 1; // Console.WriteLine("共有" + PT.Count + "筆區域資料"); // PT.ForEach(x => // { // Console.WriteLine("\t第" + (count++) + "筆資料"); // Console.WriteLine("\t車牌:" + x.Time_Carname); // Console.WriteLine("\t座號:" + x.Time_Seat); // Console.WriteLine("\t開始時間:" + x.Time_Start); // Console.WriteLine("\t結束時間:" + x.Time_End); // Console.WriteLine("\t建立時間:" + x.Time_Createtime.ToString("yyyy-MM-dd HH:mm:ss")); // Console.WriteLine(); // }); //} public static void Create_Member(Park_Database.Service.Park_Member_Service db) { var ID = "root01"; var carname = "MAC-7122"; var name = "Tsai"; var password = "******"; var createtime = DateTime.Now; Park_Database.Model.Park_Member PM = new Park_Database.Model.Park_Member(); PM.Member_ID = ID; PM.Member_Carname = carname; PM.Member_Name = name; PM.Member_Password = password; PM.Member_Createtime = (createtime); db.Create(PM); Console.WriteLine("使用者資料創建完成"); }