/// <summary> /// Deletes a ChecklistType record /// </summary> public static int Delete(ChecklistTypeDO DO) { SqlParameter _ChecklistTypeID = new SqlParameter("ChecklistTypeID", SqlDbType.VarChar); _ChecklistTypeID.Value = DO.ChecklistTypeID; SqlParameter[] _params = new SqlParameter[] { _ChecklistTypeID }; return DataCommon.ExecuteScalar("[dbo].[ChecklistType_Delete]", _params, "dbo"); }
/// <summary> /// Creates a new ChecklistType record /// </summary> public static void Create(ChecklistTypeDO DO) { SqlParameter _ChecklistTypeID = new SqlParameter("ChecklistTypeID", SqlDbType.VarChar); _ChecklistTypeID.Value = DO.ChecklistTypeID; SqlParameter[] _params = new SqlParameter[] { _ChecklistTypeID }; DataCommon.ExecuteNonQuery("[dbo].[ChecklistType_Insert]", _params, "dbo"); }
/// <summary> /// Gets all ChecklistType records /// </summary> public static ChecklistTypeDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[ChecklistType_GetAll]", new SqlParameter[] { }, "dbo"); List<ChecklistTypeDO> objs = new List<ChecklistTypeDO>(); while(sr.Read()){ ChecklistTypeDO obj = new ChecklistTypeDO(); obj.ChecklistTypeID = sr.GetString(sr.GetOrdinal("ChecklistTypeID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects ChecklistType records by PK /// </summary> public static ChecklistTypeDO[] GetByPK(String ChecklistTypeID) { SqlParameter _ChecklistTypeID = new SqlParameter("ChecklistTypeID", SqlDbType.VarChar); _ChecklistTypeID.Value = ChecklistTypeID; SqlParameter[] _params = new SqlParameter[] { _ChecklistTypeID }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[ChecklistType_GetByPK]", _params, "dbo"); List<ChecklistTypeDO> objs = new List<ChecklistTypeDO>(); while(sr.Read()) { ChecklistTypeDO obj = new ChecklistTypeDO(); obj.ChecklistTypeID = sr.GetString(sr.GetOrdinal("ChecklistTypeID")); objs.Add(obj); } return objs.ToArray(); }