public class DBCLASS//一个强大的类
{
public string sqlstr = "Data Source=192.168.132.205;Initial Catalog=XuanKeManage;Integrated Security=false;User ID = sa; Password=123;Max Pool Size=512;";
private SqlConnection cnn;
public DBCLASS()
{
cnn = new SqlConnection(sqlstr);
cnn.Open();
}
public DataSet getreturnsql(string sql)//返回查询到的表
{
using (SqlCommand cnd = cnn.CreateCommand())
{
cnd.CommandText = sql;
SqlDataAdapter sad = new SqlDataAdapter(cnd);
DataSet ds = new DataSet();
sad.Fill(ds, "tablename");
return ds;
}
}
public int returnsqlhang(string sql)//返回当前受影响的行
{
using (SqlCommand cmd = cnn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
int n = cmd.ExecuteNonQuery();
return n;
}
}
public DataSet getreturnprocssql(string procname, params SqlParameter[] list)
{
using (SqlCommand cmd = cnn.CreateCommand())
{
cmd.CommandText = procname;
cmd.Parameters.AddRange(list);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sda = new SqlDataAdapter();
DataSet ds = new DataSet();
sda.Fill(ds, "proctablename");
return ds;
}
}
public int getreturnprocrows(string procname, params SqlParameter[] list)
{
SqlParameter[] para = list;
using (SqlCommand cmd = cnn.CreateCommand())
{
cmd.CommandText = procname;
cmd.Parameters.AddRange(para);
cmd.CommandType = CommandType.StoredProcedure;
int n = cmd.ExecuteNonQuery();
return n;
}
}
}