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();
}
