private void cbCollege_SelectedIndexChanged(object sender, EventArgs e) { if (locked) { return; } //当选择了学院时显示该学院的所属专业 cbSpeciality.Text = ""; cbClass.Text = ""; string cid = "0"; if (cbCollege.SelectedValue != null) { //获取学院ID cid = cbCollege.SelectedValue.ToString(); } //根据学院ID查询专业 string sqlstr = "select * from Speciality where Speciality_College=@0"; locked = true; cbSpeciality.DataSource = DataBaseHelper.ExecDataTable(sqlstr, cid); cbSpeciality.DisplayMember = "Speciality_Name"; cbSpeciality.ValueMember = "Speciality_ID"; locked = false; cbSpeciality_SelectedIndexChanged(null, null); }
void BinderStudentinfo(string studentID) { string sql = "select ctr.ChangeTypesRecode_ID as 变动编号,st.Student_Name as 学生姓名, ct.ChangeTypes_Name as 变动,ctr.ChangeReason as 异动原因,ctr.ChangeDate as 异动时间 from (ChangeTypesRecode as ctr join Students as st on ctr.ChangeStudentID=st.Student_ID and ctr.ChangeStudentID=@0 ) join ChangeTypes as ct on ct.ChangeTypes_ID=ctr.ChangeTypes_ID"; DataTable dt = DataBaseHelper.ExecDataTable(sql, studentID); dgvChanges.DataSource = dt; }
void bindGridView(TreeViewEventArgs e, TreeNode tn) { string sqlStr = ""; string id = ""; if (e != null) { id = e.Node.Tag.ToString(); } else { id = tn.Tag.ToString(); } if (id.Length == 2) { sqlStr = "select Speciality_Name as 专业名称,Classes_ID as 班级编号,Classes_Name as 班级名称,Teacher_Name as 班主任姓名,Classes_PS as 备注 from Colleges,Speciality,Classes,Teachers where College_ID=Speciality_College and Speciality_ID=Classes_Speciality and ClassHeadTeacher=Teacher_ID and College_ID=@0"; } if (id.Length == 4) { sqlStr = "select Speciality_Name as 专业名称,Classes_ID as 班级编号,Classes_Name as 班级名称,Teacher_Name as 班主任姓名,Classes_PS as 备注 from Speciality,Classes,Teachers where Speciality_ID=Classes_Speciality and ClassHeadTeacher=Teacher_ID and Classes_Speciality=@0"; } if (id.Length == 8) { sqlStr = "select Speciality_Name as 专业名称,Classes_ID as 班级编号,Classes_Name as 班级名称,Teacher_Name as 班主任姓名,Classes_PS as 备注 from Speciality,Classes,Teachers where Speciality_ID=Classes_Speciality and ClassHeadTeacher=Teacher_ID and Classes_ID=@0"; } DataTable dt = DataBaseHelper.ExecDataTable(sqlStr, id); dGClassInfo.DataSource = dt; }
private void Bind_gridSpeciality() { string sql = "select Speciality_ID as 专业编号,Speciality_Name as 专业名称,Colleges.College_Name as 所属学院,SpeYears.SpeYears_Name as 学制 from Speciality join Colleges on Speciality.Speciality_College=Colleges.College_ID join SpeYears on Speciality.Speciality_Years=SpeYears.SpeYears_ID"; this.gridSpeciatity.DataSource = DataBaseHelper.ExecDataTable(sql); DataView view = DataBaseHelper.ExecDataTable(sql).DefaultView; view.Sort = "专业编号"; //给显示学院的下拉列表框控件绑定值 string sql1 = "select College_ID,College_Name from Colleges"; DataTable dt = DataBaseHelper.ExecDataTable(sql1); this.cbbCollege.DataSource = dt; this.cbbCollege.DisplayMember = "College_Name"; this.cbbCollege.ValueMember = "College_ID"; cbbCollege_SelectedIndexChanged(null, null); //给显示学制的下拉列表框控件绑定值 string sql2 = "select SpeYears_ID,SpeYears_Name from SpeYears"; DataTable dt1 = DataBaseHelper.ExecDataTable(sql2); this.cbbSpecYears.DataSource = dt1; this.cbbSpecYears.DisplayMember = "SpeYears_Name"; this.cbbSpecYears.ValueMember = "SpeYears_ID"; }
private void cbCollege_SelectedIndexChanged(object sender, EventArgs e) { //当选择了学院时显示该学院的所属专业 if (locked) { return; } //将原课程清空 gbSubjects.Controls.Clear(); //获取学院ID string cid = cbCollege.SelectedValue.ToString(); //根据学院ID查询专业 string sqlstr = "select * from Speciality where Speciality_College=@0"; DataTable speciality = DataBaseHelper.ExecDataTable(sqlstr, cid); locked = true; cbSpeciality.DataSource = speciality; cbSpeciality.DisplayMember = "Speciality_Name"; cbSpeciality.ValueMember = "Speciality_ID"; locked = false; if (cbSpeciality.Items.Count == 0) { button1.Enabled = false; button2.Enabled = false; } cbSpeciality_SelectedIndexChanged(null, null); }
void BinderAwards() { string sql = "select p.PunishmentAwardsRecode_ID as 获奖编号,pat.PunishmentAwardTypes_Name as 获奖类型,stu.Student_Name as 学生姓名,p.PunishmentAwardContent as 获奖内容,p.PunishmentAwardReason as 获奖原因,p.PUnishmentAwardDate as 获奖时间 from (PunishmentAwardsRecode as p join Students as stu on p.PunishmentAwardStudentID=stu.Student_ID and p.PunishmentAwardStudentID=@0 and p.PunishmentAwardsRecode_ID>0) join PunishmentAwardTypes as pat on p.PunishmentAwardsType_ID=pat.PunishmentAwardTypes_ID "; DataTable awards = DataBaseHelper.ExecDataTable(sql, studentID); dgvAwards.DataSource = awards; }
private void addUser(object sender, EventArgs e) { string unsql = "select Admin_ID,Admin_Name,Admin_Password,Admin_Rember,Admin_AutoLogin from AdminInfo"; dt = DataBaseHelper.ExecDataTable(unsql); cmbUserName.DataSource = dt; cmbUserName.DisplayMember = "Admin_Name"; cmbUserName.ValueMember = "Admin_ID"; string selectname = "select Admin_Name,Admin_ID from AdminInfo where Admin_AutoLogin=1"; if (DataBaseHelper.ExecDataTable(selectname).Rows.Count > 0) { DataTable dtname = DataBaseHelper.ExecDataTable(selectname); DataRow rowname = dtname.Rows[0]; this.cmbUserName.SelectedValue = rowname["Admin_ID"]; } DataRow row = dt.Rows[cmbUserName.SelectedIndex]; //this.cmbUserName.SelectedValue = row["Admin_Name"].ToString(); txtUserPwd.Text = row["Admin_Password"].ToString(); checkBox1.Checked = true; string auto = row["Admin_AutoLogin"].ToString(); if (auto == "True") { checkBox2.Checked = true; btnOK_Click(sender, e); } }
void BinderPunishment() { string sql = "select p.PunishmentAwardsRecode_ID as 处分编号,pat.PunishmentAwardTypes_Name as 处分类型,stu.Student_Name as 学生姓名, p.PunishmentAwardContent as 处分内容,p.PunishmentAwardReason as 处分原因,p.PUnishmentAwardDate as 处分时间 from (PunishmentAwardsRecode as p join Students as stu on p.PunishmentAwardStudentID=stu.Student_ID and p.PunishmentAwardStudentID=@0 and p.PunishmentAwardsRecode_ID<0) join PunishmentAwardTypes as pat on p.PunishmentAwardsType_ID=pat.PunishmentAwardTypes_ID "; DataTable punishment = DataBaseHelper.ExecDataTable(sql, studentID); dgvPunishments.DataSource = punishment; }
private void Bind_cbbTeachers() { string sql2 = "select Teacher_ID,Teacher_Name from Teachers"; this.cbbTeachers.DataSource = DataBaseHelper.ExecDataTable(sql2); this.cbbTeachers.DisplayMember = "Teacher_Name"; this.cbbTeachers.ValueMember = "Teacher_ID"; }
private void Bind_cbbSubjects() { string sql = "select * from Subjects"; this.cbbSubject.DataSource = DataBaseHelper.ExecDataTable(sql); this.cbbSubject.DisplayMember = "Subjects_Name"; this.cbbSubject.ValueMember = "Subjects_ID"; }
private void Bind_cbbClassSpeciality(string param) { string sql2 = "select Speciality_ID,Speciality_Name from Speciality where Speciality_College=@0"; this.cbbClassSpeciality.DataSource = DataBaseHelper.ExecDataTable(sql2, param); this.cbbClassSpeciality.DisplayMember = "Speciality_Name"; this.cbbClassSpeciality.ValueMember = "Speciality_ID"; }
private void cbStuName_SelectedIndexChanged(object sender, EventArgs e) { //当选择学生后显示该学生的学号 if (locked) { return; } if (cbStuName.SelectedValue != null) { string sqlnum = "select StudentNum from Students where Student_ID=@0"; string Student_ID = cbStuName.SelectedValue.ToString(); lblStuID.Text = cbStuName.SelectedValue.ToString(); lblStuNum.Text = DataBaseHelper.ExecScalar(sqlnum, Student_ID).ToString(); //string sqlstr = "select Student_ID,Student_Name,StudentNum from Students where StudentClass=@0"; //DataTable students = DataBaseHelper.ExecDataTable(sqlstr, classid); } else { lblStuID.Text = "0"; } //如果该学生已经录入成绩则显示成绩,并不能填写成绩 string sqlstr = "select * from Examination where StudentID=@0"; DataTable dt = DataBaseHelper.ExecDataTable(sqlstr, lblStuID.Text); int i = 0; for (int j = 0; j < dt.Rows.Count; j++) { Subjects sub = (Subjects)(gbSubjects.Controls[j]); sub.txtScore.Text = dt.Rows[j]["ExamScore"].ToString(); sub.txtScore.Enabled = false; i++; } if (gbSubjects.Controls.Count > 0) { if (i == 0) //说明该学生没有成绩记录,应该提交成绩 { foreach (Control c in gbSubjects.Controls) { Subjects sub = (Subjects)c; sub.txtScore.Enabled = true; sub.txtScore.Text = ""; } button1.Enabled = true; button2.Enabled = false; } else//说明该学生有成绩记录,应该可以修改成绩 { button1.Enabled = false; button2.Enabled = true; } } else { button1.Enabled = false; button2.Enabled = false; } }
//处分类别 void BinderPunishmentType() { string sql = "select * from PunishmentAwardTypes where PunishmentAwardTypes_ID<0"; DataTable punishmentTypes = DataBaseHelper.ExecDataTable(sql); cmbPunishmentType.DataSource = punishmentTypes; cmbPunishmentType.DisplayMember = "PunishmentAwardTypes_Name"; cmbPunishmentType.ValueMember = "PunishmentAwardTypes_ID"; }
//专业 private void BinderSpeciality(string collegeID) { string specsql = "select * from Speciality where Speciality_College=@0"; DataTable spectable = DataBaseHelper.ExecDataTable(specsql, collegeID); cmbBoxSpeciality.DataSource = spectable; cmbBoxSpeciality.DisplayMember = "Speciality_Name"; cmbBoxSpeciality.ValueMember = "Speciality_ID"; }
private void Bind_gridTeachers() { string sql = "select Teacher_ID as 编号,Teacher_Name as 姓名,Teacher_Tel as 电话,Teacher_Sex as 性别,Teacher_Indate 入职日期,Teacher_Birthday as 出生日期,Teacher_Origin as 籍贯 from Teachers"; this.gridTeachers.DataSource = DataBaseHelper.ExecDataTable(sql); DataView view = DataBaseHelper.ExecDataTable(sql).DefaultView; view.Sort = "编号"; }
//班级 private void BinderClasses(string SpecialityID) { string classsql = "select * from Classes where Classes_Speciality=@0 "; DataTable classdt = DataBaseHelper.ExecDataTable(classsql, SpecialityID); cmbBoxClass.DataSource = classdt; cmbBoxClass.DisplayMember = "Classes_Name"; cmbBoxClass.ValueMember = "Classes_ID"; }
private void Bind_gridSpeYears() { string sql = "select SpeYears_ID as 学制编号,SpeYears_Name as 学制名称,SpeYears_Years as 学制时间 from SpeYears"; this.gridSpeYears.DataSource = DataBaseHelper.ExecDataTable(sql); DataView view = DataBaseHelper.ExecDataTable(sql).DefaultView; view.Sort = "学制编号"; }
private void Bind_gridSubjects() { string sql = "select Subjects_ID as 学科编号,Subjects_Name as 学科名称 from Subjects"; this.gridSubjects.DataSource = DataBaseHelper.ExecDataTable(sql); DataView view = DataBaseHelper.ExecDataTable(sql).DefaultView; view.Sort = "学科编号"; }
//学院 private void BinderColleges() { string collegesql = "select College_ID,College_Name from Colleges"; DataTable dt = DataBaseHelper.ExecDataTable(collegesql); cmbBoxCollege.DataSource = dt; cmbBoxCollege.DisplayMember = "College_Name"; cmbBoxCollege.ValueMember = "College_ID"; }
void Bind_gridCollege() { string sql = "select College_ID as 学院编号,College_Name as 学院名称 from Colleges"; DataTable dt = DataBaseHelper.ExecDataTable(sql); DataView view = dt.DefaultView; this.gridCollege.DataSource = dt; view.Sort = "学院编号"; }
private void Bind_cbbClassCollege() { string sql1 = "select College_ID,College_Name from Colleges"; this.cbbClassCollege.DataSource = DataBaseHelper.ExecDataTable(sql1); this.cbbClassCollege.DisplayMember = "College_Name"; this.cbbClassCollege.ValueMember = "College_ID"; Bind_cbbClassSpeciality(this.cbbClassCollege.SelectedValue.ToString()); }
private void cbCollege_SelectedIndexChanged(object sender, EventArgs e) { string cid = cbCollege.SelectedValue.ToString(); string sqlstr = "select * from Speciality where Speciality_College=@0"; DataTable speciality = DataBaseHelper.ExecDataTable(sqlstr, cid); cbSpeciality.DataSource = speciality; cbSpeciality.DisplayMember = "Speciality_Name"; cbSpeciality.ValueMember = "Speciality_ID"; }
private void Bind_gridClasses() { string sql = "select Classes_ID as 班级编号,Classes_Name as 班级名称,Classes_Speciality as 所属专业编号,Speciality_Name as 专业名称,Teacher_Name as 班主任 from Classes join Speciality on Classes.Classes_Speciality=Speciality.Speciality_ID join Teachers on Classes.ClassHeadTeacher=Teachers.Teacher_ID"; DataTable dt = DataBaseHelper.ExecDataTable(sql); this.gridClasses.DataSource = dt; //this.gridClasses.Columns[2].Visible = false; Bind_cbbClassCollege(); Bind_cbbTeachers(); }
private void AddScore_Load(object sender, EventArgs e) { string sql = "select * from Colleges"; DataTable college = DataBaseHelper.ExecDataTable(sql); locked = true; cbCollege.DataSource = college; cbCollege.DisplayMember = "College_Name"; cbCollege.ValueMember = "College_ID"; locked = false; }
//获奖类别 void BinderAwardsType() { string sql = "select * from PunishmentAwardTypes where PunishmentAwardTypes_ID>0"; DataTable awardsTypes = DataBaseHelper.ExecDataTable(sql); //cmbBoxArardsType.DataSource = awardsTypes; //cmbBoxArardsType.DisplayMember = "PunishmentAwardTypes_Name"; //cmbBoxArardsType.ValueMember = "PunishmentAwardTypes_ID"; cmbAwardType.DataSource = awardsTypes; cmbAwardType.DisplayMember = "PunishmentAwardTypes_Name"; cmbAwardType.ValueMember = "PunishmentAwardTypes_ID"; }
void BindClass(TreeNode tn) { string sql = "select Classes_ID,Classes_Name from Classes where Classes_Speciality=@0"; DataTable dt = DataBaseHelper.ExecDataTable(sql, tn.Tag.ToString()); for (int i = 0; i < dt.Rows.Count; i++) { TreeNode stn = new TreeNode(dt.Rows[i]["Classes_Name"].ToString()); stn.Tag = dt.Rows[i]["Classes_ID"].ToString(); tn.Nodes.Add(stn); } }
void bindCollege() { string sql = "select * from Colleges"; DataTable dt = DataBaseHelper.ExecDataTable(sql); for (int i = 0; i < dt.Rows.Count; i++) { TreeNode tn = new TreeNode(dt.Rows[i]["College_Name"].ToString()); tn.Tag = dt.Rows[i]["College_ID"].ToString(); tvClassInfo.Nodes.Add(tn); } }
private void OrderScore_Load(object sender, EventArgs e) { //1、绑定tabPage1中的学院信息 string sql = "select * from Colleges"; cbCollege.DataSource = DataBaseHelper.ExecDataTable(sql); cbCollege.DisplayMember = "College_Name"; cbCollege.ValueMember = "College_ID"; //2、在tabPage2中将班级表中的班级信息进行绑定 sql = "select * from Classes"; cbClass.DataSource = DataBaseHelper.ExecDataTable(sql); cbClass.DisplayMember = "Classes_Name"; cbClass.ValueMember = "Classes_ID"; }
private void cbClass_SelectedIndexChanged(object sender, EventArgs e) { //当选择好班级后,应显示该班级所有应考科目 if (cbClass.SelectedValue == null) { return; } groupBox1.Text = cbClass.SelectedText; string cid = cbClass.SelectedValue.ToString(); string str = "select s.Subjects_ID,s.Subjects_Name from Subjects as s,Sepc_Subjects as ss,Classes as c where ss.Subjects_ID=s.Subjects_ID and ss.Sepc_ID=c.Classes_Speciality and c.Classes_ID=@0"; cbSubject2.DataSource = DataBaseHelper.ExecDataTable(str, cid); cbSubject2.DisplayMember = "Subjects_Name"; cbSubject2.ValueMember = "Subjects_ID"; }
private void cbSpeciality_SelectedIndexChanged(object sender, EventArgs e) { //当选择好专业后,应显示该专业的所有科目 string sid = "0"; if (cbSpeciality.SelectedValue != null) { sid = cbSpeciality.SelectedValue.ToString(); } string str = "select Subjects.Subjects_ID,Subjects_Name from Subjects,Sepc_Subjects where Sepc_Subjects.Subjects_ID=Subjects.Subjects_ID and Sepc_ID=@0"; cbSubject1.DataSource = DataBaseHelper.ExecDataTable(str, sid); cbSubject1.DisplayMember = "Subjects_Name"; cbSubject1.ValueMember = "Subjects_ID"; }