khfw_search.aspx.cs

退书管理系统

        adapter2.SelectCommand.Parameters.Add("@zddh", SqlDbType.VarChar).Value = zddh;
        adapter2.SelectCommand.Parameters.Add("@sf", SqlDbType.VarChar).Value = sf;
        adapter2.SelectCommand.Parameters.Add("@unit", SqlDbType.VarChar).Value = unit;
        adapter2.SelectCommand.Parameters.Add("@zzcljg", SqlDbType.VarChar).Value = zzcljg;
        adapter2.SelectCommand.Parameters.Add("@zdrq1", SqlDbType.VarChar).Value = zdrq1.Trim();
        adapter2.SelectCommand.Parameters.Add("@zdrq2", SqlDbType.VarChar).Value = zdrq2.Trim();
        adapter2.SelectCommand.Parameters.Add("@jzjsyclrq1", SqlDbType.VarChar).Value = jzjsyclrq1;
        adapter2.SelectCommand.Parameters.Add("@jzjsyclrq2", SqlDbType.VarChar).Value = jzjsyclrq2;
        adapter2.SelectCommand.Parameters.Add("@fhrq1", SqlDbType.VarChar).Value = fhrq1;
        adapter2.SelectCommand.Parameters.Add("@fhrq2", SqlDbType.VarChar).Value = fhrq2;
        adapter2.SelectCommand.Parameters.Add("@ecclrq1", SqlDbType.VarChar).Value = ecclrq1;
        adapter2.SelectCommand.Parameters.Add("@ecclrq2", SqlDbType.VarChar).Value = ecclrq2;
        adapter2.SelectCommand.Parameters.Add("@efhrq1", SqlDbType.VarChar).Value = efhrq1;
        adapter2.SelectCommand.Parameters.Add("@efhrq2", SqlDbType.VarChar).Value = efhrq2;
        adapter2.SelectCommand.Parameters.Add("@ffrzrq1", SqlDbType.VarChar).Value = ffrzrq1;
        adapter2.SelectCommand.Parameters.Add("@ffrzrq2", SqlDbType.VarChar).Value = ffrzrq2;
        adapter2.SelectCommand.Parameters.Add("@thjs1", SqlDbType.VarChar).Value = thjs1;
        adapter2.SelectCommand.Parameters.Add("@thjs2", SqlDbType.VarChar).Value = thjs2;
        adapter2.SelectCommand.Parameters.Add("@qdjs1", SqlDbType.VarChar).Value = qdjs1;
        adapter2.SelectCommand.Parameters.Add("@qdjs2", SqlDbType.VarChar).Value = qdjs2;
        DataSet ds2 = new DataSet();
        adapter2.Fill(ds2, "thglkhfw");
        this.DataGrid2.DataSource = ds2.Tables["thglkhfw"].DefaultView;
        this.DataGrid2.DataBind();

        string sql3;
        sql3 = "SELECT thr, SUM(thjs) as Expr1 FROM thglkhfw where 1=1";
        sql3 = sql3 + sql + "GROUP BY thr ORDER BY thr";
        SqlConnection conn3 = new SqlConnection((string)Application["connstr"]);
        conn3.Open();
        SqlDataAdapter adapter3 = new SqlDataAdapter(sql3, conn3);
        adapter3.SelectCommand.Parameters.Add("@cythid", SqlDbType.VarChar).Value = cythid;
        adapter3.SelectCommand.Parameters.Add("@zddh", SqlDbType.VarChar).Value = zddh;
        adapter3.SelectCommand.Parameters.Add("@sf", SqlDbType.VarChar).Value = sf;
        adapter3.SelectCommand.Parameters.Add("@unit", SqlDbType.VarChar).Value = unit;
        adapter3.SelectCommand.Parameters.Add("@zzcljg", SqlDbType.VarChar).Value = zzcljg;
        adapter3.SelectCommand.Parameters.Add("@zdrq1", SqlDbType.VarChar).Value = zdrq1.Trim();
        adapter3.SelectCommand.Parameters.Add("@zdrq2", SqlDbType.VarChar).Value = zdrq2.Trim();
        adapter3.SelectCommand.Parameters.Add("@jzjsyclrq1", SqlDbType.VarChar).Value = jzjsyclrq1;
        adapter3.SelectCommand.Parameters.Add("@jzjsyclrq2", SqlDbType.VarChar).Value = jzjsyclrq2;
        adapter3.SelectCommand.Parameters.Add("@fhrq1", SqlDbType.VarChar).Value = fhrq1;
        adapter3.SelectCommand.Parameters.Add("@fhrq2", SqlDbType.VarChar).Value = fhrq2;
        adapter3.SelectCommand.Parameters.Add("@ecclrq1", SqlDbType.VarChar).Value = ecclrq1;
        adapter3.SelectCommand.Parameters.Add("@ecclrq2", SqlDbType.VarChar).Value = ecclrq2;
        adapter3.SelectCommand.Parameters.Add("@efhrq1", SqlDbType.VarChar).Value = efhrq1;
        adapter3.SelectCommand.Parameters.Add("@efhrq2", SqlDbType.VarChar).Value = efhrq2;
        adapter3.SelectCommand.Parameters.Add("@ffrzrq1", SqlDbType.VarChar).Value = ffrzrq1;
        adapter3.SelectCommand.Parameters.Add("@ffrzrq2", SqlDbType.VarChar).Value = ffrzrq2;
        adapter3.SelectCommand.Parameters.Add("@thjs1", SqlDbType.VarChar).Value = thjs1;
        adapter3.SelectCommand.Parameters.Add("@thjs2", SqlDbType.VarChar).Value = thjs2;
        adapter3.SelectCommand.Parameters.Add("@qdjs1", SqlDbType.VarChar).Value = qdjs1;
        adapter3.SelectCommand.Parameters.Add("@qdjs2", SqlDbType.VarChar).Value = qdjs2;
        DataSet ds3 = new DataSet();
        adapter3.Fill(ds3, "thglkhfw");
        this.DataGrid3.DataSource = ds3.Tables["thglkhfw"].DefaultView;
        this.DataGrid3.DataBind();


        string sql4;
        sql4 = "SELECT qdr, SUM(qdjs) as Expr1 FROM thglkhfw where 1=1";
        sql4 = sql4 + sql + "GROUP BY qdr ORDER BY qdr";
        SqlConnection conn4 = new SqlConnection((string)Application["connstr"]);
        conn4.Open();
        SqlDataAdapter adapter4 = new SqlDataAdapter(sql4, conn4);
        adapter4.SelectCommand.Parameters.Add("@cythid", SqlDbType.VarChar).Value = cythid;
        adapter4.SelectCommand.Parameters.Add("@zddh", SqlDbType.VarChar).Value = zddh;
        adapter4.SelectCommand.Parameters.Add("@sf", SqlDbType.VarChar).Value = sf;
        adapter4.SelectCommand.Parameters.Add("@unit", SqlDbType.VarChar).Value = unit;
        adapter4.SelectCommand.Parameters.Add("@zzcljg", SqlDbType.VarChar).Value = zzcljg;
        adapter4.SelectCommand.Parameters.Add("@zdrq1", SqlDbType.VarChar).Value = zdrq1.Trim();
        adapter4.SelectCommand.Parameters.Add("@zdrq2", SqlDbType.VarChar).Value = zdrq2.Trim();
        adapter4.SelectCommand.Parameters.Add("@jzjsyclrq1", SqlDbType.VarChar).Value = jzjsyclrq1;
        adapter4.SelectCommand.Parameters.Add("@jzjsyclrq2", SqlDbType.VarChar).Value = jzjsyclrq2;
        adapter4.SelectCommand.Parameters.Add("@fhrq1", SqlDbType.VarChar).Value = fhrq1;
        adapter4.SelectCommand.Parameters.Add("@fhrq2", SqlDbType.VarChar).Value = fhrq2;
        adapter4.SelectCommand.Parameters.Add("@ecclrq1", SqlDbType.VarChar).Value = ecclrq1;
        adapter4.SelectCommand.Parameters.Add("@ecclrq2", SqlDbType.VarChar).Value = ecclrq2;
        adapter4.SelectCommand.Parameters.Add("@efhrq1", SqlDbType.VarChar).Value = efhrq1;
        adapter4.SelectCommand.Parameters.Add("@efhrq2", SqlDbType.VarChar).Value = efhrq2;
        adapter4.SelectCommand.Parameters.Add("@ffrzrq1", SqlDbType.VarChar).Value = ffrzrq1;
        adapter4.SelectCommand.Parameters.Add("@ffrzrq2", SqlDbType.VarChar).Value = ffrzrq2;
        adapter4.SelectCommand.Parameters.Add("@thjs1", SqlDbType.VarChar).Value = thjs1;
        adapter4.SelectCommand.Parameters.Add("@thjs2", SqlDbType.VarChar).Value = thjs2;
        adapter4.SelectCommand.Parameters.Add("@qdjs1", SqlDbType.VarChar).Value = qdjs1;
        adapter4.SelectCommand.Parameters.Add("@qdjs2", SqlDbType.VarChar).Value = qdjs2;
        DataSet ds4 = new DataSet();
        adapter4.Fill(ds4, "thglkhfw");
        this.DataGrid4.DataSource = ds4.Tables["thglkhfw"].DefaultView;
        this.DataGrid4.DataBind();

        string sql5;
        sql5 = "SELECT thrq, SUM(thjs) as Expr1 FROM thglkhfw where 1=1";
        sql5 = sql5 + sql + "GROUP BY thrq ORDER BY thrq";
        SqlConnection conn5 = new SqlConnection((string)Application["connstr"]);
        conn5.Open();
        SqlDataAdapter adapter5 = new SqlDataAdapter(sql5, conn5);
        adapter5.SelectCommand.Parameters.Add("@cythid", SqlDbType.VarChar).Value = cythid;
        adapter5.SelectCommand.Parameters.Add("@zddh", SqlDbType.VarChar).Value = zddh;
        adapter5.SelectCommand.Parameters.Add("@sf", SqlDbType.VarChar).Value = sf;
        adapter5.SelectCommand.Parameters.Add("@unit", SqlDbType.VarChar).Value = unit;
        adapter5.SelectCommand.Parameters.Add("@zzcljg", SqlDbType.VarChar).Value = zzcljg;
        adapter5.SelectCommand.Parameters.Add("@zdrq1", SqlDbType.VarChar).Value = zdrq1.Trim();
        adapter5.SelectCommand.Parameters.Add("@zdrq2", SqlDbType.VarChar).Value = zdrq2.Trim();
        adapter5.SelectCommand.Parameters.Add("@jzjsyclrq1", SqlDbType.VarChar).Value = jzjsyclrq1;
        adapter5.SelectCommand.Parameters.Add("@jzjsyclrq2", SqlDbType.VarChar).Value = jzjsyclrq2;
        adapter5.SelectCommand.Parameters.Add("@fhrq1", SqlDbType.VarChar).Value = fhrq1;
        adapter5.SelectCommand.Parameters.Add("@fhrq2", SqlDbType.VarChar).Value = fhrq2;
        adapter5.SelectCommand.Parameters.Add("@ecclrq1", SqlDbType.VarChar).Value = ecclrq1;
        adapter5.SelectCommand.Parameters.Add("@ecclrq2", SqlDbType.VarChar).Value = ecclrq2;
        adapter5.SelectCommand.Parameters.Add("@efhrq1", SqlDbType.VarChar).Value = efhrq1;
        adapter5.SelectCommand.Parameters.Add("@efhrq2", SqlDbType.VarChar).Value = efhrq2;
        adapter5.SelectCommand.Parameters.Add("@ffrzrq1", SqlDbType.VarChar).Value = ffrzrq1;
        adapter5.SelectCommand.Parameters.Add("@ffrzrq2", SqlDbType.VarChar).Value = ffrzrq2;
        adapter5.SelectCommand.Parameters.Add("@thjs1", SqlDbType.VarChar).Value = thjs1;
        adapter5.SelectCommand.Parameters.Add("@thjs2", SqlDbType.VarChar).Value = thjs2;
        adapter5.SelectCommand.Parameters.Add("@qdjs1", SqlDbType.VarChar).Value = qdjs1;
        adapter5.SelectCommand.Parameters.Add("@qdjs2", SqlDbType.VarChar).Value = qdjs2;
        DataSet ds5 = new DataSet();
        adapter5.Fill(ds5, "thglkhfw");
        this.DataGrid5.DataSource = ds5.Tables["thglkhfw"].DefaultView;
        this.DataGrid5.DataBind();

        string sql6;
        sql6 = "SELECT qdsj, SUM(qdjs) as Expr1 FROM thglkhfw where 1=1";
        sql6 = sql6 + sql + "GROUP BY qdsj ORDER BY qdsj";
        SqlConnection conn6 = new SqlConnection((string)Application["connstr"]);
        conn6.Open();
        SqlDataAdapter adapter6 = new SqlDataAdapter(sql6, conn6);
        adapter6.SelectCommand.Parameters.Add("@cythid", SqlDbType.VarChar).Value = cythid;
        adapter6.SelectCommand.Parameters.Add("@zddh", SqlDbType.VarChar).Value = zddh;
        adapter6.SelectCommand.Parameters.Add("@sf", SqlDbType.VarChar).Value = sf;
        adapter6.SelectCommand.Parameters.Add("@unit", SqlDbType.VarChar).Value = unit;
        adapter6.SelectCommand.Parameters.Add("@zzcljg", SqlDbType.VarChar).Value = zzcljg;
        adapter6.SelectCommand.Parameters.Add("@zdrq1", SqlDbType.VarChar).Value = zdrq1.Trim();
        adapter6.SelectCommand.Parameters.Add("@zdrq2", SqlDbType.VarChar).Value = zdrq2.Trim();
        adapter6.SelectCommand.Parameters.Add("@jzjsyclrq1", SqlDbType.VarChar).Value = jzjsyclrq1;
        adapter6.SelectCommand.Parameters.Add("@jzjsyclrq2", SqlDbType.VarChar).Value = jzjsyclrq2;
        adapter6.SelectCommand.Parameters.Add("@fhrq1", SqlDbType.VarChar).Value = fhrq1;
        adapter6.SelectCommand.Parameters.Add("@fhrq2", SqlDbType.VarChar).Value = fhrq2;
        adapter6.SelectCommand.Parameters.Add("@ecclrq1", SqlDbType.VarChar).Value = ecclrq1;
        adapter6.SelectCommand.Parameters.Add("@ecclrq2", SqlDbType.VarChar).Value = ecclrq2;
        adapter6.SelectCommand.Parameters.Add("@efhrq1", SqlDbType.VarChar).Value = efhrq1;
        adapter6.SelectCommand.Parameters.Add("@efhrq2", SqlDbType.VarChar).Value = efhrq2;
        adapter6.SelectCommand.Parameters.Add("@ffrzrq1", SqlDbType.VarChar).Value = ffrzrq1;
        adapter6.SelectCommand.Parameters.Add("@ffrzrq2", SqlDbType.VarChar).Value = ffrzrq2;
        adapter6.SelectCommand.Parameters.Add("@thjs1", SqlDbType.VarChar).Value = thjs1;
        adapter6.SelectCommand.Parameters.Add("@thjs2", SqlDbType.VarChar).Value = thjs2;
        adapter6.SelectCommand.Parameters.Add("@qdjs1", SqlDbType.VarChar).Value = qdjs1;
        adapter6.SelectCommand.Parameters.Add("@qdjs2", SqlDbType.VarChar).Value = qdjs2;
        DataSet ds6 = new DataSet();
        adapter6.Fill(ds6, "thglkhfw");
        this.DataGrid6.DataSource = ds6.Tables["thglkhfw"].DefaultView;
        this.DataGrid6.DataBind();
        this.Label1.Visible = true;
        this.Label2.Visible = true;
        this.Label3.Visible = true;
        this.Label4.Visible = true;
        this.Label5.Visible = true;
        this.Label6.Visible = true;





        Response.Write("<" + "script" + ">" + "window.parent.topFrame.locaton.reload();'" + "</" + "script" + ">");   
    }

}