public void CheckHelloWorld() { string name = "nitish2"; Assert.AreEqual(StudentsBLL.GetHello(name), "Hello nitish"); }
private void button4_Click(object sender, EventArgs e) { this.dataGridView1.DataSource = null; if (this.cmbClass.SelectedValue == null || this.cmbSubjects.SelectedValue == null) { MessageBox.Show("你还没选中专业或学科?"); return; } //创建某专业表dt作为datagridview的数据源 DataTable dt = new DataTable(); //为dt表创建数据列 DataColumn cnum = new DataColumn("学号", typeof(string)); //创建学号列 DataColumn cname = new DataColumn("姓名", typeof(string)); //创建姓名列 dt.Columns.Add(cnum); dt.Columns.Add(cname);//将此列添加到表dt中 //遍历学科列表,将每个学科构建成表中的列,列名为学科名称 for (int i = 0; i < cmbSubjects.Items.Count; i++) { string subname = ((DataRowView)this.cmbSubjects.Items[i])["Subjects_Name"].ToString(); DataColumn cgrade = new DataColumn(subname, typeof(int)); cgrade.DefaultValue = 0;//默认值为0 dt.Columns.Add(cgrade); } DataColumn csum = new DataColumn("总分", typeof(int)); dt.Columns.Add(csum); //为dt表添加数据行 //2.1根据专业编号选出该专业所有学生所有信息的成绩形成信息表 ClassesModel clamodel = new ClassesModel(); StudentsBLL student = new StudentsBLL(); clamodel.Classes_Speciality = this.cmbSpeciality.SelectedValue.ToString(); DataTable stu = student.GetStudentsBySpec(clamodel);//查询选中专业的所有学生形成学生表 //2.2根据专业编号选出该班级所有学生所有科目的成绩形成成绩表 SpecialityModel spemodel = new SpecialityModel(); spemodel.Speciality_ID = this.cmbSpeciality.SelectedValue.ToString(); DataTable exam = examin.GetAllGradeBySpeciality(spemodel); //遍历学生表中所有行,将每个学生构造成一个和自定义的ì?dt表具有相同结构的数据行 for (int i = 0; i < stu.Rows.Count; i++) { DataRow row = dt.NewRow(); row["学号"] = stu.Rows[i]["StudentNum"]; //初始化一个表具有相同结构的数据行 row["姓名"] = stu.Rows[i]["Student_Name"]; //从学生表第i行取出学号列赋dt表学号? //从结果集表中再次查询单个成绩并返回数据行集合 DataRow[] rows = exam.Select("StudentID=" + stu.Rows[i]["Student_ID"]); int total = 0; //总分 string name; //科目的列名 int score = 0; for (int j = 0; j < rows.Length; j++) { //获取科目名称 name = ((DataRowView)this.cmbSubjects.Items[j])["Subjects_Name"].ToString(); score = Convert.ToInt32(rows[j]["ExamScore"]); //把第i个学生的第i个成绩取出 row[name] = score; //填充成绩到表中 total += score; //累加总分 } row["总分"] = total; dt.Rows.Add(row);//将构造好的行添加到行集合 } //3创建数据表的视图进行排序 DataView view = dt.DefaultView; if (this.checkBox1.Checked) { view.Sort = "总分 desc"; } else { view.Sort = "总分 asc"; } this.dataGridView1.DataSource = dt; }
/// <summary> /// 管理员权限登陆 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { string name = this.txtName.Text.Trim(); string pass = this.txtPass.Text.Trim(); if (string.IsNullOrEmpty(name)) { MessageBox.Show("请输入姓名"); return; } if (string.IsNullOrEmpty(pass)) { MessageBox.Show("请输入密码"); return; } if (this.textBox1.Text.ToLower() != Ccode.ToLower()) { CreateImage(); MessageBox.Show("验证码输入错误"); return; } //学生登陆 StudentsModel stumodel = new StudentsModel(); StudentsBLL student = new StudentsBLL(); if (this.checkBox1.Checked) { stumodel.Student_Name = this.txtName.Text; try { DataRow row = student.GetStudentByName(stumodel).Rows[0]; string num = row["StudentNum"].ToString().Substring(10, 4); string cnum = this.txtPass.Text; if (num == cnum) { int id = Convert.ToInt32(row["Student_ID"]); PropertyForm fm = new PropertyForm(id); fm.Show(); } else { MessageBox.Show("用户名或密码错误"); return; } } catch { MessageBox.Show("用户名或密码不匹配"); } } else { AdminInfoModel adminmodel = new AdminInfoModel(); AdminInfoBLL admininfo = new AdminInfoBLL(); adminmodel.Admin_Name = name; adminmodel.Admin_Password = pass; SqlDataReader dr = admininfo.AdminLogin(adminmodel); if (dr.Read()) //如果登陆成功 { MainForm main = (MainForm)this.Owner; //实例化主窗体 //将管理员的ID和权限保存到主窗体全局字段 main.adminid = Convert.ToInt32(dr["Admin_ID"]); main.level = dr["Admin_Level"].ToString(); islog = true; //将是否登陆成功的标识改为true dr.Close(); //关闭阅读器 this.Close(); //关闭主窗体 } else { dr.Close(); MessageBox.Show("用户名或密码错误"); return; } } }