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 { }
}