/// <summary> /// Deletes a OtherPermitType record /// </summary> public static int Delete(OtherPermitTypeDO DO) { SqlParameter _OtherPermitTypeID = new SqlParameter("OtherPermitTypeID", SqlDbType.VarChar); _OtherPermitTypeID.Value = DO.OtherPermitTypeID; SqlParameter[] _params = new SqlParameter[] { _OtherPermitTypeID }; return DataCommon.ExecuteScalar("[dbo].[OtherPermitType_Delete]", _params, "dbo"); }
/// <summary> /// Creates a new OtherPermitType record /// </summary> public static void Create(OtherPermitTypeDO DO) { SqlParameter _OtherPermitTypeID = new SqlParameter("OtherPermitTypeID", SqlDbType.VarChar); _OtherPermitTypeID.Value = DO.OtherPermitTypeID; SqlParameter[] _params = new SqlParameter[] { _OtherPermitTypeID }; DataCommon.ExecuteNonQuery("[dbo].[OtherPermitType_Insert]", _params, "dbo"); }
/// <summary> /// Gets all OtherPermitType records /// </summary> public static OtherPermitTypeDO[] GetAll() { SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[OtherPermitType_GetAll]", new SqlParameter[] { }, "dbo"); List<OtherPermitTypeDO> objs = new List<OtherPermitTypeDO>(); while(sr.Read()){ OtherPermitTypeDO obj = new OtherPermitTypeDO(); obj.OtherPermitTypeID = sr.GetString(sr.GetOrdinal("OtherPermitTypeID")); objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects OtherPermitType records by PK /// </summary> public static OtherPermitTypeDO[] GetByPK(String OtherPermitTypeID) { SqlParameter _OtherPermitTypeID = new SqlParameter("OtherPermitTypeID", SqlDbType.VarChar); _OtherPermitTypeID.Value = OtherPermitTypeID; SqlParameter[] _params = new SqlParameter[] { _OtherPermitTypeID }; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[OtherPermitType_GetByPK]", _params, "dbo"); List<OtherPermitTypeDO> objs = new List<OtherPermitTypeDO>(); while(sr.Read()) { OtherPermitTypeDO obj = new OtherPermitTypeDO(); obj.OtherPermitTypeID = sr.GetString(sr.GetOrdinal("OtherPermitTypeID")); objs.Add(obj); } return objs.ToArray(); }