protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlFuns sf = new SqlFuns();
bind(sf.SearchStudent(true));
}
}
protected void DropDownList_stu_SelectedIndexChanged(object sender, EventArgs e)
{
SqlFuns sf = new SqlFuns();
uint snum = uint.Parse(DropDownList_stu.SelectedValue);
Student stu = sf.SearchStudent(snum);
Label_name.Text = stu.Name;
Label_birth.Text = stu.Birth.ToLongDateString();
Label_jodate.Text = stu.Joindate.ToLongDateString();
Label_mobile.Text = stu.Mobile;
Label_email.Text = stu.Email;
Label_addr.Text = stu.Address;
bind(sf.SearchPayment(snum));
bind(sf.SearchStudentRank(snum));
bind(sf.SearchAttendanceSNUM(snum));
Label1.Text = Label2.Text = "";
IList <StuParent> spr = sf.SearchStuParent(snum);
for (int i = 0; i < spr.Count; i++)
{
if (spr[i].Stpar == true)
{
Student pst = sf.SearchStudent(spr[i].Spnum);
if (spr[i].Mord == true)
{
Label1.Text = "Student Number: " + pst.Stnum + ", <br />Name: " + pst.Name + ", <br />Birthday: " + pst.Birth.ToShortDateString() + ", <br />Join Date: " + pst.Joindate.ToShortDateString() + ", <br />Address: " + pst.Address + ", <br />Phone Number: " + pst.Mobile + ", <br />Email: " + pst.Email;
}
else
{
Label2.Text = "Student Number: " + pst.Stnum + ", <br />Name: " + pst.Name + ", <br />Birthday: " + pst.Birth.ToShortDateString() + ", <br />Join Date: " + pst.Joindate.ToShortDateString() + ", <br />Address: " + pst.Address + ", <br />Phone Number: " + pst.Mobile + ", <br />Email: " + pst.Email;
}
}
else
{
Parent par = sf.SearchParent(spr[i].Spnum);
if (spr[i].Mord == true)
{
Label1.Text = "Name: " + par.Name + ", <br />Phone Number: " + par.Mobile + ", <br />Email: " + par.Email;
}
else
{
Label2.Text = "Name: " + par.Name + ", <br />Phone Number: " + par.Mobile + ", <br />Email: " + par.Email;
}
}
}
}
static void Main(string[] args)
{
SqlFuns sf = new SqlFuns();
IList <Student> st = sf.SearchStudent(true);
for (int i = 2; i < st.Count; i++)
{
StudentRank t = new StudentRank();
t.Stnum = st[i].Stnum;
t.Rank = 1;
t.Date = st[i].Joindate;
sf.AddStudentRank(t);
}
}