//窗体加载 private void StudentLoginForm_Load(object sender, EventArgs e) { GetGroupsBLL bll = new GetGroupsBLL(); combSchool.DataSource = bll.getSchoolGroup(); combSchool.ValueMember = "SchoolName"; }
/// <summary> /// 选择学院后 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void combCollege_SelectedIndexChanged(object sender, EventArgs e) { GetGroupsBLL bll = new GetGroupsBLL(); string collegeID = ((CollegeGroup)combCollege.SelectedItem).CollegeID; combProfession.DataSource = bll.getProfessionGroup(collegeID); combProfession.ValueMember = "ProfessionName"; }
//选择学校后 private void combSchool_SelectedIndexChanged(object sender, EventArgs e) { GetGroupsBLL bll = new GetGroupsBLL(); string schoolID = ((SchoolGroup)(combSchool.SelectedItem)).SchoolID; combCollege.DataSource = bll.getCollegeGroup(schoolID); combCollege.ValueMember = "CollegeName"; }
private void BookTypeTree_Load(object sender, EventArgs e) { GetGroupsBLL bll = new GetGroupsBLL(); List <BookTypeGroup> list = bll.getBookTypeGroup(); ControlLoad load = new ControlLoad(); //初始化树列表 load.LoadBookTypeTree("0", this.tvSearch.Nodes[0], list); this.tvSearch.SelectedNode = this.tvSearch.Nodes[0]; this.tvSearch.SelectedNode.Expand(); }
/// <summary> /// 窗体加载事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Form1_Load(object sender, EventArgs e) { this.dgvBook.AutoGenerateColumns = false; GetGroupsBLL bll = new GetGroupsBLL(); types = bll.getBookTypeGroup(); //加载学生管理 tpStudent.Controls.Clear(); AdminForm ad = new AdminForm(); ad.TopLevel = false; tpStudent.Controls.Add(ad); ad.Show(); }
private void InfoBaseForm_Load(object sender, EventArgs e) { StudentInfoBLL stubll = new StudentInfoBLL(); StudentInfoModel stuModel = new StudentInfoModel(); GetGroupsBLL group = new GetGroupsBLL(); stuModel = stubll.getStudentInfoByID(stuID); txtstuName.Text = stuModel.StuName; txtstuName.ReadOnly = true; txtstuID.Text = stuModel.StuID; txtstuID.ReadOnly = true; txtentrance.Text = stuModel.StuClass; txtentrance.ReadOnly = true; BorrowHistoryBLL bll = new BorrowHistoryBLL(); List <ShowBorrowHistory> list = bll.getListBorrowHisoryNow(stuModel.StuID); txtnowBorrows.Text = list.Count.ToString(); string sql = "select schoolName from SchoolType where schoolid='" + stuModel.SchoolID + "'"; SQLHelper h = new SQLHelper(); SqlParameter[] psa = { new SqlParameter("@stuID", stuID), }; string s = h.ExecuteScalar(sql, psa).ToString(); txtschool.Text = s; txtschool.ReadOnly = true; string sqla = "select CollegeName from Collegetype where CollegeId=" + "'" + stuModel.CollegeID + "'"; SQLHelper a = new SQLHelper(); SqlParameter[] psb = { new SqlParameter("@stuID", stuID), }; string t = a.ExecuteScalar(sqla, psb).ToString(); txtcollege.Text = t; txtcollege.ReadOnly = true; string sqlb = "select ProfessionName from professiontype where ProfessionID=" + "'" + stuModel.ProfessionID + "'"; SQLHelper b = new SQLHelper(); SqlParameter[] psc = { new SqlParameter("@stuID", stuID), }; string u = b.ExecuteScalar(sqlb, psc).ToString(); txtprofession.Text = u; txtprofession.ReadOnly = true; txtstuClass.Text = stuModel.StuClass; txtstuClass.ReadOnly = true; StudentInfoBLL stublld = new StudentInfoBLL(); int m = stublld.timeoutBorrowsBook(stuID); stuModel.NowsCredit = stuModel.NowsCredit - m; txtnowsCredit.Text = stuModel.NowsCredit.ToString(); stublld.updateStudentInfo(stuModel); }