虽然没改写SqlDbHelper.cs类的能力,但好不容易想出来的,放着留个纪念~~~~~
 /// <summary>
        /// <summary>
 /// 执行SQL语句,返回第一行,第一列(sea)
        /// 执行SQL语句,返回第一行,第一列(sea)
 /// </summary>
        /// </summary>
 /// <param name="SQLString">sql语句</param>
        /// <param name="SQLString">sql语句</param>
 /// <param name="cmdParms">参数数组</param>
        /// <param name="cmdParms">参数数组</param>
 /// <returns>int</returns>
        /// <returns>int</returns>
 public int ExecuteSql4Value(string SQLString, params SqlParameter[] cmdParms)
        public int ExecuteSql4Value(string SQLString, params SqlParameter[] cmdParms)
 {
        {
 using (SqlConnection connection = new SqlConnection(strConn))
            using (SqlConnection connection = new SqlConnection(strConn))
 {
            {
 using (SqlCommand cmd = new SqlCommand())
                using (SqlCommand cmd = new SqlCommand())
 {
                {
 try
                    try
 {
                    {
 PrepareCommand(cmd, connection, null, SQLString, cmdParms);
                        PrepareCommand(cmd, connection, null, SQLString, cmdParms);
 object r = cmd.ExecuteScalar();
                        object r = cmd.ExecuteScalar();
 if (Object.Equals(r, null))
                        if (Object.Equals(r, null))
 {
                        {
 throw new Exception("value unavailable!");
                            throw new Exception("value unavailable!");
 }
                        }
 else
                        else
 {
                        {
 try { int a = (int)r; }
                            try { int a = (int)r; }
 catch { return 0; }
                            catch { return 0; }
 return (int)r;
                            return (int)r;
 }
                        }
 
                        
 }
                    }
 catch (System.Data.SqlClient.SqlException E)
                    catch (System.Data.SqlClient.SqlException E)
 {
                    {
 throw new Exception(E.Message);
                        throw new Exception(E.Message);
 }
                    }
 finally
                    finally
 {
                    {
 cmd.Parameters.Clear();
                        cmd.Parameters.Clear();
 }
                    }
 }
                }
 }
            }
 }
        }
 /// <summary>
        /// <summary> /// 执行SQL语句,返回第一行,第一列(sea)
        /// 执行SQL语句,返回第一行,第一列(sea) /// </summary>
        /// </summary> /// <param name="SQLString">sql语句</param>
        /// <param name="SQLString">sql语句</param> /// <param name="cmdParms">参数数组</param>
        /// <param name="cmdParms">参数数组</param> /// <returns>int</returns>
        /// <returns>int</returns> public int ExecuteSql4Value(string SQLString, params SqlParameter[] cmdParms)
        public int ExecuteSql4Value(string SQLString, params SqlParameter[] cmdParms) {
        { using (SqlConnection connection = new SqlConnection(strConn))
            using (SqlConnection connection = new SqlConnection(strConn)) {
            { using (SqlCommand cmd = new SqlCommand())
                using (SqlCommand cmd = new SqlCommand()) {
                { try
                    try {
                    { PrepareCommand(cmd, connection, null, SQLString, cmdParms);
                        PrepareCommand(cmd, connection, null, SQLString, cmdParms); object r = cmd.ExecuteScalar();
                        object r = cmd.ExecuteScalar(); if (Object.Equals(r, null))
                        if (Object.Equals(r, null)) {
                        { throw new Exception("value unavailable!");
                            throw new Exception("value unavailable!"); }
                        } else
                        else {
                        { try { int a = (int)r; }
                            try { int a = (int)r; } catch { return 0; }
                            catch { return 0; } return (int)r;
                            return (int)r; }
                        } 
                         }
                    } catch (System.Data.SqlClient.SqlException E)
                    catch (System.Data.SqlClient.SqlException E) {
                    { throw new Exception(E.Message);
                        throw new Exception(E.Message); }
                    } finally
                    finally {
                    { cmd.Parameters.Clear();
                        cmd.Parameters.Clear(); }
                    } }
                } }
            } }
        } 
                    
                     
                    
                 
                    
                 
 
        

 
             
                
            
         浙公网安备 33010602011771号
浙公网安备 33010602011771号