/// <summary> /// Deletes a MineType record /// </summary> public static int Delete(MineTypeDO DO) { SqlParameter _MineTypeID = new SqlParameter("MineTypeID", SqlDbType.VarChar); _MineTypeID.Value = DO.MineTypeID; SqlParameter[] _params = new SqlParameter[] { _MineTypeID }; return DataCommon.ExecuteScalar("[dbo].[MineType_Delete]", _params, "dbo"); }
/// <summary> /// Creates a new MineType record /// </summary> public static void Create(MineTypeDO DO) { SqlParameter _MineTypeID = new SqlParameter("MineTypeID", SqlDbType.VarChar); _MineTypeID.Value = DO.MineTypeID; SqlParameter[] _params = new SqlParameter[] { _MineTypeID }; DataCommon.ExecuteNonQuery("[dbo].[MineType_Insert]", _params, "dbo"); }
/// <summary> /// Gets all MineType records /// </summary> public static MineTypeDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[MineType_GetAll]", new SqlParameter[] { }, "dbo"); List<MineTypeDO> objs = new List<MineTypeDO>(); while(sr.Read()){ MineTypeDO obj = new MineTypeDO(); obj.MineTypeID = sr.GetString(sr.GetOrdinal("MineTypeID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects MineType records by PK /// </summary> public static MineTypeDO[] GetByPK(String MineTypeID) { SqlParameter _MineTypeID = new SqlParameter("MineTypeID", SqlDbType.VarChar); _MineTypeID.Value = MineTypeID; SqlParameter[] _params = new SqlParameter[] { _MineTypeID }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[MineType_GetByPK]", _params, "dbo"); List<MineTypeDO> objs = new List<MineTypeDO>(); while(sr.Read()) { MineTypeDO obj = new MineTypeDO(); obj.MineTypeID = sr.GetString(sr.GetOrdinal("MineTypeID")); objs.Add(obj); } return objs.ToArray(); }