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("使用者資料創建完成");
}
