private void DeleMainType(object sender, RoutedEventArgs e)
{
if (MainTypeList.Count == 1)
{
MessageBox.Show("请至少保留一个分类。");
return;
}
Button BT = sender as Button;
Main_type ItemToDele = (Main_type)BT.Tag;
ItemToDele.Delete = 1;
//App.APPDB.Main_type.DeleteOnSubmit(ItemToDele);
var subTypeToDele = from s in APPDB.Sub_type
where s.Pid == ItemToDele.Id
select s;
foreach (var i in subTypeToDele)
{
i.Delete = 1;
}
//APPDB.Sub_type.DeleteAllOnSubmit(subTypeToDele);
try
{
APPDB.SubmitChanges();
}
catch (Exception ex)
{
return;
}
MainTypeList.Remove(ItemToDele);
TextBoxMainType.Text = "";
this.Focus();
}
private void AddMainType(object sender, RoutedEventArgs e)
{
if (TextBoxMainType.Text.Length > 0)
{
string name = TextBoxMainType.Text;
Main_type MainItem = new Main_type {
Name = name
};
Sub_type defaultSubItem = new Sub_type {
Name = name
};
App.APPDB.Main_type.InsertOnSubmit(MainItem);
try
{
APPDB.SubmitChanges();
defaultSubItem.Pid = MainItem.Id;
APPDB.Sub_type.InsertOnSubmit(defaultSubItem);
APPDB.SubmitChanges();
MainTypeList.Add(MainItem);
}
catch (Exception ex)
{
MessageBox.Show("数据保存失败");
}
}
this.Focus();
}
private void listPickerMainType_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (listPickerMainType.ItemsSource == null)
{
return;
}
Main_type item = listPickerMainType.SelectedItem as Main_type;
mTypeId = item.Id;
setSubList();
}
private void AddMainType(object sender, RoutedEventArgs e)
{
if (TextBoxMainType.Text.Length > 0)
{
string name = TextBoxMainType.Text;
Main_type MainItem = new Main_type { Name=name};
Sub_type defaultSubItem = new Sub_type { Name = name };
App.APPDB.Main_type.InsertOnSubmit(MainItem);
try
{
APPDB.SubmitChanges();
defaultSubItem.Pid = MainItem.Id;
APPDB.Sub_type.InsertOnSubmit(defaultSubItem);
APPDB.SubmitChanges();
MainTypeList.Add(MainItem);
}
catch (Exception ex)
{
MessageBox.Show("数据保存失败");
}
}
this.Focus();
}
partial void DeleteMain_type(Main_type instance);
partial void UpdateMain_type(Main_type instance);
partial void InsertMain_type(Main_type instance);
partial void DeleteMain_type(Main_type instance);
partial void UpdateMain_type(Main_type instance);
partial void InsertMain_type(Main_type instance);
