人力资源管理软件设计源代码.docVIP

using System; using System.Collections; using System.Data; using System.Data.SqlClient; /// summary /// 数据访问基础类(基于SQLServer) /// /summary public abstract class DbHelper { #region //数据库连接字符串(web.config来配置) protected static string connectionString = ConfigHelper.GetValueByKey(ConnString); #endregion public DbHelper() { } #region 公用方法 public static int GetMaxID(string Field, string Table) { string strsql = select max( + Field+ )+1 from + Table; object obj = GetSingle(strsql); if (obj == null) { return 1; } else { return int.Parse(obj.ToString()); } } public static bool Exists(string strS, params SqlParameter[] cmdParms) { object obj = GetSingle(strS, cmdParms); int cmdr; if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { cmdr = 0; } else { cmdr = int.Parse(obj.ToString()); } if (cmdr == 0) { return false; } else { return true; } } #endregion #region 执行简单SQL语句 /// summary /// 执行SQL语句，返回影响的记录数 /// /summary /// param name=SQLStringSQL语句/param /// returns影响的记录数/returns public static int ExecuteSql(string SQLStr) { using (SqlConnection connection = new SqlConnection(connectionStr)) { using (SqlCommand cmd = new SqlCommand(SQLStr, connection)) { try { connection.Open(); int rows = cmd.ExecuteNonQuery(); return rows; } catch (System.Data.SqlClient.SqlException E) { connection.Close(); throw new Exception(E.Message); } } } } /// summary /// 执