public static void Create_Seats(Park_Database.Service.Park_Seats_Service db) { Park_Database.Model.Park_Seats PS = new Park_Database.Model.Park_Seats(); PS.Seats_Area = "B"; for (int i = 1; i < 11; i++) { PS.Seats_Num = PS.Seats_Area + i.ToString("00"); db.Create(PS); } Console.WriteLine("區域位置資料創建完成"); }
public void Create(Park_Database.Model.Park_Seats 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_Seats(Seats_Num,Seats_Area) VALUES (N'{0}',N'{1}') ", CP.Seats_Num, CP.Seats_Area); command.ExecuteNonQuery(); connection.Close(); }
public List <Park_Database.Model.Park_Seats> LoadAll() { List <Park_Database.Model.Park_Seats> result = new List <Park_Database.Model.Park_Seats>(); var connection = new System.Data.SqlClient.SqlConnection(_connection); connection.Open(); var command = new System.Data.SqlClient.SqlCommand("", connection); command.CommandText = "Select * from Park_Seats"; var reader = command.ExecuteReader(); while (reader.Read()) { Park_Database.Model.Park_Seats item = new Park_Database.Model.Park_Seats(); item.Seats_Num = reader["Seats_Num"].ToString(); item.Seats_Area = reader["Seats_Area"].ToString(); result.Add(item); } connection.Close(); return(result); }