public void AddCalligrapher()
{
Calligraphyer calligraphyer = new Calligraphyer();
calligraphyer.Name = "努力学习";
calligraphyer.Description = "天天向上";
calligraphyer.Status = DatabaseTest.Entity.EntityBase.Statuses.New;
((ObservableCollection<Calligraphyer>)_viewSource.Source).Add(calligraphyer);
}
public static void Update(Calligraphyer c)
{
var cnn = Database.CreateConnection();
string sql=@"update DatabaseTable set Description=@Description where ID=@ID";
SqlCommand cmmd = new SqlCommand(sql, cnn);
cmmd.Parameters.Add(new SqlParameter("ID", c.Id));
//cmmd.Parameters.Add(new SqlParameter("Name", c.Name));
cmmd.Parameters.Add(new SqlParameter("Description", c.Description));
cnn.Open();
cmmd.ExecuteNonQuery();
cnn.Close();
}
public static void Insert(Calligraphyer c)
{
var cnn = Database.CreateConnection();
string sql = @"insert into DatabaseTable
(Name,Description) values (@Name,@Description)";
SqlCommand cmmd = new SqlCommand(sql, cnn);
cmmd.Parameters.Add(new SqlParameter("Name", c.Name));
cmmd.Parameters.Add(new SqlParameter("Description", c.Description));
cnn.Open();
cmmd.ExecuteNonQuery();
cnn.Close();
}
public static ObservableCollection<Calligraphyer> Load()
{
ObservableCollection<Calligraphyer> calligraphyers = new ObservableCollection<Calligraphyer>();
var cnn = Database.CreateConnection();
string sql = "select * from DatabaseTable";
SqlCommand cmmd = new SqlCommand(sql,cnn);
cnn.Open();
var reader = cmmd.ExecuteReader();
while (reader.Read())
{
Calligraphyer c = new Calligraphyer((int)reader["ID"], (string)reader["Name"], (string)reader["Description"]);
calligraphyers.Add(c);
}
cnn.Close();
return calligraphyers;
}
