Пример #1
0
        private DataSet vDsKetQuaHocTap()
        {
            tb         = new DataTable();
            boHv       = new BO_HOCVIEN();
            vDsBieuMau = new DsInBieuMau();
            int vLopID  = int.Parse(lookLop_InGCN.GetColumnValue("LOP_ID").ToString());
            int vMonID  = int.Parse(lookMonHoc.GetColumnValue("MON_ID").ToString());
            int vLanThi = int.Parse(lookLanThi.GetColumnValue("DIE_LanThi").ToString());

            tb = boHv.ExportExcel_DiemThi(vLopID, vMonID, vLanThi);
            if (tb.Rows.Count > 0)
            {
                for (int i = 0; i < tb.Rows.Count; i++)
                {
                    vRow                  = vDsBieuMau.DiemDanhHocVien.NewRow();
                    vRow["STT"]           = i + 1;
                    vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FirstName"].ToString();
                    vRow["HOV_LastName"]  = tb.Rows[i]["HOV_LastName"].ToString();
                    vRow["HOV_BirthDay"]  = tb.Rows[i]["HOV_BirthDay"].ToString();
                    vRow["TIN_Name"]      = tb.Rows[i]["TIN_Name"].ToString();
                    vRow["vLopName"]      = lookLop_InGCN.GetColumnValue("LOP_Name").ToString();
                    vRow["vMonName"]      = lookMonHoc.GetColumnValue("MON_Name").ToString();
                    vDsBieuMau.DiemDanhHocVien.Rows.Add(vRow);
                }
            }
            return(vDsBieuMau);
        }