»ùÓÚSQLServerµÄÊý¾Ý·ÃÎÊ»ù´¡Àà

/// <summary>
/// Êý¾Ý·ÃÎÊ»ù´¡Àà(»ùÓÚSQLServer)
/// Copyright (C) 2008-2009 С±¿µ°
/// </summary>
public class DbHelperSQL
{
//Êý¾Ý¿âÁ¬½Ó×Ö·û´®(web.configÀ´ÅäÖÃ)
public static string connectionString = PubConstant.ConnectionString;
public DbHelperSQL()
{
}
#region ¹«Ó÷½·¨
/// <summary>
/// ÅжÏÊÇ·ñ´æÔÚij±íµÄij¸ö×Ö¶Î
/// </summary>
/// <param name="tableName">±íÃû³Æ</param>
/// <param name="columnName">ÁÐÃû³Æ</param>
/// <returns>ÊÇ·ñ´æÔÚ</returns>
public static bool ColumnExists(string tableName, string columnName)
{
string sql = "select count(1) from syscolumns where [id]=object_id('" + tableName + "') and [name]='" + columnName + "'";
object res = GetSingle(sql);
if (res == null)
{
return false;
}
return Convert.ToInt32(res) > 0;
}
public static int GetMaxID(string FieldName, string TableName)
{
string strsql = "select max(" + FieldName + ")+1 from " + TableName;
object obj = DbHelperSQL.GetSingle(strsql);
if (obj == null)
{
return 1;
}
else
{
return int.Parse(obj.ToString());
}
}
public static bool Exists(string strSql)
{
object obj = GetSingle(strSql);
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;
}