/// <summary> /// Deletes a TOCRules record /// </summary> public static int Delete(TOCRulesDO DO) { SqlParameter _TOCRulesID = new SqlParameter("TOCRulesID", SqlDbType.Int); _TOCRulesID.Value = DO.TOCRulesID; SqlParameter[] _params = new SqlParameter[] { _TOCRulesID }; return DataCommon.ExecuteScalar("[dbo].[TOCRules_Delete]", _params, "dbo"); }
/// <summary> /// Creates a new TOCRules record /// </summary> public static int Create(TOCRulesDO DO) { SqlParameter _Section = new SqlParameter("Section", SqlDbType.VarChar); SqlParameter _SubSection = new SqlParameter("SubSection", SqlDbType.VarChar); SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int); _Section.Value = DO.Section; _SubSection.Value = DO.SubSection; _TOCID.Value = DO.TOCID; SqlParameter[] _params = new SqlParameter[] { _Section, _SubSection, _TOCID }; return DataCommon.ExecuteScalar("[dbo].[TOCRules_Insert]", _params, "dbo"); }
/// <summary> /// Gets all TOCRules records /// </summary> public static TOCRulesDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[TOCRules_GetAll]", new SqlParameter[] { }, "dbo"); List<TOCRulesDO> objs = new List<TOCRulesDO>(); while(sr.Read()){ TOCRulesDO obj = new TOCRulesDO(); obj.TOCRulesID = sr.GetInt32(sr.GetOrdinal("TOCRulesID")); obj.Section = sr.GetString(sr.GetOrdinal("Section")); obj.SubSection = sr.GetString(sr.GetOrdinal("SubSection")); obj.TOCID = sr.GetInt32(sr.GetOrdinal("TOCID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects TOCRules records by PK /// </summary> public static TOCRulesDO[] GetByPK(Int32 TOCRulesID) { SqlParameter _TOCRulesID = new SqlParameter("TOCRulesID", SqlDbType.Int); _TOCRulesID.Value = TOCRulesID; SqlParameter[] _params = new SqlParameter[] { _TOCRulesID }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[TOCRules_GetByPK]", _params, "dbo"); List<TOCRulesDO> objs = new List<TOCRulesDO>(); while(sr.Read()) { TOCRulesDO obj = new TOCRulesDO(); obj.TOCRulesID = sr.GetInt32(sr.GetOrdinal("TOCRulesID")); obj.Section = sr.GetString(sr.GetOrdinal("Section")); obj.SubSection = sr.GetString(sr.GetOrdinal("SubSection")); obj.TOCID = sr.GetInt32(sr.GetOrdinal("TOCID")); objs.Add(obj); } return objs.ToArray(); }