/// <summary> /// Updates a TOCBAK record and returns the number of records affected /// </summary> public static int Update(TOCBAKDO DO) { SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int); SqlParameter _ParentTOCID = new SqlParameter("ParentTOCID", SqlDbType.Int); SqlParameter _Description = new SqlParameter("Description", SqlDbType.VarChar); SqlParameter _NavigateUrl = new SqlParameter("NavigateUrl", SqlDbType.VarChar); SqlParameter _Instructions = new SqlParameter("Instructions", SqlDbType.VarChar); SqlParameter _Active = new SqlParameter("Active", SqlDbType.Bit); SqlParameter _DisplayOrder = new SqlParameter("DisplayOrder", SqlDbType.SmallInt); _TOCID.Value = DO.TOCID; _ParentTOCID.Value = DO.ParentTOCID; _Description.Value = DO.Description; _NavigateUrl.Value = DO.NavigateUrl; _Instructions.Value = DO.Instructions; _Active.Value = DO.Active; _DisplayOrder.Value = DO.DisplayOrder; SqlParameter[] _params = new SqlParameter[] { _TOCID, _ParentTOCID, _Description, _NavigateUrl, _Instructions, _Active, _DisplayOrder }; string pid = ConfigurationManager.AppSettings["PID"]; return DataCommon.ExecuteScalar(String.Format("[{0}].[TOCBAK_Update]", pid), _params, pid); }
/// <summary> /// Gets all TOCBAK records /// </summary> public static TOCBAKDO[] GetAll() { string pid = ConfigurationManager.AppSettings["PID"]; SafeReader sr = DataCommon.ExecuteSafeReader(String.Format("[{0}].[TOCBAK_GetAll]", pid), new SqlParameter[] { }, pid); List<TOCBAKDO> objs = new List<TOCBAKDO>(); while(sr.Read()){ TOCBAKDO obj = new TOCBAKDO(); 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.Instructions = sr.GetString(sr.GetOrdinal("Instructions")); obj.Active = sr.GetBoolean(sr.GetOrdinal("Active")); if (sr.IsDBNull(sr.GetOrdinal("DisplayOrder"))) { obj.DisplayOrder = null; } else { obj.DisplayOrder = sr.GetInt16(sr.GetOrdinal("DisplayOrder")); } objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Deletes a TOCBAK record /// </summary> public static int Delete(TOCBAKDO DO) { SqlParameter[] _params = new SqlParameter[] { }; string pid = ConfigurationManager.AppSettings["PID"]; return DataCommon.ExecuteScalar(String.Format("[{0}].[TOCBAK_Delete]", pid), _params, pid); }