/// <summary> /// Deletes a MineSiteCategory record /// </summary> public static int Delete(MineSiteCategoryDO DO) { SqlParameter _MineSiteCategoryID = new SqlParameter("MineSiteCategoryID", SqlDbType.VarChar); _MineSiteCategoryID.Value = DO.MineSiteCategoryID; SqlParameter[] _params = new SqlParameter[] { _MineSiteCategoryID }; return DataCommon.ExecuteScalar("[dbo].[MineSiteCategory_Delete]", _params, "dbo"); }
/// <summary> /// Creates a new MineSiteCategory record /// </summary> public static void Create(MineSiteCategoryDO DO) { SqlParameter _MineSiteCategoryID = new SqlParameter("MineSiteCategoryID", SqlDbType.VarChar); _MineSiteCategoryID.Value = DO.MineSiteCategoryID; SqlParameter[] _params = new SqlParameter[] { _MineSiteCategoryID }; DataCommon.ExecuteNonQuery("[dbo].[MineSiteCategory_Insert]", _params, "dbo"); }
/// <summary> /// Gets all MineSiteCategory records /// </summary> public static MineSiteCategoryDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[MineSiteCategory_GetAll]", new SqlParameter[] { }, "dbo"); List<MineSiteCategoryDO> objs = new List<MineSiteCategoryDO>(); while(sr.Read()){ MineSiteCategoryDO obj = new MineSiteCategoryDO(); obj.MineSiteCategoryID = sr.GetString(sr.GetOrdinal("MineSiteCategoryID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects MineSiteCategory records by PK /// </summary> public static MineSiteCategoryDO[] GetByPK(String MineSiteCategoryID) { SqlParameter _MineSiteCategoryID = new SqlParameter("MineSiteCategoryID", SqlDbType.VarChar); _MineSiteCategoryID.Value = MineSiteCategoryID; SqlParameter[] _params = new SqlParameter[] { _MineSiteCategoryID }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[MineSiteCategory_GetByPK]", _params, "dbo"); List<MineSiteCategoryDO> objs = new List<MineSiteCategoryDO>(); while(sr.Read()) { MineSiteCategoryDO obj = new MineSiteCategoryDO(); obj.MineSiteCategoryID = sr.GetString(sr.GetOrdinal("MineSiteCategoryID")); objs.Add(obj); } return objs.ToArray(); }