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