private void LoadData() { dtGrade = StatsCommonHandle.GetTeacherGradeData(); if (dtGrade.Rows.Count > 0) { string ss = dtGrade.Rows[0]["GroupGradeTypeName"].ToString(); DataView dataView = dtGrade.DefaultView; DataTable dtDistinct = dataView.ToTable(true, "GroupGradeType", "GroupGradeTypeName"); rptStudysection.DataSource = dtDistinct; rptStudysection.DataBind(); } }
public static string GetGradeList(string UserID) { try { UserID = UserID.Filter(); string strWhere = string.Empty; List <object> ListReturn = new List <object>(); DataTable dt = StatsCommonHandle.GetTeacherGradeData(); foreach (DataRow item in dt.Rows) { ListReturn.Add(new { GradeName = item["GradeName"].ToString(), GradeId = item["GradeId"].ToString(), ClassCount = item["ClassCount"].ToString(), StudentCount = item["StudentCount"].ToString() }); } if (dt.Rows.Count > 0) { return(JsonConvert.SerializeObject(new { err = "", list = ListReturn })); } else { return(JsonConvert.SerializeObject(new { err = "暂无数据" })); } } catch (Exception ex) { return(JsonConvert.SerializeObject(new { err = ex.Message.ToString() })); } }