public static bool Exists(string dbKey, string strSql, params MySqlParameter[] cmdParms)
{
object obj = DbHelperMySQL3.GetSingle(dbKey, strSql, cmdParms);
int cmdresult;
if (object.Equals(obj, null) || object.Equals(obj, DBNull.Value))
{
cmdresult = 0;
}
else
{
cmdresult = int.Parse(obj.ToString());
}
return(cmdresult != 0);
}
public static int GetMaxID(string dbKey, string FieldName, string TableName)
{
string strsql = "select max(" + FieldName + ")+1 from " + TableName;
object obj = DbHelperMySQL3.GetSingle(dbKey, strsql);
int result;
if (obj == null)
{
result = 1;
}
else
{
result = int.Parse(obj.ToString());
}
return(result);
}