private void btnAddPunishment_Click(object sender, EventArgs e)
{
try
{
string sql = "select min(PunishmentAwardsRecode_ID) from PunishmentAwardsRecode";
object obj = DataBaseHelper.ExecScalar(sql);
int id = -1;
if (!string.IsNullOrEmpty(obj.ToString()))
{
id = (int)obj;
}
if (id > -1)
{
id = -1;
}
else
{
id--;
}
sql = "insert into PunishmentAwardsRecode(PunishmentAwardsRecode_ID, PunishmentAwardsType_ID,PunishmentAwardStudentID, PunishmentAwardContent,PunishmentAwardReason,PunishmentAwardDate) values(@0,@1,@2,@3,@4,@5)";
int r = DataBaseHelper.ExecNoneQuery(sql, id, cmbPunishmentType.SelectedValue.ToString(), StudentID, txtBoxPunishmentAwardContent.Text, txtPunishmentReason.Text, dateTimePunishment.Value);
if (r > 0)
{
MessageBox.Show("添加成功！");
BinderPunishment();
}
else
{
MessageBox.Show("添加失败！");
}
}
catch
{
MessageBox.Show("添加数据遇到严重错误,请检测你的相关数据是否正确！");
}
}
void BinderBaseInfo()
{
string sql = "select * from Students where Student_ID=@0";
DataTable student = DataBaseHelper.ExecDataTable(sql, studentID);
if (student.Rows.Count == 0)
{
MessageBox.Show("加载出错！");
this.Close();
return;
}
DataRow row = student.Rows[0];
string sqlimage = "select * from StudentImage where Image_Student=@0";
DataTable studentImage = DataBaseHelper.ExecDataTable(sqlimage, studentID);
if (studentImage.Rows.Count == 0)
{
MessageBox.Show("加载出错！", "错误!");
this.Close();
return;
}
DataRow rowImage = studentImage.Rows[0];
//基本信息
labelName.Text = row["Student_Name"].ToString();
labelSex.Text = row["Student_Sex"].ToString();
labelIDCardNum.Text = row["StudentCard"].ToString();
labelBirthday.Text = row["StudentBirthDay"].ToString();
labelNative.Text = row["StudentOrigin"].ToString();
try
{
images = (byte[])rowImage["Images"];
MemoryStream ms = new MemoryStream(images);
Bitmap bmp = new Bitmap(ms);
pBStudentImage.Image = bmp;
}
catch
{
pBStudentImage.Image = null;
images = null;
}
//联系方法
labelHomeAdd.Text = row["StudentAddress"].ToString();
labelHomeTel.Text = row["FamilyTel"].ToString();
labelMobile.Text = row["Mobile"].ToString();
labelQQ.Text = row["QQ"].ToString();
//学籍信息
sql = "select s.Speciality_Name,c.Classes_Name,Colleges.College_Name,SpeYears.SpeYears_Name from ((( Students join Classes as c on Students.StudentClass=c.Classes_ID and Students.Student_ID=@0 ) join Speciality as s on c.Classes_Speciality=s.Speciality_ID) join Colleges on s.Speciality_College=Colleges.College_ID) join SpeYears on SpeYears.SpeYears_ID=s.Speciality_Years";
DataTable dt = DataBaseHelper.ExecDataTable(sql, studentID);
string SpecialityName = dt.Rows[0]["Speciality_Name"].ToString();
string ClassesName = dt.Rows[0]["Classes_Name"].ToString();
string CollegeName = dt.Rows[0]["College_Name"].ToString();
string SpeYearsName = dt.Rows[0]["SpeYears_Name"].ToString();
labelCollege.Text = CollegeName;
labelStuType.Text = SpeYearsName;
labelSpeciality.Text = SpecialityName;
labelClass.Text = ClassesName;
labelStuID.Text = row["StudentNum"].ToString();
labelEnterYear.Text = row["StudentEnterYear"].ToString();
BinderStudentinfo(studentID);
BinderAwards();
BinderPunishment();
}
private void Bind_gridSpecSubject()
{
string sql = "select Subjects.Subjects_ID as 学科编号,Subjects_Name as 学科名称 from Subjects join Sepc_Subjects on Subjects.Subjects_ID=Sepc_Subjects.Subjects_ID where Sepc_Subjects.Sepc_ID=@0";
this.gridSpecSubject.DataSource = DataBaseHelper.ExecDataTable(sql, Spec_ID);
}
private void btnOK_Click(object sender, EventArgs e)
{
//查询信息——可以根据其中任意多个条件进行查询
if (cbCollege.Text.Trim() == "" && cbSpeciality.Text.Trim() == "" &&
cbClass.Text.Trim() == "" && cbHeadMaster.Text.Trim() == "")
{
MessageBox.Show("至少选择一个条件进行查询!", "信息提示");
return;
}
string sqlStr = "";
string name = "";
DataTable result = new DataTable();
//如果没有教师名称
if (cbHeadMaster.Text.Trim() == "")
{
if (cbClass.Text.Trim() != "")
{
name = cbClass.Text;
sqlStr = "select c.Classes_ID as 班级编号,c.Classes_Name as 班级名称,s.Speciality_Name as 所属专业,t.Teacher_Name as 班主任,c.Classes_PS as 备注 from Classes as c,Teachers as t,Speciality as s where c.ClassHeadTeacher=t.Teacher_ID and c.Classes_Speciality=s.Speciality_ID and Classes_Name like '%'+@0+'%'";
result = DataBaseHelper.ExecDataTable(sqlStr, name);
}
else if (cbSpeciality.Text.Trim() != "")
{
name = cbSpeciality.Text;
sqlStr = "select c.Classes_ID as 班级编号,c.Classes_Name as 班级名称,s.Speciality_Name as 所属专业,t.Teacher_Name as 班主任,c.Classes_PS as 备注 from Classes as c,Teachers as t,Speciality as s where c.ClassHeadTeacher=t.Teacher_ID and c.Classes_Speciality=s.Speciality_ID and s.Speciality_Name like '%'+@0+'%'";
result = DataBaseHelper.ExecDataTable(sqlStr, name);
}
else if (cbCollege.Text.Trim() != "")
{
name = cbCollege.Text;
sqlStr = "select c.Classes_ID as 班级编号,c.Classes_Name as 班级名称,s.Speciality_Name as 所属专业,t.Teacher_Name as 班主任,c.Classes_PS as 备注 from Classes as c,Teachers as t,Speciality as s,Colleges where c.ClassHeadTeacher=t.Teacher_ID and c.Classes_Speciality=s.Speciality_ID and s.Speciality_College=Colleges.College_ID and College_Name like '%'+@0+'%'";
result = DataBaseHelper.ExecDataTable(sqlStr, name);
}
}
else
{
string tName = cbHeadMaster.Text;
if (cbClass.Text.Trim() != "")
{
name = cbClass.Text;
sqlStr = "select c.Classes_ID as 班级编号,c.Classes_Name as 班级名称,s.Speciality_Name as 所属专业,t.Teacher_Name as 班主任,c.Classes_PS as 备注 from Classes as c,Teachers as t,Speciality as s where c.ClassHeadTeacher=t.Teacher_ID and c.Classes_Speciality=s.Speciality_ID and Classes_Name like '%'+@0+'%' and Teacher_Name like '%'+@1+'%'";
result = DataBaseHelper.ExecDataTable(sqlStr, name, tName);
}
else if (cbSpeciality.Text.Trim() != "")
{
name = cbSpeciality.Text;
sqlStr = "select c.Classes_ID as 班级编号,c.Classes_Name as 班级名称,s.Speciality_Name as 所属专业,t.Teacher_Name as 班主任,c.Classes_PS as 备注 from Classes as c,Teachers as t,Speciality as s where c.ClassHeadTeacher=t.Teacher_ID and c.Classes_Speciality=s.Speciality_ID and Speciality_Name like '%'+@0+'%' and Teacher_Name like '%'+@1+'%'";
result = DataBaseHelper.ExecDataTable(sqlStr, name, tName);
}
else if (cbCollege.Text.Trim() != "")
{
name = cbCollege.Text;
sqlStr = "select c.Classes_ID as 班级编号,c.Classes_Name as 班级名称,s.Speciality_Name as 所属专业,t.Teacher_Name as 班主任,c.Classes_PS as 备注 from Classes as c,Teachers as t,Speciality as s,Colleges where c.ClassHeadTeacher=t.Teacher_ID and c.Classes_Speciality=s.Speciality_ID and s.Speciality_College=Colleges.College_ID and College_Name like '%'+@0+'%' and Teacher_Name like '%'+@1+'%'";
result = DataBaseHelper.ExecDataTable(sqlStr, name, tName);
}
else
{
sqlStr = "select c.Classes_ID as 班级编号,c.Classes_Name as 班级名称,s.Speciality_Name as 所属专业,t.Teacher_Name as 班主任,c.Classes_PS as 备注 from Classes as c,Teachers as t,Speciality as s where c.ClassHeadTeacher=t.Teacher_ID and c.Classes_Speciality=s.Speciality_ID and Teacher_Name like '%'+@1+'%'";
result = DataBaseHelper.ExecDataTable(sqlStr, name, tName);
}
}
if (result.Rows.Count == 0)
{
MessageBox.Show("没有符合查询条件的记录，请重新填写！", "信息提示");
}
dataGridView1.DataSource = result;
}
private void btnInsertClass_Click(object sender, EventArgs e)
{
if (btnInsertClass.Text == "点击添加")
{
if (this.cbbClassCollege.Items.Count != 0)
{
this.cbbClassCollege.SelectedIndex = 0;
}
else
{
MessageBox.Show("警告！数据库中还没有学院的记录，请到’学院设置’添加学院");
}
if (this.cbbClassSpeciality.Items.Count != 0)
{
this.cbbClassSpeciality.SelectedIndex = 0;
}
else
{
MessageBox.Show("警告！数据库中" + this.cbbClassCollege.Text + "还没有添加专业的记录，请到专业设置添加");
}
if (this.cbbTeachers.Items.Count != 0)
{
this.cbbTeachers.SelectedIndex = 0;
}
else
{
MessageBox.Show("警告！数据库中还没有班主任的记录，请到学院设置添加班主任");
}
btnInsertClass.Text = "添加班级";
btnUpdateClass.Visible = false;
this.cbbClassCollege.Enabled = true;
this.cbbClassSpeciality.Enabled = true;
this.txtClassID.Enabled = true;
this.txtClassName.Enabled = true;
this.cbbTeachers.Enabled = true;
this.cbbClassCollege.SelectedIndex = 0;
this.cbbClassSpeciality.SelectedIndex = 0;
this.txtClassID.Text = "";
this.txtClassName.Text = "";
this.cbbTeachers.SelectedIndex = 0;
}
else
{
if (!CheckIDLenght(this.txtClassID, 4))
{
return;
}
if (!CheckTextBoxValue(this.txtClassName, "班级名称"))
{
return;
}
if (!CheckCbbValue(this.cbbClassCollege, "没有学院信息，请到'学院设置'添加学院！"))
{
return;
}
if (!CheckCbbValue(this.cbbClassSpeciality, "没有专业信息，请到'专业设置'添加专业！"))
{
return;
}
if (!CheckCbbValue(this.cbbTeachers, "没有班主任信息，请到'班主任设置'添加班主任！"))
{
return;
}
string ClassID = lbClassIDCollegeSpec.Text + this.txtClassID.Text.Trim();
try
{
string sql = "insert into Classes(Classes_ID,Classes_Name,Classes_Speciality,ClassHeadTeacher) values(@0,@1,@2,@3)";
int i = DataBaseHelper.ExecNoneQuery(sql, ClassID, this.txtClassName.Text.Trim(), lbClassIDCollegeSpec.Text, this.cbbTeachers.SelectedValue.ToString());
if (i == 1)
{
MessageBox.Show("添加成功！");
}
else
{
MessageBox.Show("添加失败！");
}
Bind_gridClasses();
}
catch
{
MessageBox.Show("ID为" + ClassID + "的编号已存在，请另选编号");
}
}
}
private void 除ToolStripMenuItem_Click(object sender, EventArgs e)
{
//删除学院
if (tabControl1.SelectedIndex == 0)
{
try
{
string sql = "delete from Colleges where College_ID=@0";
int i = DataBaseHelper.ExecNoneQuery(sql, this.gridCollege.SelectedRows[0].Cells["学院编号"].Value.ToString());
if (i == 1)
{
MessageBox.Show("删除成功！");
}
else
{
MessageBox.Show("删除失败！");
}
Bind_gridCollege();
}
catch
{
MessageBox.Show("该学院中有学生，删除失败");
}
}
else if (tabControl1.SelectedIndex == 1)
{
try
{
string sql = "Delete from Speciality where Speciality_ID=@0";
int i = DataBaseHelper.ExecNoneQuery(sql, this.gridSpeciatity.SelectedRows[0].Cells[0].Value);
if (i == 1)
{
MessageBox.Show("删除成功！");
}
else
{
MessageBox.Show("删除失败！");
}
Bind_gridSpeciality();
}
catch
{
MessageBox.Show("该专业中有学生，删除失败");
}
}
else if (tabControl1.SelectedIndex == 2)
{
try
{
string sql = "delete from SpeYears where SpeYears_id=@0";
int i = DataBaseHelper.ExecNoneQuery(sql, this.gridSpeYears.SelectedRows[0].Cells[0].Value.ToString());
if (i == 1)
{
MessageBox.Show("删除成功！");
}
else
{
MessageBox.Show("删除失败！");
}
Bind_gridSpeYears();
}
catch
{
MessageBox.Show("该学制中有学科，删除失败");
}
}
else if (tabControl1.SelectedIndex == 3)
{
try
{
string sql = "Delete from Subjects where Subjects_ID=@0";
int i = DataBaseHelper.ExecNoneQuery(sql, this.gridSubjects.SelectedRows[0].Cells[0].Value.ToString());
if (i == 1)
{
MessageBox.Show("删除成功!");
}
else
{
MessageBox.Show("删除失败！");
}
Bind_gridSubjects();
}
catch
{
MessageBox.Show("该学科中有学生，删除失败");
}
}
else if (tabControl1.SelectedIndex == 4)
{
try
{
string sql = "Delete from Teachers where Teacher_ID=@0";
int i = DataBaseHelper.ExecNoneQuery(sql, this.gridTeachers.SelectedRows[0].Cells[0].Value.ToString());
if (i == 1)
{
MessageBox.Show("删除成功！");
}
else
{
MessageBox.Show("删除失败！");
}
Bind_gridTeachers();
}
catch
{
MessageBox.Show("该班主任带有班级，删除失败");
}
}
else if (tabControl1.SelectedIndex == 5)
{
try
{
string sql = "Delete from Classes where Classes_ID=@0";
int i = DataBaseHelper.ExecNoneQuery(sql, this.gridClasses.SelectedRows[0].Cells[0].Value.ToString());
if (i == 1)
{
MessageBox.Show("修改成功！");
}
else
{
MessageBox.Show("修改失败！");
}
Bind_gridClasses();
}
catch
{
MessageBox.Show("该班级下有学生，删除失败");
}
}
}
private void BinderSpeYears(string SpecialityID)
{
string yearssql = "select sy.SpeYears_Name from SpeYears as sy join Speciality as sp on sp.Speciality_Years=sy.SpeYears_ID where sp.Speciality_ID=@0 ";
LableBoxStuType.Text = DataBaseHelper.ExecScalar(yearssql, SpecialityID).ToString();
}
private void Bind_gridAdmin()
{
string sql = "select Admin_ID as 管理员编号,Admin_Name as 管理员姓名,Admin_Level as 权限等级, Admin_Rember as 记住密码 , Admin_AutoLogin as 自动登录 from AdminInfo";
this.gridAdmin.DataSource = DataBaseHelper.ExecDataTable(sql);
}
private void tvStudentsInfo_AfterSelect(object sender, TreeViewEventArgs e)
{
try
{
if (e == null)
{
return;
}
else if (e.Node.Tag.ToString() == "Colleges")
{
//TreeNode node = this.tvStudentsInfo.SelectedNode;
//lvStudentsinfo.Items.Clear();
//this.tvStudentsInfo.SelectedNode = node;
lvStudentsinfo.Items.Clear();
string sql = "select stu.*,spec.Speciality_Name,coll.College_Name,spy.SpeYears_Name from ((( Students as stu join Classes as cla on stu.StudentClass=cla.Classes_ID) join Speciality as spec on cla.Classes_Speciality=spec.Speciality_ID ) join SpeYears as spy on spec.Speciality_Years=spy.SpeYears_ID) join Colleges as coll on spec.Speciality_College=coll.College_ID where coll.College_ID =@0";
DataTable students = DataBaseHelper.ExecDataTable(sql, e.Node.Name);
foreach (DataRow student in students.Rows)
{
//绑定该班级的学生信息
ListViewItem stu = new ListViewItem();
//学生姓名
stu.Text = student["Student_Name"].ToString();
//通过性别设置图标样式
stu.ImageIndex = student["Student_Sex"].ToString() == "男" ? 1 : 0;
//保存学生信息的主键
stu.Name = student["Student_ID"].ToString();
//添加学号
stu.SubItems.Add(student["StudentNum"].ToString());
//添加性别
stu.SubItems.Add(student["Student_Sex"].ToString());
//所在学院
stu.SubItems.Add(student["College_Name"].ToString());
//所属专业
stu.SubItems.Add(student["Speciality_Name"].ToString());
//年级
stu.SubItems.Add(Convert.ToDateTime(student["StudentEnterYear"]).ToString("yyyy") + "级");
//stu.SubItems.Add(student["StudentEnterYear"].ToString());
//学制
stu.SubItems.Add(student["SpeYears_Name"].ToString());
//出生日期
//stu.SubItems.Add(student["SpeYears_Name"].ToString());
stu.SubItems.Add(Convert.ToDateTime(student["StudentBirthDay"]).ToString("yyyy-MM-dd"));
//籍贯
stu.SubItems.Add(student["StudentOrigin"].ToString());
lvStudentsinfo.Items.Add(stu);
}
int cuco = tvStudentsInfo.SelectedNode.Index + 1;
tSSLTreeview.Text = "共" + tvStudentsInfo.Nodes.Count + "个学院，当前第" + cuco + "个学院";
tSSLListView.Text = "本学院共" + lvStudentsinfo.Items.Count + "个学生";
tSSLListViewCu.Text = "";
}
else if (e.Node.Tag.ToString() == "Speciality")
{
lvStudentsinfo.Items.Clear();
string sql = "select stu.*,spec.Speciality_Name,coll.College_Name,spy.SpeYears_Name from ((( Students as stu join Classes as cla on stu.StudentClass=cla.Classes_ID) join Speciality as spec on cla.Classes_Speciality=spec.Speciality_ID ) join SpeYears as spy on spec.Speciality_Years=spy.SpeYears_ID) join Colleges as coll on spec.Speciality_College=coll.College_ID where spec.Speciality_ID =@0";
DataTable students = DataBaseHelper.ExecDataTable(sql, e.Node.Name);
foreach (DataRow student in students.Rows)
{
//绑定该班级的学生信息
ListViewItem stu = new ListViewItem();
//学生姓名
stu.Text = student["Student_Name"].ToString();
//通过性别设置图标样式
stu.ImageIndex = student["Student_Sex"].ToString() == "男" ? 1 : 0;
//保存学生信息的主键
stu.Name = student["Student_ID"].ToString();
//添加学号
stu.SubItems.Add(student["StudentNum"].ToString());
//添加性别
stu.SubItems.Add(student["Student_Sex"].ToString());
//所在学院
stu.SubItems.Add(student["College_Name"].ToString());
//所属专业
stu.SubItems.Add(student["Speciality_Name"].ToString());
//年级
stu.SubItems.Add(Convert.ToDateTime(student["StudentEnterYear"]).ToString("yyyy") + "级");
//stu.SubItems.Add(student["StudentEnterYear"].ToString());
//学制
stu.SubItems.Add(student["SpeYears_Name"].ToString());
//出生日期
//stu.SubItems.Add(student["SpeYears_Name"].ToString());
stu.SubItems.Add(Convert.ToDateTime(student["StudentBirthDay"]).ToString("yyyy-MM-dd"));
//籍贯
stu.SubItems.Add(student["StudentOrigin"].ToString());
lvStudentsinfo.Items.Add(stu);
}
tSSLListView.Text = "本专业共" + lvStudentsinfo.Items.Count + "个学生";
tSSLListViewCu.Text = "";
}
else if (e.Node.Tag.ToString() == "Classes")
{
lvStudentsinfo.Items.Clear();
//查询选择的班级的学生信息
string sql = "select stu.*,spec.Speciality_Name,coll.College_Name,spy.SpeYears_Name from ((( Students as stu join Classes as cla on stu.StudentClass=cla.Classes_ID) join Speciality as spec on cla.Classes_Speciality=spec.Speciality_ID ) join SpeYears as spy on spec.Speciality_Years=spy.SpeYears_ID) join Colleges as coll on spec.Speciality_College=coll.College_ID where cla.Classes_ID=@0";
DataTable students = DataBaseHelper.ExecDataTable(sql, e.Node.Name);
foreach (DataRow student in students.Rows)
{
//绑定该班级的学生信息
ListViewItem stu = new ListViewItem();
//学生姓名
stu.Text = student["Student_Name"].ToString();
//通过性别设置图标样式
stu.ImageIndex = student["Student_Sex"].ToString() == "男" ? 1 : 0;
//保存学生信息的主键
stu.Name = student["Student_ID"].ToString();
//添加学号
stu.SubItems.Add(student["StudentNum"].ToString());
//添加性别
stu.SubItems.Add(student["Student_Sex"].ToString());
//所在学院
stu.SubItems.Add(student["College_Name"].ToString());
//所属专业
stu.SubItems.Add(student["Speciality_Name"].ToString());
//年级
stu.SubItems.Add(Convert.ToDateTime(student["StudentEnterYear"]).ToString("yyyy") + "级");
//stu.SubItems.Add(student["StudentEnterYear"].ToString());
//学制
stu.SubItems.Add(student["SpeYears_Name"].ToString());
//出生日期
//stu.SubItems.Add(student["SpeYears_Name"].ToString());
stu.SubItems.Add(Convert.ToDateTime(student["StudentBirthDay"]).ToString("yyyy-MM-dd"));
//籍贯
stu.SubItems.Add(student["StudentOrigin"].ToString());
lvStudentsinfo.Items.Add(stu);
}
tSSLListView.Text = "本班级共" + lvStudentsinfo.Items.Count + "个学生";
tSSLListViewCu.Text = "";
}
}
catch
{
MessageBox.Show("加载数据出现错误！", "警告！");
}
lvStudentsinfo.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
}
private void btnOK_Click(object sender, EventArgs e)
{
if (FormText == null)
{
if (cbCollege.Text.ToString() == "")
{
MessageBox.Show("学院信息不允许空！请添加学院信息", "警告", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (cbSpeciality.Text.ToString() == "")
{
MessageBox.Show("专业信息不允许空！请添加专业信息", "警告", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (txtClassID.Text.Trim() == "")
{
MessageBox.Show("班级编号不允许空！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (txtClassName.Text.Trim() == "")
{
MessageBox.Show("班级名称不允许空！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (cbHeadMaster.Text.ToString() == "")
{
MessageBox.Show("班主任信息不允许空！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (txtClassID.Text.Trim().Length != 4)
{
MessageBox.Show("班级编号需写四位！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
try
{
string cid = lblPre.Text.Trim() + txtClassID.Text.Trim(); //班级编号
string cname = txtClassName.Text.Trim(); //班级名称
string c_s = cbSpeciality.SelectedValue.ToString(); //专业编号
string c_t = cbHeadMaster.SelectedValue.ToString(); //班主任编号
string sqlstr = "insert into Classes(Classes_ID,Classes_Name,Classes_Speciality,ClassHeadTeacher,Classes_PS) values(@0,@1,@2,@3,@4)";
int i = DataBaseHelper.ExecNoneQuery(sqlstr, cid, cname, c_s, c_t, txtPS.Text);
if (i > 0)
{
MessageBox.Show("添加班级成功！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.None);
txtClassID.Text = "";
txtClassName.Text = "";
}
else
{
MessageBox.Show("添加班级失败！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch
{
MessageBox.Show("已经存在该班级编号,请重新填写！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.None);
}
}
if (FormText == "修改班级信息")
{
string sqlstr = "update Classes set Classes_Name=@0,ClassHeadTeacher=@1,Classes_PS=@2 where Classes_ID=@3";
string cname = txtClassName.Text.Trim();
string tid = cbHeadMaster.SelectedValue.ToString();
string ps = txtPS.Text;
string cid = lblPre.Text.Trim() + txtClassID.Text.Trim();
int i = DataBaseHelper.ExecNoneQuery(sqlstr, cname, tid, ps, cid);
if (i > 0)
{
MessageBox.Show("修改班级信息成功！", "信息提示");
}
else
{
MessageBox.Show("修改班级信息失败！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Close();
}
}
private void btnOK1_Click(object sender, EventArgs e)
{
if (cbSpeciality.SelectedIndex != -1)
{
dataGridView1.DataSource = null;
if (cbSubject1.Items.Count == 0)
{
return;
}
DataTable scores = new DataTable();
DataColumn colClass = new DataColumn("班级", typeof(string));
scores.Columns.Add(colClass);
DataColumn colName = new DataColumn("姓名", typeof(string));
scores.Columns.Add(colName);
for (int i = 0; i < cbSubject1.Items.Count; i++)
{
DataColumn colScore = new DataColumn(((DataRowView)cbSubject1.Items[i])["Subjects_Name"].ToString(), typeof(int));
colScore.DefaultValue = 0;
scores.Columns.Add(colScore);
}
DataColumn colTotal = new DataColumn("总分", typeof(int));
scores.Columns.Add(colTotal);
string sql = "select e.* from Examination as e,Students as s,Classes as c where e.StudentID=s.Student_ID and s.StudentClass=c.Classes_ID and c.Classes_Speciality=@0";
string specialityID = cbSpeciality.SelectedValue.ToString();
DataTable exam = DataBaseHelper.ExecDataTable(sql, specialityID);
sql = "select Student_ID,Student_Name,Classes_Name from Students,Classes where Students.StudentClass=Classes.Classes_ID and Classes_Speciality=@0";
DataTable students = DataBaseHelper.ExecDataTable(sql, specialityID);
DataRow row;
int total = 0;
for (int i = 0; i < students.Rows.Count; i++)
{
row = scores.NewRow();
row["班级"] = students.Rows[i]["Classes_Name"].ToString();
row["姓名"] = students.Rows[i]["Student_Name"].ToString();
DataRow[] rows = exam.Select("StudentID=" + students.Rows[i]["Student_ID"].ToString());
total = 0;
int tempScore;
string tempSubName;
for (int j = 1; j <= rows.Length; j++)
{
tempScore = (int)rows[j - 1]["ExamScore"];
tempSubName = ((DataRowView)cbSubject1.Items[j - 1]).Row["Subjects_Name"].ToString();
row[tempSubName] = tempScore;
total += tempScore;
}
row["总分"] = total;
scores.Rows.Add(row);
}
DataView view = scores.DefaultView;
if (checkBoxAll1.Checked)
{
view.Sort = "总分 desc";
}
else if (cbSubject1.SelectedItem != null)
{
view.Sort = ((DataRowView)cbSubject1.SelectedItem)["Subjects_Name"].ToString() + " desc";
}
dataGridView1.DataSource = view;
groupBox1.Text = ((DataRowView)cbSpeciality.SelectedItem)["Speciality_Name"].ToString();
}
else
{
MessageBox.Show("请选择要查询的专业", "信息提示");
}
}
void BinderBaseInfo()
{
string sql = "select * from Students where Student_ID=@0";
DataTable student = DataBaseHelper.ExecDataTable(sql, StudentID);
if (student.Rows.Count == 0)
{
MessageBox.Show("加载出错！", "错误!");
this.Close();
return;
}
DataRow row = student.Rows[0];
string sqlimage = "select * from StudentImage where Image_Student=@0";
DataTable studentImage = DataBaseHelper.ExecDataTable(sqlimage, StudentID);
if (studentImage.Rows.Count == 0)
{
MessageBox.Show("加载出错！", "错误!");
this.Close();
return;
}
DataRow rowImage = studentImage.Rows[0];
//基本信息
txtBoxName.Text = row["Student_Name"].ToString();
if (row["Student_Sex"].ToString() == "男")
{
rdoBtnMale.Checked = true;
}
else
{
rdoBtnFemale.Checked = true;
}
txtBoxIDCardNum.Text = row["StudentCard"].ToString();
dateTimePickerBirth.Value = (DateTime)row["StudentBirthDay"];
txtBoxNative.Text = row["StudentOrigin"].ToString();
try
{
images = (byte[])rowImage["Images"];
MemoryStream ms = new MemoryStream(images);
Bitmap bmp = new Bitmap(ms);
pBStudentImage.Image = bmp;
}
catch
{
pBStudentImage.Image = null;
images = null;
}
//联系方式
txtBoxHomeAdd.Text = row["StudentAddress"].ToString();
txtBoxHomeTel.Text = row["FamilyTel"].ToString();
txtBoxMobile.Text = row["Mobile"].ToString();
txtBoxQQ.Text = row["QQ"].ToString();
//学籍信息
sql = "select s.Speciality_College,c.Classes_Speciality from ( Students join Classes as c on Students.StudentClass=c.Classes_ID and Students.Student_ID=@0 ) join Speciality as s on c.Classes_Speciality=s.Speciality_ID";
DataTable dt = DataBaseHelper.ExecDataTable(sql, StudentID);
string SpecialityID = dt.Rows[0]["Classes_Speciality"].ToString();
string CollegeID = dt.Rows[0]["Speciality_College"].ToString();
BinderColleges();
BinderSpeciality(CollegeID);
BinderClasses(SpecialityID);
string classID = row["StudentClass"].ToString();
if (cmbBoxCollege.Items.Count > 0)
{
cmbBoxCollege.SelectedValue = CollegeID;
}
if (cmbBoxSpeciality.Items.Count > 0)
{
cmbBoxSpeciality.SelectedValue = SpecialityID;
//学制
BinderSpeYears(SpecialityID);
}
if (cmbBoxClass.Items.Count > 0)
{
cmbBoxClass.SelectedValue = classID;
}
//学号
string num = row["StudentNum"].ToString();
//txtBoxNum.Text = num.Substring(num.Length - 4);
txtBoxNum.Text = num;
dateTimePickerEnterDate.Value = (DateTime)row["StudentEnterYear"];
//学籍变动
BinderStudentinfo(StudentID);
sql = "select * from ChangeTypes";
DataTable changetypes = DataBaseHelper.ExecDataTable(sql);
cmbChangeType.DataSource = changetypes;
cmbChangeType.DisplayMember = "ChangeTypes_Name";
cmbChangeType.ValueMember = "ChangeTypes_ID";
dateTimeChange.Value = DateTime.Now;
//获奖记录
BinderAwards();
BinderAwardsType();
dateTimeAward.Value = DateTime.Now;
//处分记录
BinderPunishment();
BinderPunishmentType();
dateTimePunishment.Value = DateTime.Now;
}
//学制
private void BinderSpeYears(string SpecialityID)
{
string yearssql = "select SpeYears_Name from SpeYears join Speciality on Speciality.Speciality_Years=SpeYears.SpeYears_ID where Speciality.Speciality_ID=@0 ";
labStuType.Text = DataBaseHelper.ExecScalar(yearssql, SpecialityID).ToString();
}
private void btnAddPA_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtPunishmentAwards.Text.Trim()))
{
MessageBox.Show("请输入奖惩类型名称！");
return;
}
int id = 0;
if (cbbPunishmentAwards.Text == "奖励")
{
string sql = "select max(PunishmentAwardTypes_ID) from PunishmentAwardTypes ";
object obj = DataBaseHelper.ExecScalar(sql);
if (!string.IsNullOrEmpty(obj.ToString()))
{
id = int.Parse(obj.ToString());
if (id < 1)
{
id = 1;
}
else
{
id++;
}
}
else
{
id = 1;
}
}
else
{
string sql = "select min(PunishmentAwardTypes_ID) from PunishmentAwardTypes";
object obj = DataBaseHelper.ExecScalar(sql);
if (!string.IsNullOrEmpty(obj.ToString()))
{
id = (int)obj;
if (id > 0)
{
id = -1;
}
else
{
id--;
}
}
else
{
id = -1;
}
}
string sql1 = "insert into PunishmentAwardTypes values(@0,@1)";
int i = DataBaseHelper.ExecNoneQuery(sql1, id, this.txtPunishmentAwards.Text.Trim());
if (i == 1)
{
MessageBox.Show("添加成功！");
}
else
{
MessageBox.Show("添加失败！");
}
Bind_gridPunishmentAwards();
}
private void Bind_gridPunishmentAwards()
{
string sql = "select PunishmentAwardTypes_ID as 奖惩类型编号,PunishmentAwardTypes_Name as 奖惩类型名称 from PunishmentAwardTypes order by PunishmentAwardTypes_ID desc";
this.gridPunishmentAwards.DataSource = DataBaseHelper.ExecDataTable(sql);
}
private void Bind_girdXueJi()
{
string sql = "select ChangeTypes_ID as 编号,ChangeTypes_Name as 变动类型名称 from ChangeTypes";
this.gridXueJi.DataSource = DataBaseHelper.ExecDataTable(sql);
}
