SQL过程自动C#封装,支持从表到基本存储过程生成,

前面版本请看这里,
http://www.cnblogs.com/edobnet/archive/2004/06/04/13320.html

生成添加,修改,选择,删除等存储过程,

/**//******************************************************************
* 名称: Trade_OperationType_N_Insert
* 作者: WANGYJ<edobnet@hotmail.com>
* 时间: 2004-11-3 9:24:14
*
* -----------------------------------------------------------------
* 版本        时间            作者        备注
*
* V1.00        2004-11-3 9:24:14    WANGYJ        创建
* -----------------------------------------------------------------
******************************************************************/
CREATE  PROCEDURE Trade_OperationType_N_Insert
    @TOT_TypeID    int OUTPUT,
    @TOT_Description    TEXT,
    @TOT_TypeName    VARCHAR(50)
 AS

    INSERT INTO Trade_OperationType_N
    (
        TOT_Description,
        TOT_TypeName
    )
    VALUES
    (
        @TOT_Description,
        @TOT_TypeName
    )
    SELECT @TOT_TypeID = @@IDENTITY


go
/**//******************************************************************
* 名称: Trade_OperationType_N_Update
* 作者: WANGYJ<edobnet@hotmail.com>
* 时间: 2004-11-3 9:24:14
*
* -----------------------------------------------------------------
* 版本        时间            作者        备注
*
* V1.00        2004-11-3 9:24:14    WANGYJ        创建
* -----------------------------------------------------------------
******************************************************************/
CREATE  PROCEDURE Trade_OperationType_N_Update
    @TOT_TypeID    int,
    @TOT_Description    TEXT,
    @TOT_TypeName    VARCHAR(50)
 AS 
    UPDATE Trade_OperationType_N SET
        TOT_Description = @TOT_Description,
        TOT_TypeName = @TOT_TypeName
    where TOT_TypeName = @TOT_TypeName
go

/**//******************************************************************
* 名称: Trade_OperationType_N_Delete
* 作者: WANGYJ<edobnet@hotmail.com>
* 时间: 2004-11-3 9:24:14
*
* -----------------------------------------------------------------
* 版本        时间            作者        备注
*
* V1.00        2004-11-3 9:24:14    WANGYJ        创建
* -----------------------------------------------------------------
******************************************************************/
CREATE  PROCEDURE Trade_OperationType_N_Delete
     @TOT_TypeName    varchar
AS
    DELETE FROM Trade_OperationType_N
    where TOT_TypeName = @TOT_TypeName
go

/**//******************************************************************
* 名称: Trade_OperationType_N_Select
* 作者: WANGYJ<edobnet@hotmail.com>
* 时间: 2004-11-3 9:24:14
*
* -----------------------------------------------------------------
* 版本        时间            作者        备注
*
* V1.00        2004-11-3 9:24:14    WANGYJ        创建
* -----------------------------------------------------------------
******************************************************************/
CREATE  PROCEDURE Trade_OperationType_N_Select
     @TOT_TypeName    varchar
AS
    SELECT 
        TOT_Description,
        TOT_TypeName
    FROM Trade_OperationType_N
    where TOT_TypeName = @TOT_TypeName
go

从存储过程到c#代码封装,改国Data Application Block 3.1

封装以后的代码为:

using System;
using System.Data.SqlClient;
using System.Data;
using Xpay.Framework.Data;
namespace XpayLibrary.Components
{
    /**//// <summary>
    ///  Data
    /// </summary>
    public class Data
    {
        public Data()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }

        Trade_Operation_N_Delete#region Trade_Operation_N_Delete
        /**//// <summary>
        /// Trade_Operation_N_Delete
        /// </summary>
        /// <param name="TO_ID"></param>
        /// <returns></returns>
        public static void Trade_Operation_N_Delete(int TO_ID)
        {
                System.Data.SqlClient.SqlParameter[] ps=new SqlParameter[]{
                                    new SqlParameter("@TO_ID",SqlDbType.Int,4),

                                                                          };
                ps[0].Value =TO_ID;

                AdoHelper.GetAdoHelper().ExecuteNonQuery(AdoHelper.CONN_STRING,CommandType.StoredProcedure,"Trade_Operation_N_Delete",ps);


        }
        #endregion Trade_Operation_N_Delete

