人力资源管理软件设计源代码.docx
- 文档编号:3469968
- 上传时间:2022-11-23
- 格式:DOCX
- 页数:127
- 大小:45.25KB
人力资源管理软件设计源代码.docx
《人力资源管理软件设计源代码.docx》由会员分享,可在线阅读,更多相关《人力资源管理软件设计源代码.docx(127页珍藏版)》请在冰豆网上搜索。
人力资源管理软件设计源代码
usingSystem;
usingSystem.Collections;
usingSystem.Data;
usingSystem.Data.SqlClient;
///
///数据访问基础类(基于SQLServer)
///
publicabstractclassDbHelper
{
#region//数据库连接字符串(web.config来配置)
protectedstaticstringconnectionString=ConfigHelper.GetValueByKey("ConnString");
#endregion
publicDbHelper()
{
}
#region公用方法
publicstaticintGetMaxID(stringField,stringTable)
{
stringstrsql="selectmax("+Field+")+1from"+Table;
objectobj=GetSingle(strsql);
if(obj==null)
{
return1;
}
else
{
returnint.Parse(obj.ToString());
}
}
publicstaticboolExists(stringstrS,paramsSqlParameter[]cmdParms)
{
objectobj=GetSingle(strS,cmdParms);
intcmdr;
if((Object.Equals(obj,null))||(Object.Equals(obj,System.DBNull.Value)))
{
cmdr=0;
}
else
{
cmdr=int.Parse(obj.ToString());
}
if(cmdr==0)
{
returnfalse;
}
else
{
returntrue;
}
}
#endregion
#region执行简单SQL语句
///
///执行SQL语句,返回影响的记录数
///
///
///
publicstaticintExecuteSql(stringSQLStr)
{
using(SqlConnectionconnection=newSqlConnection(connectionStr))
{
using(SqlCommandcmd=newSqlCommand(SQLStr,connection))
{
try
{
connection.Open();
introws=cmd.ExecuteNonQuery();
returnrows;
}
catch(System.Data.SqlClient.SqlExceptionE)
{
connection.Close();
thrownewException(E.Message);
}
}
}
}
///
///执行多条SQL语句,实现数据库事务。
///
///
publicstaticvoidExecuteSqlTran(ArrayListSQLStringList)
{
using(SqlConnectionconn=newSqlConnection(connectionStr))
{
conn.Open();
SqlCommandcmd=newSqlCommand();
cmd.Connection=conn;
SqlTransactiontx=conn.BeginTransaction();
cmd.Transaction=tx;
try
{
for(intn=0;n { stringstrsql=SQLStringList[n].ToString(); if(strsql.Trim().Length>1) { cmd.CommandText=strsql; cmd.ExecuteNonQuery(); } } tx.Commit(); } catch(System.Data.SqlClient.SqlExceptionE) { tx.Rollback(); thrownewException(E.Message); } } } /// ///执行带一个存储过程参数的的SQL语句。 /// /// /// /// publicstaticintExecuteSql(stringSQLStr,stringcontent) { using(SqlConnectionconnection=newSqlConnection(connectionStr)) { SqlCommandcmd=newSqlCommand(SQLStr,connection); System.Data.SqlClient.SqlParametermyParameter=newSystem.Data.SqlClient.SqlParameter("@content",SqlDbType.NText); myParameter.Value=content; cmd.Parameters.Add(myParameter); try { connection.Open(); introws=cmd.ExecuteNonQuery(); returnrows; } catch(System.Data.SqlClient.SqlExceptionE) { thrownewException(E.Message); } finally { cmd.Dispose(); connection.Close(); } } } /// ///向数据库里插入图像格式的字段(和上面情况类似的另一种实例) /// /// /// /// publicstaticintExecuteSqlInsertImg(stringstrSQL,byte[]fs) { using(SqlConnectionconnection=newSqlConnection(connectionString)) { SqlCommandcmd=newSqlCommand(strSQL,connection); System.Data.SqlClient.SqlParametermyParameter=newSystem.Data.SqlClient.SqlParameter("@fs",SqlDbType.Image); myParameter.Value=fs; cmd.Parameters.Add(myParameter); try { connection.Open(); introws=cmd.ExecuteNonQuery(); returnrows; } catch(System.Data.SqlClient.SqlExceptionE) { thrownewException(E.Message); } finally { cmd.Dispose(); connection.Close(); } } } /// ///执行一条计算查询结果语句,返回查询结果(object)。 /// /// /// publicstaticobjectGetSingle(stringSQLStr) { using(SqlConnectionconnection=newSqlConnection(connectionStr)) { using(SqlCommandcmd=newSqlCommand(SQLStr,connection)) { try { connection.Open(); objectobj=cmd.ExecuteScalar(); if((Object.Equals(obj,null))||(Object.Equals(obj,System.DBNull.Value))) { returnnull; } else { returnobj; } } catch(System.Data.SqlClient.SqlExceptione) { connection.Close(); thrownewException(e.Message); } } } } /// ///执行查询语句,返回SqlDataReader /// /// /// publicstaticSqlDataReaderExecuteReader(stringstrSQL) { SqlConnectionconnection=newSqlConnection(connectionStr); SqlCommandcmd=newSqlCommand(strSQL,connection); try { connection.Open(); SqlDataReadermyReader=cmd.ExecuteReader(); returnmyReader; } catch(System.Data.SqlClient.SqlExceptione) { thrownewException(e.Message); } } /// ///执行查询语句,返回DataSet /// /// /// publicstaticDataSetQuery(stringSQLStr) { using(SqlConnectionconnection=newSqlConnection(connectionStr)) { DataSetds=newDataSet(); try { connection.Open(); SqlDataAdaptercommand=newSqlDataAdapter(SQLStr,connection); command.Fill(ds,"ds"); } catch(System.Data.SqlClient.SqlExceptionex) { thrownewException(ex.Message); } returnds; } } #endregion #region执行带参数的SQL语句 /// ///执行SQL语句,返回影响的记录数 /// /// /// publicstaticintExecuteSql(stringSQLStr,paramsSqlParameter[]cmdParms) { using(SqlConnectionconnection=newSqlConnection(connectionStr)) { using(SqlCommandcmd=newSqlCommand()) { try { PrepareCommand(cmd,connection,null,SQLStr,cmdParms); introws=cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); returnrows; } catch(System.Data.SqlClient.SqlExceptionE) { thrownewException(E.Message); } } } } /// ///执行多条SQL语句,实现数据库事务。 /// /// publicstaticvoidExecuteSqlTran(HashtableSQLStringList) { using(SqlConnectionconn=newSqlConnection(connectionStr)) { conn.Open(); using(SqlTransactiontrans=conn.BeginTransaction()) { SqlCommandcmd=newSqlCommand(); try { //循环 foreach(DictionaryEntrymyDEinSQLStringList) { stringcmdText=myDE.Key.ToString(); SqlParameter[]cmdParms=(SqlParameter[])myDE.Value; PrepareCommand(cmd,conn,trans,cmdText,cmdParms); intval=cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); trans.Commit(); } } catch { trans.Rollback(); throw; } } } } /// ///执行一条计算查询结果语句,返回查询结果(object)。 /// /// /// publicstaticobjectGetSingle(stringSQLStr,paramsSqlParameter[]cmdParms) { using(SqlConnectionconnection=newSqlConnection(connectionStr)) { using(SqlCommandcmd=newSqlCommand()) { try { PrepareCommand(cmd,connection,null,SQLStr,cmdParms); objectobj=cmd.ExecuteScalar(); cmd.Parameters.Clear(); if((Object.Equals(obj,null))||(Object.Equals(obj,System.DBNull.Value))) { returnnull; } else { returnobj; } } catch(System.Data.SqlClient.SqlExceptione) { thrownewException(e.Message); } } } } /// ///执行查询语句,返回SqlDataReader /// /// /// publicstaticSqlDataReaderExecuteReader(stringSQLStr,paramsSqlParameter[]cmdParms) { SqlConnectionconnection=newSqlConnection(connectionStr); SqlCommandcmd=newSqlCommand(); try { PrepareCommand(cmd,connection,null,SQLStr,cmdParms); SqlDataReadermyReader=cmd.ExecuteReader(); cmd.Parameters.Clear(); returnmyReader; } catch(System.Data.SqlClient.SqlExceptione) { thrownewException(e.Message); } } /// ///执行查询语句,返回DataSet /// /// /// publicstaticDataSetQuery(stringSQLStr,paramsSqlParameter[]cmdParms) { using(SqlConnectionconnection=newSqlConnection(connectionStr)) { SqlCommandcmd=newSqlCommand(); PrepareCommand(cmd,connection,null,SQLStr,cmdParms); using(SqlDataAdapterda=newSqlDataAdapter(cmd)) { DataSetds=newDataSet(); try { da.Fill(ds,"ds"); cmd.Parameters.Clear(); } catch(System.Data.SqlClient.SqlExceptionex) { thrownewException(ex.Message); } returnds; } } } privatestaticvoidPrepareCommand(SqlCommandcmd,SqlConnectionconn,SqlTransactiontrans,stringcmdText,SqlParameter[]cmdParms) { if(conn.State! =ConnectionState.Open) conn.Open(); cmd.Connection=conn; cmd.CommandText=cmdText; if(trans! =null) cmd.Transaction=trans; cmd.CommandType=CommandType.Text;//cmdType; if(cmdParms! =null) { foreach(SqlParameterparmincmdParms) { cmd.Parameters.Add(parm); } } } #endregion #region存储过程操作 /// ///执行存储过程 /// /// /// /// publicstaticSqlDataReaderRunProcedure(stringstoredProcName,IDataParameter[]parameters) { SqlConnectionconnection=newSqlConnection(connectionString); SqlDataReaderreturnReader; connection.Open(); SqlCommandcommand=BuildQueryCommand(connection,storedProcName,parameters); command.CommandType=CommandType.
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 人力资源 管理软件 设计 源代码