khfw_sum.aspx.cs

退书管理系统

        adapter1.Fill(ds1, "tuihuoguanli");
        this.DataGrid1.DataSource = ds1.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid1.DataBind();
        Response.Write("<" + "script" + ">" + "window.parent.topFrame.locaton.reload();'" + "</" + "script" + ">");
        this.LinkButton1.Font.Underline = false;
        this.LinkButton2.Font.Underline = true;
        this.LinkButton3.Font.Underline = false;
        this.LinkButton4.Font.Underline = false;
        this.LinkButton5.Font.Underline = false;
        

    }
    protected void LinkButton3_Click(object sender, EventArgs e)
    {
        string sql1;
        sql1 = "SELECT khdq, SUM(thjs) as Expr1, SUM(qdjs) as Expr2 FROM tuihuoguanli where (thrq>=@thismonthb and thrq<=@thismonthe) GROUP BY khdq ORDER BY khdq";
        SqlConnection conn1 = new SqlConnection((string)Application["connstr"]);
        conn1.Open();
        SqlDataAdapter adapter1 = new SqlDataAdapter(sql1, conn1);
        adapter1.SelectCommand.Parameters.Add("@thismonthb", SqlDbType.Int).Value = thismonthb;
        adapter1.SelectCommand.Parameters.Add("@thismonthe", SqlDbType.Int).Value = thismonthe;
        DataSet ds1 = new DataSet();
        adapter1.Fill(ds1, "tuihuoguanli");
        this.DataGrid1.DataSource = ds1.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid1.DataBind();
        Response.Write("<" + "script" + ">" + "window.parent.topFrame.locaton.reload();'" + "</" + "script" + ">");
        this.LinkButton1.Font.Underline = false;
        this.LinkButton2.Font.Underline = false;
        this.LinkButton3.Font.Underline = true;
        this.LinkButton4.Font.Underline = false;
        this.LinkButton5.Font.Underline = false;

    }
    protected void LinkButton4_Click(object sender, EventArgs e)
    {
        string sql1;
        sql1 = "SELECT khdq, SUM(thjs) as Expr1, SUM(qdjs) as Expr2 FROM tuihuoguanli where (thrq>=@thisyearb and thrq<=@thisyeare) GROUP BY khdq ORDER BY khdq";
        SqlConnection conn1 = new SqlConnection((string)Application["connstr"]);
        conn1.Open();
        SqlDataAdapter adapter1 = new SqlDataAdapter(sql1, conn1);
        adapter1.SelectCommand.Parameters.Add("@thisyearb", SqlDbType.Int).Value = thisyearb;
        adapter1.SelectCommand.Parameters.Add("@thisyeare", SqlDbType.Int).Value = thisyeare;
        DataSet ds1 = new DataSet();
        adapter1.Fill(ds1, "tuihuoguanli");
        this.DataGrid1.DataSource = ds1.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid1.DataBind();
        Response.Write("<" + "script" + ">" + "window.parent.topFrame.locaton.reload();'" + "</" + "script" + ">");
        this.LinkButton1.Font.Underline = false;
        this.LinkButton2.Font.Underline = false;
        this.LinkButton3.Font.Underline = false;
        this.LinkButton4.Font.Underline = true;
        this.LinkButton5.Font.Underline = false;

    }
    protected void LinkButton5_Click(object sender, EventArgs e)
    {
        string sql1;
        sql1 = "SELECT khdq, SUM(thjs) as Expr1, SUM(qdjs) as Expr2 FROM tuihuoguanli GROUP BY khdq ORDER BY khdq";
        SqlConnection conn1 = new SqlConnection((string)Application["connstr"]);
        conn1.Open();
        SqlDataAdapter adapter1 = new SqlDataAdapter(sql1, conn1);
        DataSet ds1 = new DataSet();
        adapter1.Fill(ds1, "tuihuoguanli");
        this.DataGrid1.DataSource = ds1.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid1.DataBind();
        this.LinkButton1.Font.Underline = false;
        this.LinkButton2.Font.Underline = false;
        this.LinkButton3.Font.Underline = false;
        this.LinkButton4.Font.Underline = false;
        this.LinkButton5.Font.Underline = true;
    }
    protected void LinkButton6_Click(object sender, EventArgs e)
    {
        string sql2;
        sql2 = "SELECT thr, SUM(thjs) as Expr1 FROM tuihuoguanli where thrq=@thisday GROUP BY thr ORDER BY thr";
        SqlConnection conn2 = new SqlConnection((string)Application["connstr"]);
        conn2.Open();
        SqlDataAdapter adapter2 = new SqlDataAdapter(sql2, conn2);
        adapter2.SelectCommand.Parameters.Add("@thisday", SqlDbType.Int).Value = thisday;
        DataSet ds2 = new DataSet();
        adapter2.Fill(ds2, "tuihuoguanli");
        this.DataGrid2.DataSource = ds2.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid2.DataBind();
        this.LinkButton6.Font.Underline = true;
        this.LinkButton7.Font.Underline = false;
        this.LinkButton8.Font.Underline = false;
        this.LinkButton9.Font.Underline = false;
        this.LinkButton10.Font.Underline = false;

    }
    protected void LinkButton7_Click(object sender, EventArgs e)
    {
        string sql2;
        sql2 = "SELECT thr, SUM(thjs) as Expr1 FROM tuihuoguanli where (thrq>=@thisweekb and thrq<=@thisweeke) GROUP BY thr ORDER BY thr";
        SqlConnection conn2 = new SqlConnection((string)Application["connstr"]);
        conn2.Open();
        SqlDataAdapter adapter2 = new SqlDataAdapter(sql2, conn2);
        adapter2.SelectCommand.Parameters.Add("@thisweekb", SqlDbType.Int).Value = thisweekb;
        adapter2.SelectCommand.Parameters.Add("@thisweeke", SqlDbType.Int).Value = thisweeke;
        DataSet ds2 = new DataSet();
        adapter2.Fill(ds2, "tuihuoguanli");
        this.DataGrid2.DataSource = ds2.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid2.DataBind();
        this.LinkButton6.Font.Underline = false;
        this.LinkButton7.Font.Underline = true;
        this.LinkButton8.Font.Underline = false;
        this.LinkButton9.Font.Underline = false;
        this.LinkButton10.Font.Underline = false;

    }
    protected void LinkButton8_Click(object sender, EventArgs e)
    {
        string sql2;
        sql2 = "SELECT thr, SUM(thjs) as Expr1 FROM tuihuoguanli where (thrq>=@thismonthb and thrq<=@thismonthe) GROUP BY thr ORDER BY thr";
        SqlConnection conn2 = new SqlConnection((string)Application["connstr"]);
        conn2.Open();
        SqlDataAdapter adapter2 = new SqlDataAdapter(sql2, conn2);
        adapter2.SelectCommand.Parameters.Add("@thismonthb", SqlDbType.Int).Value = thismonthb;
        adapter2.SelectCommand.Parameters.Add("@thismonthe", SqlDbType.Int).Value = thismonthe;
        DataSet ds2 = new DataSet();
        adapter2.Fill(ds2, "tuihuoguanli");
        this.DataGrid2.DataSource = ds2.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid2.DataBind();
        this.LinkButton6.Font.Underline = false;
        this.LinkButton7.Font.Underline = false;
        this.LinkButton8.Font.Underline = true;
        this.LinkButton9.Font.Underline = false;
        this.LinkButton10.Font.Underline = false;

    }
    protected void LinkButton9_Click(object sender, EventArgs e)
    {
        string sql2;
        sql2 = "SELECT thr, SUM(thjs) as Expr1 FROM tuihuoguanli where (thrq>=@thisyearb and thrq<=@thisyeare) GROUP BY thr ORDER BY thr";
        SqlConnection conn2 = new SqlConnection((string)Application["connstr"]);
        conn2.Open();
        SqlDataAdapter adapter2 = new SqlDataAdapter(sql2, conn2);
        adapter2.SelectCommand.Parameters.Add("@thisyearb", SqlDbType.Int).Value = thisyearb;
        adapter2.SelectCommand.Parameters.Add("@thisyeare", SqlDbType.Int).Value = thisyeare;
        DataSet ds2 = new DataSet();
        adapter2.Fill(ds2, "tuihuoguanli");
        this.DataGrid2.DataSource = ds2.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid2.DataBind();
        this.LinkButton6.Font.Underline = false;
        this.LinkButton7.Font.Underline = false;
        this.LinkButton8.Font.Underline = false;
        this.LinkButton9.Font.Underline = true;
        this.LinkButton10.Font.Underline = false;

    }
    protected void LinkButton10_Click(object sender, EventArgs e)
    {
        string sql2;
        sql2 = "SELECT thr, SUM(thjs) as Expr1 FROM tuihuoguanli GROUP BY thr ORDER BY thr";
        SqlConnection conn2 = new SqlConnection((string)Application["connstr"]);
        conn2.Open();
        SqlDataAdapter adapter2 = new SqlDataAdapter(sql2, conn2);
        DataSet ds2 = new DataSet();
        adapter2.Fill(ds2, "tuihuoguanli");
        this.DataGrid2.DataSource = ds2.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid2.DataBind();
        this.LinkButton6.Font.Underline = false;
        this.LinkButton7.Font.Underline = false;
        this.LinkButton8.Font.Underline = false;
        this.LinkButton9.Font.Underline = false;
        this.LinkButton10.Font.Underline = true;

    }
    protected void LinkButton11_Click(object sender, EventArgs e)
    {
        string sql3;
        sql3 = "SELECT qdr, SUM(qdjs) as Expr1 FROM tuihuoguanli where qdsj=@thisday GROUP BY qdr ORDER BY qdr";
        SqlConnection conn3 = new SqlConnection((string)Application["connstr"]);
        conn3.Open();
        SqlDataAdapter adapter3 = new SqlDataAdapter(sql3, conn3);
        adapter3.SelectCommand.Parameters.Add("@thisday", SqlDbType.Int).Value = thisday;
        DataSet ds3 = new DataSet();
        adapter3.Fill(ds3, "tuihuoguanli");
        this.DataGrid3.DataSource = ds3.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid3.DataBind();
        this.LinkButton11.Font.Underline = true;
        this.LinkButton12.Font.Underline = false;
        this.LinkButton13.Font.Underline = false;
        this.LinkButton14.Font.Underline = false;
        this.LinkButton15.Font.Underline = false;

    }
    protected void LinkButton12_Click(object sender, EventArgs e)
    {
        string sql3;
        sql3 = "SELECT qdr, SUM(qdjs) as Expr1 FROM tuihuoguanli where (qdsj>=@thisweekb and qdsj<=@thisweeke) GROUP BY qdr ORDER BY qdr";
        SqlConnection conn3 = new SqlConnection((string)Application["connstr"]);
        conn3.Open();
        SqlDataAdapter adapter3 = new SqlDataAdapter(sql3, conn3);
        adapter3.SelectCommand.Parameters.Add("@thisweekb", SqlDbType.Int).Value = thisweekb;
        adapter3.SelectCommand.Parameters.Add("@thisweeke", SqlDbType.Int).Value = thisweeke;
        DataSet ds3 = new DataSet();
        adapter3.Fill(ds3, "tuihuoguanli");
        this.DataGrid3.DataSource = ds3.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid3.DataBind();
        this.LinkButton11.Font.Underline = false;
        this.LinkButton12.Font.Underline = true;
        this.LinkButton13.Font.Underline = false;
        this.LinkButton14.Font.Underline = false;
        this.LinkButton15.Font.Underline = false;

    }
    protected void LinkButton13_Click(object sender, EventArgs e)
    {
        string sql3;
        sql3 = "SELECT qdr, SUM(qdjs) as Expr1 FROM tuihuoguanli where (qdsj>=@thismonthb and qdsj<=@thismonthe) GROUP BY qdr ORDER BY qdr";
        SqlConnection conn3 = new SqlConnection((string)Application["connstr"]);
        conn3.Open();
        SqlDataAdapter adapter3 = new SqlDataAdapter(sql3, conn3);
        adapter3.SelectCommand.Parameters.Add("@thismonthb", SqlDbType.Int).Value = thismonthb;
        adapter3.SelectCommand.Parameters.Add("@thismonthe", SqlDbType.Int).Value = thismonthe;
        DataSet ds3 = new DataSet();
        adapter3.Fill(ds3, "tuihuoguanli");
        this.DataGrid3.DataSource = ds3.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid3.DataBind();
        this.LinkButton11.Font.Underline = false;
        this.LinkButton12.Font.Underline = false;
        this.LinkButton13.Font.Underline = true;
        this.LinkButton14.Font.Underline = false;
        this.LinkButton15.Font.Underline = false;

    }
    protected void LinkButton14_Click(object sender, EventArgs e)
    {
        string sql3;