public List <Park_Database.Model.Park_Root> LoadAll() { List <Park_Database.Model.Park_Root> result = new List <Park_Database.Model.Park_Root>(); var connection = new System.Data.SqlClient.SqlConnection(_connection); connection.Open(); var command = new System.Data.SqlClient.SqlCommand("", connection); command.CommandText = "Select * from Park_Root"; var reader = command.ExecuteReader(); while (reader.Read()) { Park_Database.Model.Park_Root item = new Park_Database.Model.Park_Root(); item.Root_ID = reader["Root_ID"].ToString(); item.Root_Password = reader["Root_Password"].ToString(); item.Root_Authority = reader["Root_Authority"].ToString(); result.Add(item); } connection.Close(); return(result); }
public static void Create_Root(Park_Database.Service.Park_Root_Service db) { var ID = "root01"; var password = "******"; var Authority = "1"; Park_Database.Model.Park_Root PR = new Park_Database.Model.Park_Root(); PR.Root_ID = ID; PR.Root_Password = password; PR.Root_Authority = Authority; db.Create(PR); Console.WriteLine("使用者資料創建完成"); }
public void Create(Park_Database.Model.Park_Root 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_Root(Root_ID,Root_Password, Root_Authority) VALUES (N'{0}',N'{1}',N'{2}') ", CP.Root_ID, CP.Root_Password, CP.Root_Authority); command.ExecuteNonQuery(); connection.Close(); }