        Trade_Operation_N_Insert#region Trade_Operation_N_Insert
        /**//// <summary>
        /// Trade_Operation_N_Insert
        /// </summary>
        /// <param name="Trade_RateDescription"></param>
        /// <param name="TO_Name"></param>
        /// <param name="TO_BussLinkName"></param>
        /// <param name="TO_BussLinkEmail"></param>
        /// <param name="TO_TechLinkName"></param>
        /// <param name="TO_TechLinkEmail"></param>
        /// <param name="TO_Remark"></param>
        /// <param name="TOT_TypeID"></param>
        /// <param name="Trade_ID"></param>
        /// <param name="TO_ID"></param>
        /// <returns></returns>
        public static void Trade_Operation_N_Insert(string Trade_RateDescription,string TO_Name,string TO_BussLinkName,string TO_BussLinkEmail,string TO_TechLinkName,string TO_TechLinkEmail,string TO_Remark,int TOT_TypeID,int Trade_ID, out int TO_ID)
        {
                System.Data.SqlClient.SqlParameter[] ps=new SqlParameter[]{
                                    new SqlParameter("@Trade_RateDescription",SqlDbType.VarChar,4000),
                                    new SqlParameter("@TO_Name",SqlDbType.VarChar,50),
                                    new SqlParameter("@TO_BussLinkName",SqlDbType.VarChar,10),
                                    new SqlParameter("@TO_BussLinkEmail",SqlDbType.VarChar,64),
                                    new SqlParameter("@TO_TechLinkName",SqlDbType.VarChar,10),
                                    new SqlParameter("@TO_TechLinkEmail",SqlDbType.VarChar,64),
                                    new SqlParameter("@TO_Remark",SqlDbType.Char,10),
                                    new SqlParameter("@TOT_TypeID",SqlDbType.Int,4),
                                    new SqlParameter("@Trade_ID",SqlDbType.Int,4),
                                    new SqlParameter("@TO_ID",SqlDbType.Int,4,ParameterDirection.Output,true,0,0,"",DataRowVersion.Default,null),

                                                                          };
                ps[0].Value =Trade_RateDescription;
                ps[1].Value =TO_Name;
                ps[2].Value =TO_BussLinkName;
                ps[3].Value =TO_BussLinkEmail;
                ps[4].Value =TO_TechLinkName;
                ps[5].Value =TO_TechLinkEmail;
                ps[6].Value =TO_Remark;
                ps[7].Value =TOT_TypeID;
                ps[8].Value =Trade_ID;

                AdoHelper.GetAdoHelper().ExecuteNonQuery(AdoHelper.CONN_STRING,CommandType.StoredProcedure,"Trade_Operation_N_Insert",ps);
                TO_ID = int.Parse(ps[9].Value.ToString());;


        }
        #endregion Trade_Operation_N_Insert

        Trade_Operation_N_Select#region Trade_Operation_N_Select
        /**//// <summary>
        /// Trade_Operation_N_Select
        /// </summary>
        /// <param name="TO_ID"></param>
        /// <returns></returns>
        public static void Trade_Operation_N_Select(int TO_ID)
        {
                System.Data.SqlClient.SqlParameter[] ps=new SqlParameter[]{
                                    new SqlParameter("@TO_ID",SqlDbType.Int,4),

                                                                          };
                ps[0].Value =TO_ID;

                AdoHelper.GetAdoHelper().ExecuteNonQuery(AdoHelper.CONN_STRING,CommandType.StoredProcedure,"Trade_Operation_N_Select",ps);


        }
        #endregion Trade_Operation_N_Select

        Trade_Operation_N_Update#region Trade_Operation_N_Update
        /**//// <summary>
        /// Trade_Operation_N_Update
        /// </summary>
        /// <param name="TO_ID"></param>
        /// <param name="Trade_RateDescription"></param>
        /// <param name="TO_Name"></param>
        /// <param name="TO_BussLinkName"></param>
        /// <param name="TO_BussLinkEmail"></param>
        /// <param name="TO_TechLinkName"></param>
        /// <param name="TO_TechLinkEmail"></param>
        /// <param name="TO_Remark"></param>
        /// <param name="TOT_TypeID"></param>
        /// <returns></returns>
        public static void Trade_Operation_N_Update(int TO_ID,string Trade_RateDescription,string TO_Name,string TO_BussLinkName,string TO_BussLinkEmail,string TO_TechLinkName,string TO_TechLinkEmail,string TO_Remark,int TOT_TypeID)
        {
                System.Data.SqlClient.SqlParameter[] ps=new SqlParameter[]{
                                    new SqlParameter("@TO_ID",SqlDbType.Int,4),
                                    new SqlParameter("@Trade_RateDescription",SqlDbType.VarChar,4000),
                                    new SqlParameter("@TO_Name",SqlDbType.VarChar,50),
                                    new SqlParameter("@TO_BussLinkName",SqlDbType.VarChar,10),
                                    new SqlParameter("@TO_BussLinkEmail",SqlDbType.VarChar,64),
                                    new SqlParameter("@TO_TechLinkName",SqlDbType.VarChar,10),
                                    new SqlParameter("@TO_TechLinkEmail",SqlDbType.VarChar,64),
                                    new SqlParameter("@TO_Remark",SqlDbType.Char,10),
                                    new SqlParameter("@TOT_TypeID",SqlDbType.Int,4),

                                                                          };
                ps[0].Value =TO_ID;
                ps[1].Value =Trade_RateDescription;
                ps[2].Value =TO_Name;
                ps[3].Value =TO_BussLinkName;
                ps[4].Value =TO_BussLinkEmail;
                ps[5].Value =TO_TechLinkName;
                ps[6].Value =TO_TechLinkEmail;
                ps[7].Value =TO_Remark;
                ps[8].Value =TOT_TypeID;

                AdoHelper.GetAdoHelper().ExecuteNonQuery(AdoHelper.CONN_STRING,CommandType.StoredProcedure,"Trade_Operation_N_Update",ps);


        }
        #endregion Trade_Operation_N_Update


    }

}

下一步要完善的地方:
数据实体的自动生成,
源码下载:
https://files.cnblogs.com/edobnet/AutoDal.rar
需要代码研究或有意见;可以与我联系,edobnet@163.com