public static ApplicationRelation GetApplicationRelationById(Guid appid) { ApplicationRelation info = null; IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IApplicationRelation dp = DataProvider.DbApplicationRelationDP; conn = DbConnOperation.CreateConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; info = dp.GetApplicationRelationById(cmd, appid); trans.Commit(); } catch (Exception ex) { log.Error(string.Format("GetApplicationRelationById()发生错误,错误信息如下:{0}", ex)); if (trans != null) { trans.Rollback(); } } finally { if (conn != null) { conn.Close(); } } return(info); }
public static bool AddOrUpdateApplicationRelation(ApplicationRelation info, ModifierType mode) { bool ret = false; IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IApplicationRelation dp = DataProvider.DbApplicationRelationDP; conn = DbConnOperation.CreateConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; ret = dp.AddOrUpdateApplicationRelation(cmd, info, mode); trans.Commit(); } catch (Exception ex) { log.Error(string.Format("AddOrUpdateApplicationRelation()发生错误,错误信息如下:{0}", ex)); if (trans != null) { trans.Rollback(); } } finally { if (conn != null) { conn.Close(); } } return(ret); }