/// <summary> /// Deletes a LifeOfMinePhaseType record /// </summary> public static int Delete(LifeOfMinePhaseTypeDO DO) { SqlParameter _LifeOfMinePhaseTypeID = new SqlParameter("LifeOfMinePhaseTypeID", SqlDbType.VarChar); _LifeOfMinePhaseTypeID.Value = DO.LifeOfMinePhaseTypeID; SqlParameter[] _params = new SqlParameter[] { _LifeOfMinePhaseTypeID }; return DataCommon.ExecuteScalar("[dbo].[LifeOfMinePhaseType_Delete]", _params, "dbo"); }
/// <summary> /// Creates a new LifeOfMinePhaseType record /// </summary> public static void Create(LifeOfMinePhaseTypeDO DO) { SqlParameter _LifeOfMinePhaseTypeID = new SqlParameter("LifeOfMinePhaseTypeID", SqlDbType.VarChar); _LifeOfMinePhaseTypeID.Value = DO.LifeOfMinePhaseTypeID; SqlParameter[] _params = new SqlParameter[] { _LifeOfMinePhaseTypeID }; DataCommon.ExecuteNonQuery("[dbo].[LifeOfMinePhaseType_Insert]", _params, "dbo"); }
/// <summary> /// Gets all LifeOfMinePhaseType records /// </summary> public static LifeOfMinePhaseTypeDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[LifeOfMinePhaseType_GetAll]", new SqlParameter[] { }, "dbo"); List<LifeOfMinePhaseTypeDO> objs = new List<LifeOfMinePhaseTypeDO>(); while(sr.Read()){ LifeOfMinePhaseTypeDO obj = new LifeOfMinePhaseTypeDO(); obj.LifeOfMinePhaseTypeID = sr.GetString(sr.GetOrdinal("LifeOfMinePhaseTypeID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects LifeOfMinePhaseType records by PK /// </summary> public static LifeOfMinePhaseTypeDO[] GetByPK(String LifeOfMinePhaseTypeID) { SqlParameter _LifeOfMinePhaseTypeID = new SqlParameter("LifeOfMinePhaseTypeID", SqlDbType.VarChar); _LifeOfMinePhaseTypeID.Value = LifeOfMinePhaseTypeID; SqlParameter[] _params = new SqlParameter[] { _LifeOfMinePhaseTypeID }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[LifeOfMinePhaseType_GetByPK]", _params, "dbo"); List<LifeOfMinePhaseTypeDO> objs = new List<LifeOfMinePhaseTypeDO>(); while(sr.Read()) { LifeOfMinePhaseTypeDO obj = new LifeOfMinePhaseTypeDO(); obj.LifeOfMinePhaseTypeID = sr.GetString(sr.GetOrdinal("LifeOfMinePhaseTypeID")); objs.Add(obj); } return objs.ToArray(); }