コード例 #1
0
    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() + "页)";
    }
コード例 #2
0
    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();
    }
コード例 #3
0
    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();");
    }