protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
var d = GridView1.DataKeys[e.RowIndex];
BaoKao baokao = new BaoKao();
baokao.Sid = d[0].ToString();
baokao.Eid = Convert.ToInt32(d[1].ToString());
//Response.Write((GridView1.Rows[e.RowIndex].Cells[3].Controls[0] as TextBox).Text + "," );
string score = (GridView1.Rows[e.RowIndex].Cells[3].Controls[0] as TextBox).Text;
try
{
baokao.Score = Convert.ToInt32(score);
}
catch
{
Response.Write("<script>alert('未正确填写分数');</script>");
return;
}
string sql = "update baokao set score=" + baokao.Score + ",estate=3 where sid='" + baokao.Sid + "' and eid=" + baokao.Eid;
SqlHelper.GetExecuteNonQuery(sql, CommandType.Text);
GridView1.EditIndex = -1;
BindGV();
}
// 查看可报考的 科目 去掉约束科目 去掉已选科目
public List <ExamSubject> NotBKtable(BaoKao baoKao)
{
//string str = "select * from ExamSubject where id not in( select Eid from baokao where sid=@id)";
string str = "select * from ExamSubject where (id not in (select * from ( sele" +
"ct examSubjectNo from check_grade where checkGrade not in" +
" (select grade from Students where id=@id) ) a where" +
" a.examSubjectNo in (select examSubjectNo from Check_major wh" +
"ere '专业名' not in (select major from Students where id=@id))) ) and (id not in( select Eid from baokao where sid=@id ))";//andEstate!=3
SqlParameter[] pars =
{
new SqlParameter("@id", SqlDbType.VarChar, 50),
};
pars[0].Value = baoKao.Sid;
DataTable da = SqlHelper.GetTable(str, CommandType.Text, pars);
List <ExamSubject> list = new List <ExamSubject>();
if (da.Rows.Count > 0)
{
ExamSubject bk = null;
foreach (DataRow datarow in da.Rows)
{
bk = new ExamSubject();
LoadExamSubject(datarow, bk);
list.Add(bk);
}
}
return(list);
}
//查找可此学号学生报考信息
public List <BaoKao> SelectId(BaoKao baoKao)
{
string str = "select * from baokao where Sid=@id";
SqlParameter[] pars =
{
//new SqlParameter("@name", userInfo.UserName),
new SqlParameter("@id", SqlDbType.VarChar, 50),
};
pars[0].Value = baoKao.Sid;
DataTable da = SqlHelper.GetTable(str, CommandType.Text, pars);
List <BaoKao> list = null;
if (da.Rows.Count > 0)
{
list = new List <BaoKao>();
BaoKao bk = null;
foreach (DataRow datarow in da.Rows)
{
bk = new BaoKao();
LoadBaoKao(datarow, bk);
list.Add(bk);
}
}
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer();
//context.Response.Write("Hello World");
BaoKao baoKao = new BaoKao();
// baoKao.Sid= context.Request.QueryString["sid"];
Students students = (Students)Session["account"];
baoKao.Sid = students.id;
baoKao.Eid = Convert.ToInt32(Request.QueryString["eid"]);
string sql = "select * from baokao where sid='" + baoKao.Sid + "' and Eid=" + baoKao.Eid;
string str = "baokao.aspx?id=" + baoKao.Sid;
//已报考
if (SqlHelper.GetTable(sql, System.Data.CommandType.Text).Rows.Count > 0)
{
Server.Transfer(str);
}
else
{
baoKao.ApplyTime = DateTime.Now;
baoKao.Estate = 1;//待考试
examSubjectDalServer.InsertBK(baoKao);
Server.Transfer(str);
}
}
public List <DetailsSubject> DetailsSubject(BaoKao baoKao)
{
string str = "select name,grade,ApplyTime,Score,Estate,sid from baokao b,Students s where b.Sid=s.id and b.eid=@eid";
SqlParameter[] pars =
{
new SqlParameter("@eid", SqlDbType.Int)
};
pars[0].Value = baoKao.Eid;
DataTable da = SqlHelper.GetTable(str, CommandType.Text, pars);
List <DetailsSubject> list = new List <DetailsSubject>();//
if (da.Rows.Count > 0)
{
DetailsSubject detailsSubject = null;
foreach (DataRow datarow in da.Rows)
{
detailsSubject = new DetailsSubject();
LoadExamSubject1(datarow, detailsSubject);
list.Add(detailsSubject);
}
}
return(list);
}
public void LoadBaoKao(DataRow rows, BaoKao baoKao)
{
baoKao.Sid = rows["Sid"] != null ? rows["Sid"].ToString() : string.Empty;
baoKao.Eid = Convert.ToInt32(rows["Eid"]);
baoKao.ERid = Convert.ToInt32(rows["ERid"]);
baoKao.Estate = Convert.ToInt32(rows["Estate"]);
baoKao.Score = Convert.ToInt32(rows["Score"]);
//students.img= rows["img"] != null ? Convert.FromBase64String(rows["img"].ToString()) : Convert.FromBase64String(string.Empty);
baoKao.ApplyTime = Convert.ToDateTime(rows["applytime"]);
//转换未字符类型后再转换为 []byte 类型 tc
}
public int DeletBK(BaoKao baoKao)
{
string str = "delete baokao where sid=@sid and eid=@eid";
SqlParameter[] pars =
{
new SqlParameter("@sid", SqlDbType.VarChar, 50),
new SqlParameter("@eid", SqlDbType.Int),
};
pars[0].Value = baoKao.Sid;
pars[1].Value = baoKao.Eid;
return(SqlHelper.GetExecuteNonQuery(str, CommandType.Text, pars));
}
public DataTable DetailsSubjectDataTable(BaoKao baoKao)
{
string str = "select name,grade,ApplyTime,Score,Estate,sid from baokao b,Students s where b.Sid=s.id and b.eid=@eid";
SqlParameter[] pars =
{
new SqlParameter("@eid", SqlDbType.Int)
};
pars[0].Value = baoKao.Eid;
DataTable da = SqlHelper.GetTable(str, CommandType.Text, pars);
return(da);
}
public void ProcessRequest(HttpContext context)
{
ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer();
context.Response.ContentType = "html/plain";
//context.Response.Write("Hello World");
BaoKao baoKao = new BaoKao();
baoKao.Sid = context.Request.QueryString["sid"];
baoKao.Eid = Convert.ToInt32(context.Request.QueryString["eid"]);
examSubjectDalServer.DeletBK(baoKao);
string str = "detailStudent.aspx?id=" + baoKao.Sid;
context.Response.Redirect(str);
}
public int UpdateBaoKao(BaoKao baoKao)
{
string str = "update BaoKao set score =@score where sid=@sid and eid=@eid";
SqlParameter[] pars =
{
new SqlParameter("@score", SqlDbType.Int),
new SqlParameter("@sid", SqlDbType.VarChar,50),
new SqlParameter("@eid", SqlDbType.Int),
};
pars[0].Value = baoKao.Score;
pars[1].Value = baoKao.Sid;
pars[2].Value = baoKao.Eid;
return(SqlHelper.GetExecuteNonQuery(str, CommandType.Text, pars));
}
protected void Page_Load(object sender, EventArgs e)
{
Students students = new Students();
students = (Students)Session["account"];
BaoKao baoKao = new BaoKao();
baoKao.Sid = students.id;
baoKao.Eid = Convert.ToInt32(Request.QueryString["id"]);
ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer();
examSubjectDalServer.DeletBK(baoKao);
string str = "detailStudent.aspx?id=" + baoKao.Sid;
Response.Redirect(str);
}
public int InsertBK(BaoKao baoKao)
{
string str = "insert into baokao(sid,eid,applytime,Estate) values(@sid,@eid,@applytime,@Estate)";
SqlParameter[] pars =
{
new SqlParameter("@sid", SqlDbType.VarChar, 50),
new SqlParameter("@eid", SqlDbType.Int),
new SqlParameter("@applytime", SqlDbType.DateTime),
new SqlParameter("@Estate", SqlDbType.Int),
};
pars[0].Value = baoKao.Sid;
pars[1].Value = baoKao.Eid;
pars[2].Value = baoKao.ApplyTime;
pars[3].Value = baoKao.Estate;// 报考默认为1 1为待考试 2已完成考试
return(SqlHelper.GetExecuteNonQuery(str, CommandType.Text, pars));
}
public void ProcessRequest(HttpContext context)
{
ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer();
context.Response.ContentType = "html/plain";
//context.Response.Write("Hello World");
BaoKao baoKao = new BaoKao();
baoKao.Sid = context.Request.QueryString["sid"];
baoKao.Eid = Convert.ToInt32(context.Request.QueryString["eid"]);
baoKao.ApplyTime = DateTime.Now;
baoKao.Estate = 2;
examSubjectDalServer.InsertBK(baoKao);
string str = "baokao.aspx?id=" + baoKao.Sid;
context.Response.Redirect(str);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["account"] == null)
{
Response.Write("<script>alert(\"请先登录！\");</script>");
Server.Transfer("index.aspx");
return;
}
Students students = new Students();
students = (Students)Session["account"];
//更新科目状态
string sql1 = "update baokao set Estate=2 where eid in ( select eid from baokao,examsubject where ExamEnd<'" + DateTime.Now + "' and Estate=1 and eid=id) and sid='" + students.id + "'";
// Response.Write(sql1);
SqlHelper.GetExecuteNonQuery(sql1, CommandType.Text);
MessageDalServer messageDalServer = new MessageDalServer();
Students st = new Students();
// st.id= Context.Request.QueryString["id"];
st = (Students)Session["account"];
//Response.Write(st.id);
StudentsDalServer studentsDalServer = new StudentsDalServer();
ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer();
BaoKao bk = new BaoKao();
bk.Sid = st.id;
examSubjectsList = examSubjectDalServer.BKtable(bk);
Sstudents = studentsDalServer.SelectId(st);
GetData();
if (!IsPostBack)
{
}
}
public List <ExamSubject> BKtable(BaoKao baoKao)
{
string str = "select * from ExamSubject where id in( select Eid from baokao where sid=@id)";
SqlParameter[] pars =
{
new SqlParameter("@id", SqlDbType.VarChar, 50),
};
pars[0].Value = baoKao.Sid;
DataTable da = SqlHelper.GetTable(str, CommandType.Text, pars);
List <ExamSubject> list = new List <ExamSubject>();
if (da.Rows.Count > 0)
{
ExamSubject bk = null;
foreach (DataRow datarow in da.Rows)
{
bk = new ExamSubject();
LoadExamSubject(datarow, bk);
list.Add(bk);
}
}
return(list);
}
public BaoKao SelectIdAndEid(BaoKao baoKao)
{
string str = "select * from baokao where Sid=@id and Eid=@eid";
SqlParameter[] pars =
{
//new SqlParameter("@name", userInfo.UserName),
new SqlParameter("@id", SqlDbType.VarChar, 50),
new SqlParameter("@eid", SqlDbType.Int),
};
pars[0].Value = baoKao.Sid;
pars[1].Value = baoKao.Eid;
DataTable da = SqlHelper.GetTable(str, CommandType.Text, pars);
BaoKao list = new BaoKao();
if (da.Rows.Count > 0)
{
foreach (DataRow datarow in da.Rows)
{
LoadBaoKao(datarow, list);
}
}
return(list);
}
public List <DetailsSubject> DetailsSubject(BaoKao baoKao)
{
return(examSubjuectDal.DetailsSubject(baoKao));
}
//查找学生已报考的考试科目
public List <ExamSubject> BKtable(BaoKao baoKao)
{
return(examSubjuectDal.BKtable(baoKao));
}
public DataTable DetailsSubjectDataTable(BaoKao baoKao)
{
return(examSubjuectDal.DetailsSubjectDataTable(baoKao));
}
public int UpdateBaoKao(BaoKao baoKao)
{
return(examSubjuectDal.UpdateBaoKao(baoKao));
}
public BaoKao SelectIdAndEid(BaoKao baoKao)
{
return(baokao.SelectIdAndEid(baoKao));
}
public int DeletBK(BaoKao baoKao)
{
return(baokao.DeletBK(baoKao));
}
public int InsertBK(BaoKao baoKao)
{
return(baokao.InsertBK(baoKao));
}
