public TestScore GetTestScore(string matruong, string sbd, string hoTen)
 {
     TestScore testScore = new TestScore();
     testScore.ListTruong = GetTruongs();
     testScore.MaTruong = matruong;
     testScore.Sbd = sbd;
     testScore.HoTen = hoTen;
     string sql = string.Format("SELECT DISTINCT TS.SBD, TS.HOTEN, TS.NGAYSINH, CN.TENNGANH, DT.KHOITHI, DT.DIEM FROM DIEMTHI DT JOIN THISINH TS ON DT.SBD = TS.SBD JOIN CHUYENNGANH CN ON CN.MANGANH = DT.MANGANH WHERE DT.MATRUONG = N'{0}' AND (TS.SBD = '{1}' OR HOTEN = N'{2}')", matruong, sbd, hoTen);
     var dataTableDiemThi = dataProvider.ExecuteQuery(sql);
     foreach (DataRow row in dataTableDiemThi.Rows)
     {
         DiemThi diemThi = new DiemThi();
         diemThi.Sbd = row["Sbd"].ToString();
         diemThi.HoTen = row["HoTen"].ToString();
         diemThi.NgaySinh = Convert.ToDateTime(row["NgaySinh"].ToString());
         diemThi.TenNganh = row["TenNganh"].ToString();
         diemThi.KhoiThi = row["KhoiThi"].ToString();
         diemThi.Diem = float.Parse(row["Diem"].ToString());
         testScore.ListDiem.Add(diemThi);
     }
     return testScore;
 }
Пример #2
0
        public TestScore GetTestScore(string matruong, string sbd, string hoTen)
        {
            TestScore testScore = new TestScore();

            testScore.ListTruong = GetTruongs();
            testScore.MaTruong   = matruong;
            testScore.Sbd        = sbd;
            testScore.HoTen      = hoTen;
            string sql = string.Format("SELECT DISTINCT TS.SBD, TS.HOTEN, TS.NGAYSINH, CN.TENNGANH, DT.KHOITHI, DT.DIEM FROM DIEMTHI DT JOIN THISINH TS ON DT.SBD = TS.SBD JOIN CHUYENNGANH CN ON CN.MANGANH = DT.MANGANH WHERE DT.MATRUONG = N'{0}' AND (TS.SBD = '{1}' OR HOTEN = N'{2}')", matruong, sbd, hoTen);
            var    dataTableDiemThi = dataProvider.ExecuteQuery(sql);

            foreach (DataRow row in dataTableDiemThi.Rows)
            {
                DiemThi diemThi = new DiemThi();
                diemThi.Sbd      = row["Sbd"].ToString();
                diemThi.HoTen    = row["HoTen"].ToString();
                diemThi.NgaySinh = Convert.ToDateTime(row["NgaySinh"].ToString());
                diemThi.TenNganh = row["TenNganh"].ToString();
                diemThi.KhoiThi  = row["KhoiThi"].ToString();
                diemThi.Diem     = float.Parse(row["Diem"].ToString());
                testScore.ListDiem.Add(diemThi);
            }
            return(testScore);
        }
 public ActionResult TestScore()
 {
     TestScore testScore = new TestScore();
     testScore.ListTruong = truongHelper.GetTruongs();
     return View(testScore);
 }