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";
}
