来到UI层编写了，由于三层的架构体系，所以UI层只需要和BLL层沟通就好。(BLL层和DAL层交互，DAL层与底层数据库交互)，关于DAL层的编码和BLL层编码实现过程，请参考前面的文章。
先来看看最终效果：（这里只能抛砖引玉，小虫我在界面美观上没有仔细用功，这一点大家千万不能也如此不重视，好的编程人员在UI上也要起码的让客户看上去舒服，这一点我做得很不够。所以后面的界面效果望大家能见谅！）
数据库已经切换了（目前只有Access数据库和SqlServer数据库）
实际上就是实现了用户的增删改和按部门查询的功能，加上了一个鸡肋(数据库切换)（对app.config的配置更新还是有了解的必要）。
<实际上是不存在此需求，具体的一个客户端只选择一种固定数据库的。这里仅仅为了测试方便，硬加上的。>
(其他的比如对部门的增删改功能和组合查询等就省略了。)
接下来，看看实现的过程：(首先界面需要的控件如图)
这里说明一下：控件的命名，后续代码看起来明白些。
| 序号 | 控件名[类型名] | 位置 | 备注 |
| 1 | cboAllDepts | 最上面的ComboBox | |
| 2 | bndingNavigator1 |  |
其属性DataSource=sourceUsers |
| 3 | dgvUsers[DataGridView控件] |  |
dgvUsers.DataSource=sourceUsers 请注意：姓名这一列的命名为：colName，因为后续要编码。 |
| 4 | sourceUsers[BindingSource] |  |
非可视化控件(运行时看不见的控件) sourcUsers.Current获取当前的项 |
| 5 |  |
txtName.Tag=”姓名不能为空!” 为了与errorMsg控件配合显示错误用 ComboBox控件的DropDownStyle=DropDownList属性，这样不可能为空。(FormLoad事件) |
|
| 6 |  |
txtNameAdd.Tag=”姓名不能为空！” 为了与errorMsg控件配合显示错误用 |
|
| 7 | errorMsg[ErrorProvider] |  |
用来在指定控件右边显示错误图标和指定的错误信息 SetError方法、GetError方法 |
| 8 | msgHelp[ErrorProvider] |  |
用来显示添加成功的图标！
|
切换后台数据库：
App.config代码
1 <?xml version="1.0" encoding="utf-8" ?>
2 <configuration>
3 <appSettings>
4 <add key="ProviderType" value="Sql"/>
5 </appSettings>
6 <connectionStrings>
7 <add name="DBConnString"
8 connectionString="Data Source=.\sqlexpress;Initial Catalog=testdb;Integrated Security=True"/>
9 </connectionStrings>
10 </configuration>
11 <!--
12 <?xml version="1.0" encoding="utf-8" ?>
13 <configuration>z
14 <appSettings>
15 <add key="ProviderType" value="Access"/>
16 </appSettings>
17 <connectionStrings>
18 <add name="DBConnString"
19 connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\netStudy\抽象工厂模式\testdb.mdb"/>
20 </connectionStrings>
21 </configuration>
22 -->
其实就只需要更改：<appSettings>节点的key[ProviderType]的Value值、<connectionStrings>节点的name[DBConnString]的connectionString。
操控XML文档可以用System.Xml命名空间的类。这里提供另外一种方法(读写文件替换)
首先建立一个模板AppTemplate.xml，内容如下：
程序运行的时候读取该文件，将%ProviderType%和%DBConnString%替换成合适的内容，然后将该内容保存到App.config中就可以了。
见上图：
1.读取模板 2.替换特别字符串 3.写入到app.config
4.ConfigurationManager.RefreshSection一定不要忘记，它会强制从磁盘重新读取。否则读取的是缓存内容<要重启程序才能生效>。 
注意：程序如果处在调试状态，你要看到效果：对应的config文件是vshost.exe.config，但程序独立运行不调试的时候，代码要换为：.config。
总之要留心这个问题。（调试和独立运行对应的config文件不同。）
正式基于这点，又上网查询了下，有牛人给出了更好的解决方案<见下图方法：ChangeConfiguration()>，
一来会自动解决调试和独立运行的config文件，二来不要模板文件(读写都不需要)。 实现的直接替换。
在运行测试的过程中，发生了一些异常，主要是Access数据库sql语句访问的一些特殊地方。
对比一下：SqlUserProvider.cs中对应的代码：
参考代码：
Form1.cs代码：
View Code
1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Text;
7 using System.Windows.Forms;
8 using 抽象工厂模式.BLL;
9 using System.Configuration;
10
11 namespace 抽象工厂模式
12 {
13 public partial class Form1 : Form
14 {
15 public Form1()
16 {
17 InitializeComponent();
18 }
19
20 private void Form1_Load(object sender, EventArgs e)
21 {
22 sourceUsers.DataSource = UserObj.GetUsers();//获得所有的用户
23 cboDepts.ValueMember = "Id"; //comboBox显示的内容实际关联的值(一般是主键值，通过它后台编码)
24 cboDepts.DisplayMember = "Name"; //comboBox显示的内容
25 var depts = DepartmentObj.GetDepartments();//获得所有的部门<用depts遍历来获取数据库获取的集合>
26 cboDepts.DataSource = depts;//depts集合中的每一个元素类型是 DepartmentObj---对应于ComboBox的每一项
27
28 cboDeptAdd.ValueMember = "Id";
29 cboDeptAdd.DisplayMember = "Name";
30 //不推荐这么写：cboDeptAdd.DataSource=DepartmentObj.GetDepartments();因为避免再次后台访问
31 var deptArrays = depts.ToArray(); //将集合depts复制到新数组deptArray中
32 cboDeptAdd.DataSource = deptArrays;
33
34
35 cboAllDepts.ValueMember = "Id";
36 cboAllDepts.DisplayMember = "Name";
37 depts.Insert(0,new DepartmentObj(0,"所有部门",""));//上1：为了下拉能显示<所有部门>，注意这里
38 cboAllDepts.DataSource = depts.ToArray(); //下2：提示<上1和下2这两行代码不能交换>，因为组合框一旦绑定后，不允许再手动更改Items的元素
39 }
40
41 private void btnEdit_Click(object sender, EventArgs e)
42 {
43 if (txtName.Text.Trim() == "")//验证<姓名不能为空>
44 {
45 errorMsg.SetError(txtName, txtName.Tag.ToString());//设置txtName控件显示错误图标(错误字符串)
46 return;
47 }
48 else
49 errorMsg.SetError(txtName, "");//隐藏错误图标
50 var obj = this.sourceUsers.Current as UserObj; //获得当前的用户域对象 UserObj
51 if (obj == null) return;
52 //更新用户的方法
53 UserObj.UpdateUserObj(obj.Id, obj.Name,
54 (cboDepts.SelectedItem as DepartmentObj).Id //找到选择的部门对象的主键
55 );
56 }
57
58 private void btnInsert_Click(object sender, EventArgs e)
59 {
60 if (txtNameAdd.Text.Trim() == "")//验证<姓名不能为空>
61 {
62 errorMsg.SetError(txtNameAdd, txtNameAdd.Tag.ToString());//设置txtNameAdd控件显示错误图标(错误字符串)
63 return;
64 }
65 else
66 errorMsg.SetError(txtNameAdd, "");//隐藏错误图标
67 UserObj.InsertUserObj((int)cboDeptAdd.SelectedValue, txtNameAdd.Text);//添加用户记录的方法
68 msgHelp.SetError(btnInsert, "添加成功");//显示成功图标
69 txtNameAdd.Text = ""; //清空txtNameAdd的文本
70
71 UsersRefresh();//刷新获得最新数据
72
73 }
74
75
76 private void txtNameAdd_TextChanged(object sender, EventArgs e)
77 {
78 if (msgHelp.GetError(btnInsert) != "") msgHelp.SetError(btnInsert, "");
79 }
80
81
82 private void cboAllDepts_SelectedIndexChanged(object sender, EventArgs e)
83 {
84 if (cboAllDepts.SelectedItem != null) UsersRefresh();
85 }
86
87 /// <summary>
88 /// 根据所选择部门获得对应的用户列表
89 /// </summary>
90 private void UsersRefresh()
91 {
92 int deptId = (int)cboAllDepts.SelectedValue;
93 if (deptId == 0)
94 sourceUsers.DataSource = UserObj.GetUsers(); //显示所有用户
95 else
96 sourceUsers.DataSource = UserObj.GetUsers(deptId);//显示对应部门的用户
97 }
98
99 private void tsbtnDelete_Click(object sender, EventArgs e)
100 {
101 if (MessageBox.Show("是否删除该记录？", "确认", MessageBoxButtons.OKCancel) ==
102 System.Windows.Forms.DialogResult.OK)
103 {
104 var obj = sourceUsers.Current as UserObj;
105 UserObj.DeleteUserObj(obj.Id); //删除该用户
106 UsersRefresh(); //刷新数据
107 }
108 }
109
110 private void tsbtnRefresh_Click(object sender, EventArgs e)
111 {
112 UsersRefresh();
113 }
114
115 private void tsbtnChangeDb_Click(object sender, EventArgs e)
116 {
117 try
118 {
119 Helper.ChangeDbServer();//切换数据库(Access与SqlServer切换)
120 UserObj.ChangeDB();
121 UsersRefresh();
122 }
123 catch (Exception ex)
124 {
125
126 MessageBox.Show(ex.Message);
127 }
128 }
129
130 private void toolStripButton1_Click(object sender, EventArgs e)
131 {
132 Helper.ChangeConfiguration(); //切换数据库(Access与SqlServer切换)
133 UserObj.ChangeDB();
134 UsersRefresh();
135 }
136
137
138 private void dgvUsers_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
139 {
140 string tipError = "";
141 var user= dgvUsers.Rows[e.RowIndex].DataBoundItem as UserObj;//获得当前选中的用户对象
142 if (user != null && string.IsNullOrEmpty(user.Name))
143 {
144 tipError = "姓名不能为空！";
145 dgvUsers.Rows[e.RowIndex].Cells["colName"].ErrorText = tipError;
146 }
147 errorMsg.SetError(txtName, tipError);
148 }
149
150
151 }
152 }
Form1.Designer.cs代码如下：
namespace 抽象工厂模式
{
partial class Form1
{
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// Clean up any resources being used.
/// </summary>
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
this.label1 = new System.Windows.Forms.Label();
this.txtName = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.cboDepts = new System.Windows.Forms.ComboBox();
this.btnEdit = new System.Windows.Forms.Button();
this.errorMsg = new System.Windows.Forms.ErrorProvider(this.components);
this.cboDeptAdd = new System.Windows.Forms.ComboBox();
this.txtNameAdd = new System.Windows.Forms.TextBox();
this.btnInsert = new System.Windows.Forms.Button();
this.label3 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.msgHelp = new System.Windows.Forms.ErrorProvider(this.components);
this.panel1 = new System.Windows.Forms.Panel();
this.panel3 = new System.Windows.Forms.Panel();
this.dgvUsers = new System.Windows.Forms.DataGridView();
this.bindingNavigator1 = new System.Windows.Forms.BindingNavigator(this.components);
this.bindingNavigatorCountItem = new System.Windows.Forms.ToolStripLabel();
this.bindingNavigatorMoveFirstItem = new System.Windows.Forms.ToolStripButton();
this.bindingNavigatorMovePreviousItem = new System.Windows.Forms.ToolStripButton();
this.bindingNavigatorSeparator = new System.Windows.Forms.ToolStripSeparator();
this.bindingNavigatorPositionItem = new System.Windows.Forms.ToolStripTextBox();
this.bindingNavigatorSeparator1 = new System.Windows.Forms.ToolStripSeparator();
this.bindingNavigatorMoveNextItem = new System.Windows.Forms.ToolStripButton();
this.bindingNavigatorMoveLastItem = new System.Windows.Forms.ToolStripButton();
this.bindingNavigatorSeparator2 = new System.Windows.Forms.ToolStripSeparator();
this.tsbtnDelete = new System.Windows.Forms.ToolStripButton();
this.tsbtnRefresh = new System.Windows.Forms.ToolStripButton();
this.tsbtnChangeDb = new System.Windows.Forms.ToolStripButton();
this.panel2 = new System.Windows.Forms.Panel();
this.cboAllDepts = new System.Windows.Forms.ComboBox();
this.label5 = new System.Windows.Forms.Label();
this.toolStripButton1 = new System.Windows.Forms.ToolStripButton();
this.colId = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.colName = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.deptTitleDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.sourceUsers = new System.Windows.Forms.BindingSource(this.components);
((System.ComponentModel.ISupportInitialize)(this.errorMsg)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.msgHelp)).BeginInit();
this.panel1.SuspendLayout();
this.panel3.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dgvUsers)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.bindingNavigator1)).BeginInit();
this.bindingNavigator1.SuspendLayout();
this.panel2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.sourceUsers)).BeginInit();
this.SuspendLayout();
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(75, 402);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(41, 12);
this.label1.TabIndex = 2;
this.label1.Text = "姓名：";
//
// txtName
//
this.txtName.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.sourceUsers, "Name", true));
this.errorMsg.SetIconPadding(this.txtName, 5);
this.txtName.Location = new System.Drawing.Point(113, 399);
this.txtName.Name = "txtName";
this.txtName.Size = new System.Drawing.Size(100, 21);
this.txtName.TabIndex = 3;
this.txtName.Tag = "姓名不能为空！";
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(75, 429);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(41, 12);
this.label2.TabIndex = 4;
this.label2.Text = "部门：";
//
// cboDepts
//
this.cboDepts.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.sourceUsers, "DeptTitle", true));
this.cboDepts.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cboDepts.FormattingEnabled = true;
this.errorMsg.SetIconPadding(this.cboDepts, 5);
this.cboDepts.Location = new System.Drawing.Point(113, 426);
this.cboDepts.Name = "cboDepts";
this.cboDepts.Size = new System.Drawing.Size(100, 20);
this.cboDepts.TabIndex = 6;
this.cboDepts.Tag = "部门不能为空！";
//
// btnEdit
//
this.btnEdit.Location = new System.Drawing.Point(152, 461);
this.btnEdit.Name = "btnEdit";
this.btnEdit.Size = new System.Drawing.Size(61, 23);
this.btnEdit.TabIndex = 7;
this.btnEdit.Text = "修改";
this.btnEdit.UseVisualStyleBackColor = true;
this.btnEdit.Click += new System.EventHandler(this.btnEdit_Click);
//
// errorMsg
//
this.errorMsg.ContainerControl = this;
//
// cboDeptAdd
//
this.cboDeptAdd.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cboDeptAdd.FormattingEnabled = true;
this.errorMsg.SetIconPadding(this.cboDeptAdd, 5);
this.cboDeptAdd.Location = new System.Drawing.Point(304, 426);
this.cboDeptAdd.Name = "cboDeptAdd";
this.cboDeptAdd.Size = new System.Drawing.Size(100, 20);
this.cboDeptAdd.TabIndex = 11;
this.cboDeptAdd.Tag = "部门不能为空！";
//
// txtNameAdd
//
this.errorMsg.SetIconPadding(this.txtNameAdd, 5);
this.txtNameAdd.Location = new System.Drawing.Point(304, 399);
this.txtNameAdd.Name = "txtNameAdd";
this.txtNameAdd.Size = new System.Drawing.Size(100, 21);
this.txtNameAdd.TabIndex = 9;
this.txtNameAdd.Tag = "姓名不能为空！";
this.txtNameAdd.TextChanged += new System.EventHandler(this.txtNameAdd_TextChanged);
//
// btnInsert
//
this.errorMsg.SetIconPadding(this.btnInsert, 5);
this.btnInsert.Location = new System.Drawing.Point(339, 461);
this.btnInsert.Name = "btnInsert";
this.btnInsert.Size = new System.Drawing.Size(65, 26);
this.btnInsert.TabIndex = 12;
this.btnInsert.Text = "添加";
this.btnInsert.UseVisualStyleBackColor = true;
this.btnInsert.Click += new System.EventHandler(this.btnInsert_Click);
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(266, 429);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(41, 12);
this.label3.TabIndex = 10;
this.label3.Text = "部门：";
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(266, 402);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(41, 12);
this.label4.TabIndex = 8;
this.label4.Text = "姓名：";
//
// msgHelp
//
this.msgHelp.ContainerControl = this;
this.msgHelp.Icon = ((System.Drawing.Icon)(resources.GetObject("msgHelp.Icon")));
//
// panel1
//
this.panel1.Controls.Add(this.panel3);
this.panel1.Controls.Add(this.panel2);
this.panel1.Dock = System.Windows.Forms.DockStyle.Top;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(613, 368);
this.panel1.TabIndex = 13;
//
// panel3
//
this.panel3.Controls.Add(this.dgvUsers);
this.panel3.Controls.Add(this.bindingNavigator1);
this.panel3.Dock = System.Windows.Forms.DockStyle.Fill;
this.panel3.Location = new System.Drawing.Point(0, 34);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(613, 334);
this.panel3.TabIndex = 5;
//
// dgvUsers
//
this.dgvUsers.AutoGenerateColumns = false;
this.dgvUsers.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dgvUsers.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.colId,
this.colName,
this.deptTitleDataGridViewTextBoxColumn});
this.dgvUsers.DataSource = this.sourceUsers;
this.dgvUsers.Dock = System.Windows.Forms.DockStyle.Fill;
this.dgvUsers.Location = new System.Drawing.Point(0, 25);
this.dgvUsers.Name = "dgvUsers";
this.dgvUsers.RowTemplate.Height = 23;
this.dgvUsers.Size = new System.Drawing.Size(613, 309);
this.dgvUsers.TabIndex = 4;
this.dgvUsers.CellMouseClick += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.dgvUsers_CellMouseClick);
//
// bindingNavigator1
//
this.bindingNavigator1.AddNewItem = null;
this.bindingNavigator1.BindingSource = this.sourceUsers;
this.bindingNavigator1.CountItem = this.bindingNavigatorCountItem;
this.bindingNavigator1.DeleteItem = null;
this.bindingNavigator1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
this.bindingNavigatorMoveFirstItem,
this.bindingNavigatorMovePreviousItem,
this.bindingNavigatorSeparator,
this.bindingNavigatorPositionItem,
this.bindingNavigatorCountItem,
this.bindingNavigatorSeparator1,
this.bindingNavigatorMoveNextItem,
this.bindingNavigatorMoveLastItem,
this.bindingNavigatorSeparator2,
this.tsbtnDelete,
this.tsbtnRefresh,
this.tsbtnChangeDb,
this.toolStripButton1});
this.bindingNavigator1.Location = new System.Drawing.Point(0, 0);
this.bindingNavigator1.MoveFirstItem = this.bindingNavigatorMoveFirstItem;
this.bindingNavigator1.MoveLastItem = this.bindingNavigatorMoveLastItem;
this.bindingNavigator1.MoveNextItem = this.bindingNavigatorMoveNextItem;
this.bindingNavigator1.MovePreviousItem = this.bindingNavigatorMovePreviousItem;
this.bindingNavigator1.Name = "bindingNavigator1";
this.bindingNavigator1.PositionItem = this.bindingNavigatorPositionItem;
this.bindingNavigator1.Size = new System.Drawing.Size(613, 25);
this.bindingNavigator1.TabIndex = 3;
this.bindingNavigator1.Text = "bindingNavigator1";
//
// bindingNavigatorCountItem
//
this.bindingNavigatorCountItem.Name = "bindingNavigatorCountItem";
this.bindingNavigatorCountItem.Size = new System.Drawing.Size(35, 22);
this.bindingNavigatorCountItem.Text = "/ {0}";
this.bindingNavigatorCountItem.ToolTipText = "总项数";
//
// bindingNavigatorMoveFirstItem
//
this.bindingNavigatorMoveFirstItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
this.bindingNavigatorMoveFirstItem.Image = ((System.Drawing.Image)(resources.GetObject("bindingNavigatorMoveFirstItem.Image")));
this.bindingNavigatorMoveFirstItem.Name = "bindingNavigatorMoveFirstItem";
this.bindingNavigatorMoveFirstItem.RightToLeftAutoMirrorImage = true;
this.bindingNavigatorMoveFirstItem.Size = new System.Drawing.Size(23, 22);
this.bindingNavigatorMoveFirstItem.Text = "移到第一条记录";
//
// bindingNavigatorMovePreviousItem
//
this.bindingNavigatorMovePreviousItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
this.bindingNavigatorMovePreviousItem.Image = ((System.Drawing.Image)(resources.GetObject("bindingNavigatorMovePreviousItem.Image")));
this.bindingNavigatorMovePreviousItem.Name = "bindingNavigatorMovePreviousItem";
this.bindingNavigatorMovePreviousItem.RightToLeftAutoMirrorImage = true;
this.bindingNavigatorMovePreviousItem.Size = new System.Drawing.Size(23, 22);
this.bindingNavigatorMovePreviousItem.Text = "移到上一条记录";
//
// bindingNavigatorSeparator
//
this.bindingNavigatorSeparator.Name = "bindingNavigatorSeparator";
this.bindingNavigatorSeparator.Size = new System.Drawing.Size(6, 25);
//
// bindingNavigatorPositionItem
//
this.bindingNavigatorPositionItem.AccessibleName = "位置";
this.bindingNavigatorPositionItem.AutoSize = false;
this.bindingNavigatorPositionItem.Name = "bindingNavigatorPositionItem";
this.bindingNavigatorPositionItem.Size = new System.Drawing.Size(50, 21);
this.bindingNavigatorPositionItem.Text = "0";
this.bindingNavigatorPositionItem.ToolTipText = "当前位置";
//
// bindingNavigatorSeparator1
//
this.bindingNavigatorSeparator1.Name = "bindingNavigatorSeparator1";
this.bindingNavigatorSeparator1.Size = new System.Drawing.Size(6, 25);
//
// bindingNavigatorMoveNextItem
//
this.bindingNavigatorMoveNextItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
this.bindingNavigatorMoveNextItem.Image = ((System.Drawing.Image)(resources.GetObject("bindingNavigatorMoveNextItem.Image")));
this.bindingNavigatorMoveNextItem.Name = "bindingNavigatorMoveNextItem";
this.bindingNavigatorMoveNextItem.RightToLeftAutoMirrorImage = true;
this.bindingNavigatorMoveNextItem.Size = new System.Drawing.Size(23, 22);
this.bindingNavigatorMoveNextItem.Text = "移到下一条记录";
//
// bindingNavigatorMoveLastItem
//
this.bindingNavigatorMoveLastItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
this.bindingNavigatorMoveLastItem.Image = ((System.Drawing.Image)(resources.GetObject("bindingNavigatorMoveLastItem.Image")));
this.bindingNavigatorMoveLastItem.Name = "bindingNavigatorMoveLastItem";
this.bindingNavigatorMoveLastItem.RightToLeftAutoMirrorImage = true;
this.bindingNavigatorMoveLastItem.Size = new System.Drawing.Size(23, 22);
this.bindingNavigatorMoveLastItem.Text = "移到最后一条记录";
//
// bindingNavigatorSeparator2
//
this.bindingNavigatorSeparator2.Name = "bindingNavigatorSeparator2";
this.bindingNavigatorSeparator2.Size = new System.Drawing.Size(6, 25);
//
// tsbtnDelete
//
this.tsbtnDelete.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
this.tsbtnDelete.Image = ((System.Drawing.Image)(resources.GetObject("tsbtnDelete.Image")));
this.tsbtnDelete.ImageTransparentColor = System.Drawing.Color.Magenta;
this.tsbtnDelete.Name = "tsbtnDelete";
this.tsbtnDelete.Size = new System.Drawing.Size(23, 22);
this.tsbtnDelete.Text = "toolStripButton1";
this.tsbtnDelete.ToolTipText = "删除用户";
this.tsbtnDelete.Click += new System.EventHandler(this.tsbtnDelete_Click);
//
// tsbtnRefresh
//
this.tsbtnRefresh.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
this.tsbtnRefresh.Image = ((System.Drawing.Image)(resources.GetObject("tsbtnRefresh.Image")));
this.tsbtnRefresh.ImageTransparentColor = System.Drawing.Color.Magenta;
this.tsbtnRefresh.Name = "tsbtnRefresh";
this.tsbtnRefresh.Size = new System.Drawing.Size(23, 22);
this.tsbtnRefresh.Text = "toolStripButton2";
this.tsbtnRefresh.ToolTipText = "刷新";
this.tsbtnRefresh.Click += new System.EventHandler(this.tsbtnRefresh_Click);
//
// tsbtnChangeDb
//
this.tsbtnChangeDb.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
this.tsbtnChangeDb.Image = ((System.Drawing.Image)(resources.GetObject("tsbtnChangeDb.Image")));
this.tsbtnChangeDb.ImageTransparentColor = System.Drawing.Color.Magenta;
this.tsbtnChangeDb.Name = "tsbtnChangeDb";
this.tsbtnChangeDb.Size = new System.Drawing.Size(23, 22);
this.tsbtnChangeDb.Text = "toolStripButton1";
this.tsbtnChangeDb.ToolTipText = "切换数据库";
this.tsbtnChangeDb.Click += new System.EventHandler(this.tsbtnChangeDb_Click);
//
// panel2
//
this.panel2.Controls.Add(this.cboAllDepts);
this.panel2.Controls.Add(this.label5);
this.panel2.Dock = System.Windows.Forms.DockStyle.Top;
this.panel2.Location = new System.Drawing.Point(0, 0);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(613, 34);
this.panel2.TabIndex = 4;
//
// cboAllDepts
//
this.cboAllDepts.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cboAllDepts.FormattingEnabled = true;
this.cboAllDepts.Location = new System.Drawing.Point(77, 4);
this.cboAllDepts.Name = "cboAllDepts";
this.cboAllDepts.Size = new System.Drawing.Size(181, 20);
this.cboAllDepts.TabIndex = 1;
this.cboAllDepts.SelectedIndexChanged += new System.EventHandler(this.cboAllDepts_SelectedIndexChanged);
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(7, 9);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(77, 12);
this.label5.TabIndex = 0;
this.label5.Text = "请选择部门：";
//
// toolStripButton1
//
this.toolStripButton1.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Text;
this.toolStripButton1.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton1.Image")));
this.toolStripButton1.ImageTransparentColor = System.Drawing.Color.Magenta;
this.toolStripButton1.Name = "toolStripButton1";
this.toolStripButton1.Size = new System.Drawing.Size(69, 22);
this.toolStripButton1.Text = "切换数据库";
this.toolStripButton1.Click += new System.EventHandler(this.toolStripButton1_Click);
//
// colId
//
this.colId.DataPropertyName = "Id";
this.colId.HeaderText = "主键";
this.colId.Name = "colId";
this.colId.ReadOnly = true;
//
// colName
//
this.colName.DataPropertyName = "Name";
this.colName.HeaderText = "姓名";
this.colName.Name = "colName";
//
// deptTitleDataGridViewTextBoxColumn
//
this.deptTitleDataGridViewTextBoxColumn.DataPropertyName = "DeptTitle";
this.deptTitleDataGridViewTextBoxColumn.HeaderText = "部门";
this.deptTitleDataGridViewTextBoxColumn.Name = "deptTitleDataGridViewTextBoxColumn";
this.deptTitleDataGridViewTextBoxColumn.ReadOnly = true;
//
// sourceUsers
//
this.sourceUsers.AllowNew = false;
this.sourceUsers.DataSource = typeof(抽象工厂模式.BLL.UserObj);
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(613, 549);
this.Controls.Add(this.panel1);
this.Controls.Add(this.btnInsert);
this.Controls.Add(this.cboDeptAdd);
this.Controls.Add(this.label3);
this.Controls.Add(this.txtNameAdd);
this.Controls.Add(this.label4);
this.Controls.Add(this.btnEdit);
this.Controls.Add(this.cboDepts);
this.Controls.Add(this.label2);
this.Controls.Add(this.txtName);
this.Controls.Add(this.label1);
this.Name = "Form1";
this.Text = "测试";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.errorMsg)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.msgHelp)).EndInit();
this.panel1.ResumeLayout(false);
this.panel3.ResumeLayout(false);
this.panel3.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dgvUsers)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.bindingNavigator1)).EndInit();
this.bindingNavigator1.ResumeLayout(false);
this.bindingNavigator1.PerformLayout();
this.panel2.ResumeLayout(false);
this.panel2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.sourceUsers)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
#endregion
private System.Windows.Forms.BindingSource sourceUsers;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.TextBox txtName;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.ComboBox cboDepts;
private System.Windows.Forms.ErrorProvider errorMsg;
private System.Windows.Forms.Button btnEdit;
private System.Windows.Forms.ComboBox cboDeptAdd;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.TextBox txtNameAdd;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.ErrorProvider msgHelp;
private System.Windows.Forms.Button btnInsert;
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.BindingNavigator bindingNavigator1;
private System.Windows.Forms.ToolStripLabel bindingNavigatorCountItem;
private System.Windows.Forms.ToolStripButton bindingNavigatorMoveFirstItem;
private System.Windows.Forms.ToolStripButton bindingNavigatorMovePreviousItem;
private System.Windows.Forms.ToolStripSeparator bindingNavigatorSeparator;
private System.Windows.Forms.ToolStripTextBox bindingNavigatorPositionItem;
private System.Windows.Forms.ToolStripSeparator bindingNavigatorSeparator1;
private System.Windows.Forms.ToolStripButton bindingNavigatorMoveNextItem;
private System.Windows.Forms.ToolStripButton bindingNavigatorMoveLastItem;
private System.Windows.Forms.ToolStripSeparator bindingNavigatorSeparator2;
private System.Windows.Forms.ToolStripButton tsbtnDelete;
private System.Windows.Forms.Panel panel2;
private System.Windows.Forms.ComboBox cboAllDepts;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Panel panel3;
private System.Windows.Forms.DataGridView dgvUsers;
private System.Windows.Forms.ToolStripButton tsbtnRefresh;
private System.Windows.Forms.ToolStripButton tsbtnChangeDb;
private System.Windows.Forms.ToolStripButton toolStripButton1;
private System.Windows.Forms.DataGridViewTextBoxColumn colId;
private System.Windows.Forms.DataGridViewTextBoxColumn colName;
private System.Windows.Forms.DataGridViewTextBoxColumn deptTitleDataGridViewTextBoxColumn;
}
}
Help.cs代码：
View Code
1 using System;
2 using System.Collections.Generic;
3 using System.Text;
4 using System.IO;
5 using System.Configuration;
6 using System.Windows.Forms;
7 using System.Reflection;
8 namespace 抽象工厂模式
9 {
10 class Helper
11 {
12 private static string ProviderType = ConfigurationManager.AppSettings["ProviderType"];
13 private static string DBConnString =
14 ConfigurationManager.ConnectionStrings["DBConnString"].ConnectionString;
15 public static void ChangeDbServer()
16 {
17 SetConfig();
18 //可以采用System.Xml命名空间中的类
19
20 string content = File.ReadAllText(Application.StartupPath + "\\AppTemplate.xml");
21 content = content.Replace("%ProviderType%", ProviderType).Replace("%DBConnString%", DBConnString);
22
23 File.WriteAllText(Application.ExecutablePath + ".config", content);
24 // File.WriteAllText(Application.StartupPath + "\\抽象工厂模式.vshost.exe.config",content);
25
26 //强制刷新，避免重启程序
27 ConfigurationManager.RefreshSection("appSettings");
28 ConfigurationManager.RefreshSection("connectionStrings");
29 }
30
31 private static void SetConfig()
32 {
33 if (ProviderType.ToLower() == "sql")
34 {
35 ProviderType = "Access";
36 DBConnString =
37 @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\netStudy\抽象工厂模式\testdb.mdb";
38 }
39 else
40 {
41 ProviderType = "Sql";
42 DBConnString = @"Data Source=.\sqlexpress;Initial Catalog=testdb;Integrated Security=True";
43 }
44 }
45
46 public static void ChangeConfiguration()
47 {
48
49 SetConfig(); //读取程序集的配置文件
50
51 Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
52
53 //获取appSettings节点
54 AppSettingsSection appSettings = (AppSettingsSection)config.GetSection("appSettings");
55 appSettings.Settings["ProviderType"].Value = ProviderType;
56
57 var connectionSection = (ConnectionStringsSection)config.GetSection("connectionStrings");
58 connectionSection.ConnectionStrings["DBConnString"].ConnectionString = DBConnString;
59 //保存配置文件
60 config.Save();
61
62 //强制刷新，避免重启程序
63 ConfigurationManager.RefreshSection("appSettings");//刷新命名节，在下次检索它时将会从磁盘重新读取
64 ConfigurationManager.RefreshSection("connectionStrings");
65 }
66 }
67 }
AccessUserProvider的代码：
View Code
1 using System;
2 using System.Collections.Generic;
3 using System.Text;
4 using System.Data;
5 using System.Data.OleDb;
6 using 抽象工厂模式.DAL;
7 using 抽象工厂模式.DAL.Entity;
8
9 namespace 抽象工厂模式.DAL.Provider.Access
10 {
11 public class AccessUserProvider:UserProvider
12 {
13
14 public override List<User> GetUsers()
15 {
16 using (OleDbConnection conn = new OleDbConnection(ConnString))
17 {
18 var dbcmd = conn.CreateCommand();
19 dbcmd.CommandText = "GetUsers";
20 dbcmd.CommandType = CommandType.StoredProcedure;
21 conn.Open();
22 return GetUsersFromReader(dbcmd.ExecuteReader());
23 }
24 }
25
26 public override List<User> GetUsers(int deptId)
27 {
28 using (OleDbConnection conn = new OleDbConnection(ConnString))
29 {
30 var dbcmd = conn.CreateCommand();
31 dbcmd.CommandText = "GetUsersByDepartmentId";
32 dbcmd.CommandType = CommandType.StoredProcedure;
33 dbcmd.Parameters.Add("@DeptId", OleDbType.Integer).Value = deptId;
34 conn.Open();
35 return GetUsersFromReader(dbcmd.ExecuteReader());
36 }
37 }
38
39 public override User GetUserById(int id)
40 {
41 using (OleDbConnection conn = new OleDbConnection(ConnString))
42 {
43 var dbcmd = conn.CreateCommand();
44 dbcmd.CommandText = "GetUserById";
45 dbcmd.CommandType = CommandType.StoredProcedure;
46 dbcmd.Parameters.Add("@Id", OleDbType.Integer).Value =id ;
47 conn.Open();
48 var reader = dbcmd.ExecuteReader();
49 if (reader.Read()) return GetUserFromReader(reader); else return null;
50 }
51 }
52
53 public override bool DeleteUser(int id)
54 {
55 using (OleDbConnection conn = new OleDbConnection(ConnString))
56 {
57 OleDbCommand cmd = new OleDbCommand(
58 "delete from [user] where Id=" + id, conn);
59 conn.Open();
60 return cmd.ExecuteNonQuery() == 1;
61 }
62 }
63
64 public override int InsertUser(User user)
65 {
66 int result = 0;
67 using (OleDbConnection conn = new OleDbConnection(ConnString))
68 {
69 OleDbCommand cmd = new OleDbCommand(
70 @"insert into [user]([name],deptId) values(@name,@deptid);", conn);
71 cmd.Parameters.Add("@name", OleDbType.VarChar).Value = user.Name; //与下面的一行代码不能颠倒
72 cmd.Parameters.Add("@deptid", OleDbType.Integer).Value = user.DeptId;//access的sql语句参数必须按照顺序匹配
73 conn.Open();
74 var trans = conn.BeginTransaction();//执行数据库事务
75 cmd.Transaction = trans;
76 try
77 {
78
79 bool success = cmd.ExecuteNonQuery() == 1;
80 if (success)
81 {
82 cmd.CommandText = "select max(id) from [user] as newid;"; //由于access不支持多条语句一起执行，只好分多次<两次>执行
83 result = (int)cmd.ExecuteScalar();
84 trans.Commit(); //提交事务
85 }
86 }
87 catch (Exception)
88 {
89 trans.Rollback();//出现异常，回滚事务
90 }
91 }
92 return result;
93 }
94
95 public override bool UpdateUser(User user)
96 {
97 using (OleDbConnection conn = new OleDbConnection(ConnString))
98 {
99 OleDbCommand cmd = new OleDbCommand(
100 "update [user] set [name]=@name,deptId=@deptid where Id=@id" , conn);
101 cmd.Parameters.Add("@name", OleDbType.VarChar).Value = user.Name;
102 cmd.Parameters.Add("@deptid", OleDbType.Integer).Value = user.DeptId;
103 cmd.Parameters.Add("@id", OleDbType.Integer).Value = user.Id;
104 conn.Open();
105 return cmd.ExecuteNonQuery() == 1;
106 }
107 }
108
109 }
110 }