public static int OleDbGetMaxID(string FieldName, string TableName)
{
string oledbSQL = "select max(" + FieldName + ")+1 from " + TableName;
object obj = OleDbHelperSQL.OleDbGetSingle(oledbSQL);
if (obj == null)
{
return(1);
}
else
{
return(int.Parse(obj.ToString()));
}
}
public static bool OleDbExists(string oledbSQL)
{
object obj = OleDbHelperSQL.OleDbGetSingle(oledbSQL);
int cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = int.Parse(obj.ToString());
}
if (cmdresult == 0)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// 表是否存在
/// </summary>
/// <param name="TableName"></param>
/// <returns></returns>
public static bool OleDbTabExists(string TableName)
{
string oledbSQL = "select count(*) from sysobjects where id = object_id(N'[" + TableName + "]') and OBJECTPROPERTY(id, N'IsUserTable') = 1";
//string strsql = "SELECT count(*) FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + TableName + "]') AND type in (N'U')";
object obj = OleDbHelperSQL.OleDbGetSingle(oledbSQL);
int cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = int.Parse(obj.ToString());
}
if (cmdresult == 0)
{
return(false);
}
else
{
return(true);
}
}