khfw_sum.aspx.cs

退书管理系统

        sql3 = "SELECT qdr, SUM(qdjs) as Expr1 FROM tuihuoguanli where (qdsj>=@thisyearb and qdsj<=@thisyeare) 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("@thisyearb", SqlDbType.Int).Value = thisyearb;
        adapter3.SelectCommand.Parameters.Add("@thisyeare", SqlDbType.Int).Value = thisyeare;
        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 = false;
        this.LinkButton14.Font.Underline = true;
        this.LinkButton15.Font.Underline = false;


    }
    protected void LinkButton15_Click(object sender, EventArgs e)
    {
        string sql3;
        sql3 = "SELECT qdr, SUM(qdjs) as Expr1 FROM tuihuoguanli GROUP BY qdr ORDER BY qdr";
        SqlConnection conn3 = new SqlConnection((string)Application["connstr"]);
        conn3.Open();
        SqlDataAdapter adapter3 = new SqlDataAdapter(sql3, conn3);
        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 = false;
        this.LinkButton14.Font.Underline = false;
        this.LinkButton15.Font.Underline = true;

    }
    protected void LinkButton16_Click(object sender, EventArgs e)
    {
        string sql4;
        sql4 = "SELECT thrq, SUM(thjs) as Expr1 FROM tuihuoguanli where thrq=@thisday GROUP BY thrq ORDER BY thrq";
        SqlConnection conn4 = new SqlConnection((string)Application["connstr"]);
        conn4.Open();
        SqlDataAdapter adapter4 = new SqlDataAdapter(sql4, conn4);
        adapter4.SelectCommand.Parameters.Add("@thisday", SqlDbType.Int).Value = thisday;
        DataSet ds4 = new DataSet();
        adapter4.Fill(ds4, "tuihuoguanli");
        this.DataGrid4.DataSource = ds4.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid4.DataBind();
        this.LinkButton16.Font.Underline = true;
        this.LinkButton17.Font.Underline = false;
        this.LinkButton18.Font.Underline = false;
        this.LinkButton19.Font.Underline = false;
        this.LinkButton20.Font.Underline = false;

    }
    protected void LinkButton17_Click(object sender, EventArgs e)
    {
        string sql4;
        sql4 = "SELECT thrq, SUM(thjs) as Expr1 FROM tuihuoguanli where (thrq>=@thisweekb and thrq<=@thisweeke) GROUP BY thrq ORDER BY thrq";
        SqlConnection conn4 = new SqlConnection((string)Application["connstr"]);
        conn4.Open();
        SqlDataAdapter adapter4 = new SqlDataAdapter(sql4, conn4);
        adapter4.SelectCommand.Parameters.Add("@thisweekb", SqlDbType.Int).Value = thisweekb;
        adapter4.SelectCommand.Parameters.Add("@thisweeke", SqlDbType.Int).Value = thisweeke;
        DataSet ds4 = new DataSet();
        adapter4.Fill(ds4, "tuihuoguanli");
        this.DataGrid4.DataSource = ds4.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid4.DataBind();
        this.LinkButton16.Font.Underline = false;
        this.LinkButton17.Font.Underline = true;
        this.LinkButton18.Font.Underline = false;
        this.LinkButton19.Font.Underline = false;
        this.LinkButton20.Font.Underline = false;

    }
    protected void LinkButton18_Click(object sender, EventArgs e)
    {
        string sql4;
        sql4 = "SELECT thrq, SUM(thjs) as Expr1 FROM tuihuoguanli where (thrq>=@thismonthb and thrq<=@thismonthe) GROUP BY thrq ORDER BY thrq";
        SqlConnection conn4 = new SqlConnection((string)Application["connstr"]);
        conn4.Open();
        SqlDataAdapter adapter4 = new SqlDataAdapter(sql4, conn4);
        adapter4.SelectCommand.Parameters.Add("@thismonthb", SqlDbType.Int).Value = thismonthb;
        adapter4.SelectCommand.Parameters.Add("@thismonthe", SqlDbType.Int).Value = thismonthe;
        DataSet ds4 = new DataSet();
        adapter4.Fill(ds4, "tuihuoguanli");
        this.DataGrid4.DataSource = ds4.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid4.DataBind();
        this.LinkButton16.Font.Underline = false;
        this.LinkButton17.Font.Underline = false;
        this.LinkButton18.Font.Underline = true;
        this.LinkButton19.Font.Underline = false;
        this.LinkButton20.Font.Underline = false;


    }
    protected void LinkButton19_Click(object sender, EventArgs e)
    {
        string sql4;
        sql4 = "SELECT thrq, SUM(thjs) as Expr1 FROM tuihuoguanli where (thrq>=@thisyearb and thrq<=@thisyeare) GROUP BY thrq ORDER BY thrq";
        SqlConnection conn4 = new SqlConnection((string)Application["connstr"]);
        conn4.Open();
        SqlDataAdapter adapter4 = new SqlDataAdapter(sql4, conn4);
        adapter4.SelectCommand.Parameters.Add("@thisyearb", SqlDbType.Int).Value = thisyearb;
        adapter4.SelectCommand.Parameters.Add("@thisyeare", SqlDbType.Int).Value = thisyeare;
        DataSet ds4 = new DataSet();
        adapter4.Fill(ds4, "tuihuoguanli");
        this.DataGrid4.DataSource = ds4.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid4.DataBind();
        this.LinkButton16.Font.Underline = false;
        this.LinkButton17.Font.Underline = false;
        this.LinkButton18.Font.Underline = false;
        this.LinkButton19.Font.Underline = true;
        this.LinkButton20.Font.Underline = false;

    }
    protected void LinkButton20_Click(object sender, EventArgs e)
    {
        string sql4;
        sql4 = "SELECT thrq, SUM(thjs) as Expr1 FROM tuihuoguanli GROUP BY thrq ORDER BY thrq";
        SqlConnection conn4 = new SqlConnection((string)Application["connstr"]);
        conn4.Open();
        SqlDataAdapter adapter4 = new SqlDataAdapter(sql4, conn4);
        DataSet ds4 = new DataSet();
        adapter4.Fill(ds4, "tuihuoguanli");
        this.DataGrid4.DataSource = ds4.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid4.DataBind();
        this.LinkButton16.Font.Underline = false;
        this.LinkButton17.Font.Underline = false;
        this.LinkButton18.Font.Underline = false;
        this.LinkButton19.Font.Underline = false;
        this.LinkButton20.Font.Underline = true;

    }
    protected void LinkButton21_Click(object sender, EventArgs e)
    {
        string sql5;
        sql5 = "SELECT qdsj, SUM(qdjs) as Expr1 FROM tuihuoguanli where qdsj=@thisday GROUP BY qdsj ORDER BY qdsj";
        SqlConnection conn5 = new SqlConnection((string)Application["connstr"]);
        conn5.Open();
        SqlDataAdapter adapter5 = new SqlDataAdapter(sql5, conn5);
        adapter5.SelectCommand.Parameters.Add("@thisday", SqlDbType.Int).Value = thisday;
        DataSet ds5 = new DataSet();
        adapter5.Fill(ds5, "tuihuoguanli");
        this.DataGrid5.DataSource = ds5.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid5.DataBind();
        this.LinkButton21.Font.Underline = true;
        this.LinkButton22.Font.Underline = false;
        this.LinkButton23.Font.Underline = false;
        this.LinkButton24.Font.Underline = false;
        this.LinkButton25.Font.Underline = false;

    }
    protected void LinkButton22_Click(object sender, EventArgs e)
    {
        string sql5;
        sql5 = "SELECT qdsj, SUM(qdjs) as Expr1 FROM tuihuoguanli where (qdsj>=@thisweekb and qdsj<=@thisweeke) GROUP BY qdsj ORDER BY qdsj";
        SqlConnection conn5 = new SqlConnection((string)Application["connstr"]);
        conn5.Open();
        SqlDataAdapter adapter5 = new SqlDataAdapter(sql5, conn5);
        adapter5.SelectCommand.Parameters.Add("@thisweekb", SqlDbType.Int).Value = thisweekb;
        adapter5.SelectCommand.Parameters.Add("@thisweeke", SqlDbType.Int).Value = thisweeke;
        DataSet ds5 = new DataSet();
        adapter5.Fill(ds5, "tuihuoguanli");
        this.DataGrid5.DataSource = ds5.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid5.DataBind();
        this.LinkButton21.Font.Underline = false;
        this.LinkButton22.Font.Underline = true;
        this.LinkButton23.Font.Underline = false;
        this.LinkButton24.Font.Underline = false;
        this.LinkButton25.Font.Underline = false;
    }
    protected void LinkButton23_Click(object sender, EventArgs e)
    {
        string sql5;
        sql5 = "SELECT qdsj, SUM(qdjs) as Expr1 FROM tuihuoguanli where (qdsj>=@thismonthb and qdsj<=@thismonthe) GROUP BY qdsj ORDER BY qdsj";
        SqlConnection conn5 = new SqlConnection((string)Application["connstr"]);
        conn5.Open();
        SqlDataAdapter adapter5 = new SqlDataAdapter(sql5, conn5);
        adapter5.SelectCommand.Parameters.Add("@thismonthb", SqlDbType.Int).Value = thismonthb;
        adapter5.SelectCommand.Parameters.Add("@thismonthe", SqlDbType.Int).Value = thismonthe;
        DataSet ds5 = new DataSet();
        adapter5.Fill(ds5, "tuihuoguanli");
        this.DataGrid5.DataSource = ds5.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid5.DataBind();
        this.LinkButton21.Font.Underline = false;
        this.LinkButton22.Font.Underline = false;
        this.LinkButton23.Font.Underline = true;
        this.LinkButton24.Font.Underline = false;
        this.LinkButton25.Font.Underline = false;
    }
    protected void LinkButton24_Click(object sender, EventArgs e)
    {
        string sql5;
        sql5 = "SELECT qdsj, SUM(qdjs) as Expr1 FROM tuihuoguanli where (qdsj>=@thisyearb and qdsj<=@thisyeare) GROUP BY qdsj ORDER BY qdsj";
        SqlConnection conn5 = new SqlConnection((string)Application["connstr"]);
        conn5.Open();
        SqlDataAdapter adapter5 = new SqlDataAdapter(sql5, conn5);
        adapter5.SelectCommand.Parameters.Add("@thisyearb", SqlDbType.Int).Value = thisyearb;
        adapter5.SelectCommand.Parameters.Add("@thisyeare", SqlDbType.Int).Value = thisyeare;
        DataSet ds5 = new DataSet();
        adapter5.Fill(ds5, "tuihuoguanli");
        this.DataGrid5.DataSource = ds5.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid5.DataBind();
        this.LinkButton21.Font.Underline = false;
        this.LinkButton22.Font.Underline = false;
        this.LinkButton23.Font.Underline = false;
        this.LinkButton24.Font.Underline = true;
        this.LinkButton25.Font.Underline = false;
    }
    protected void LinkButton25_Click(object sender, EventArgs e)
    {
        string sql5;
        sql5 = "SELECT qdsj, SUM(qdjs) as Expr1 FROM tuihuoguanli GROUP BY qdsj ORDER BY qdsj";
        SqlConnection conn5 = new SqlConnection((string)Application["connstr"]);
        conn5.Open();
        SqlDataAdapter adapter5 = new SqlDataAdapter(sql5, conn5);
        DataSet ds5 = new DataSet();
        adapter5.Fill(ds5, "tuihuoguanli");
        this.DataGrid5.DataSource = ds5.Tables["tuihuoguanli"].DefaultView;
        this.DataGrid5.DataBind();
        this.LinkButton21.Font.Underline = false;
        this.LinkButton22.Font.Underline = false;
        this.LinkButton23.Font.Underline = false;
        this.LinkButton24.Font.Underline = false;
        this.LinkButton25.Font.Underline = true;

    }
}