private void QueryKC2() { //构造查询Hash对象 Hashtable queryItems = new Hashtable(); queryItems.Add("kcmc", txtKcmc.Value); DataTable dt = Gzl.BusinessLogicLayer.KC.QueryKC(queryItems); GVKC.DataSource = dt; GVKC.DataBind(); labelPageKC.Text = "查询结果(第" + (GVKC.PageIndex + 1).ToString() + "页 共" + GVKC.PageCount.ToString() + "页)"; }
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();"); }