在空数据网格中添加行

本文关键字:添加行 网格 数据网 数据 | 更新日期: 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);
}