/// <summary>
        /// 执行一个命令对数据库进行增,删,改
        /// </summary>
        /// <param name="sqlText">Sql语句或者存储过程名</param>
        /// <param name="commandType">sql语句或者存储过程</param>
        /// <param name="paras">参数名数组</param>
        /// <param name="values">参数值数组</param>
        /// <param name="para">输出参数名</param>
        /// <param name="value">输出参数值</param>
        /// <returns>返回影响的行数</returns>
        public static int ExecuteSql(string sqlText, CommandType commandType, string[] paras, object[] values, string para, out object value,SqlDbType type)
        {            cmd = PrepareCommand(sqlText, commandType, paras, values);
            if (para != null)
            {     
                SqlParameter pram = new SqlParameter(para, type);
                if (type == SqlDbType.VarChar)
                    pram.Size = 2000;
                cmd.Parameters.Add(pram);
                cmd.Parameters[para].Direction = ParameterDirection.Output;
            }            try
            {                if (conn.State != ConnectionState.Open)
                    conn.Open();
            }
            catch (Exception ex)
            {
                throw ex;
            }            int count;
            count=cmd.ExecuteNonQuery();
            if (para != null)
            {
                value = cmd.Parameters[para].Value;            }
            else
                value = null;
            conn.Close();
            return count;
            
        }