【正文】 peration類的代碼如下：using System。 return cmd?！　　　?/執(zhí)行類型：命令文本 // 依次把參數(shù)傳入命令文本 if (prams != null) { foreach (SqlParameter parameter in prams) (parameter)。 SqlCommand cmd = new SqlCommand(procName, con)。 return dap。 //執(zhí)行類型：命令文本 if (prams != null) { foreach (SqlParameter parameter in prams) (parameter)。 SqlDataAdapter dap = new SqlDataAdapter(procName, con)。 //得到執(zhí)行成功返回值 return ds。 (ds, tbName)。 } /// summary /// 執(zhí)行命令文本，并且返回DataSet數(shù)據(jù)集 /// /summary /// param name=procName命令文本/param /// param name=tbName數(shù)據(jù)表名稱/param /// returnsDataSet/returns public DataSet RunProcReturn(string procName, string tbName) { SqlDataAdapter dap = CreateDataAdaper(procName, null)。 ()。 DataSet ds = new DataSet()。 return 1。 ()。 } /// summary /// 直接執(zhí)行SQL語(yǔ)句 /// /summary /// param name=procName命令文本/param /// returns/returns public int RunProc(string procName) { ()。 ()。 } endregion region 執(zhí)行參數(shù)命令文本(無(wú)數(shù)據(jù)庫(kù)中數(shù)據(jù)返回) /// summary /// 執(zhí)行命令 /// /summary /// param name=procName命令文本/param /// param name=prams參數(shù)對(duì)象/param /// returns/returns public int RunProc(string procName, SqlParameter[] prams) { SqlCommand cmd = CreateCommand(procName, prams)。 Value == null)) = Value。 if (!(Direction == amp。 else param = new SqlParameter(ParamName, DbType)。 } /// summary /// 初始化參數(shù)值 /// /summary /// param name=ParamName存儲(chǔ)過程名稱或命令文本/param /// param name=DbType參數(shù)類型/param /// param name=Size參數(shù)大小/param /// param name=Direction參數(shù)方向/param /// param name=Value參數(shù)值/param /// returns新的parameter 對(duì)象/returns public SqlParameter MakeParam(string ParamName, SqlDbType DbType, Int32 Size, ParameterDirection Direction, object Value) { SqlParameter param。 con = null。 } endregion region 關(guān)閉連接 /// summary /// 關(guān)閉數(shù)據(jù)庫(kù)連接 /// /summary public void Close() { if (con != null) ()。 region 打開數(shù)據(jù)庫(kù)連接 /// summary /// 打開數(shù)據(jù)庫(kù)連接. /// /summary private void Open() { if (con == null) { con = new SqlConnection( )。namespace { class DataBase:IDisposable { private SqlConnection con。using 。using 。)五、 詳細(xì)設(shè)計(jì)(一) 基礎(chǔ)類設(shè)計(jì)在一個(gè)信息管理系統(tǒng)中，數(shù)據(jù)是主動(dòng)的，操作跟隨數(shù)據(jù)，使用面向?qū)ο缶幊陶Z(yǔ)言C可以很容易的做到軟件的重用、提高軟件可維護(hù)性。,39。,39。)INSERT INTO sb_sblb(firstID,sblb,secondID) VALUES(39。,39。,39。)INSERT INTO sb_sblb(firstID,sblb,secondID) VALUES(39。,39。,39。)INSERT INTO sb_sblb(firstID,sblb,secondID) VALUES(39。,39。,39。)INSERT INTO sb_sblb(firstID,sblb,secondID) VALUES(39。,39。,39。,10001)INSERT INTO sb_sblb(firstID,sblb,secondID) VALUES(39。,80,1,14)INSERT INTO sb_bhgz(firstNO,defaultNO) VALUES (39。,39。,39。,80,1,13)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(14,39。,39。,39。,80,1,12)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(13,39。,39。,39。,80,1,11)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(12,39。,39。,39。,80,1,10)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(11,39。,39。,39。,80,1,9)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(10,39。,39。,39。,80,1,8)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(9,39。,39。,39。,80,1,7)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(8,39。,39。,39。,80,1,6)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(7,39。,39。,39。,80,1,5)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(6,39。,39。,39。,80,1,4)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(5,39。,39。,39。,80,1,3)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(4,39。,39。,39。,80,1,2)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(3,39。,39。,39。,80,1,1)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(2,39。,39。,39。,123456,0)INSERT INTO sb_DataGridViewList (bh,tableName,filedName,title,width,visible,place)VALUES(1,39。表411 系統(tǒng)管理員表字段名是否主鍵字段類型字段長(zhǎng)度是否允許為空備注ID是int否userName否varchar50是用戶名userPwd否varchar50是密碼userRole否int是類型Name否varchar50是姓名(三) 建庫(kù)腳本建庫(kù)腳本內(nèi)容如下：/*create database DB_EquInfManSys*/beginuse DB_EquInfManSysendBEGINCREATE TABLE [sb_DataGridViewList]( [ID] [int] IDENTITY(1,1) NOT NULL, [bh] [smallint] NULL, [tableName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [filedName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [title] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [width] [float] NULL, [visible] [bit] NOT NULL, [place] [smallint] NULL, CONSTRAINT [PK_sb_DataGridViewList] PRIMARY KEY CLUSTERED SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOBEGINCREATE TABLE [shebei]( [ID] [int] IDENTITY(1,1) NOT NULL, [bh] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [mc] [