/// <summary> /// Deletes a TOC record /// </summary> public static int Delete(TOCDO DO) { SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int); _TOCID.Value = DO.TOCID; SqlParameter[] _params = new SqlParameter[] { _TOCID }; return DataCommon.ExecuteScalar("[dbo].[TOC_Delete]", _params, "dbo"); }
/// <summary> /// Gets all TOC records /// </summary> public static TOCDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[TOC_GetAll]", new SqlParameter[] { }, "dbo"); List<TOCDO> objs = new List<TOCDO>(); while(sr.Read()){ TOCDO obj = new TOCDO(); obj.TOCID = sr.GetInt32(sr.GetOrdinal("TOCID")); obj.ParentTOCID = sr.GetInt32(sr.GetOrdinal("ParentTOCID")); obj.Description = sr.GetString(sr.GetOrdinal("Description")); obj.NavigateUrl = sr.GetString(sr.GetOrdinal("NavigateUrl")); obj.Tips = sr.GetString(sr.GetOrdinal("Tips")); obj.Active = sr.GetBoolean(sr.GetOrdinal("Active")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Creates a new TOC record /// </summary> public static int Create(TOCDO DO) { SqlParameter _ParentTOCID = new SqlParameter("ParentTOCID", SqlDbType.Int); SqlParameter _Description = new SqlParameter("Description", SqlDbType.VarChar); SqlParameter _NavigateUrl = new SqlParameter("NavigateUrl", SqlDbType.VarChar); SqlParameter _Tips = new SqlParameter("Tips", SqlDbType.VarChar); SqlParameter _Active = new SqlParameter("Active", SqlDbType.Bit); _ParentTOCID.Value = DO.ParentTOCID; _Description.Value = DO.Description; _NavigateUrl.Value = DO.NavigateUrl; _Tips.Value = DO.Tips; _Active.Value = DO.Active; SqlParameter[] _params = new SqlParameter[] { _ParentTOCID, _Description, _NavigateUrl, _Tips, _Active }; return DataCommon.ExecuteScalar("[dbo].[TOC_Insert]", _params, "dbo"); }
/// <summary> /// Selects TOC records by PK /// </summary> public static TOCDO[] GetByPK(Int32 TOCID) { SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int); _TOCID.Value = TOCID; SqlParameter[] _params = new SqlParameter[] { _TOCID }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[TOC_GetByPK]", _params, "dbo"); List<TOCDO> objs = new List<TOCDO>(); while(sr.Read()) { TOCDO obj = new TOCDO(); obj.TOCID = sr.GetInt32(sr.GetOrdinal("TOCID")); obj.ParentTOCID = sr.GetInt32(sr.GetOrdinal("ParentTOCID")); obj.Description = sr.GetString(sr.GetOrdinal("Description")); obj.NavigateUrl = sr.GetString(sr.GetOrdinal("NavigateUrl")); obj.Tips = sr.GetString(sr.GetOrdinal("Tips")); obj.Active = sr.GetBoolean(sr.GetOrdinal("Active")); objs.Add(obj); } return objs.ToArray(); }