public class DBConfigration{public static string ConnectionString="server=数据库服务器;User ID=登录名;Password=密码;initial catalog=数据库";public DBConfigration(){// TODO: 读取XML文件的数据库的配置string fileName =AppDomain.CurrentDomain.BaseDirectory.ToString()+ @"/dataBaseConnect.xml";string connectstring = "";XmlTextReader tr = new XmlTextReader(fileName);while(tr.Read()){if(tr.NodeType==XmlNodeType.Text){connectstring = tr.Value;break;}}tr.Close();tr=null;if (connectstring.Length<10){ConnectionString="server=数据库服务器;User ID=登录名;Password=密码;initial catalog=数据库";}else{ConnectionString = connectstring;}}}
这样可能通过改变XML文件里的数据库的配置，而不必编译文件，对于系统的移植来说相对比较方便，当然这种方法不是一种好方法。对于开发小型的单一的系统还是很好用的。
数据层（Data）
定义一个基类，把基本的字段类型都提取出来。便于管理public class BaseDataColumn : DataColumn{// 定义变量// 设置字段是否为关键字段。private bool isKeyColumn;// 设置字段是否为有效字段。private bool isValidColumn;// 设置字段是否允许中文。private bool isDBCSColumn;// 设置字段的“SqlDbType”类型。private SqlDbType columnSqlDbType;// 若为数字型字段，记录字段的最大值。private double columnMaxValue = 0;// 若为数字型字段，记录字段的最小值。private double columnMinValue = 0;// 若为数字型字段，记录字段的小数点位数。private int columnDecimalPosition = -1;//定义方法// 返回是否为关键字列public bool IsKeyColumn(){return isKeyColumn;}// 返回是否为有效列public bool IsValidColumn(){return isValidColumn;}// 设置关键字列状态public void SetKeyState(bool isKS){isKeyColumn = isKS;}// 设置有效列状态public void SetValidState(bool isVS){isValidColumn = isVS;}// 返回是否为有效列public bool IsDBCSColumn(){return isDBCSColumn;}// 设置关键字列状态public void SetDBCSState(bool isDBCS){isDBCSColumn = isDBCS;}// 获取列的 SqlDbTypepublic SqlDbType GetColumnSqlDbType(){return columnSqlDbType;}// 设置列的最大长度public void SetMaxLength(int length){MaxLength = length;}// 设置列的最大值public void SetMaxValue(double value){columnMaxValue = value;}// 设置列的最小值public void SetMinValue(double value){columnMinValue = value;}// 设置数字列的小数点位数。public void SetDecimalPosition(int position){columnDecimalPosition = position;}// 获取数字列的小数点位数。public int GetDecimalPosition(){return columnDecimalPosition;}// 重载重构函数public BaseDataColumn(bool isKS, bool isVS) : base(){isKeyColumn = isKS;isValidColumn = isVS;columnSqlDbType = SqlDbType.VarChar;isDBCSColumn = false;}public BaseDataColumn() : base(){isKeyColumn = false;isValidColumn = true;columnSqlDbType = SqlDbType.VarChar;isDBCSColumn = false;}public BaseDataColumn( System.String columnName , SqlDbType dataType , System.String expr , System.Data.MappingType type ) : base( columnName ,CommonInfo.GetSystemType(dataType) , expr , type ){isKeyColumn = false;isValidColumn = true;columnSqlDbType = dataType;isDBCSColumn = false;}public BaseDataColumn( System.String columnName , SqlDbType dataType , System.String expr ) : base( columnName ,CommonInfo.GetSystemType(dataType) ,expr ){isKeyColumn = false;isValidColumn = true; columnSqlDbType = dataType;isDBCSColumn = false;}public BaseDataColumn( System.String columnName , SqlDbType dataType ) : base( columnName , CommonInfo.GetSystemType(dataType) ){isKeyColumn = false;isValidColumn = true; columnSqlDbType = dataType;isDBCSColumn = false;}public BaseDataColumn( System.String columnName , SqlDbType dataType, bool isKS, bool isVS ) : base( columnName , CommonInfo.GetSystemType(dataType) ){isKeyColumn = isKS;isValidColumn = isVS; columnSqlDbType = dataType;isDBCSColumn = false;this.ColumnName = columnName;}public BaseDataColumn( System.String columnName , SqlDbType dataType, bool isKS, bool isVS,int isAutoADD ) : base( columnName , CommonInfo.GetSystemType(dataType) ){isKeyColumn = isKS;isValidColumn = isVS; columnSqlDbType = dataType;isDBCSColumn = false;if (isAutoADD==1){this.AutoIncrement = true;}this.ColumnName = columnName;}public BaseDataColumn( System.String columnName , SqlDbType dataType, bool isKS, bool isVS, bool isDBCS ) : base( columnName , CommonInfo.GetSystemType(dataType) ){isKeyColumn = isKS;isValidColumn = isVS; columnSqlDbType = dataType;isDBCSColumn = isDBCS;}public BaseDataColumn( System.String columnName ) : base( columnName ){isKeyColumn = false;isValidColumn = true; columnSqlDbType = SqlDbType.VarChar;isDBCSColumn = false;}}
再定义一个抽象类。用于其子类的继承来。public class BaseDataSet : DataSet{public BaseDataSet(){//BuildDataTables();}// 构建 DataSet 中所有表、字段和关键字protected virtual void BuildDataTables(){} }
这样就完成了基础建设接下来就是对各各数据表结构的定义和操作我们来举个例子这是声明一个数据集，叫数据表的名字是t_hotsubject_column，有九个字段，并分别定义他们数据类型，是否是关键字，是否是有效字。 public class columnClass:BaseDataSet { public const string T_HOTSUBJECT_COLUMN_CLASS_TABLE ="t_hotsubject_column"; public const string COLUMNID_CLASS_FIELD ="columnid"; public const string HOTSUBJECTID_CLASS_FIELD ="hotsubjectid"; public const string COLUMNTITTLE_CLASS_FIELD ="columntittle"; public const string PARENTID_CLASS_FIELD ="parentid"; public const string COLUMNPOSITION_CLASS_FIELD ="columnposition"; public const string COLUMNCREATOR_CLASS_FIELD ="columncreator"; public const string COLUMNDESCRIPTION_CLASS_FIELD ="columndescription"; public const string DEPTNO_CLASS_FILED ="deptno"; public const string LOCKED_CLASS_FILED ="locked"; public columnClass() { BuildDataTables();// TODO: 在此处添加构造函数逻辑 } protected override void BuildDataTables() { DataTable columnTable=new DataTable(T_HOTSUBJECT_COLUMN_CLASS_TABLE); DataColumnCollection columnColumns=columnTable.Columns; columnColumns.Add(new BaseDataColumn(COLUMNID_CLASS_FIELD,SqlDbType.Int,true,true)); columnColumns.Add(new BaseDataColumn(HOTSUBJECTID_CLASS_FIELD,SqlDbType.Int,false,true)); columnColumns.Add(new BaseDataColumn(COLUMNTITTLE_CLASS_FIELD,SqlDbType.VarChar,false,true)); columnColumns.Add(new BaseDataColumn(PARENTID_CLASS_FIELD,SqlDbType.VarChar,false,true)); columnColumns.Add(new BaseDataColumn(COLUMNPOSITION_CLASS_FIELD,SqlDbType.Int,false,true)); columnColumns.Add(new BaseDataColumn(COLUMNCREATOR_CLASS_FIELD,SqlDbType.NVarChar,false,true)); columnColumns.Add(new BaseDataColumn(COLUMNDESCRIPTION_CLASS_FIELD,SqlDbType.NText,false,true)); columnColumns.Add(new BaseDataColumn(DEPTNO_CLASS_FILED,SqlDbType.Int,false,true)); columnColumns.Add(new BaseDataColumn(LOCKED_CLASS_FILED,SqlDbType.Char,false,true)); this.Tables.Add(columnTable);
} }这种方法也不是最好的方法，我们要以通过XST模式来生成XML的数据集合。这个以后再补充。
作者Blog： http://blog.csdn.net/kennymoni/