SQL 預存程序封裝代碼產生器

介面圖:

產生的程式碼如下：（通過sqlHelp封裝執行）
using System;
using System.Data.SqlClient;
using System.Data;

namespace Etime.BEP
{
 /// <summary>
 ///  ProjectTask
 /// </summary>
 public class ProjectTask
 {
  public ProjectTask()
  {
   //
   // TODO: 在此處添加建構函式邏輯
   //
  }

  #region AddActivityToRole
  /// <summary>
  /// AddActivityToRole
  /// </summary>
  /// <param name="_RoleID"></param>
  /// <param name="_ActivityName"></param>
  /// <returns></returns>
  public static void AddActivityToRole(int _RoleID,string _ActivityName)
  {
   try
   {
    System.Data.SqlClient.SqlParameter[] ps=new SqlParameter[]{
         new SqlParameter("@iv_RoleID",SqlDbType.Int,4),
         new SqlParameter("@iv_ActivityName",SqlDbType.VarChar,50),

                    };
    ps[0].Value =_RoleID;
    ps[1].Value =_ActivityName;

    SqlHelper.ExecuteNonQuery(SqlHelper.CONN_STRING,CommandType.StoredProcedure,"AddActivityToRole",ps);

   }
   catch(System.Data.SqlClient.SqlException ex)
   {
    throw ex;
   }

  }
  #endregion AddActivityToRole

  #region GetUserList
  /// <summary>
  /// GetUserList
  /// </summary>
  /// <returns></returns>
  public static DataSet GetUserList()
  {
   try
   {
    System.Data.SqlClient.SqlParameter[] ps=new SqlParameter[]{

                    };

    
    return SqlHelper.ExecuteDataset(SqlHelper.CONN_STRING,CommandType.StoredProcedure,"GetUserList",ps);

   }
   catch(System.Data.SqlClient.SqlException ex)
   {
    throw ex;
   }

  }
  #endregion GetUserList

  #region updateCharge
  /// <summary>
  /// updateCharge
  /// </summary>
  /// <param name="_typeName"></param>
  /// <param name="_value"></param>
  /// <param name="_ChargeID"></param>
  /// <returns></returns>
  public static void updateCharge(string _typeName,string _value,int _ChargeID)
  {
   try
   {
    System.Data.SqlClient.SqlParameter[] ps=new SqlParameter[]{
         new SqlParameter("@iv_typeName",SqlDbType.VarChar,50),
         new SqlParameter("@iv_value",SqlDbType.VarChar,8),
         new SqlParameter("@iv_ChargeID",SqlDbType.Int,4),

                    };
    ps[0].Value =_typeName;
    ps[1].Value =_value;
    ps[2].Value =_ChargeID;

    SqlHelper.ExecuteNonQuery(SqlHelper.CONN_STRING,CommandType.StoredProcedure,"updateCharge",ps);

   }
   catch(System.Data.SqlClient.SqlException ex)
   {
    throw ex;
   }

  }
  #endregion updateCharge

 }

}

有興趣聯絡：edobnet@163.com