//void View_CollectionChanged(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
//{
// if (e.Action == System.Collections.Specialized.NotifyCollectionChangedAction.Add)
// {
// CalligrapherDataHelper.Insert((Calligraphyer)e.NewItems[0]);
// }
//}
public void AddCalligrapher()
{
Calligraphyer calligraphyer = new Calligraphyer();
calligraphyer.Name = "书法家";
calligraphyer.Description = "简介";
calligraphyer.Id = Guid.NewGuid();
((ObservableCollection<Calligraphyer>)_viewSource.Source).Add(calligraphyer);
}
//void View_CollectionChanged(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
//{
// if (e.Action == System.Collections.Specialized.NotifyCollectionChangedAction.Add)
// {
// CalligrapherDataHelper.Insert((Calligraphyer)e.NewItems[0]);
// }
//}
public void AddCalligrapher()
{
Calligraphyer calligraphyer = new Calligraphyer();
calligraphyer.Name = "书法家";
calligraphyer.Description="简介";
((ObservableCollection<Calligraphyer>)_viewSource.Source).Add(calligraphyer);
calligraphyer.Status = EntityBase.Statuses.New;
;CalligrapherDataHelper.Save((ObservableCollection<Calligraphyer>)_viewSource.Source);
}
public static void Delete(Calligraphyer c)
{
var cnn = DataHelper.CreateConnection();
string sql = @"DELETE FROM T_Calligrapher WHERE ID=@ID";
SqlCommand cmmd = new SqlCommand(sql, cnn);
cmmd.Parameters.Add(new SqlParameter("ID", c.Id));
cnn.Open();
cmmd.ExecuteNonQuery();
cnn.Close();
}
private static void Update(Calligraphyer c)
{
var cnn = DataHelper.CreateConnection();
string sql = @"UPDATE T_Calligrapher 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("Description", c.Description));
cnn.Open();
cmmd.ExecuteNonQuery();
cnn.Close();
}
private static void Insert(Calligraphyer c)
{
var cnn = DataHelper.CreateConnection();
string sql = @"INSERT INTO T_Calligrapher
(ID,Name, Description) VALUES (@ID, @Name, @Description)";
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 ObservableCollection<Calligraphyer> Load()
{
ObservableCollection<Calligraphyer> calligraphyers = new ObservableCollection<Calligraphyer>();
var cnn = DataHelper.CreateConnection();
string sql = "select * from T_Calligrapher";
SqlCommand cmmd = new SqlCommand(sql, cnn);
cnn.Open();
var reader = cmmd.ExecuteReader();
while (reader.Read())
{
Calligraphyer c = new Calligraphyer((Guid)reader["ID"], (string)reader["Name"], (string)reader["Description"]);
calligraphyers.Add(c);
}
cnn.Close();
return calligraphyers;
}
public static void Save(Calligraphyer c)
{
if (c.Status == EntityBase.Statuses.New)
{
Insert(c);
c.Status = EntityBase.Statuses.Updated;
}
else if (c.Status == EntityBase.Statuses.Edit)
{
Update(c);
c.Status = EntityBase.Statuses.Updated;
}
else if (c.Status == EntityBase.Statuses.Delete)
{
Delete(c);
//c.Status = EntityBase.Statuses.Updated;
}
}
private static void Update(Calligraphyer c)
{
}
public void Delete(Calligraphyer c)
{
((ObservableCollection<Calligraphyer>)_viewSource.Source).Remove(c);
c.Status = EntityBase.Statuses.Delete;
CalligrapherDataHelper.Save(c);
}
