/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void StudentsDataRowToModel(XYStudent model, DataRow dr) { model.strTeacherGUID = ObjectConvertClass.static_ext_string(dr["strTeacherGUID"]); model.strStudentGUID = ObjectConvertClass.static_ext_string(dr["strStudentGUID"]); model.strStudentNumber = ObjectConvertClass.static_ext_string(dr["strStudentNumber"]); model.strStudentName = ObjectConvertClass.static_ext_string(dr["strStudentName"]); }
/// <summary> /// 读取DataRow数据到Model中 /// </summary> private void RelationsDataRowToModel(XYTeacher model, DataRow dr) { model.strTeacherGUID = ObjectConvertClass.static_ext_string(dr["strTeacherGUID"]); model.strTeacherNumber = ObjectConvertClass.static_ext_string(dr["strTeacherNumber"]); model.strTeacherName = ObjectConvertClass.static_ext_string(dr["strTeacherName"]); //学员数组 XYStudentArray listStudent = new XYStudentArray(); XYStudent _XYStudent = new XYStudent(); _XYStudent.strTeacherGUID = ObjectConvertClass.static_ext_string(dr["strTeacherGUID"]); _XYStudent.strStudentGUID = ObjectConvertClass.static_ext_string(dr["strStudentGUID"]); _XYStudent.strStudentNumber = ObjectConvertClass.static_ext_string(dr["strStudentNumber"]); _XYStudent.strStudentName = ObjectConvertClass.static_ext_string(dr["strStudentName"]); listStudent.Add(_XYStudent); model.StudentArray = listStudent; }
/// <summary> /// 获得数据List /// </summary> public XYStudentArray GetStudentsDataList(string strTeacherGUID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from VIEW_Base_XYRelation_Student where strTeacherGUID=@strTeacherGUID "); strSql.Append(" and (not (strStudentGUID is null)) and (strStudentGUID <> '')"); SqlParameter[] parameters = { new SqlParameter("@strTeacherGUID", strTeacherGUID) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters).Tables[0]; XYStudentArray list = new XYStudentArray(); foreach (DataRow dr in dt.Rows) { XYStudent _Base_XYRelation_Student = new XYStudent(); StudentsDataRowToModel(_Base_XYRelation_Student, dr); list.Add(_Base_XYRelation_Student); } return(list); }