public static object QueryScalar(string _strSql)
{
using (HDataBase hDatabase = new HDataBase())
{
using (IDbCommand iCommand = hDatabase.CreateDBCommand(_strSql))
{
object oValue = iCommand.ExecuteScalar();
iCommand.Dispose();
hDatabase.AutoClose();
return oValue;
}
}
}
public static int QueryNonQuery(string _strSql)
{
using (HDataBase hDatabase = new HDataBase())
{
using (IDbCommand iCommand = hDatabase.CreateDBCommand(_strSql))
{
object oValue = iCommand.ExecuteNonQuery();
iCommand.Dispose();
hDatabase.AutoClose();
return (int)oValue;
}
}
}
