/// <summary>
/// 执行sqlSelect 返回 数据集
/// </summary>
/// <param name="sqlSelect">select类型的sql</param>
/// <returns></returns>
public DataSet ReturnDataSet(string sqlSelect)
{
DataSet ds = new DataSet();
try
{
switch (dbConnectType_)
{
case DBConnectType.ORACLE:
ds = JHDBUse.Query(sqlSelect);
break;
case DBConnectType.SQLSERVER:
SqlConnection cn = new SqlConnection(strConnection);
SqlCommand cmd = new SqlCommand(sqlSelect, cn);
SqlParameter[] mParametes = GetParametes();
if (null != mParametes && mParametes.Length > 0)
{
cmd.Parameters.AddRange(mParametes);
}
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds); //通过适配器填充数据集
break;
}
}
catch (Exception e)
{
throw e;
}
return(ds);
}
/// <summary>
/// 返回首行首列的值
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public object ReturnScalar(string sql)
{
object ret = new object();
SqlConnection cn = new SqlConnection(strConnection);
try
{
switch (dbConnectType_)
{
case DBConnectType.ORACLE:
ret = JHDBUse.GetSingle(sql);
break;
case DBConnectType.SQLSERVER:
SqlCommand cmd = new SqlCommand(sql, cn);
SqlParameter[] mParametes = GetParametes();
if (null != mParametes && mParametes.Length > 0)
{
cmd.Parameters.AddRange(mParametes);
}
cn.Open();
ret = cmd.ExecuteScalar();
cn.Close();
break;
}
}
catch (Exception e)
{
throw e;
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
}
return(ret);
}
