代码生成器模式下的快速项目实施(生成的代码服务部分）

保存太慢了。

代码放这里

 

// ================ 生成器自动生成的代码 ==================
// ====   版权所有：杭州************信息技术有限公司
// ====   主页地址： http://www**************com
// ====   创建日期：2006年11月2日(内部测试版)
// ========================================================

using  System;

namespace  zkSuperMap.Web.ModuleWebServices.SoapHeader
... {
    /**//// <summary>
    /// SqlServer数据库 对象 T_Dept的属性类DeptSoapHeader
    /// </summary>
    [Serializable]
    public class DeptSoapHeader:System.Web.Services.Protocols.SoapHeader
    ...{
        构造函数#region 构造函数
        /**//// <summary>
        /// 数据库表T_Dept
        /// </summary>
        public  DeptSoapHeader()
        ...{
            // TODO: 在此处添加构造函数逻辑
        }
        #endregion
        
        属性 -> 部门内码#region 属性 -> 部门内码
        //私有变量_部门内码
        private System.Int32 _Dept_ID;
        //私有变量部门内码”的值是否修改
        public System.Boolean Changed_Dept_ID;
        
        /**//// <summary>
        /// 部门内码
        /// </summary>
        public System.Int32 Dept_ID
        ...{
            get
            ...{
                return _Dept_ID;
            }
            set
            ...{
                if (!Changed_Dept_ID) 
                ...{
                    if (_Dept_ID!=value)
                        Changed_Dept_ID=true;
                }
                _Dept_ID=value;
            }
        }
        #endregion
        
        属性 -> 部门名称#region 属性 -> 部门名称
        //私有变量_部门名称
        private System.String _Dept_Name;
        //私有变量部门名称”的值是否修改
        public System.Boolean Changed_Dept_Name;
        
        /**//// <summary>
        /// 部门名称
        /// </summary>
        public System.String Dept_Name
        ...{
            get
            ...{
                return _Dept_Name;
            }
            set
            ...{
                if (!Changed_Dept_Name) 
                ...{
                    if (_Dept_Name!=value)
                        Changed_Dept_Name=true;
                }
                _Dept_Name=value;
            }
        }
        #endregion
        
        属性 -> 部门索引#region 属性 -> 部门索引
        //私有变量_部门索引
        private System.Int32 _Dept_Index;
        //私有变量部门索引”的值是否修改
        public System.Boolean Changed_Dept_Index;
        
        /**//// <summary>
        /// 部门索引
        /// </summary>
        public System.Int32 Dept_Index
        ...{
            get
            ...{
                return _Dept_Index;
            }
            set
            ...{
                if (!Changed_Dept_Index) 
                ...{
                    if (_Dept_Index!=value)
                        Changed_Dept_Index=true;
                }
                _Dept_Index=value;
            }
        }
        #endregion
        
        属性 -> 父部门#region 属性 -> 父部门
        //私有变量_父部门
        private System.Int32 _Dept_PID;
        //私有变量父部门”的值是否修改
        public System.Boolean Changed_Dept_PID;
        
        /**//// <summary>
        /// 父部门
        /// </summary>
        public System.Int32 Dept_PID
        ...{
            get
            ...{
                return _Dept_PID;
            }
            set
            ...{
                if (!Changed_Dept_PID) 
                ...{
                    if (_Dept_PID!=value)
                        Changed_Dept_PID=true;
                }
                _Dept_PID=value;
            }
        }
        #endregion
        
        属性 -> 描述#region 属性 -> 描述
        //私有变量_描述
        private System.String _Dept_Desc;
        //私有变量描述”的值是否修改
        public System.Boolean Changed_Dept_Desc;
        
        /**//// <summary>
        /// 描述
        /// </summary>
        public System.String Dept_Desc
        ...{
            get
            ...{
                return _Dept_Desc;
            }
            set
            ...{
                if (!Changed_Dept_Desc) 
                ...{
                    if (_Dept_Desc!=value)
                        Changed_Dept_Desc=true;
                }
                _Dept_Desc=value;
            }
        }
        #endregion
        
        属性 -> 简称#region 属性 -> 简称
        //私有变量_简称
        private System.String _Dept_SName;
        //私有变量简称”的值是否修改
        public System.Boolean Changed_Dept_SName;
        
        /**//// <summary>
        /// 简称
        /// </summary>
        public System.String Dept_SName
        ...{
            get
            ...{
                return _Dept_SName;
            }
            set
            ...{
                if (!Changed_Dept_SName) 
                ...{
                    if (_Dept_SName!=value)
                        Changed_Dept_SName=true;
                }
                _Dept_SName=value;
            }
        }
        #endregion
        
    }
}

 

// ================ 生成器自动生成的代码 ==================
// ====   版权所有：杭州************信息技术有限公司
// ====   主页地址： http://www**************com
// ====   创建日期：2006年11月2日(内部测试版)
// ========================================================

using  System;
using  System.IO;
using  System.Text;
using  System.Data;
using  System.Data.SqlClient;
using  zkSuperMap.Data;
using  zkSuperMap.Web.Utility;
using  zkSuperMap.Web.Configuration;
using  zkSuperMap.Web.ModuleWebServices.SoapHeader;

namespace  zkSuperMap.Web.ModuleWebServices.Data
... {
    /**//// <summary>
    /// SqlServer数据库 对象 T_Dept的数据库操作类DeptData
    /// </summary>
    public class DeptData:IDisposable
    ...{
        构造函数#region 构造函数
        /**//// <summary>
        /// 数据库表T_Dept
        /// </summary>
        public  DeptData()
        ...{
            // TODO: 在此处添加构造函数逻辑
        }
        
        //私有变量
        private SqlConnection _Connection;
        private SqlTransaction _Transaction;
        private bool isSelfConnection=false;
        /**//// <summary>
        /// 数据库连接串
        /// </summary>
        /// <param name="ConnString"></param>
        public DeptData(string ConnString)
        ...{
            isSelfConnection=true;
            _Connection=new SqlConnection(ConnString);
        }
        
        /**//// <summary>
        /// 数据库连接
        /// </summary>
        /// <param name="Connection"></param>
        public DeptData(ref SqlConnection Connection)
        ...{
            _Connection=Connection;
        }
        
        /**//// <summary>
        /// 数据库事务
        /// </summary>
        /// <param name="Transaction"></param>
        public DeptData(ref SqlTransaction Transaction)
        ...{
            _Transaction=Transaction;
            _Connection=_Transaction.Connection;
        }
        #endregion
        
        IDisposable 成员#region IDisposable 成员
        /**//// <summary>
        /// Disposable
        /// </summary>
        public void Dispose()
        ...{
            Disposing();
            if (isSelfConnection)
            ...{
                _Connection.Close();
                _Connection.Dispose();
            }
            GC.SuppressFinalize(this);
        }
        /**//// <summary>
        /// 保留给继承
        /// </summary>
        public virtual void Disposing()
        ...{
        }
        #endregion
        
        属性 -> 数据库事务#region 属性 -> 数据库事务
        /**//// <summary>
        /// 数据库连接
        /// </summary>
        public SqlTransaction Transaction
        ...{
            get...{return _Transaction;}
            set
            ...{
                _Transaction=value;
                _Connection=_Transaction.Connection;
            }
        }
        
        #endregion
        
        属性 -> 缓存页存储目录#region 属性 -> 缓存页存储目录
        private string _CacheFilePath=PathSetting.TemporaryPath+"测试数据/";
        /**//// <summary>
        /// 缓存页存储目录（只对Select有效）
        /// </summary>
        public string CacheFilePath
        ...{
            get...{return _CacheFilePath;}
            set...{_CacheFilePath=value;}
        }
        #endregion
        
        属性 -> 是否使用缓存页#region 属性 -> 是否使用缓存页
        private bool _UsedCacheFile=true;
        /**//// <summary>
        /// 是否使用缓存页（只对Select有效）
        /// </summary>
        public bool UsedCacheFile
        ...{
            get...{return _UsedCacheFile;}
            set...{_UsedCacheFile=value;}
        }
        #endregion
        
        属性 -> 数据库连接#region 属性 -> 数据库连接
        /**//// <summary>
        /// 数据库连接
        /// </summary>
        public SqlConnection Connection
        ...{
            get...{return _Connection;}
            set...{_Connection=value;}
        }
        
        #endregion
        
        属性 -> 数据库连接串#region 属性 -> 数据库连接串
        /**//// <summary>
        /// 数据库连接串
        /// </summary>
        public string ConnectionString
        ...{
            get...{return _Connection.ConnectionString;}
        }
        #endregion    
        
        方法 ->  ExecuteNonQuery 这个接口不建议提供给服务开放到前台#region 方法 ->  ExecuteNonQuery 这个接口不建议提供给服务开放到前台
        /**//// <summary>
        /// 执行SQL
        /// </summary>
        /// <param name="sqlString">SQLString</param>
        /// <returns>影响行数</returns>
        public int ExecuteNonQuery(string sqlString)
        ...{
            return SqlServerHelper.ExecuteNonQuery(_Connection,sqlString);
        }
        /**//// <summary>
        /// 执行SQL
        /// </summary>
        /// <param name="sqlString">SQLString</param>
        /// <param name="cmdType">命令字符串的类型(CommandType)</param>
        /// <param name="cmdParms">SqlDb参数</param>
        /// <returns>影响行数</returns>
        public int ExecuteNonQuery(string sqlString,CommandType cmdType, params SqlParameter[] cmdParms)
        ...{
            return SqlServerHelper.ExecuteNonQuery(_Connection,cmdType,sqlString,cmdParms);
        }
        #endregion
        
        方法 ->  Insert 插入一条记录并返回属性类(为了补充只录入部分数据或数据库中使用触发器生成了部分值#region 方法 ->  Insert 插入一条记录并返回属性类(为了补充只录入部分数据或数据库中使用触发器生成了部分值
        /**//// <summary>
        /// 插入数据
        /// </summary>
        /// <param name="soapHeader">类(Passport)</param>
        public void Insert(ref DeptSoapHeader soapHeader)
        ...{
            try
            ...{
            构造SQL#region 构造SQL
                SqlCommand _Command=new SqlCommand();
                StringBuilder _StringBuilderSQLString=new StringBuilder();
                StringBuilder _StringBuilderParameters=new StringBuilder();
                if (soapHeader.Changed_Dept_ID)
                ...{
                    _StringBuilderSQLString.Append(",Dept_ID");
                    _StringBuilderParameters.Append(",@Dept_ID");
                    _Command.Parameters.Add("@Dept_ID",soapHeader.Dept_ID);
                }
                if (soapHeader.Changed_Dept_Name)
                ...{
                    _StringBuilderSQLString.Append(",Dept_Name");
                    _StringBuilderParameters.Append(",@Dept_Name");
                    _Command.Parameters.Add("@Dept_Name",soapHeader.Dept_Name);
                }
                if (soapHeader.Changed_Dept_Index)
                ...{
                    _StringBuilderSQLString.Append(",Dept_Index");
                    _StringBuilderParameters.Append(",@Dept_Index");
                    _Command.Parameters.Add("@Dept_Index",soapHeader.Dept_Index);
                }
                if (soapHeader.Changed_Dept_PID)
                ...{
                    _StringBuilderSQLString.Append(",Dept_PID");
                    _StringBuilderParameters.Append(",@Dept_PID");
                    _Command.Parameters.Add("@Dept_PID",soapHeader.Dept_PID);
                }
                if (soapHeader.Changed_Dept_Desc)
                ...{
                    _StringBuilderSQLString.Append(",Dept_Desc");
                    _StringBuilderParameters.Append(",@Dept_Desc");
                    _Command.Parameters.Add("@Dept_Desc",soapHeader.Dept_Desc);
                }
                if (soapHeader.Changed_Dept_SName)
                ...{
                    _StringBuilderSQLString.Append(",Dept_SName");
                    _StringBuilderParameters.Append(",@Dept_SName");
                    _Command.Parameters.Add("@Dept_SName",soapHeader.Dept_SName);
                }
                if (_StringBuilderSQLString.Length==0)
                    throw new Exception("没有任何数据需要插入，请检查您的属性类的赋值情况。");
                _StringBuilderSQLString=_StringBuilderSQLString.Remove(0,1);
                _StringBuilderParameters=_StringBuilderParameters.Remove(0,1);
                _StringBuilderSQLString.Insert(0,"Insert into T_Dept (");
                _StringBuilderSQLString.Append(" ) values ("+_StringBuilderParameters.ToString()+")");
                
                SqlParameter[] _Parameter=new SqlParameter[_Command.Parameters.Count];
                for (int i=0;i<_Command.Parameters.Count;i++)
                    _Parameter[i]=_Command.Parameters[i];
                _Command.Parameters.Clear();
                _Command.Dispose();
                #endregion
                
                object _object=SqlServerHelper.ExecuteInsert(_Connection,_StringBuilderSQLString.ToString(),_Parameter);
                if (_object==null)
                    throw new Exception("插入数据失败！");
                soapHeader.Dept_ID=System.Int32.Parse(_object.ToString());
                soapHeader=Select(soapHeader.Dept_ID);
            }
            catch (Exception ex)
            ...{
                throw new Exception("插入数据失败，详细信息为："+ex.Message);
            }
        }
        #endregion
        
        方法 ->  Update 根据属性类（的主键ID）更新一条记录#region 方法 ->  Update 根据属性类（的主键ID）更新一条记录
        /**//// <summary>
        /// 更新数据
        /// </summary>
        /// <param name="soapHeader">类(Passport)</param>
        /// <param name="ReloadData">重新加载数据</param>
        public void Update(ref DeptSoapHeader soapHeader,bool ReloadData)
        ...{
            //删除硬盘临时文件
            string _CacheFileName=_CacheFilePath+"Dept/"+StringHelper.StringEncryptWithDES(soapHeader.Dept_ID.ToString())+"/";
            if (Directory.Exists(_CacheFileName))
                Directory.Delete(_CacheFileName,true);
            构造SQL#region 构造SQL
            SqlCommand _Command=new SqlCommand();
            StringBuilder _StringBuilderSQLString=new StringBuilder();
            if (soapHeader.Changed_Dept_Name)
            ...{
                _StringBuilderSQLString.Append(",Dept_Name=@Dept_Name");
                _Command.Parameters.Add("@Dept_Name",soapHeader.Dept_Name);
            }
            if (soapHeader.Changed_Dept_Index)
            ...{
                _StringBuilderSQLString.Append(",Dept_Index=@Dept_Index");
                _Command.Parameters.Add("@Dept_Index",soapHeader.Dept_Index);
            }
            if (soapHeader.Changed_Dept_PID)
            ...{
                _StringBuilderSQLString.Append(",Dept_PID=@Dept_PID");
                _Command.Parameters.Add("@Dept_PID",soapHeader.Dept_PID);
            }
            if (soapHeader.Changed_Dept_Desc)
            ...{
                _StringBuilderSQLString.Append(",Dept_Desc=@Dept_Desc");
                _Command.Parameters.Add("@Dept_Desc",soapHeader.Dept_Desc);
            }
            if (soapHeader.Changed_Dept_SName)
            ...{
                _StringBuilderSQLString.Append(",Dept_SName=@Dept_SName");
                _Command.Parameters.Add("@Dept_SName",soapHeader.Dept_SName);
            }
            if (_StringBuilderSQLString.Length==0)
                throw new Exception("没有任何数据需要更新，请检查您的属性类的赋值情况。");
            _StringBuilderSQLString=_StringBuilderSQLString.Remove(0,1);
            
            _StringBuilderSQLString.Insert(0,"Update T_Dept Set ");
            _StringBuilderSQLString.Append(" where Dept_ID=@Dept_ID");
            _Command.Parameters.Add("@Dept_ID",soapHeader.Dept_ID);
            SqlParameter[] _Parameter=new SqlParameter[_Command.Parameters.Count];
            for (int i=0;i<_Command.Parameters.Count;i++)
                _Parameter[i]=_Command.Parameters[i];
            _Command.Parameters.Clear();
            _Command.Dispose();
            #endregion
            
            if (ExecuteNonQuery(_StringBuilderSQLString.ToString(),CommandType.Text,_Parameter)!=1)
                throw new Exception("更新数据失败！");
            //是否加载数据
            if (ReloadData)
                soapHeader=Select(soapHeader.Dept_ID);
            else
            ...{
                soapHeader.Changed_Dept_ID=false;
                soapHeader.Changed_Dept_Name=false;
                soapHeader.Changed_Dept_Index=false;
                soapHeader.Changed_Dept_PID=false;
                soapHeader.Changed_Dept_Desc=false;
                soapHeader.Changed_Dept_SName=false;
            }
        }
        
        #endregion
        
        方法 ->  Delete 根据主键ID物理删除一条记录（逻辑删除请用UpDate函数）#region 方法 ->  Delete 根据主键ID物理删除一条记录（逻辑删除请用UpDate函数）
        /**//// <summary>
        /// 物理删除数据
        /// </summary>
        /// <param name="Dept_ID">主健ID</param>
        public void Delete(System.Int32 Dept_ID)
        ...{
            //删除硬盘临时文件
            string _CacheFileName=_CacheFilePath+"Dept/"+StringHelper.StringEncryptWithDES(Dept_ID.ToString())+"/";
            if (Directory.Exists(_CacheFileName))
                Directory.Delete(_CacheFileName,true);
            //如果主键设置成非数字型的，这里需要改成参数的方式会比较好。
            _CacheFileName="Delete from T_Dept  where Dept_ID="+Dept_ID.ToString();
            ExecuteNonQuery(_CacheFileName);
        }
        
        #endregion
        
        方法 ->  Search 根据字段名和值查找主键ID#region 方法 ->  Search 根据字段名和值查找主键ID
        /**//// <summary>
        /// 根据字段名和值查找主键ID
        /// </summary>
        /// <param name="FieldName">字段名</param>
        /// <param name="FieldValue">字段值</param>
        /// <returns>Object</returns>
        public object Search(string FieldName,object FieldValue)
        ...{
            SqlCommand _Command=new SqlCommand();
            StringBuilder _StringBuilderSQLString=new StringBuilder();
            _StringBuilderSQLString.Append("Select Dept_ID from T_Dept ");
            _StringBuilderSQLString.Append("where "+FieldName+"=@FieldName");
            _Command.Parameters.Add("@FieldName",FieldValue);
            SqlParameter[] _Parameter=new SqlParameter[_Command.Parameters.Count];
            for (int i=0;i<_Command.Parameters.Count;i++)
                _Parameter[i]=_Command.Parameters[i];
            _Command.Parameters.Clear();
            _Command.Dispose();
            return SqlServerHelper.ExecuteScalar(_Connection,CommandType.Text,_StringBuilderSQLString.ToString(),_Parameter);
        }
        #endregion
        
        方法 ->  Select 根据主键生成一个属性类#region 方法 ->  Select 根据主键生成一个属性类
        /**//// <summary>
        /// 获取数据
        /// </summary>
        /// <returns>类(DeptSoapHeader)</returns>
        public DeptSoapHeader Select(System.Int32 Dept_ID)
        ...{
            DeptSoapHeader _Dept;
            if (_UsedCacheFile)
            ...{
                //存储到硬盘临时文件
                string _CacheFileName=_CacheFilePath+"Dept/"+StringHelper.StringEncryptWithDES(Dept_ID.ToString())+"/";
                _CacheFileName+="CacheData.zkSuperMap";
                if (File.Exists(_CacheFileName))
                ...{
                直接从缓存数据中获取数据#region 直接从缓存数据中获取数据
                    DataSet _DataSet=new DataSet();
                    _DataSet.ReadXml(_CacheFileName,XmlReadMode.ReadSchema);
                    DataRow _DataReader=_DataSet.Tables[0].Rows[0];
                    _Dept= new DeptSoapHeader();
                    if (_DataReader["Dept_ID"]!=System.DBNull.Value)
                        _Dept.Dept_ID=(System.Int32)_DataReader["Dept_ID"];//部门内码
                    if (_DataReader["Dept_Name"]!=System.DBNull.Value)
                        _Dept.Dept_Name=(System.String)_DataReader["Dept_Name"];//部门名称
                    if (_DataReader["Dept_Index"]!=System.DBNull.Value)
                        _Dept.Dept_Index=(System.Int32)_DataReader["Dept_Index"];//部门索引
                    if (_DataReader["Dept_PID"]!=System.DBNull.Value)
                        _Dept.Dept_PID=(System.Int32)_DataReader["Dept_PID"];//父部门
                    if (_DataReader["Dept_Desc"]!=System.DBNull.Value)
                        _Dept.Dept_Desc=(System.String)_DataReader["Dept_Desc"];//描述
                    if (_DataReader["Dept_SName"]!=System.DBNull.Value)
                        _Dept.Dept_SName=(System.String)_DataReader["Dept_SName"];//简称
                    _Dept.Changed_Dept_ID=false;
                    _Dept.Changed_Dept_Name=false;
                    _Dept.Changed_Dept_Index=false;
                    _Dept.Changed_Dept_PID=false;
                    _Dept.Changed_Dept_Desc=false;
                    _Dept.Changed_Dept_SName=false;
                    _DataSet.Dispose();
                    #endregion 
                    return _Dept;
                }
            }
            SqlCommand _Command=new SqlCommand();
            StringBuilder _StringBuilderSQLString=new StringBuilder();
            _StringBuilderSQLString.Append("Select Dept_ID,Dept_Name,Dept_Index,Dept_PID,Dept_Desc,Dept_SName from T_Dept ");
            _StringBuilderSQLString.Append("where Dept_ID=@Dept_ID");
            _Command.Parameters.Add("@Dept_ID",Dept_ID);
            SqlParameter[] _Parameter=new SqlParameter[_Command.Parameters.Count];
            for (int i=0;i<_Command.Parameters.Count;i++)
                _Parameter[i]=_Command.Parameters[i];
            _Command.Parameters.Clear();
            _Command.Dispose();
    
            if (_UsedCacheFile)
            ...{
                DataSet _DataSet =SqlServerHelper.FillDataSet(_Connection,CommandType.Text,_StringBuilderSQLString.ToString(),_Parameter);
                if (_DataSet.Tables[0].Rows.Count==0)
                ...{
                    _DataSet.Dispose();
                    return null;
                }
                DataRow _DataReader=_DataSet.Tables[0].Rows[0];
                //存储到硬盘临时文件
                string _CacheFileName=_CacheFilePath+"Dept/"+StringHelper.StringEncryptWithDES(Dept_ID.ToString())+"/";
                if (!Directory.Exists(_CacheFileName)) Directory.CreateDirectory(_CacheFileName);
                _CacheFileName+="CacheData.zkSuperMap";
                _DataSet.WriteXml(_CacheFileName,XmlWriteMode.WriteSchema);
            属性类赋值#region 属性类赋值
                _Dept= new DeptSoapHeader();
                if (_DataReader["Dept_ID"]!=System.DBNull.Value)
                    _Dept.Dept_ID=(System.Int32)_DataReader["Dept_ID"];//部门内码
                if (_DataReader["Dept_Name"]!=System.DBNull.Value)
                    _Dept.Dept_Name=(System.String)_DataReader["Dept_Name"];//部门名称
                if (_DataReader["Dept_Index"]!=System.DBNull.Value)
                    _Dept.Dept_Index=(System.Int32)_DataReader["Dept_Index"];//部门索引
                if (_DataReader["Dept_PID"]!=System.DBNull.Value)
                    _Dept.Dept_PID=(System.Int32)_DataReader["Dept_PID"];//父部门
                if (_DataReader["Dept_Desc"]!=System.DBNull.Value)
                    _Dept.Dept_Desc=(System.String)_DataReader["Dept_Desc"];//描述
                if (_DataReader["Dept_SName"]!=System.DBNull.Value)
                    _Dept.Dept_SName=(System.String)_DataReader["Dept_SName"];//简称
                _Dept.Changed_Dept_ID=false;
                _Dept.Changed_Dept_Name=false;
                _Dept.Changed_Dept_Index=false;
                _Dept.Changed_Dept_PID=false;
                _Dept.Changed_Dept_Desc=false;
                _Dept.Changed_Dept_SName=false;
                _DataSet.Dispose();
                #endregion
                return _Dept;
            }
            else
            ...{
                SqlDataReader _DataReader=SqlServerHelper.ExecuteReader(_Connection,CommandType.Text,_StringBuilderSQLString.ToString(),_Parameter);
                if (_DataReader.Read())
                ...{
                属性类赋值#region 属性类赋值
                    _Dept= new DeptSoapHeader();
                    if (_DataReader["Dept_ID"]!=System.DBNull.Value)
                        _Dept.Dept_ID=(System.Int32)_DataReader["Dept_ID"];//部门内码
                    if (_DataReader["Dept_Name"]!=System.DBNull.Value)
                        _Dept.Dept_Name=(System.String)_DataReader["Dept_Name"];//部门名称
                    if (_DataReader["Dept_Index"]!=System.DBNull.Value)
                        _Dept.Dept_Index=(System.Int32)_DataReader["Dept_Index"];//部门索引
                    if (_DataReader["Dept_PID"]!=System.DBNull.Value)
                        _Dept.Dept_PID=(System.Int32)_DataReader["Dept_PID"];//父部门
                    if (_DataReader["Dept_Desc"]!=System.DBNull.Value)
                        _Dept.Dept_Desc=(System.String)_DataReader["Dept_Desc"];//描述
                    if (_DataReader["Dept_SName"]!=System.DBNull.Value)
                        _Dept.Dept_SName=(System.String)_DataReader["Dept_SName"];//简称
                    _Dept.Changed_Dept_ID=false;
                    _Dept.Changed_Dept_Name=false;
                    _Dept.Changed_Dept_Index=false;
                    _Dept.Changed_Dept_PID=false;
                    _Dept.Changed_Dept_Desc=false;
                    _Dept.Changed_Dept_SName=false;
                    _DataReader.Close();
                    #endregion
                    return _Dept;
                }
                else
                ...{
                    _DataReader.Close();
                    return null;
                }
            }
        }
        
        #endregion
        
        方法 -> Count#region 方法 -> Count
        /**//// <summary>
        /// 返回记录数(使用这个函数时注意自己处理已经删除及其已经无效的记录)
        /// </summary>
        /// <param name="whereSQLString">不带Where关键字的Where条件</param>
        /// <returns>记录数</returns>
        public int Count(string whereSQLString)
        ...{
            string sqlString="select Count(Dept_ID) from T_Dept"+(whereSQLString==string.Empty?string.Empty:" where "+whereSQLString);
            return (int)SqlServerHelper.ExecuteScalar(_Connection,CommandType.Text,sqlString,null);
        }
        #endregion
        
        方法 -> FillDataSet 对大数据量的表不建议使用这个函数,使用这个函数时注意自己处理已经删除及其已经无效的记录#region 方法 -> FillDataSet 对大数据量的表不建议使用这个函数,使用这个函数时注意自己处理已经删除及其已经无效的记录
        /**//// <summary>
        /// 返回DataSet(对大数据量的表不建议使用这个函数,使用这个函数时注意自己处理已经删除及其已经无效的记录)
        /// </summary>
        /// <param name="sqlString">SQLString</param>
        /// <param name="startRecord">开始的记录数</param>
        /// <param name="maxRecords">返回的最大记录数</param>
        /// <returns>DataSet</returns>
        public DataSet FillDataSet(string sqlString,int startRecord ,int maxRecords)
        ...{
            if (sqlString.ToLower().TrimStart().IndexOf("select")!=0)
                throw new Exception("sqlString 必须是Select打头的语句。");
            return SqlServerHelper.FillDataSet(_Connection,startRecord,maxRecords,CommandType.Text,sqlString,null);
        }
        
        /**//// <summary>
        /// 返回DataSet(对大数据量的表不建议使用这个函数,使用这个函数时注意自己处理已经删除及其已经无效的记录)
        /// </summary>
        /// <param name="sqlString">SQLString</param>
        /// <returns>DataSet</returns>
        public DataSet FillDataSet(string sqlString)
        ...{
            if (sqlString.ToLower().TrimStart().IndexOf("select")!=0)
                throw new Exception("sqlString 必须是Select打头的语句。");
            return SqlServerHelper.FillDataSet(_Connection,CommandType.Text,sqlString,null);
        }
        
        #endregion
    }
}

 

 

 SqlServer) #region [自动生成] T_Dept  (数据源TestConnectString --> SqlServer)        
        //定义服务属性交换类
        public SoapHeader.DeptSoapHeader DeptHeader;

        Dept_Insert#region Dept_Insert
        /**//// <summary>
        /// 插入数据
        /// </summary>
        /// <returns></returns>
        [WebMethod]
        [SoapHeaderAttribute("DeptHeader",
             Direction = SoapHeaderDirection.InOut)]
        public bool Dept_Insert()
        ...{
            if (DeptHeader==null) 
                throw new Exception("请创建属性交换类DeptHeader；");
            using (Data.DeptData _Data=new Data.DeptData(
                       ConnectStringSetting.GetSqlServerConnectString("TestConnectString")))
            ...{
                _Data.Insert(ref DeptHeader);
                return true;
            }
        }
        #endregion

        Dept_Update#region Dept_Update
        /**//// <summary>
        /// 插入数据
        /// </summary>
        /// <param name="ReloadData">是否重新获取数据</param>
        /// <returns></returns>
        [WebMethod]
        [SoapHeaderAttribute("DeptHeader",
             Direction = SoapHeaderDirection.InOut)]
        public bool Dept_Update(bool ReloadData)
        ...{
            if (DeptHeader==null) 
                throw new Exception("请创建属性交换类DeptHeader；");
            using (Data.DeptData _Data=new Data.DeptData(
                       ConnectStringSetting.GetSqlServerConnectString("TestConnectString")))
            ...{
                _Data.Update(ref DeptHeader,ReloadData);
                return true;
            }
        }
        #endregion

        Dept_DeletePhysics#region Dept_DeletePhysics
        /**//// <summary>
        /// 物理删除
        /// </summary>
        /// <param name="Dept_ID">主键ID</param>
        [WebMethod]
        public void Dept_DeletePhysics(System.Int32 Dept_ID)
        ...{
            using (Data.DeptData _Data=new Data.DeptData(
                       ConnectStringSetting.GetSqlServerConnectString("TestConnectString")))
            ...{
                _Data.Delete(Dept_ID);
            }
        }
        #endregion

        Dept_Select#region Dept_Select
        /**//// <summary>
        /// 获取属性类
        /// </summary>
        /// <param name="Dept_ID">主键ID</param>        
        [WebMethod]
        [SoapHeaderAttribute("DeptHeader",
             Direction = SoapHeaderDirection.Out)]
        public bool Dept_Select(System.Int32 Dept_ID)
        ...{
            using (Data.DeptData _Data=new Data.DeptData(
                       ConnectStringSetting.GetSqlServerConnectString("TestConnectString")))
            ...{
                DeptHeader= _Data.Select(Dept_ID);
                return DeptHeader!=null;
            }
        }
        #endregion

        Dept_Search#region Dept_Search
        /**//// <summary>
        /// 获取属性类
        /// </summary>
        /// <param name="Field_Name">字段名称</param>
        /// <param name="Field_Value">字段值</param>        
        [WebMethod]
        [SoapHeaderAttribute("DeptHeader",
             Direction = SoapHeaderDirection.Out)]
        public bool Dept_Search(string Field_Name,object Field_Value)
        ...{
            using (Data.DeptData _Data=new Data.DeptData(
                       ConnectStringSetting.GetSqlServerConnectString("TestConnectString")))
            ...{
                DeptHeader=  _Data.Select((System.Int32)_Data.Search(Field_Name,Field_Value));
                return DeptHeader!=null;
            }
        }
        #endregion

        Dept_Count#region Dept_Count
        /**//// <summary>        
        /// 返回记录数(使用这个函数时注意自己处理已经删除及其已经无效的记录)        
        /// </summary>        
        /// <param name="whereSQLString">不带Where关键字的Where条件</param>    
        /// <returns>记录数</returns>        
        public int Dept_Count(string whereSQLString)
        ...{
            using (Data.DeptData _Data=new Data.DeptData(
                       ConnectStringSetting.GetSqlServerConnectString("TestConnectString")))
            ...{
                return _Data.Count(whereSQLString);
            }
        }
        #endregion

        Dept_Record#region Dept_Record
        /**//// <summary>        
        /// 返回记录数(使用这个函数时注意自己处理已经删除及其已经无效的记录)        
        /// </summary>        
        /// <param name="sqlString">查询SQL语句</param>
        /// <param name="startRecord">开始的记录数</param>
        /// <param name="maxRecords">返回最大记录数</param>
        /// <returns>记录</returns>        
        public DataSet Dept_Record(string sqlString,int startRecord,int maxRecords)
        ...{
            using (Data.DeptData _Data=new Data.DeptData(
                       ConnectStringSetting.GetSqlServerConnectString("TestConnectString")))
            ...{
                return _Data.FillDataSet(sqlString,startRecord,maxRecords);
            }
        }
        #endregion

        Dept_DataSet#region Dept_DataSet
        /**//// <summary>        
        /// 返回记录数(使用这个函数时注意自己处理已经删除及其已经无效的记录)        
        /// </summary>        
        /// <param name="sqlString">查询SQL语句</param>
        /// <returns>记录</returns>        
        public DataSet Dept_DataSet(string sqlString)
        ...{
            using (Data.DeptData _Data=new Data.DeptData(
                       ConnectStringSetting.GetSqlServerConnectString("TestConnectString")))
            ...{
                return _Data.FillDataSet(sqlString);
            }
        }
        #endregion

        #endregion

 

然后把这个服务封装成一个程序集合，页上就可以直接调用了。