/// <summary> /// Creates a new PerformanceStandard record /// </summary> public static int Create(PerformanceStandardDO DO) { SqlParameter _PerformanceStandardTypeID = new SqlParameter("PerformanceStandardTypeID", SqlDbType.Int); SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int); SqlParameter _Section = new SqlParameter("Section", SqlDbType.VarChar); SqlParameter _SubSection = new SqlParameter("SubSection", SqlDbType.VarChar); SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int); SqlParameter _AgreeToComply = new SqlParameter("AgreeToComply", SqlDbType.Bit); SqlParameter _OperatorComments = new SqlParameter("OperatorComments", SqlDbType.VarChar); _PerformanceStandardTypeID.Value = DO.PerformanceStandardTypeID; _PermitKey.Value = DO.PermitKey; _Section.Value = DO.Section; _SubSection.Value = DO.SubSection; _TOCID.Value = DO.TOCID; _AgreeToComply.Value = DO.AgreeToComply; _OperatorComments.Value = DO.OperatorComments; SqlParameter[] _params = new SqlParameter[] { _PerformanceStandardTypeID, _PermitKey, _Section, _SubSection, _TOCID, _AgreeToComply, _OperatorComments }; return DataCommon.ExecuteScalar("[dbo].[PerformanceStandard_Insert]", _params, "dbo"); }
/// <summary> /// Deletes a PerformanceStandard record /// </summary> public static int Delete(PerformanceStandardDO DO) { SqlParameter _PerformanceStandardID = new SqlParameter("PerformanceStandardID", SqlDbType.Int); _PerformanceStandardID.Value = DO.PerformanceStandardID; SqlParameter[] _params = new SqlParameter[] { _PerformanceStandardID }; return DataCommon.ExecuteScalar("[dbo].[PerformanceStandard_Delete]", _params, "dbo"); }
/// <summary> /// Gets all PerformanceStandard records /// </summary> public static PerformanceStandardDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[PerformanceStandard_GetAll]", new SqlParameter[] { }, "dbo"); List<PerformanceStandardDO> objs = new List<PerformanceStandardDO>(); while(sr.Read()){ PerformanceStandardDO obj = new PerformanceStandardDO(); obj.PerformanceStandardID = sr.GetInt32(sr.GetOrdinal("PerformanceStandardID")); obj.PerformanceStandardTypeID = sr.GetInt32(sr.GetOrdinal("PerformanceStandardTypeID")); obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey")); obj.Section = sr.GetString(sr.GetOrdinal("Section")); obj.SubSection = sr.GetString(sr.GetOrdinal("SubSection")); obj.TOCID = sr.GetInt32(sr.GetOrdinal("TOCID")); obj.AgreeToComply = sr.GetBoolean(sr.GetOrdinal("AgreeToComply")); if (sr.IsDBNull(sr.GetOrdinal("OperatorComments"))) { obj.OperatorComments = null; } else { obj.OperatorComments = sr.GetString(sr.GetOrdinal("OperatorComments")); } objs.Add(obj); } return objs.ToArray(); }