public void UpdateStudentResult(StudentResult studentresult)
{
var query = "UPDATE Student_Result SET TotalMarks = @totalmarks , ObtainedMarks = @obtainedmarks , Percentage = @percentage Where StudentId = @studentid ";
List <SqlParameter> parameters = new List <SqlParameter>
{
new SqlParameter()
{
ParameterName = "@totalmarks",
Value = studentresult.TotalMarks
},
new SqlParameter()
{
ParameterName = "@obtainedmarks",
Value = studentresult.ObtainedMarks
},
new SqlParameter()
{
ParameterName = "@percentage",
Value = studentresult.Percentage
},
new SqlParameter()
{
ParameterName = "@studentid",
Value = studentresult.StudentId
}
};
_dbClient.InvokeParameters(query, parameters);
}
public ActionResult Create([Bind(Include = "Id,RegisterStudentId,Name,Email,DepartmentId,CourseId,GradeLetterId")] StudentResult studentResult)
{
if (ModelState.IsValid)
{
var enrollCourses = db.StudentResults.Where(m => m.RegisterStudentId == studentResult.RegisterStudentId && m.CourseId == studentResult.CourseId).ToList();
if (enrollCourses.Count() == 1)
{
var id = enrollCourses[0].Id;
// var date = enrollCourses[0].EnrollDate;
studentResult.Id = id;
// studentResult.EnrollDate = date;
db.StudentResults.AddOrUpdate(studentResult);
db.SaveChanges();
ViewBag.Msg = "Update Result Successful!";
}
else
{
db.StudentResults.Add(studentResult);
db.SaveChanges();
ViewBag.Msg = "Result Saved Successful!";
}
//db.StudentResults.Add(studentResult);
// int aa = db.SaveChanges();
// return RedirectToAction("Create");
}
ViewBag.CourseId = new SelectList(db.Courses, "Id", "Code", studentResult.CourseId);
ViewBag.GradeLetterId = new SelectList(db.GradeLetters, "Id", "Grade", studentResult.GradeLetterId);
ViewBag.RegisterStudentId = new SelectList(db.RegisterStudents, "Id", "RegNo", studentResult.RegisterStudentId);
return(View(studentResult));
}
public void InsertStudentResult(StudentResult studentresult)
{
var query = "INSERT INTO Student_Result (TotalMarks, ObtainedMarks, Percentage, StudentId) VALUES (@totalmarks, @obtainedmarks, @percentage, @studentid) ";
List <SqlParameter> parameters = new List <SqlParameter>
{
new SqlParameter()
{
ParameterName = "@totalmarks",
Value = studentresult.TotalMarks
},
new SqlParameter()
{
ParameterName = "@obtainedmarks",
Value = studentresult.ObtainedMarks
},
new SqlParameter()
{
ParameterName = "@percentage",
Value = studentresult.Percentage
},
new SqlParameter()
{
ParameterName = "@studentid",
Value = studentresult.StudentId
}
};
_dbClient.InvokeParameters(query, parameters);
}
public int Save(StudentResult studentResult)
{
string query = "INSERT INTO Result VALUES(@studentId,@departmentId,@courseId,@gradeId)";
Command = new SqlCommand(query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("studentId", SqlDbType.Int);
Command.Parameters["studentId"].Value = studentResult.StudentId;
Command.Parameters.Add("departmentId", SqlDbType.Int);
Command.Parameters["departmentId"].Value = studentResult.DepartmentId;
Command.Parameters.Add("courseId", SqlDbType.Int);
Command.Parameters["courseId"].Value = studentResult.CourseId;
Command.Parameters.Add("gradeId", SqlDbType.Int);
Command.Parameters["gradeId"].Value = studentResult.GradeId;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public ActionResult Save(StudentResult studentResult)
{
ViewBag.StudentList = GetAllStudentsForDropdown();
ViewBag.GradeList = GetAllGradesForDropdown();
studentResult.CourseEnrollId = StudentResultManager.EnrollCourseManager.GetEnrollId(studentResult);
if (ModelState.IsValid)
{
string message = StudentResultManager.Save(studentResult);
ViewBag.Message = message;
if (message == "Result Saved")
{
ModelState.Clear();
return(View());
}
else
{
return(View(studentResult));
}
}
else
{
ViewBag.Message = "Please Fill All Field With Correct Format";
return(View(studentResult));
}
}
public JsonResult SaveStudentResult(StudentResult studentResult)
{
string result = "";
try
{
if (ModelState.IsValid)
{
StudentResult aResult = new StudentResult();
aResult.StudentId = studentResult.StudentId;
aResult.CourseId = studentResult.CourseId;
aResult.GradeId = studentResult.GradeId;
var alreadySaveResult = db.StudentResults.FirstOrDefault(x => x.StudentId == studentResult.StudentId && x.CourseId == studentResult.CourseId);
if (alreadySaveResult == null)
{
db.StudentResults.Add(aResult);
db.SaveChanges();
result = "Successfully! Save Student Result";
}
else
{
alreadySaveResult.GradeId = studentResult.GradeId;
db.SaveChanges();
result = "Successfully! Update Student Result";
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateResult(StudentResult studentResult)
{
var studentInfo = studentManager.GetStudentInfoByStudentId(studentResult.StudentId);
var department = studentManager.GetDepartmentByStudentId(studentResult.StudentId);
var result = studentManager.GetStudentResultByStudentId(studentResult.StudentId);
if (result.Count == 0)
{
ViewBag.Message = "No result found!";
}
else
{
ViewBag.StudentInfo = studentInfo;
ViewBag.Department = department;
ViewBag.Result = result;
double totalCredit = 0.00d, totalPoint = 0.00d, point;
foreach (var value in result)
{
totalCredit += value.Credit;
point = Convert.ToDouble(value.GradePoint);
totalPoint += point * value.Credit;
}
string cgpa = Convert.ToString(totalPoint / totalCredit);
if (cgpa.Length < 4)
{
ViewBag.CGPA = cgpa + ".00";
}
else
{
ViewBag.CGPA = cgpa.Substring(0, 4);
}
}
return(View());
}
public string Save(StudentResult result)
{
int rowAffected = studentResultGateway.UpdateGrade(result);
bool isExists = studentResultGateway.IsCourseResultSaved(result);
if (isExists)
{
if (rowAffected > 0)
{
return("Successfully Update Grade");
}
else
{
return("Update Failed");
}
}
else
{
int rowAffect = studentResultGateway.Save(result);
if (rowAffect > 0)
{
return("Save Successful");
}
else
{
return("Save Failed");
}
}
}
public byte[] PrePareReport(List <StudentResult> students, StudentResult studentResult)
{
_students = students;
#region
_document = new Document(PageSize.A4, 0f, 0f, 0f, 0f);
_document.SetPageSize(PageSize.A4);
_document.SetMargins(20f, 20f, 20f, 20f);
_pdfTable.WidthPercentage = 100;
_pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
_fontStyle = FontFactory.GetFont("Tahoma", 8f, 1);
PdfWriter.GetInstance(_document, _memoryStream);
_document.Open();
_pdfTable.SetWidths(new float[] { 70f, 100f, 100f });
#endregion
this.ReportHeader(studentResult);
this.ReportBody();
_pdfTable.HeaderRows = 2;
_document.Add(_pdfTable);
_document.Close();
return(_memoryStream.ToArray());
}
public List <StudentResult> GetStudentResultByStudentId(int studentId)
{
try
{
List <StudentResult> studentResults = null;
const string storeProcedure = "GetStudentResultByStudentId";
Connection.Open();
Command.CommandType = CommandType.StoredProcedure;
Command.CommandText = storeProcedure;
Command.Parameters.Clear();
Command.Parameters.AddWithValue("@StudentId", studentId);
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
studentResults = new List <StudentResult>();
while (Reader.Read())
{
var studentResult = new StudentResult
{
CourseCode = Reader["CourseCode"].ToString(),
CourseName = Reader["CourseName"].ToString(),
GradeLetter = Reader["GradeLetter"].ToString()
};
studentResults.Add(studentResult);
}
Reader.Close();
}
return(studentResults);
}
finally
{
Connection.Close();
}
}
public string SaveASubjectGrade(StudentResult aStudentResult)
{
aResultGateway = new ResultGateway();
if (DoesThisSubjectExist(aStudentResult))
{
if (DoesThisSubjectResultExist(aStudentResult))
{
if (aStudentResult.GradeLetter == "F")
{
aStudentResult.Status = 1;
}
else
{
aStudentResult.Status = 0;
}
return(aResultGateway.SaveASubjectGrade(aStudentResult));
}
else
{
return("You already completed this subject");
}
}
else
{
return("You Does not Get this Subject");
}
}
public int SaveStudentResult(StudentResult studentResult)
{
Query = "INSERT INTO StudentResults VALUES(@studentId,@courseId,@gradeLetter)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("studentId", SqlDbType.Int);
Command.Parameters["studentId"].Value = studentResult.StudentId;
Command.Parameters.Add("courseId", SqlDbType.Int);
Command.Parameters["courseId"].Value = studentResult.CourseId;
Command.Parameters.Add("gradeLetter", SqlDbType.VarChar);
Command.Parameters["gradeLetter"].Value = studentResult.GradeLetter;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public PagedResult <StudentResult> GetStudentByName(string name, Pageable pageable)
{
PagedResult <StudentResult> result = new PagedResult <StudentResult>();
result.Page = pageable.Page;
result.Size = pageable.Size;
int skipRow = PaginatorUtils.GetSkipRow(pageable.Page, pageable.Size);
result.Total = _context.Student.Count(p => p.IsDelete != true);
if (result.Total > 0)
{
// filter
var lstStudentByName = _context.Student.Where(x => x.Name.IndexOf(name, System.StringComparison.OrdinalIgnoreCase) >= 0 && x.IsDelete != true).OrderBy(x => x.Name).Skip(skipRow).Take(pageable.Size).ToList();
var lstContactId = (from i in lstStudentByName
select i.Id).ToList();
List <StudentResult> StudentResults = new List <StudentResult>();
foreach (var student in lstStudentByName)
{
var StudentView = new StudentResult()
{
Id = student.Id,
Name = student.Name,
gender = student.gender,
DateOfBirth = student.DateOfBirth,
address = student.address,
Point = student.Point
};
StudentResults.Add(StudentView);
}
result.Data = StudentResults;
}
return(result);
}
public List <StudentResult> GetSubjectResult(StudentResult aStudentResult)
{
try
{
connection.Open();
List <StudentResult> aStudentResults = new List <StudentResult>();
string query = "SELECT * FROM t_Result WHERE RegistationNo=@regNo And CourseId=@CourseId";
command.CommandText = query;
command.Parameters.Clear();
command.Parameters.AddWithValue("@regNo", aStudentResult.RegistationNo);
command.Parameters.AddWithValue("@CourseId", aStudentResult.CourseId);
SqlDataReader ResultReader = command.ExecuteReader();
while (ResultReader.Read())
{
StudentResult studentResult = new StudentResult();
studentResult.RegistationNo = ResultReader[0].ToString();
studentResult.DepartmentId = Convert.ToInt16(ResultReader[1].ToString());
studentResult.CourseId = Convert.ToInt16(ResultReader[2].ToString());
studentResult.GradeLetter = ResultReader[3].ToString();
studentResult.Status = Convert.ToInt16(ResultReader[4].ToString());
aStudentResults.Add(studentResult);
}
return(aStudentResults);
}
finally
{
connection.Close();
}
}
private void session_comboBox_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
StudentResult sr = new StudentResult();
StudentProfile sp = new StudentProfile();
DataTable dt1 = sr.getAbsentStudents(session_comboBox.Text);
int length = dt1.Rows.Count;
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Name");
dt.Columns.Add("StudentsMobileNo");
dt.Columns.Add("GuardianMobileNo");
dt.Columns.Add("AbsentDays");
DataRow dr;
for (int i = 0; i < length; i++)
{
dr = dt.NewRow();
string id = dt1.Rows[i][0].ToString();
dr["ID"] = id;
dr["Name"] = sp.getNameOfSelectedId(id);
dr["StudentsMobileNo"] = sp.getStudentMblSelectedId(id);
dr["GuardianMobileNo"] = sp.getGuardianMblSelectedId(id);
dr["AbsentDays"] = dt1.Rows[i][1].ToString();
dt.Rows.Add(dr);
}
absentStudent_dataGridView.DataSource = dt;
}
catch (Exception ex) {
MessageBox.Show(ex.ToString());
}
}
public List <StudentResult> GetAllStudentResults()
{
CommandObj.CommandText = "SELECT * FROM StudentResult_tbl";
List <StudentResult> studentResults = new List <StudentResult>();
ConnectionObj.Open();
SqlDataReader reader = CommandObj.ExecuteReader();
while (reader.Read())
{
StudentResult studentResult = new StudentResult
{
Id = Convert.ToInt32(reader["Id"].ToString()),
CourseId = Convert.ToInt32(reader["CourseId"].ToString()),
StudentId = Convert.ToInt32(reader["StudentId"].ToString()),
Grade = reader["Grade"].ToString(),
Status = (bool)reader["IsStudentActive"]
};
studentResults.Add(studentResult);
}
reader.Close();
CommandObj.Dispose();
ConnectionObj.Close();
return(studentResults);
}
public string SaveStudentResult(StudentResult studentResult)
{
bool hasExists = studentGateway.IsGradeExistsByStudentId(studentResult);
if (!hasExists)
{
int row = studentGateway.SaveStudentResult(studentResult);
if (row > 0)
{
return("Saved Successfully");
}
else
{
return("Failed");
}
}
else
{
int row = studentGateway.UpdateStudentResult(studentResult);
if (row > 0)
{
return("Update Successfully");
}
else
{
return("Failed");
}
}
}
public List <StudentResult> GetAllStudentResultsByRegNo(string RegNo)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM t_studentresult WHERE RegistrationNo='" + RegNo + "'";
SqlCommand command = new SqlCommand(query, connection);
List <StudentResult> list = new List <StudentResult>();
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
StudentResult aResult = new StudentResult();
aResult.RegistrationNo = reader["RegistrationNo"].ToString();
aResult.Name = reader["Name"].ToString();
aResult.Email = reader["Email"].ToString();
aResult.DepartmentName = reader["DepartmentName"].ToString();
aResult.CourseId = Convert.ToInt32(reader["CourseId"].ToString());
aResult.MidNum = Convert.ToInt32(reader["MidNum"].ToString());
aResult.QuizeNum = Convert.ToInt32(reader["QuizeNum"].ToString());
aResult.AsignmentNum = Convert.ToInt32(reader["AsignmentNum"].ToString());
aResult.Attendence = Convert.ToInt32(reader["Attendence"].ToString());
aResult.FinalNum = Convert.ToInt32(reader["FinalNum"].ToString());
aResult.Grade = reader["Grade"].ToString();
list.Add(aResult);
}
reader.Close();
}
connection.Close();
return(list);
}
public int SaveStudentResult(StudentResult studentResult)
{
try
{
connection = new SqlConnection(connectionString);
string query = "INSERT INTO t_StudentResult VALUES(@StudentId,@CourseId,@Grade,@Status)";
command = new SqlCommand(query, connection);
connection.Open();
command.Parameters.Clear();
command.Parameters.AddWithValue("@StudentId", studentResult.StudentId);
command.Parameters.AddWithValue("@CourseId", studentResult.CourseId);
command.Parameters.AddWithValue("@Grade", studentResult.Grade.ToUpper());
command.Parameters.AddWithValue("@Status", studentResult.Status);
int rowAffected = command.ExecuteNonQuery();
return(rowAffected);
}
catch (Exception exception)
{
throw new Exception("Could Not save", exception);
}
finally
{
connection.Close();
}
}
public IEnumerable <StudentResult> GetStudentEnrollCourses(int studentId)
{
try
{
connection = new SqlConnection(connectionString);
string query = "select course.Id as id,Course.Code as code,Course.Name as name,StudentEnrollInCourse.StudentId as studentId from Course inner join StudentEnrollInCourse on Course.Id=StudentEnrollInCourse.CourseId where StudentEnrollInCourse.StudentId='" + studentId + "'";
command = new SqlCommand(query, connection);
List <StudentResult> courses = new List <StudentResult>();
connection.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
StudentResult course = new StudentResult();
{
course.Id = Convert.ToInt32(reader["id"].ToString());
course.StudentId = (int)reader["studentId"];
course.CourseCode = reader["code"].ToString();
};
courses.Add(course);
}
reader.Close();
return(courses);
}
catch (Exception exception)
{
throw new Exception("Unable to connect ", exception);
}
finally
{
connection.Close();
}
}
public string Save(StudentResult studentResult)
{
StudentResult result =
GetAllStudentResults().ToList()
.Find(s => s.StudentId == studentResult.StudentId && s.CourseId == studentResult.CourseId && s.Status);
if (result == null)
{
if (studentGateway.SaveStudentResult(studentResult) > 0)
{
return("Saved sucessfully");
}
return("Failed to save");
}
if (result != null)
{
if (studentGateway.UpdateStudentResult(studentResult) > 0)
{
return("update sucessfully");
}
return("not updated");
}
return("Failed to save");
}
public ActionResult StudentResult(StudentResult studentResult)
{
ViewBag.Message = aStudentResultManager.Save(studentResult);
ViewBag.RegistrationNo = aRegisteredCourseManager.GetRegistrationNo();
ViewBag.Grades = aStudentResultManager.GetAllGrades();
return(View());
}
public ActionResult StudentResult(StudentResult studentResult)
{
bool isResultExist = false;
if (ModelState.IsValid)
{
string message;
isResultExist = resultManager.IsResultExist(studentResult);
if (isResultExist)
{
message = resultManager.UpdateResult(studentResult);
ViewBag.Message = message;
}
else
{
message = resultManager.Save(studentResult);
ViewBag.Message = message;
}
ModelState.Clear();
}
else
{
ViewBag.Message = "Model state is invalid!";
}
ViewBag.IsResultExist = isResultExist;
ViewBag.Grades = studentManager.GetAllGrades();
ViewBag.StudentInfo = studentManager.GetStudentInfo();
return(View());
}
public StudentResult StudentStatus([FromBody] InComingStudent inComingStudent)
{
ProcessStudent po = new ProcessStudent();
StudentResult studentResult = po.ProcessStudent();
return(StudentResult);
}
public StudentResult Find(long id)
{
Model.Student entity = Dao.Find(id);
StudentResult result = ResultConverter.Convert(entity);
return(result);
}
public string Save(StudentResult studentResult)
{
StudentResult result =
GetAllResult.ToList()
.Find(st => st.StudentId == studentResult.StudentId && st.CourseId == studentResult.CourseId);
if (result == null)
{
if (studentGateway.Insert(studentResult) > 0)
{
return("Saved sucessfull!");
}
return("Failed to save");
}
if (result.Status)
{
return("This course result already saved");
}
if (studentGateway.UpdateStudentResult(studentResult) > 0)
{
return("Saved sucessfull!");
}
return("This course result already saved");
}
public ActionResult DeleteConfirmed(int id)
{
StudentResult studentResult = _studentResultBusiness.GetById((int)id);
_studentResultBusiness.Delete(studentResult);
return(RedirectToAction("Index"));
}
public ActionResult AddStudentResult(StudentResult studentResult)
{
ViewBag.Student = new SelectList(db.Students.ToList().OrderBy(s => s.Id), "Id", "RegNo");
ViewBag.Course = new SelectList(db.Courses.ToList().OrderBy(s => s.Id), "Id", "Name");
ViewBag.Grade = new SelectList(db.Grades.ToList().OrderBy(s => s.Id), "Id", "GradeName");
try
{
if (ModelState.IsValid)
{
if (!db.StudentsResults.Any(t => t.CourseId == studentResult.CourseId && t.StudentId == studentResult.StudentId))
{
db.StudentsResults.Add(studentResult);
db.SaveChanges();
Session["success_div"] = "true";
Session["success_msg"] = "Insert Successfully.";
return(RedirectToAction("IndexStudentResult"));
}
else
{
Session["success_div"] = "true";
Session["success_msg"] = "Email is not unique.";
return(RedirectToAction("AddStudentResult"));
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(RedirectToAction("IndexStudentResult"));
}
//<-----Save Result------>
public List <StudentResult> GetStudentByEnrollCourse(int StudentId)
{
string query = "SELECT EnrollCourseTB.CourseId AS CourseId ,CourseTB.CourseName,StudentTB.DepartmentId,DepartmentTB.DepartmentName,StudentName,StudentTB.Id AS StudentId,Email FROM StudentTB INNER JOIN EnrollCourseTB ON EnrollCourseTB.StudentId = StudentTB.Id INNER JOIN DepartmentTB ON StudentTB.DepartmentId = DepartmentTB.Id INNER JOIN CourseTB ON CourseTB.Id = EnrollCourseTB.CourseId WHERE EnrollCourseTB.StudentId = " + StudentId;
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <StudentResult> studentViews = new List <StudentResult>();
while (Reader.Read())
{
StudentResult studentView = new StudentResult();
studentView.StudentId = Convert.ToInt32(Reader["StudentId"]);
studentView.DepartmentName = Reader["DepartmentName"].ToString();
studentView.Email = Reader["Email"].ToString();
studentView.StudentName = Reader["StudentName"].ToString();
studentView.CourseName = Reader["CourseName"].ToString();
studentView.CourseId = Convert.ToInt32(Reader["CourseId"]);
studentViews.Add(studentView);
}
Connection.Close();
return(studentViews);
}
private void loaddata(int id)
{
try
{
DataRow dr = StudentResult.GetDataByKey(id);
if (dr != null)
{
txttotalMarks.Text = dr["TotalMarks"].ToString();
txtObtainMarks.Text = dr["ObtainMarks"].ToString();
if (!string.IsNullOrEmpty(dr["ExamId"].ToString()))
{
drpExam.SelectedValue = dr["ExamId"].ToString();
// drpstd.SelectedValue = dr["StdId"].ToString();
}
if (!string.IsNullOrEmpty(dr["StudentId"].ToString()))
{
DataRow drStd = StudentMst.GetDataByKey(int.Parse(dr["StudentId"].ToString()));
if (drStd != null)
{
drpdiv.SelectedValue = drStd["DivId"].ToString();
bindStudent();
drpstudent.SelectedValue = drStd["SID"].ToString();
}
ResultID = id;
// drpstd.SelectedValue = dr["StdId"].ToString();
}
btnadd.Text = "Update";
}
}
catch
{
}
}
public StudentResult getStudentDataWho(string StudentID)
{
StudentResult returnValue = new StudentResult();
returnValue.StudentData = new CreateStudent();
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
Sqlconn.Open();
string sql = "SELECT * FROM StudentDatabase WHERE isDeleted=0 AND StudentID= @ID";////修正SQL式[ StudentID= (@ID) ] → [ ID = @ID ] by Awho
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@ID", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentID);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
returnValue.Column = Int64.Parse(dr["ID"].ToString());
CreateStudent addValue = new CreateStudent();
StaffDataBase sDB = new StaffDataBase();
List<string> StaffData = sDB.getStaffDataName(dr["WriteName"].ToString());
addValue.fillInName = StaffData[1];
addValue.ID = dr["ID"].ToString();
addValue.assessDate = dr["EvaluationDate"].ToString();
addValue.consultationDate = dr["ConsultDate"].ToString();
addValue.upDate = dr["Updated"].ToString();
addValue.caseStatu = dr["CaseStatu"].ToString();
addValue.Unit = dr["Unit"].ToString();
addValue.studentID = dr["StudentID"].ToString();
addValue.studentName = dr["StudentName"].ToString();
addValue.studentTWID = dr["StudentIdentity"].ToString();
addValue.censusAddressZip = dr["AddressZip1"].ToString();
addValue.censusAddressCity = dr["AddressCity1"].ToString();
addValue.censusAddress = dr["AddressOther1"].ToString();
addValue.addressZip = dr["AddressZip2"].ToString();
addValue.addressCity = dr["AddressCity2"].ToString();
addValue.address = dr["AddressOther2"].ToString();
addValue.studentbirthday = DateTime.Parse(dr["StudentBirthday"].ToString()).ToString("yyyy-MM-dd");
addValue.studentSex = dr["StudentSex"].ToString();
addValue.firstClassDate = DateTime.Parse(dr["ClassDate"].ToString()).ToString("yyyy-MM-dd");
addValue.guaranteeDate = DateTime.Parse(dr["GuaranteeDate"].ToString()).ToString("yyyy-MM-dd");
addValue.endReasonDate = DateTime.Parse(dr["CompletedDate"].ToString()).ToString("yyyy-MM-dd");
addValue.endReasonType = dr["CompletedType"].ToString();
addValue.endReason = dr["CompletedReason"].ToString();
addValue.sendDateSince = DateTime.Parse(dr["ShortEndDateSince"].ToString()).ToString("yyyy-MM-dd");
addValue.sendDateUntil = DateTime.Parse(dr["ShortEndDateUntil"].ToString()).ToString("yyyy-MM-dd");
addValue.nomembershipType = dr["NomembershipType"].ToString();
addValue.nomembershipReason = dr["NomembershipReason"].ToString();
addValue.studentPhoto = dr["StudentAvatar"].ToString();
addValue.wCare = dr["CaregiversDaytime"].ToString();
addValue.wCareName = dr["CaregiversDaytimeText"].ToString();
addValue.bCare = dr["CaregiversNight"].ToString();
addValue.bCareName = dr["CaregiversNightText"].ToString();
addValue.fPRelation1 = dr["ContactRelation1"].ToString();
addValue.fPName1 = dr["ContactName1"].ToString();
addValue.fPTel1 = dr["ContactTel_company1"].ToString();
addValue.fPPhone1 = dr["ContactPhone1"].ToString();
addValue.fPHPhone1 = dr["ContactTel_home1"].ToString();
addValue.fPFax1 = dr["ContactFax1"].ToString();
addValue.fPRelation2 = dr["ContactRelation2"].ToString();
addValue.fPName2 = dr["ContactName2"].ToString();
addValue.fPTel2 = dr["ContactTel_company2"].ToString();
addValue.fPPhone2 = dr["ContactPhone2"].ToString();
addValue.fPHPhone2 = dr["ContactTel_home2"].ToString();
addValue.fPFax2 = dr["ContactFax2"].ToString();
addValue.fPRelation3 = dr["ContactRelation3"].ToString();
addValue.fPName3 = dr["ContactName3"].ToString();
addValue.fPTel3 = dr["ContactTel_company3"].ToString();
addValue.fPPhone3 = dr["ContactPhone3"].ToString();
addValue.fPHPhone3 = dr["ContactTel_home3"].ToString();
addValue.fPFax3 = dr["ContactFax3"].ToString();
addValue.fPRelation4 = dr["ContactRelation4"].ToString();
addValue.fPName4 = dr["ContactName4"].ToString();
addValue.fPTel4 = dr["ContactTel_company4"].ToString();
addValue.fPPhone4 = dr["ContactPhone4"].ToString();
addValue.fPHPhone4 = dr["ContactTel_home4"].ToString();
addValue.fPFax4 = dr["ContactFax4"].ToString();
addValue.email = dr["StudentEmail"].ToString();
addValue.sourceType = dr["ReferralSourceType"].ToString();
addValue.sourceName = dr["ReferralSource"].ToString();
addValue.manualWhether = dr["PhysicalAndMentalDisabilityHandbook"].ToString();
addValue.manualCategory1 = dr["DisabilityCategory1"].ToString();
addValue.manualGrade1 = dr["DisabilityGrade1"].ToString();
addValue.manualCategory2 = dr["DisabilityCategory2"].ToString();
addValue.manualGrade2 = dr["DisabilityGrade2"].ToString();
addValue.manualCategory3 = dr["DisabilityCategory3"].ToString();
addValue.manualGrade3 = dr["DisabilityGrade3"].ToString();
addValue.manualNo = dr["NoDisabilityHandbook"].ToString();
addValue.manualUnit = dr["ApplyDisabilityHandbook"].ToString();
addValue.studentManualImg = dr["DisabilityProve"].ToString();
addValue.notificationWhether = dr["Notify"].ToString();
addValue.notificationUnit = dr["Notify_Unit"].ToString();
addValue.notificationManage = dr["Notify_Member"].ToString();
addValue.notificationTel = dr["Notify_Tel"].ToString();
addValue.notificationDate = DateTime.Parse(dr["Notify_Date"].ToString()).ToString("yyyy-MM-dd");
addValue.notificationCity = dr["Notify_City"].ToString();
addValue.economy = dr["EconomyState"].ToString();
addValue.economyLow = dr["EconomyLow"].ToString();
addValue.fAppellation1 = dr["FamilyAppellation1"].ToString();
addValue.fName1 = dr["FamilyName1"].ToString();
addValue.fBirthday1 = DateTime.Parse(dr["FamilyBirthday1"].ToString()).ToString("yyyy-MM-dd");
addValue.fEDU1 = dr["FamilyEducation1"].ToString();
addValue.fProfession1 = dr["FamilyProfession1"].ToString();
addValue.fLive1 = dr["FamilyLive1"].ToString();
addValue.fHearing1 = dr["FamilyHearing1"].ToString();
addValue.fHealthy1 = dr["FamilyHealth1"].ToString();
addValue.familyText01 = dr["FamilyHealthText1"].ToString();
addValue.fAppellation2 = dr["FamilyAppellation2"].ToString();
addValue.fName2 = dr["FamilyName2"].ToString();
addValue.fBirthday2 = DateTime.Parse(dr["FamilyBirthday2"].ToString()).ToString("yyyy-MM-dd");
addValue.fEDU2 = dr["FamilyEducation2"].ToString();
addValue.fProfession2 = dr["FamilyProfession2"].ToString();
addValue.fLive2 = dr["FamilyLive2"].ToString();
addValue.fHearing2 = dr["FamilyHearing2"].ToString();
addValue.fHealthy2 = dr["FamilyHealth2"].ToString();
addValue.familyText02 = dr["FamilyHealthText2"].ToString();
addValue.fAppellation3 = dr["FamilyAppellation3"].ToString();
addValue.fName3 = dr["FamilyName3"].ToString();
addValue.fBirthday3 = DateTime.Parse(dr["FamilyBirthday3"].ToString()).ToString("yyyy-MM-dd");
addValue.fEDU3 = dr["FamilyEducation3"].ToString();
addValue.fProfession3 = dr["FamilyProfession3"].ToString();
addValue.fLive3 = dr["FamilyLive3"].ToString();
addValue.fHearing3 = dr["FamilyHearing3"].ToString();
addValue.fHealthy3 = dr["FamilyHealth3"].ToString();
addValue.familyText03 = dr["FamilyHealthText3"].ToString();
addValue.fAppellation4 = dr["FamilyAppellation4"].ToString();
addValue.fName4 = dr["FamilyName4"].ToString();
addValue.fBirthday4 = DateTime.Parse(dr["FamilyBirthday4"].ToString()).ToString("yyyy-MM-dd");
addValue.fEDU4 = dr["FamilyEducation4"].ToString();
addValue.fProfession4 = dr["FamilyProfession4"].ToString();
addValue.fLive4 = dr["FamilyLive4"].ToString();
addValue.fHearing4 = dr["FamilyHearing4"].ToString();
addValue.fHealthy4 = dr["FamilyHealth4"].ToString();
addValue.familyText04 = dr["FamilyHealthText4"].ToString();
addValue.fAppellation5 = dr["FamilyAppellation5"].ToString();
addValue.fName5 = dr["FamilyName5"].ToString();
addValue.fBirthday5 = DateTime.Parse(dr["FamilyBirthday5"].ToString()).ToString("yyyy-MM-dd");
addValue.fEDU5 = dr["FamilyEducation5"].ToString();
addValue.fProfession5 = dr["FamilyProfession5"].ToString();
addValue.fLive5 = dr["FamilyLive5"].ToString();
addValue.fHearing5 = dr["FamilyHearing5"].ToString();
addValue.fHealthy5 = dr["FamilyHealth5"].ToString();
addValue.familyText05 = dr["FamilyHealthText5"].ToString();
addValue.fAppellation6 = dr["FamilyAppellation6"].ToString();
addValue.fName6 = dr["FamilyName6"].ToString();
addValue.fBirthday6 = DateTime.Parse(dr["FamilyBirthday6"].ToString()).ToString("yyyy-MM-dd");
addValue.fEDU6 = dr["FamilyEducation6"].ToString();
addValue.fProfession6 = dr["FamilyProfession6"].ToString();
addValue.fLive6 = dr["FamilyLive6"].ToString();
addValue.fHearing6 = dr["FamilyHearing6"].ToString();
addValue.fHealthy6 = dr["FamilyHealth6"].ToString();
addValue.familyText06 = dr["FamilyHealthText6"].ToString();
addValue.fAppellation7 = dr["FamilyAppellation7"].ToString();
addValue.fName7 = dr["FamilyName7"].ToString();
addValue.fBirthday7 = DateTime.Parse(dr["FamilyBirthday7"].ToString()).ToString("yyyy-MM-dd");
addValue.fEDU7 = dr["FamilyEducation7"].ToString();
addValue.fProfession7 = dr["FamilyProfession7"].ToString();
addValue.fLive7 = dr["FamilyLive7"].ToString();
addValue.fHearing7 = dr["FamilyHearing7"].ToString();
addValue.fHealthy7 = dr["FamilyHealth7"].ToString();
addValue.familyText07 = dr["FamilyHealthText7"].ToString();
addValue.fAppellation8 = dr["FamilyAppellation8"].ToString();
addValue.fName8 = dr["FamilyName8"].ToString();
addValue.fBirthday8 = DateTime.Parse(dr["FamilyBirthday8"].ToString()).ToString("yyyy-MM-dd");
addValue.fEDU8 = dr["FamilyEducation8"].ToString();
addValue.fProfession8 = dr["FamilyProfession8"].ToString();
addValue.fLive8 = dr["FamilyLive8"].ToString();
addValue.fHearing8 = dr["FamilyHearing8"].ToString();
addValue.fHealthy8 = dr["FamilyHealth8"].ToString();
addValue.familyText08 = dr["FamilyHealthText8"].ToString();
addValue.lang1 = dr["FamilyLanguage"].ToString();
addValue.lang1t01 = dr["FamilyLanguageText"].ToString();
addValue.lang2 = dr["FamilyConnectLanguage"].ToString();
addValue.lang2t01 = dr["FamilyConnectLanguageText"].ToString();
addValue.familyEcological = dr["FamilyProfile1"].ToString();
addValue.famailySituation = dr["FamilyProfile2"].ToString();
addValue.famailyMedical = dr["FamilyProfile3"].ToString();
addValue.famailyActionSituation = dr["FamilyProfile4"].ToString();
addValue.fswAssess = dr["FamilyProfile5"].ToString();
StaffData = sDB.getStaffDataName(dr["FamilyProfileWriteName"].ToString());
addValue.socialName = StaffData[1];
addValue.socialDate = DateTime.Parse(dr["FamilyProfileWriteDate"].ToString()).ToString("yyyy-MM-dd");
returnValue.StudentData = addValue;
StudentHearingInformation addValue2 = new StudentHearingInformation();
addValue2.history = dr["StudentDevelop"].ToString();
addValue2.history02t01 = dr["StudentDevelopText21"].ToString();
addValue2.history02t02 = dr["StudentDevelopText22"].ToString();
addValue2.history03t01 = dr["StudentDevelopText31"].ToString();
addValue2.history06t01 = dr["StudentDevelopText61"].ToString();
addValue2.history06t02 = dr["StudentDevelopText62"].ToString();
addValue2.history08t01 = dr["StudentDevelopText81"].ToString();
addValue2.history10t01 = dr["StudentDevelopText10"].ToString();
addValue2.history11t01 = dr["StudentDevelopText11"].ToString();
addValue2.history12t01 = dr["StudentDevelopText12"].ToString();
addValue2.problems01t01 = dr["HearingProblemAge"].ToString();
addValue2.problems01t02 = dr["HearingProblemMonth"].ToString();
addValue2.hearingQ = dr["HearingProblem"].ToString();
addValue2.hearingQText = dr["HearingProblemText"].ToString();
addValue2.problems02t01 = dr["DiagnoseAge"].ToString();
addValue2.problems02t02 = dr["DiagnoseMonth"].ToString();
addValue2.problems02t03 = dr["DiagnoseAgency"].ToString();
addValue2.problems02t04 = dr["DiagnoseR"].ToString();
addValue2.problems02t05 = dr["DiagnoseL"].ToString();
addValue2.hearingcheck = dr["NewbornHearing"].ToString();
addValue2.hearingYescheck = dr["NewbornHearingInspection"].ToString();
addValue2.hearingYesPlace = dr["NewbornHearingInspectionAgency"].ToString();
addValue2.hearingYesResultR = dr["NewbornHearingInspectionDiagnoseR"].ToString();
addValue2.hearingYesResultL = dr["NewbornHearingInspectionDiagnoseL"].ToString();
addValue2.sleepcheck = dr["AuditoryElectrophysiology1"].ToString();
addValue2.sleepcheckTime1 = DateTime.Parse(dr["AuditoryElectrophysiology_Date1"].ToString()).ToString("yyyy-MM-dd");//dr["AuditoryElectrophysiology_Date1"].ToString();
addValue2.sleepcheckPlace1 = dr["AuditoryElectrophysiology_Agency1"].ToString();
addValue2.sleepcheckCheckItem1 = dr["AuditoryElectrophysiology_Item1"].ToString();
addValue2.sleepcheckResultL1 = dr["AuditoryElectrophysiology_Diagnose1R"].ToString();
addValue2.sleepcheckResultR1 = dr["AuditoryElectrophysiology_Diagnose1L"].ToString();
addValue2.sleepcheckTime2 = DateTime.Parse(dr["AuditoryElectrophysiology_Date2"].ToString()).ToString("yyyy-MM-dd");
addValue2.sleepcheckPlace2 = dr["AuditoryElectrophysiology_Agency2"].ToString();
addValue2.sleepcheckCheckItem2 = dr["AuditoryElectrophysiology_Item2"].ToString();
addValue2.sleepcheckResultL2 = dr["AuditoryElectrophysiology_Diagnose2R"].ToString();
addValue2.sleepcheckResultR2 = dr["AuditoryElectrophysiology_Diagnose2L"].ToString();
addValue2.sleepcheckTime3 = DateTime.Parse(dr["AuditoryElectrophysiology_Date3"].ToString()).ToString("yyyy-MM-dd");
addValue2.sleepcheckPlace3 = dr["AuditoryElectrophysiology_Agency3"].ToString();
addValue2.sleepcheckCheckItem3 = dr["AuditoryElectrophysiology_Item3"].ToString();
addValue2.sleepcheckResultL3 = dr["AuditoryElectrophysiology_Diagnose3R"].ToString();
addValue2.sleepcheckResultR3 = dr["AuditoryElectrophysiology_Diagnose3L"].ToString();
addValue2.sleepcheckTime4 = DateTime.Parse(dr["AuditoryElectrophysiology_Date4"].ToString()).ToString("yyyy-MM-dd");
addValue2.sleepcheckPlace4 = dr["AuditoryElectrophysiology_Agency4"].ToString();
addValue2.sleepcheckCheckItem4 = dr["AuditoryElectrophysiology_Item4"].ToString();
addValue2.sleepcheckResultL4 = dr["AuditoryElectrophysiology_Diagnose4R"].ToString();
addValue2.sleepcheckResultR4 = dr["AuditoryElectrophysiology_Diagnose4L"].ToString();
addValue2.sleepcheckTime5 = DateTime.Parse(dr["AuditoryElectrophysiology_Date5"].ToString()).ToString("yyyy-MM-dd");
addValue2.sleepcheckPlace5 = dr["AuditoryElectrophysiology_Agency5"].ToString();
addValue2.sleepcheckCheckItem5 = dr["AuditoryElectrophysiology_Item5"].ToString();
addValue2.sleepcheckResultL5 = dr["AuditoryElectrophysiology_Diagnose5R"].ToString();
addValue2.sleepcheckResultR5 = dr["AuditoryElectrophysiology_Diagnose5L"].ToString();
addValue2.ctmri = dr["CTorMRI"].ToString();
addValue2.ctmriTime = DateTime.Parse(dr["CTorMRI_Date1"].ToString()).ToString("yyyy-MM-dd");
addValue2.ctmriPlace = dr["CTorMRI_Agency1"].ToString();
addValue2.ctmriResultL = dr["CTorMRI_DiagnoseR"].ToString();
addValue2.ctmriResultR = dr["CTorMRI_DiagnoseL"].ToString();
addValue2.gene = dr["GeneScreening"].ToString();
addValue2.geneTime = DateTime.Parse(dr["GeneScreening_Date"].ToString()).ToString("yyyy-MM-dd");
addValue2.genePlace = dr["GeneScreening_Agency"].ToString();
addValue2.geneResult = dr["GeneScreening_Item"].ToString();
addValue2.familyhistory = dr["FamilyHearingProblemHistory"].ToString();
addValue2.familyhistoryText = dr["FamilyHearingProblemHistoryText"].ToString();
addValue2.changehistory = dr["HearingChangeHistory"].ToString();
addValue2.changehistoryText = dr["HearingChangeHistoryText"].ToString();
addValue2.assistmanage = dr["AidsManagement"].ToString();
addValue2.accessory = dr["AidsManagementTextAge"].ToString();
addValue2.assistmanageR = dr["HearingAids_R"].ToString();
addValue2.brandR = dr["AidsBrand_R"].ToString();
addValue2.modelR = dr["AidsModel_R"].ToString();
addValue2.buyingPlaceR = dr["AidsOptionalLocation_R"].ToString();
addValue2.buyingtimeR = DateTime.Parse(dr["AidsOptionalTime_R"].ToString()).ToString("yyyy-MM-dd");
addValue2.insertHospitalR = dr["EEarHospital_R"].ToString();
addValue2.openHzDateR = DateTime.Parse(dr["EEarOpen_R"].ToString()).ToString("yyyy-MM-dd");
addValue2.assistmanageL = dr["HearingAids_L"].ToString();
addValue2.brandL = dr["AidsBrand_L"].ToString();
addValue2.modelL = dr["AidsModel_L"].ToString();
addValue2.buyingtimeL = DateTime.Parse(dr["AidsOptionalTime_L"].ToString()).ToString("yyyy-MM-dd");
addValue2.buyingPlaceL = dr["AidsOptionalLocation_L"].ToString();
addValue2.insertHospitalL = dr["EEarHospital_L"].ToString();
addValue2.openHzDateL = DateTime.Parse(dr["EEarOpen_L"].ToString()).ToString("yyyy-MM-dd");
addValue2.allassis = dr["AllDayAids"].ToString();
addValue2.allassisNoText = dr["AllDayAidsText"].ToString();
addValue2.assis1 = dr["ActiveReaction"].ToString();
addValue2.assis1NoText = dr["ActiveReactionText"].ToString();
addValue2.assis2 = dr["BasicCare"].ToString();
addValue2.assis2NoText = dr["BasicCareText"].ToString();
addValue2.assisFM = dr["UseFMsystem"].ToString();
addValue2.assisFMBrand = dr["UseFMsystemBrand"].ToString();
addValue2.assessnotes = dr["HearingAssessmentSummary"].ToString();
addValue2.assessnotes1 = dr["EarEndoscopy"].ToString();
addValue2.assessnotes102Text = dr["EarEndoscopyAbnormalText"].ToString();
addValue2.problems11t02 = dr["PureToneText"].ToString();
addValue2.assessnotes2 = dr["Tympanogram"].ToString();
addValue2.problems11t03 = dr["SATorSDT"].ToString();
addValue2.problems11t04 = dr["SpeechRecognition"].ToString();
addValue2.problems11t05 = dr["AidsSystem"].ToString();
addValue2.problems11t06 = dr["HearingInspection"].ToString();
addValue2.problems11t07 = dr["HearingOther"].ToString();
addValue2.inspectorID = dr["Audiologist"].ToString();
addValue2.inspectorDate = DateTime.Parse(dr["SurveyingDate"].ToString()).ToString("yyyy-MM-dd");
returnValue.HearingData = addValue2;
StudentTeachingInformation addValue4 = new StudentTeachingInformation();
addValue4.case1 = dr["CaseFamilyCooperative"].ToString();
addValue4.case1t04 = dr["EntrustOthers"].ToString();
addValue4.case1t05 = dr["CooperativeDifficulty"].ToString();
addValue4.case2 = dr["RearingAttitude"].ToString();
addValue4.case21 = dr["RearingAttitude1"].ToString();
addValue4.case21t01 = dr["RearingAttitude1Text"].ToString();
addValue4.case22 = dr["RearingAttitude2"].ToString();
addValue4.case22t01 = dr["RearingAttitude2Text"].ToString();
addValue4.case23 = dr["RearingAttitude3"].ToString();
addValue4.case23t01 = dr["RearingAttitude3Text"].ToString();
addValue4.case24 = dr["RearingAttitude4"].ToString();
addValue4.case24t01 = dr["RearingAttitude4Text"].ToString();
addValue4.case25 = dr["RearingAttitude5"].ToString();
addValue4.case25t01 = dr["RearingAttitude5Text"].ToString();
addValue4.case26 = dr["RearingAttitude6"].ToString();
addValue4.case26t01 = dr["RearingAttitude6Text"].ToString();
addValue4.case3 = dr["Dispositional"].ToString();
addValue4.case31 = dr["Dispositional1"].ToString();
addValue4.case31t01 = dr["Dispositional1Text"].ToString();
addValue4.case32 = dr["Dispositional2"].ToString();
addValue4.case32t01 = dr["Dispositional2Text"].ToString();
addValue4.case33 = dr["Dispositional3"].ToString();
addValue4.case33t01 = dr["Dispositional3Text"].ToString();
addValue4.case34 = dr["Dispositional4"].ToString();
addValue4.case34t01 = dr["Dispositional4Text"].ToString();
addValue4.attend = dr["Attendance"].ToString();
addValue4.attend01t01 = dr["AttendanceText"].ToString();
addValue4.accompany = dr["TeachEscorts"].ToString();
addValue4.accompany01t01 = dr["TeachEscortsText"].ToString();
addValue4.teach = dr["AfterTeach"].ToString();
addValue4.teach01t01 = dr["AfterTeachText"].ToString();
addValue4.caseQ = dr["MajorProblem"].ToString();
addValue4.caseQ01t01 = dr["MajorProblemText"].ToString();
addValue4.OtherRemark1 = dr["RemarkOther"].ToString();
addValue4.case4 = dr["LearningAttitude"].ToString();
addValue4.case5 = dr["Temperament"].ToString();
addValue4.case6 = dr["Activity"].ToString();
addValue4.case7 = dr["Focus"].ToString();
addValue4.case8 = dr["Persistence"].ToString();
addValue4.case9 = dr["CommunicationBehavior"].ToString();
addValue4.case10 = dr["AuditorySkill"].ToString();
addValue4.case11 = dr["Acknowledge"].ToString();
addValue4.case12 = dr["Language"].ToString();
addValue4.case12t01 = dr["LanguageText"].ToString();
addValue4.case13 = dr["Action"].ToString();
addValue4.wear = dr["WearAids"].ToString();
addValue4.mind = dr["SpiritAndCoordinate"].ToString();
addValue4.mind01t01 = dr["SpiritAndCoordinateOther"].ToString();
addValue4.connectwish = dr["Communication"].ToString();
addValue4.studywish = dr["LearningDesire"].ToString();
addValue4.related = dr["AttachmentData"].ToString();
addValue4.related01t01 = dr["AttachmentDataText"].ToString();
addValue4.OtherRemark2 = dr["RemarkOther2"].ToString();
addValue4.case14 = dr["ExistingResources"].ToString();
addValue4.trusteeship = dr["InterventionAgencies"].ToString();
addValue4.case14t01 = dr["HospitalIntervention"].ToString();
addValue4.proceed = dr["RelatedIntervention"].ToString();
addValue4.proceedt01 = dr["RelatedInterventionText"].ToString();
addValue4.preschools = dr["InNurserySchool"].ToString();
addValue4.case15 = dr["HearingRehabilitation"].ToString();
addValue4.Rehabilitation1 = dr["CaseNeed"].ToString();
addValue4.Rehabilitation2 = dr["CaseFamilyEnthusiasm"].ToString();
addValue4.Rehabilitation3 = dr["Rehousing"].ToString();
addValue4.Rehabilitation3Text = dr["RehousingText"].ToString();
addValue4.case16 = dr["CaseFamilyCourseProposal"].ToString();
addValue4.OtherRemark3 = dr["CaseFamilyCourseProposalText"].ToString();
addValue4.case17 = dr["CaseCourseProposal"].ToString();
addValue4.OtherRemark4 = dr["CaseCourseProposalText"].ToString();
addValue4.teacherID = dr["Teacher"].ToString();
addValue4.teacherDate = DateTime.Parse(dr["TeacherDate"].ToString()).ToString("yyyy-MM-dd");
returnValue.TeachData = addValue4;
}
dr.Close();
List<StudentBodyInformation> addValue3 = new List<StudentBodyInformation>();
sql = "SELECT * FROM StudentHeightWeightRecord WHERE isDeleted=0 AND StudentID=(@ID)";
cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@ID", SqlDbType.NVarChar).Value = returnValue.StudentData.studentID;
dr = cmd.ExecuteReader();
while (dr.Read())
{
StudentBodyInformation addValue3item = new StudentBodyInformation();
addValue3item.RecordID = dr["hwID"].ToString();
addValue3item.RecordDate = DateTime.Parse(dr["hwDate"].ToString()).ToString("yyyy-MM-dd");
addValue3item.studentID = dr["StudentID"].ToString();
addValue3item.RecordHeight = dr["StudentHeight"].ToString();
addValue3item.RecordWeight = dr["StudentWeight"].ToString();
addValue3item.RecordRemark = dr["hwRemark"].ToString();
addValue3.Add(addValue3item);
}
dr.Close();
returnValue.BodyData = addValue3;
Sqlconn.Close();
}
catch (Exception e)
{
returnValue.checkNo = "-1";
returnValue.errorMsg = e.Message;
}
}
return returnValue;
}
