internal class SqlHelper
{
private string sqlConnectionString;
public SqlHelper(string ConnectStr)
{
sqlConnectionString = ConnectStr;
}
/// <summary>
/// 返回查询结果中的第一行第一列的值
/// </summary>
/// <param name="sqlstr">sql查询语句</param>
/// <returns>正常返回值,出现异常返回null</returns>
public object ExecSQL(string sqlstr)
{
try
{
SqlCommand cmd;
object num;
using (SqlConnection sqlserver = new SqlConnection(sqlConnectionString))
{
cmd = new SqlCommand(sqlstr, sqlserver);
sqlserver.Open();
num = cmd.ExecuteScalar().ToString();
sqlserver.Close();
}
return num;
}
catch (Exception ex)
{
return null;
}
}
/// <summary>
/// 执行增删改操作
/// </summary>
/// <param name="sqlstr">sql执行语句</param>
/// <returns>返回执行成功行数,执行失败返回-1</returns>
public int ExecSQLResult(string sqlstr)
{
try
{
SqlCommand cmd;
int num;
using (SqlConnection sqlserver = new SqlConnection(sqlConnectionString))
{
cmd = new SqlCommand(sqlstr, sqlserver);
sqlserver.Open();
num = cmd.ExecuteNonQuery();
sqlserver.Close();
}
return num;
}
catch
{
return -1;
}
}
/// <summary>
/// 根据条件查询SQL数据
/// </summary>
/// <param name="sqlstr">sql语句</param>
/// <returns>返回数据,查询失败返回null</returns>
public DataSet GetDataSet(string sqlstr)
{
try
{
SqlDataAdapter sqlda;
DataSet ds = new DataSet();
using (SqlConnection sqlserver = new SqlConnection(sqlConnectionString))
{
sqlda = new SqlDataAdapter(sqlstr, sqlserver);
sqlda.Fill(ds);
}
return ds;
}
catch
{
return null;
}
}
/// <summary>
/// 获取当前数据库状态
/// </summary>
public bool State
{
get
{
try
{
using (SqlConnection sqlserver = new SqlConnection(sqlConnectionString))
{
sqlserver.Open();
if (sqlserver.State == ConnectionState.Open)
{
sqlserver.Close();
return true;
}
else
{
sqlserver.Close();
return false;
}
}
}
catch
{
return false;
}
}
}
}