public SYS_RightOfRoles SelectSYS_RightOfRoles(int ID) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); SYS_RightOfRoles sys_rightofroles = new SYS_RightOfRoles(); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false)); reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_RightOfRoles_SelectById]", para.ToArray()); if (reader.HasRows && reader.Read()) { SYS_RightOfRolesDataAccess.SetSYS_RightOfRolesInfo(reader, ref sys_rightofroles); } return(sys_rightofroles); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightOfRolesDataAccess.SelectById: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public int InsertSYS_RightOfRoles(SYS_RightOfRoles sys_rightofroles) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ROLEID, sys_rightofroles.RoleId, false)); para.Add(_DbHelper.CreateParameter(FIELD_RIGHTID, sys_rightofroles.RightId, false)); para.Add(_DbHelper.CreateParameter(FIELD_VIEW, sys_rightofroles.View, false)); para.Add(_DbHelper.CreateParameter(FIELD_UPDATE, sys_rightofroles.Update, false)); para.Add(_DbHelper.CreateParameter(FIELD_CREATE, sys_rightofroles.Create, false)); para.Add(_DbHelper.CreateParameter(FIELD_DELETE, sys_rightofroles.Delete, false)); para.Add(_DbHelper.CreateParameter(FIELD_APPROVE, sys_rightofroles.Approve, false)); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_RightOfRole_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightOfRolesDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
private static void SetListSYS_RightOfRolesInfo(ref DbDataReader reader, ref List <SYS_RightOfRoles> sys_rightofroless) { SYS_RightOfRoles sys_rightofroles = null; while (reader.Read()) { sys_rightofroles = new SYS_RightOfRoles(); SYS_RightOfRolesDataAccess.SetSYS_RightOfRolesInfo(reader, ref sys_rightofroles); sys_rightofroless.Add(sys_rightofroles); } }
public void DeleteSYS_RightOfRoles(SYS_RightOfRoles sys_rightofroles) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_rightofroles.ID, false)); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_RightOfRoles_Delete]", para.ToArray()); } catch (Exception) { throw; } finally { conn.Close(); } }
public void UpdateSYS_RightOfRoles(DbTransaction transaction, SYS_RightOfRoles sys_rightofroles) { try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ROLEID, sys_rightofroles.RoleId, false)); para.Add(_DbHelper.CreateParameter(FIELD_RIGHTID, sys_rightofroles.RightId, false)); para.Add(_DbHelper.CreateParameter(FIELD_VIEW, sys_rightofroles.View, false)); para.Add(_DbHelper.CreateParameter(FIELD_UPDATE, sys_rightofroles.Update, false)); para.Add(_DbHelper.CreateParameter(FIELD_CREATE, sys_rightofroles.Create, false)); para.Add(_DbHelper.CreateParameter(FIELD_DELETE, sys_rightofroles.Delete, false)); para.Add(_DbHelper.CreateParameter(FIELD_APPROVE, sys_rightofroles.Approve, false)); para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_rightofroles.ID, false)); _DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_RightOfRoles_Update]", para.ToArray()); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightOfRolesDataAccess.Update: {0}", ex.Message)); } }
private static void SetSYS_RightOfRolesInfo(DbDataReader reader, ref SYS_RightOfRoles sys_rightofroles) { sys_rightofroles.RoleId = int.Parse("0" + reader[FIELD_ROLEID]); sys_rightofroles.RightId = int.Parse("0" + reader[FIELD_RIGHTID]); sys_rightofroles.ID = int.Parse("0" + reader[FIELD_ID]); }
public void DeleteSYS_RightOfRoles(SYS_RightOfRoles sys_rightofroless) { _sys_rightofrolesDataAccess.DeleteSYS_RightOfRoles(sys_rightofroless); }
public void UpdateSYS_RightOfRoles(SYS_RightOfRoles sys_rightofroles) { _sys_rightofrolesDataAccess.UpdateSYS_RightOfRoles(sys_rightofroles); }
public int InsertSYS_RightOfRoles(SYS_RightOfRoles sys_rightofroles) { return(_sys_rightofrolesDataAccess.InsertSYS_RightOfRoles(sys_rightofroles)); }