protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; class_TracNghiem ob = new class_TracNghiem(); lbCongTy.Text = ob.company_name(); if (Request["SBD"] != null) { if (Request.Cookies["ADMIN"] == null) return; SHOW_RESULT(Request["SBD"]); } else if (Request.Cookies["EXAMS"] != null) SHOW_RESULT(Request.Cookies["EXAMS"].Value); else Response.Redirect("Default.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; if (Request.Cookies["ADMIN"] == null) return; class_TracNghiem ob = new class_TracNghiem(); lbCongTy.Text = ob.company_name(); if (Request["ID"] == null) Response.Redirect("Admin_List.aspx"); else try { DataSet ds = ob.fillDataset("EXEC dbo.Session_Result " + Request["ID"]); lbNghe.Text = ds.Tables[0].Rows[0][0].ToString(); gvStudent.DataSource = ds.Tables[1]; gvStudent.DataBind(); } catch { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; class_TracNghiem ob = new class_TracNghiem(); lbCongTy.Text = ob.company_name(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; if (Request.Cookies["ADMIN"] == null) return; class_TracNghiem ob = new class_TracNghiem(); lbCongTy.Text = ob.company_name(); try { DataSet ds = ob.fillDataset("EXEC dbo.Session_Select " + Request["ID"]); lbNghe.Text = ds.Tables[0].Rows[0][1].ToString(); ds = ob.fillDataset("EXEC dbo.Result_Show_In_Code " + Request["ID"]); // Điểm theo lĩnh vực có yêu cầu DataView dv = ds.Tables[1].DefaultView; DataColumn dc; string col_id, col_name, col_check; foreach (DataRow dr2 in ds.Tables[2].Rows) { col_id = dr2[0].ToString(); col_name = dr2[1].ToString(); col_check = "OK" + col_id; dc = new DataColumn(col_name); ds.Tables[0].Columns.Add(dc); dc = new DataColumn(col_check); ds.Tables[0].Columns.Add(dc); ds.Tables[0].AcceptChanges(); foreach (DataRow dr0 in ds.Tables[0].Rows) { dv.RowFilter = string.Format("ThiSinh={0} and LinhVuc={1}", dr0[0].ToString(), col_id); dr0.BeginEdit(); try { dr0[col_name] = dv[0][2].ToString(); dr0[col_check] = float.Parse(dv[0][2].ToString()) >= float.Parse(dr2[2].ToString()) ? "1" : "0"; } catch { dr0[col_check] = "0"; } dr0.EndEdit(); } } // Tổng điểm dc = new DataColumn("Tổng điểm"); ds.Tables[0].Columns.Add(dc); dc = new DataColumn("OK0"); ds.Tables[0].Columns.Add(dc); dv = ds.Tables[3].DefaultView; ds.Tables[0].AcceptChanges(); foreach (DataRow dr0 in ds.Tables[0].Rows) { dv.RowFilter = "ThiSinh=" + dr0[0].ToString(); dr0.BeginEdit(); try { dr0["Tổng điểm"] = dv[0][1].ToString(); dr0["OK0"] = float.Parse(dv[0][1].ToString()) >= float.Parse(dr0[3].ToString()) ? "1" : "0"; } catch { dr0["OK0"] = "0"; } dr0.EndEdit(); } // Kết quả dc = new DataColumn("Kết quả"); ds.Tables[0].Columns.Add(dc); ds.Tables[0].AcceptChanges(); foreach (DataRow dr0 in ds.Tables[0].Rows) { //bool ok = true; //for (int i = 0; i < ds.Tables[0].Columns.Count; i++) //{ // if (ds.Tables[0].Columns[i].ColumnName.StartsWith("OK")) // { // ok = ok && dr0[i].ToString() == "1"; // } //} dr0.BeginEdit(); //dr0["Kết quả"] = ok ? "Đạt" : "Trượt"; try { dr0["Kết quả"] = ob.fillDataset("EXEC dbo.Result_ThaiNguyen " + dr0[0].ToString()).Tables[0].Rows[0][0].ToString(); } catch { dr0["Kết quả"] = null; } dr0.EndEdit(); } // Tạo table để hiển thị DataTable myDT = new DataTable(); dc = new DataColumn("SBD"); myDT.Columns.Add(dc); dc = new DataColumn("Họ tên"); myDT.Columns.Add(dc); for (int i = 4; i < ds.Tables[0].Columns.Count; i++) if (!ds.Tables[0].Columns[i].ColumnName.StartsWith("OK")) { dc = new DataColumn(ds.Tables[0].Columns[i].ColumnName); myDT.Columns.Add(dc); } foreach (DataRow dr0 in ds.Tables[0].Rows) { DataRow row = myDT.NewRow(); row["SBD"] = dr0[1].ToString(); row["Họ tên"] = dr0[2].ToString(); for (int i = 2; i < myDT.Columns.Count; i++) row[i] = dr0[myDT.Columns[i].ColumnName].ToString(); myDT.Rows.Add(row); } gvStudent.DataSource = myDT; gvStudent.DataBind(); foreach (GridViewRow dr in gvStudent.Rows) { dr.Cells[1].CssClass = "center"; for (int i = 3; i < dr.Cells.Count - 1; i++) dr.Cells[i].CssClass = "right"; } } catch { } }