using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;
using?System.Data.OleDb;
using?System.Configuration;
using?System.Windows.Forms;
using?System.Collections;
using?System.Threading;
using?System.IO;
using?System.Drawing;

namespace?MenuDemo
{

????#region?數(shù)據(jù)適配器鏈表類
????public?class?SqlDataAdapterList
????{
????????//定義?表及其適配器的節(jié)點?結(jié)構(gòu)體
????????public?struct?SqlDataAdapterNode
????????{
????????????public?string?TableName;
????????????public?SqlDataAdapter?DA;
????????}

????????private?SqlDataAdapter?tempDA?=?new?SqlDataAdapter（）;
????????//定義?TableDataAdapter?的?List
????????private?List?Nodes?=?new?List（）;

????????//Add?節(jié)點
????????public?void?Add（string?TableName?SqlDataAdapter?DA）
????????{
????????????SqlDataAdapterNode?NewNode?=?new?SqlDataAdapterNode（）;
????????????NewNode.TableName?=?TableName;
????????????NewNode.DA?=?DA;
????????????//判斷該Node是否存在
????????????foreach?（SqlDataAdapterNode?Node?in?Nodes）
????????????{???//該節(jié)點已經(jīng)存在刪除
????????????????if?（Node.TableName?==?TableName）
????????????????{
????????????????????Nodes.Remove（Node）;
????????????????????break;
????????????????}
????????????}
????????????Nodes.Add（NewNode）;
????????}

????????//Del節(jié)點
????????public?void?Del（string?TableName）
????????{
????????????//判斷該Node是否存在
????????????foreach?（SqlDataAdapterNode?Node?in?Nodes）
????????????{???//該節(jié)點已經(jīng)存在刪除
????????????????if?（Node.TableName?==?TableName）
????????????????{
????????????????????Nodes.Remove（Node）;
????????????????????break;
????????????????}
????????????}
????????}

????????//查找節(jié)點的?SqlDataAdapter
????????public?SqlDataAdapter?FindDA（string?TableName）
????????{
????????????//判斷該Node是否存在
????????????foreach?（SqlDataAdapterNode?Node?in?Nodes）
????????????{????//該節(jié)點已經(jīng)存在
????????????????if?（Node.TableName?==?TableName）
????????????????{
????????????????????tempDA?=?Node.DA;
????????????????????break;
????????????????}
????????????}
????????????return?tempDA;
????????}
????}
????#endregion

????#region?數(shù)據(jù)訪問類?CDatabase
????public?class?CDatabase
????{
????????private?DataSet?DS;
????????private?SqlConnection?SqlConn;
????????public?string?DBServer?DBName?PWD;
????????private?SqlDataAdapter?tempDA;
????????SqlDataAdapterList?MySqlDataAdapterList?=?new?SqlDataAdapterList（）;

????????#region?構(gòu)造函數(shù)
????????//構(gòu)造函數(shù)讀取數(shù)據(jù)庫配置信息??LoginDBName?
????????public?CDatabase（）
????????{
????????????//讀取注冊表
????????????DBServer?=?Program.DBServer;
????????????DBName?=?Program.LoginDBName;
????????????PWD?=?Program.PWD;
????????????//連接字符串
????????????string?ConnStr?=?“user?id=sa;password=“?+?PWD?+?“;initial?catalog=“?+?DBName?+?“;data?source=“?+?DBServer?+?“;connect?Timeout=1“;
????????????SqlConn?=?new?SqlConnection（ConnStr）;
????????????try
????????????{
????????????????//SqlConn.Open（）;
????????????}
????????????catch?（Exception?ex）
?????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????913??2016-05-11?08:12??MenuDemo\MenuDemo.sln

????..A..H.?????19968??2016-05-20?10:23??MenuDemo\MenuDemo.suo

?????文件???15663104??2016-05-13?09:36??MenuDemo\Menu_Data.MDF

?????文件???????1694??2016-05-11?08:30??MenuDemo\Menu_Data.MDF.baiduyun.uploading.cfg

?????文件???18677760??2016-05-13?09:36??MenuDemo\Menu_Log.LDF

?????文件???????1694??2016-05-11?08:30??MenuDemo\Menu_Log.LDF.baiduyun.uploading.cfg

?????文件????????932??2016-05-11?08:28??MenuDemo\qmDataGridSet.sql

?????文件????????836??2016-05-11?08:28??MenuDemo\qmDict.sql

?????文件????????672??2016-05-11?08:28??MenuDemo\qmRole.sql

?????文件????????776??2016-05-11?08:28??MenuDemo\qmUser.sql

?????文件????????406??2016-05-11?08:44??MenuDemo\MenuDemo\app.config

?????文件??????36671??2016-05-12?22:57??MenuDemo\MenuDemo\CDatabase.cs

?????文件??????68233??2016-05-11?08:22??MenuDemo\MenuDemo\COtherAid.cs

?????文件???????3835??2016-05-12?22:57??MenuDemo\MenuDemo\frmAddMenu.cs

?????文件???????7704??2016-05-12?21:27??MenuDemo\MenuDemo\frmAddMenu.Designer.cs

?????文件???????5814??2016-05-12?21:27??MenuDemo\MenuDemo\frmAddMenu.resx

?????文件??????11301??2016-05-13?09:18??MenuDemo\MenuDemo\frmDict.cs

?????文件??????15333??2016-05-13?09:05??MenuDemo\MenuDemo\frmDict.designer.cs

?????文件???????5814??2016-05-13?09:05??MenuDemo\MenuDemo\frmDict.resx

?????文件????????949??2016-05-12?21:56??MenuDemo\MenuDemo\frmMain.cs

?????文件???????4603??2016-05-12?21:56??MenuDemo\MenuDemo\frmMain.Designer.cs

?????文件???????5814??2016-05-12?21:56??MenuDemo\MenuDemo\frmMain.resx

?????文件???????4113??2016-05-13?09:34??MenuDemo\MenuDemo\frmOrder.cs

?????文件???????2783??2016-05-12?23:00??MenuDemo\MenuDemo\frmOrder.Designer.cs

?????文件???????5814??2016-05-12?23:00??MenuDemo\MenuDemo\frmOrder.resx

?????文件???????4466??2016-05-12?21:37??MenuDemo\MenuDemo\MenuDemo.csproj

?????文件????????806??2016-05-11?09:19??MenuDemo\MenuDemo\Program.cs

?????文件???????1164??2016-05-11?08:12??MenuDemo\MenuDemo\Properties\AssemblyInfo.cs

?????文件???????2872??2016-05-11?08:12??MenuDemo\MenuDemo\Properties\Resources.Designer.cs

?????文件???????5612??2016-05-11?08:12??MenuDemo\MenuDemo\Properties\Resources.resx

............此處省略29個文件信息