public object GetMinPunishment() { string sql = "select MIN(PunshmentAwardsRecode_ID) from PunshmentAwardsRecode"; return(DataBaseHelper.cmdExecuteScalar(sql)); }
//学制 public string GetSpeYearsName(string SpecialityID) { string sql = "select sy.SpeYears_Name from SpeYears as sy join Speciality as sp on sp.Speciality_Years=sy.SpeYears_ID where sp.Speciality_ID=@0"; return(DataBaseHelper.cmdExecuteScalar(sql, SpecialityID).ToString()); }