DbHelperSQL.cs.docVIP

DbHelperSQL.cs Title: DbHelperSQL.cs From目田文摘 Time:Tue, 18 Nov 2008 14:22:27 +0000 Author: URL:/post/1293/ Content: 把李天平老师的代码拿过来学习 原文地址:/aivdesign/articles/1263247.html using System; using System.Collections; using System.Collections.Specialized; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Data.Common; using System.Collections.Generic; namespace Maticsoft.DBUtility { /// /// 数据访问抽象基础类 /// Copyright (C) 2004-2008 By LiTianPing /// public abstract class DbHelperSQL { //数据库连接字符串(web.config来配置)，可以动态更改connectionString支持多数据库. public static string connectionString = PubConstant.ConnectionString; public DbHelperSQL() { } #region 公用方法 /// /// 判断是否存在某表的某个字段 /// /// 表名称 /// 列名称 /// 是否存在 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 = DbHelperSQL.GetSingle(strSql); int cmdresult; if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { cmdresult = 0; } else {