khfw_sum.aspx.cs

退书管理系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class kehufuwu_khfw_sum : System.Web.UI.Page
{
    public string thisday;
    public string thisweekb;
    public string thisweeke;
    public string thismonthb;
    public string thismonthe;
    public string thisyearb;
    public string thisyeare;
    protected void MessageBox(string Message)
    {
        Response.Write("<script language='javascript'>alert('" + Message + "')</script>");
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        this.SmartNavigation = true;
        string day;
        string month;
        string weekday;
        string weekmonth;
        string monthmonth;
        thisyearb = DateTime.Now.Year + "0101";
        thisyeare = DateTime.Now.Year + "1231";
        if (DateTime.Now.Month < 10)
        {
            monthmonth = "0" + DateTime.Now.Month.ToString();
        }
        else 
        {
            monthmonth = DateTime.Now.Month.ToString();
        }
        thismonthb = DateTime.Now.Year + monthmonth + "01";
        thismonthe = DateTime.Now.Year + monthmonth + "31";
        DateTime dtb = new DateTime();
        DateTime dte = new DateTime();
        DateTime dt = DateTime.Now;
        switch (DateTime.Now.DayOfWeek.ToString()) 
        {
            case "Monday":
                dtb = dt.AddDays(+0);
                dte = dt.AddDays(+6);
                    break;
            case "Tuesday":
                dtb = dt.AddDays(-1);
                dte = dt.AddDays(+5);
                break;
            case "Wednesday":
                dtb = dt.AddDays(-2);
                dte = dt.AddDays(+4);
                break;
            case "Thursday":
                dtb = dt.AddDays(-3);
                dte = dt.AddDays(+3);
                break;
            case "Friday":
                dtb = dt.AddDays(-4);
                dte = dt.AddDays(+2);
                break;
            case "Saturday":
                dtb = dt.AddDays(-5);
                dte = dt.AddDays(+1);
                break;
            case"Sunday":
                dtb = dt.AddDays(-6);
                dte = dt.AddDays(+0);
                break;
        }
        if (dtb.Day< 10)
        {
            weekday = "0" + dtb.Day.ToString();
        }
        else 
        {
            weekday = dtb.Day.ToString();
        }
        if (dtb.Month < 10)
        {
            weekmonth = "0" + dtb.Month.ToString();
        }
        else
        {
            weekmonth = dtb.Month.ToString();
        }
        thisweekb = dtb.Year.ToString() + weekmonth + weekday;
        if (dte.Day < 10)
        {
            weekday = "0" + dte.Day.ToString();
        }
        else
        {
            weekday = dte.Day.ToString();
        }
        if (dte.Month < 10)
        {
            weekmonth = "0" + dte.Month.ToString();
        }
        else
        {
            weekmonth = dte.Month.ToString();
        }
        thisweeke = dte.Year.ToString() + weekmonth + weekday;
        if (DateTime.Now.Day < 10)
        {
            day = "0" + DateTime.Now.Day.ToString();
        }
        else { day = DateTime.Now.Day.ToString(); }
        if (DateTime.Now.Month < 10)
        {
            month = "0" + DateTime.Now.Month.ToString();
        }
        else 
        {
            month = DateTime.Now.Month.ToString();
        }
        thisday = DateTime.Now.Year.ToString() + month + day;
        if (!IsPostBack)
        {
            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();
            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();
            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();
            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();
            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.LinkButton1.Font.Underline = false;
            this.LinkButton2.Font.Underline = false;
            this.LinkButton3.Font.Underline = false;
            this.LinkButton4.Font.Underline = false;
            this.LinkButton5.Font.Underline = true;
            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;
            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;
            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;
            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;
        }    
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        string sql1;
        sql1 = "SELECT khdq, SUM(thjs) as Expr1, SUM(qdjs) as Expr2 FROM tuihuoguanli where thrq=@thisday 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("@thisday", SqlDbType.Int).Value = thisday;
        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 = true;
        this.LinkButton2.Font.Underline = false;
        this.LinkButton3.Font.Underline = false;
        this.LinkButton4.Font.Underline = false;
        this.LinkButton5.Font.Underline = false;
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        string sql1;
        sql1 = "SELECT khdq, SUM(thjs) as Expr1, SUM(qdjs) as Expr2 FROM tuihuoguanli where (thrq>=@thisweekb and thrq<=@thisweeke) 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("@thisweekb", SqlDbType.Int).Value = thisweekb;
        adapter1.SelectCommand.Parameters.Add("@thisweeke", SqlDbType.Int).Value = thisweeke;
        DataSet ds1 = new DataSet();