/// <summary>
/// 添加
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int Create(TB_UserConnectDormArea info)
{
try
{
Database db = DBO.CreateDatabase();
return(this.Create(info, (DbTransaction)null, db));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 事务添加
/// </summary>
/// <param name="info"></param>
/// <param name="tran"></param>
/// <param name="db"></param>
/// <returns></returns>
public int Create(TB_UserConnectDormArea info, DbTransaction tran, Database db)
{
DbCommand dbCommandWrapper = null;
int intId;
string strInsertSql = @"INSERT INTO [TB_UserConnectDormArea] ([UserID]
,[DormAreaID])
VALUES(@UserID
,@DormAreaID
)";
string strSelectIdSql = ";SELECT SCOPE_IDENTITY()";
try
{
dbCommandWrapper = db.GetSqlStringCommand(strInsertSql + strSelectIdSql);
#region Add parameters
db.AddInParameter(dbCommandWrapper, "@UserID", DbType.Int32, info.UserID);
db.AddInParameter(dbCommandWrapper, "@DormAreaID", DbType.Int32, info.DormAreaID);
#endregion
if (tran == null)
{
intId = Convert.ToInt32(db.ExecuteScalar(dbCommandWrapper));
}
else
{
intId = Convert.ToInt32(db.ExecuteScalar(dbCommandWrapper, tran));
}
return(intId);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommandWrapper != null)
{
dbCommandWrapper = null;
}
}
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="tb_User"></param>
/// <param name="lstDormAreaID"></param>
private void Update(TB_User tb_User, List <int> lstDormAreaID)
{
TB_UserConnectDormArea mTB_UserConnectDormArea = null;
//启用事务
_db = DBO.CreateDatabase();
_connection = _db.CreateConnection();
_connection.Open();
_tran = _connection.BeginTransaction();
try
{
//更新用户信息
_mTB_UserDAL.Edit(tb_User, _tran, _db);
//删除用户关联宿舍区信息
_mTB_UserConnectDormAreaDAL.Delete(tb_User.ID, _tran, _db);
//添加用户关联宿舍区信息
foreach (var item in lstDormAreaID)
{
mTB_UserConnectDormArea = new TB_UserConnectDormArea()
{
UserID = tb_User.ID,
DormAreaID = item,
};
_mTB_UserConnectDormAreaDAL.Create(mTB_UserConnectDormArea, _tran, _db);
}
//提交事务
_tran.Commit();
}
catch
{
//回滚事务
_tran.Rollback();
}
finally
{
//关闭连接
_connection.Close();
}
}
/// <summary>
/// 添加用户信息
/// </summary>
/// <param name="tb_User"></param>
/// <param name="lstDormAreaID"></param>
/// <returns></returns>
private int Add(TB_User tb_User, List <int> lstDormAreaID)
{
TB_UserConnectDormArea mTB_UserConnectDormArea = null;
int intUserID = 0;
//启用事务
_db = DBO.CreateDatabase();
_connection = _db.CreateConnection();
_connection.Open();
_tran = _connection.BeginTransaction();
try
{
//添加用户信息
intUserID = _mTB_UserDAL.Create(tb_User, _tran, _db);
//添加用户关联宿舍区信息
foreach (var item in lstDormAreaID)
{
mTB_UserConnectDormArea = new TB_UserConnectDormArea()
{
UserID = intUserID,
DormAreaID = item,
};
_mTB_UserConnectDormAreaDAL.Create(mTB_UserConnectDormArea, _tran, _db);
}
//提交事务
_tran.Commit();
}
catch
{
//回滚事务
_tran.Rollback();
}
finally
{
//关闭连接
_connection.Close();
}
return(intUserID);
}
