C#ÖÐÓÃÓÚÁ¬½ÓSQLÊý¾Ý¿âµÄSQLHelperÀà

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;   //ÒýÓÃÃüÃû¿Õ¼ä
namespace DAL
{
    /*******************************************************************************
    * Name: SQLHelper
    * File: SQLHelper.cs
    * Description: ÓÃÓÚÍê³É¶ÔÊý¾Ý¿âµÄÏà¹Ø²Ù×÷
    * Author: Ñ©ÀÇ
    * DateTime: 2010Äê05ÔÂ13ÈÕ
    *******************************************************************************/
    public class SQLHelper
    {
        //ÉèÖÃÁ¬½Ó×Ö·û´® —— SQL ServerÑé֤ģʽµÄÁ¬½Ó×Ö·û´®
        //public static string strConn = @"server = PANLING;database = StudentMIS;uid = sa;pwd = sa";
        //ÉèÖÃÁ¬½Ó×Ö·û´® —— WindowsÑé֤ģʽµÄÁ¬½Ó×Ö·û´®
        public static string strConn = @"server = T403-004\HB_SQLSERVER;database = DB_LibraryManage;Integrated Security = SSPI";
        /// <summary>
        /// ¹¦ÄÜÃèÊö£ºÖ´ÐÐADO.NETÔö¡¢É¾¡¢¸Ä²Ù×÷
        /// </summary>
        /// <param name="strText">ÊäÈë²ÎÊý —— ÒªÖ´ÐеÄSQLÓï¾ä(ÃüÁîÎı¾)</param>
        /// <param name="cmdType">ÊäÈë²ÎÊý —— ÒªÖ´ÐеÄSQLÃüÁîÀàÐÍ</param>
        /// <param name="SqlParams">ÊäÈë²ÎÊý —— ÒªÖ´ÐеÄSQLÓï¾äÖеIJÎÊýÁбí(ÃüÁî²ÎÊýÁбí)</param>
        /// <returns>·µ»ØÖ´ÐÐÓ°ÏìµÄÐÐÊý</returns>
        public static int MyExecu