protected void Page_Load(object sender, EventArgs e)
{
Server.Execute("judgeJs.aspx");//**********************************
string loginName = Session["login_name"].ToString();
userMessage01.InnerText = "你好！" + loginName;
string xnd = Session["xnd"].ToString();
labelXnd.Text = xnd + "学年度";
Database db = new Database();
DataRow dr = db.GetDataRow("exec proJsZgzlJs " + SqlStringConstructor.GetQuotedString(loginName) + " , " + SqlStringConstructor.GetQuotedString(xnd));
txtJsbh.Value = dr["jsbh"].ToString();
txtJsxm.Value = dr["jsxm"].ToString();
txtJsxb.Value = dr["jsxb"].ToString();
txtJszc.Value = dr["zcmc"].ToString();
txtJszw.Value = dr["zwlx"].ToString();
txtSsyx.Value = dr["yxmc"].ToString();
txtZgzl.Value = dr["zgzl"].ToString();
txtGzlqk.Value = dr["gzlqk"].ToString();
DataTable dtKc = db.GetDataTable("select * from viewKcrw where jsbh = " + SqlStringConstructor.GetQuotedString(loginName) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVKC.DataSource = dtKc;
GVKC.DataBind();
DataTable dtKcsj = db.GetDataTable("select * from viewKcsjrw where jsbh = " + SqlStringConstructor.GetQuotedString(loginName) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVKCSJ.DataSource = dtKcsj;
GVKCSJ.DataBind();
DataTable dtSx = db.GetDataTable("select * from viewSxrw where jsbh = " + SqlStringConstructor.GetQuotedString(loginName) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVSX.DataSource = dtSx;
GVSX.DataBind();
DataTable dtBysj = db.GetDataTable("select * from viewBysjrw where jsbh = " + SqlStringConstructor.GetQuotedString(loginName) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVBYSJ.DataSource = dtBysj;
GVBYSJ.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Server.Execute("judgeJxms.aspx");
string jsbh = Page.Request.QueryString["jsbh"];
string xnd = Page.Request.QueryString["xnd"];
Database db = new Database();
DataRow dr = db.GetDataRow("exec proJsZgzlJs " + SqlStringConstructor.GetQuotedString(jsbh) + " , " + SqlStringConstructor.GetQuotedString(xnd));
txtJsbh.Value = dr["jsbh"].ToString();
txtJsxm.Value = dr["jsxm"].ToString();
txtJsxb.Value = dr["jsxb"].ToString();
txtJszc.Value = dr["zcmc"].ToString();
txtJszw.Value = dr["zwlx"].ToString();
txtSsyx.Value = dr["yxmc"].ToString();
txtZgzl.Value = dr["zgzl"].ToString();
txtGzlqk.Value = dr["gzlqk"].ToString();
DataTable dtKc = db.GetDataTable("select * from viewKcrw where jsbh = " + SqlStringConstructor.GetQuotedString(jsbh) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVKC.DataSource = dtKc;
GVKC.DataBind();
DataTable dtKcsj = db.GetDataTable("select * from viewKcsjrw where jsbh = " + SqlStringConstructor.GetQuotedString(jsbh) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVKCSJ.DataSource = dtKcsj;
GVKCSJ.DataBind();
DataTable dtSx = db.GetDataTable("select * from viewSxrw where jsbh = " + SqlStringConstructor.GetQuotedString(jsbh) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVSX.DataSource = dtSx;
GVSX.DataBind();
DataTable dtBysj = db.GetDataTable("select * from viewBysjrw where jsbh = " + SqlStringConstructor.GetQuotedString(jsbh) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVBYSJ.DataSource = dtBysj;
GVBYSJ.DataBind();
btnClose.Attributes.Add("onclick", "window.close();");
}
