在空数据网格中添加行
本文关键字:添加行 网格 数据网 数据 | 更新日期: 2023-09-27 18:15:05
我正在构建一个MVVM - WPF应用程序。我有几个数据网格,其中CRUD操作工作得很好。
现在,我想要一个dataGrid总是空的开始,当然我可以添加行。所以我可以填充它但是当我点击保存时,什么都没有保存
为什么?
ViewModel:
public class InvoiceViewModel : ViewModelBase
{
public Context ctx = new Context();
public InvoiceViewModel()
{
this.Collection = new ObservableCollection<Invoice>();
}
private ObservableCollection<Invoice> collection;
public ObservableCollection<Invoice> Collection
{
get
{
return collection;
}
set
{
collection = value;
OnPropertyChanged("Collection");
}
}
private Invoice _selected;
public Invoice Selected
{
get
{
return _selected;
}
set
{
_selected = value;
OnPropertyChanged("Selected");
}
}
private void Get()
{
ctx.Invoices.ToList().ForEach(invoice => ctx.Invoices.Local.Add(invoice));;
Collection = ctx.Invoices.Local;
}
private void Save()
{
foreach (Invoice item in Collection)
{
if (ctx.Entry(item).State == System.Data.Entity.EntityState.Added)
{
ctx.Invoices.Add(item);
}
}
ctx.SaveChanges();
}
private void Delete()
{
var id = Selected;
var invoice = (from i in ctx.Invoices
where i.idInvoice == id.idInvoice
select i).SingleOrDefault();
Collection.Remove(invoice);
}
#region "Command"
// private ICommand getCommand;
private ICommand saveCommand;
private ICommand removeCommand;
/*public ICommand GetCommand
{
get
{
return getCommand ?? (getCommand = new RelayCommand(p => this.Get(), p => this.CanGet()));
}
}
private bool CanGet()
{
return true;
}*/
public ICommand SaveCommand
{
get
{
return saveCommand ?? (saveCommand = new RelayCommand(p => this.Save(), p => this.CanSave()));
}
}
private bool CanSave()
{
return true;
}
public ICommand DeleteCommand
{
get
{
return removeCommand ?? (removeCommand = new RelayCommand(p => this.Delete(), p => this.CanDelete()));
}
}
public bool CanDelete()
{
if (Selected != null)
return true;
else
return false;
}
#endregion
}
视图:
<Page.Resources>
<local:InvoiceViewModel x:Key="invoice" />
<local:ShopViewModel x:Key="shop" />
<local:SupplierViewModel x:Key="supplier" />
<local:ProductViewModel x:Key="product" />
<DataTemplate x:Key="ProductDataTemplate">
<TextBlock Text="{Binding product}" />
</DataTemplate>
</Page.Resources>
<DataGrid x:Name="dataGridInvoice"
Margin="5"
Grid.Row="1"
ItemsSource="{Binding Collection}"
AutoGenerateColumns="False"
SelectedItem="{Binding Selected, Mode=TwoWay}"
SelectionMode="Extended"
SelectionUnit="FullRow">
<DataGrid.Columns>
<DataGridTextColumn x:Name="dataGridTextColumn"
Header="Supplier Invoice Nb"
Width="*" />
<DataGridComboBoxColumn Header="Ref Supplier"
ItemsSource="{Binding Products, Source={StaticResource supplier}, Mode=OneWay}"
DisplayMemberPath="refsup"
SelectedValueBinding="{Binding refSupp}"
SelectedValuePath="refsup"
Width="*" />
<DataGridTextColumn Header="Unit"
Binding="{Binding unit, UpdateSourceTrigger=PropertyChanged, Mode=TwoWay}"
Width="*" />
<DataGridTextColumn Header="Quantity"
Binding="{Binding quantity, UpdateSourceTrigger=PropertyChanged, Mode=TwoWay}"
Width="*" />
<DataGridTextColumn Header="Prix/MOQ"
Binding="{Binding unitPrice, UpdateSourceTrigger=PropertyChanged, Mode=TwoWay}"
Width="*" />
<DataGridTextColumn Header="Total Price"
Binding="{Binding totalPrice, UpdateSourceTrigger=PropertyChanged, Mode=TwoWay}"
Width="*" />
</DataGrid.Columns>
</DataGrid>
<StackPanel Orientation="Horizontal">
<Button x:Name="BtnDelete"
Content="Delete"
Command="{Binding DeleteCommand}"
HorizontalAlignment="Center"
Margin="100,5,5,5"
Width="85" />
<Button x:Name="BtnAdd"
Content="Save"
Command="{Binding SaveCommand}"
HorizontalAlignment="Center"
Margin="20,5,5,5"
Width="85" />
</StackPanel>
这个方法实际上将Collection
绑定到实体集的缓存本地。如果没有绑定,就很难保存添加的项:
private void Get() {
ctx.Invoices.ToList().ForEach(invoice => ctx.Invoices.Local.Add(invoice));;
Collection = ctx.Invoices.Local;
}
事实上,它可以像这样加载所有发票和缓存到Local:
private void Get() {
ctx.Invoices.Load();
Collection = ctx.Invoices.Local;
}
然而,正如你说的,你想要一个空的数据网格(只是为了添加),然后你可以重构Get
方法接受一个bool值,表明数据是否应该首先从db加载:
private void Get(bool loadDataFirst) {
if(loadDataFirst) ctx.Invoices.Load();
Collection = ctx.Invoices.Local;
}
现在通过使用Get
方法而不首先加载数据,您的Collection
仍然很好地绑定到Local
缓存(应该是空的)。在向Collection
添加新项目后,Local
将自动添加这些项目,Save
可以直接调用SaveChanges
:
private void Save() {
ctx.SaveChanges();
}
Get
方法应该在构造函数中使用,像这样替换this.Collection = new ObservableCollection<Invoice>();
:
public InvoiceViewModel() {
Get(false);
}