关于C#的数据绑定，存取数据库实例详解 （二）

我首先实现了显示的功能（不用去读数据库，将数据直接填到集合里面，通过数据绑定，在界面能都显示出来），所以我应该是从Model和View层开始的。

首先是MainWindow.xaml 界面，代码和界面如下。

有5处关于数据绑定的：

　　1）ListBox 绑定 InlineTools（这是tool的集合，从数据库中获取所有的tools）但显示的只是Name。

　　2）SelectedItem绑定的是CurrentInlineTool,当选中其中一条tool时，CurrentInlineTool就是你当前选中的tool。

　　3) TextBox绑定的是CreateNewTool.Name，当创建一个新的tool时，其Name可以通过用户输入的方式命名。

      4）两个Buttton分别绑定CreateCommand和DeleteCommand。新建一个tool以及删除一个tool.

    <Grid Margin="10">
        <TabControl>
            <TabItem  Header="Equipment">
                <Grid >
                    <Grid.ColumnDefinitions >
                        <ColumnDefinition Width="220"></ColumnDefinition>
                        <ColumnDefinition Width="*">
                        </ColumnDefinition>
                    </Grid.ColumnDefinitions>
                    <Grid.RowDefinitions >
                        <RowDefinition Height="40"></RowDefinition>
                        <RowDefinition Height="*"></RowDefinition>
                        <RowDefinition Height="30"></RowDefinition>
                    </Grid.RowDefinitions>
                    <ListView Margin="5" Grid.RowSpan="2" ItemsSource="{Binding InlineTools}"  SelectedItem="{Binding CurrentInlineTool,Mode=TwoWay,UpdateSourceTrigger=PropertyChanged }" DisplayMemberPath="Name" ></ListView>
                    <WrapPanel Grid.Column="0" Grid.Row="2"  >
                        <!--<Border Height="20" Margin="4,0,0,0" Width="80" BorderBrush="Black"  BorderThickness="1"></Border>-->
                        <TextBox   Text="{Binding CreateNewTool.Name,Mode=TwoWay }"  Height="30" Width="80"  ></TextBox>
                        <Button Margin="6,0,0,0" Content="Create" Height="30"   Width="60" Command="{Binding CreateCommand}"></Button>
                        <Button Margin="6,0,0,0" Content="Delete" Height="30" Width="60" Command="{Binding DeleteCommand}"></Button>
                    </WrapPanel>
                </Grid>
            </TabItem>
            <TabItem  Header="Dispatching">
            </TabItem>
        </TabControl>
    </Grid>

InlineToolModel.cs代码如下，开始写的时候只写了前两个字段用来创建数据库，后面的方法是用到的时候添加上去的。

using CIS.DAL;
using Microsoft.Practices.Prism.Mvvm;
using SQL.DAL.Model;
using SQL.DAL.Repository;
using SQLtest.Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SQLtest.Model
{
   public  class InlineToolModel:BindableBase, IEntity
    {
        public int Id
        {
            get;
            set;
        }
        private string name;
        public string Name
        {
            get { return name; }
            set
            {
                if (name != value)
                {
                    name = value;
                    this.OnPropertyChanged("name");
                }
            }
        }

        public void SaveTool()
        {
            if (string.IsNullOrEmpty(this.Name))
            {
                throw new Exception("用户名不能为空!");
            }
            if (this.IsExistSameName())
            {
                throw new Exception("已存在同名用户!");
            }
            InlineToolModel tool= new InlineToolModel();
            tool.Name  = this.Name;
            CISDbContext db = new CISDbContext();
            db.t_InlineToolModel.Add(tool);
            db.SaveChanges();
        }
        public void DeleteTool()
        {
            InlineToolModel tool = new InlineToolModel();
            tool.Name = this.Name;
            CISDbContext db = new CISDbContext();
            var dblog = db.t_InlineToolModel.FirstOrDefault(d => d.Name == tool.Name);

            if (dblog != null)
            {
                db.t_InlineToolModel.Remove(dblog);
                db.SaveChanges();
            }
        }
        public bool IsExistSameName()
        {
            CISDbContext db = new CISDbContext();
            Repository<InlineToolModel> oRep = new Repository<InlineToolModel>(db);
            var exists = oRep.GetAll().Where(d => d.Name == this.Name && d.Id != this.Id);
            return exists.Count() > 0;
        }
        public InlineToolModel()
        {          
        }
    }
}

MainWindowViewModel.cs代码如下，在此一定要注意实例化，不然总是会出错。里面定义了InlineTools,CurrentInlineTool ,CreateNewTool,CreateCommand和DeleteCommand，与数据绑定有关。

using CIS.DAL;
using Microsoft.Practices.Prism.Commands;
using Microsoft.Practices.Prism.Mvvm;
using SQL.DAL.Repository;
using SQLtest.Model;
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data.Entity;
using System.Data.Entity.Validation;
using System.Linq;
using System.Text;

using System.Threading.Tasks;
using System.Windows;

namespace SQLtest.Model
{
    public class MainWindowViewModel : BindableBase
    {
        private ObservableCollection<InlineToolModel> inlineTools;
        public ObservableCollection<InlineToolModel> InlineTools
        {
            get { return inlineTools; }
            set
            {
                inlineTools = value;
                this.OnPropertyChanged(() => InlineTools);
            }
        }
        private InlineToolModel currentTool;
        public InlineToolModel CurrentInlineTool
        {
            get { return currentTool; }
            set
            {
                currentTool = value;
                this.OnPropertyChanged(() => CurrentInlineTool);
            }
        }
        private InlineToolModel createNewTool;
        public InlineToolModel CreateNewTool
        {
            get { return createNewTool; }
            set
            {
                createNewTool = value;
                this.OnPropertyChanged(() => CreateNewTool);
            }
        }

        public static DelegateCommand<object> CreateCommand { get; set; }
        public static DelegateCommand<object> DeleteCommand { get; set; }
        public MainWindowViewModel()
        {
            this.DataRefresh();
            CreateCommand = new DelegateCommand<object>(OnCreate);
            DeleteCommand = new DelegateCommand<object>(OnDelete);
            CreateNewTool= new Model.InlineToolModel();

        }

        public void OnCreate(object e)
        {
            try
            {
                CreateNewTool.SaveTool();//检查有无重名和空，CreateNewTool.SaveTest(CreateNewTool.Name)
                this.DataRefresh();
            }
            catch (System.Exception ex)
            {
                MessageBox.Show(string.Format("{0}", ex.Message));
            }
        }
        public void OnDelete(object e)
        {
            if (CurrentInlineTool == null) return;
            if (MessageBox.Show(string.Format("Delete Tool:{0}?", CurrentInlineTool.Name), "Delete", MessageBoxButton.OKCancel) == MessageBoxResult.OK)
            {
                CurrentInlineTool.DeleteTool();
            }
            DataRefresh();
        }
        public void DataRefresh()
        {
            InlineTools = new ObservableCollection<InlineToolModel>();
            CISDbContext db = new CISDbContext();
            Repository<InlineToolModel> oRep = new Repository<InlineToolModel>(db);
            foreach (var item in oRep.GetAll())
            {
                InlineTools.Add(item);
            }
        }
    }           
}