public DBModel.Student GetStudentAndClassByStudentID(int ID)
{
var Result = new DBModel.Student();
var Students = new List <object>();
var Sql = string.Empty;
try
{
Sql = string.Format(DBScript.DBScript.GetStudentAndClassByStudentID, ID);
Students = InitSettings.GetDBManager().ExecuteRow(Sql, null, null);
if (Students.Count > 0)
{
var d = (Dictionary <string, object>)Students[0];
Result.ID = Convert.ToInt16(d["ID"]);
Result.ClassID = Convert.ToInt16(d["ClassID"]);
Result.Gender = Convert.ToInt16(d["Gender"]);
Result.ParentName = Convert.ToString(d["ParentName"]);
Result.ParentMobile = Convert.ToString(d["ParentMobile"]);
Result.ClassName = Convert.ToString(d["ClassName"]);
Result.Note = Convert.ToString(d["Note"]);
Result.PictureName = Convert.ToString(d["PictureName"]);
Result.StudentNo = Convert.ToString(d["StudentNo"]);
Result.Name = Convert.ToString(d["Name"]);
Result.StudentFeatureID = Convert.ToInt16(d["StudentFeatureID"]);
Result.StudentClassID = Convert.ToInt16(d["StudentClassID"]);
}
}
finally
{
}
return(Result);
}
private void InitData()
{
if (IsEditModel)
{
try
{
var StudentInfo = new DBModel.Student();
StudentInfo = GetStudentInstance().GetStudentAndClassByStudentID(StudentID);
txtName.Text = StudentInfo.Name;
txtStudentNo.Text = StudentInfo.StudentNo;
txtParentName.Text = StudentInfo.ParentName;
txtParentMobileNumber.Text = StudentInfo.ParentMobile;
cbClass.SelectedValue = StudentInfo.ClassID;
txtNote.Text = StudentInfo.Note;
StudentFeatureID = StudentInfo.StudentFeatureID;
StudentClassID = StudentInfo.StudentClassID;
if (StudentInfo.Gender == 0)
{
rbGirl.Checked = true;
}
else
{
rbBoy.Checked = true;
}
btnSave.Enabled = true;
pbPreview.ImageLocation = string.Concat(InitSettings.GetPicturePath, StudentInfo.PictureName);
}
finally {
}
}
}
