khfw_search.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_search : System.Web.UI.Page
{
    public static string i = "start";
    protected void Page_Load(object sender, EventArgs e)
    {
       // this.SmartNavigation = true;
        
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string cythid = this.TextBox1.Text.ToString();
        string zddh = this.TextBox2.Text.ToString();
        string sf = this.TextBox3.Text.ToString();
        string unit = this.TextBox4.Text.ToString();
        string zzcljg = this.TextBox5.Text.ToString();
        string zdrq1 = this.TextBox12.Text.ToString();
        string zdrq2 = this.TextBox13.Text.ToString();
        string jzjsyclrq1 = this.TextBox10.Text.ToString();
        string jzjsyclrq2 = this.TextBox11.Text.ToString();
        string fhrq1 = this.TextBox14.Text.ToString();
        string fhrq2 = this.TextBox15.Text.ToString();
        string ecclrq1 = this.TextBox16.Text.ToString();
        string ecclrq2 = this.TextBox17.Text.ToString();
        string efhrq1 = this.TextBox18.Text.ToString();
        string efhrq2 = this.TextBox19.Text.ToString();
        string ffrzrq1 = this.TextBox20.Text.ToString();
        string ffrzrq2 = this.TextBox21.Text.ToString();
        string thjs1 = this.TextBox6.Text.ToString();
        string thjs2 = this.TextBox7.Text.ToString();
        string qdjs1 = this.TextBox8.Text.ToString();
        string qdjs2 = this.TextBox9.Text.ToString();
        string sql1 = "select   *  from   [thglkhfw]   where     1=1";
        string sql = "";
        if (cythid.Trim() != string.Empty)
        {
            sql = sql + "and cythid like '%" + @cythid + "%'";
        }
        if (zddh.Trim() != string.Empty)
        {
            sql = sql + "and zddh like '%" + @zddh + "%'";
        }
        if (sf.Trim() != string.Empty)
        {
            sql = sql + "and sf like '%" + @sf + "%'";
        }
        if (unit.Trim() != string.Empty)
        {
            sql = sql + "and unit like '%" + @unit + "%'";
        }
        if (zzcljg.Trim() != string.Empty)
        {
            sql = sql + "and zzcljg like '%" + @zzcljg + "%'";
        }
        if (zdrq1.Trim() != string.Empty)
        {
            sql = sql + "and zdrq>=@zdrq1 ";
        }
        if (zdrq2.Trim() != string.Empty)
        {
            sql = sql + "and zdrq<=@zdrq2 ";
        }
        if (jzjsyclrq1.Trim() != string.Empty)
        {
            sql = sql + "and jzjsyclrq>=@jzjsyclrq1 ";
        }
        if (jzjsyclrq2.Trim() != string.Empty)
        {
            sql = sql + "and jzjsyclrq<=@jzjsyclrq2 ";
        }
        if (fhrq1.Trim() != string.Empty)
        {
            sql = sql + "and fhrq>=@fhrq1 ";
        }
        if (fhrq2.Trim() != string.Empty)
        {
            sql = sql + "and fhrq<=@fhrq2 ";
        }
        if (ecclrq1.Trim() != string.Empty)
        {
            sql = sql + "and ecclrq>=@ecclrq1 ";
        }
        if (ecclrq2.Trim() != string.Empty)
        {
            sql = sql + "and ecclrq<=@ecclrq2 ";
        }
        if (efhrq1.Trim() != string.Empty)
        {
            sql = sql + "and efhrq>=@efhrq1 ";
        }
        if (efhrq2.Trim() != string.Empty)
        {
            sql = sql + "and efhrq<=@efhrq2 ";
        }
        if (ffrzrq1.Trim() != string.Empty)
        {
            sql = sql + "and ffrzrq>=@ffrzrq1 ";
        }
        if (ffrzrq2.Trim() != string.Empty)
        {
            sql = sql + "and ffrzrq<=@ffrzrq2 ";
        }
        if (thjs1.Trim() != string.Empty)
        {
            sql = sql + "and thjs>=@thjs1 ";
        }
        if (thjs2.Trim() != string.Empty)
        {
            sql = sql + "and thjs<=@thjs2 ";
        }
        if (qdjs1.Trim() != string.Empty)
        {
            sql = sql + "and qdjs>=@qdjs1 ";
        }
        if (qdjs2.Trim() != string.Empty)
        {
            sql = sql + "and qdjs<=@qdjs2 ";
        }
        //sql=sql+") GROUP BY zdrq ORDER BY zdrq";
        sql1 = sql1 + sql;
        SqlConnection conn1 = new SqlConnection((string)Application["connstr"]);
        conn1.Open();

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

        conn1.Close();
        string sql2;
        sql2 = "SELECT sf, SUM(thjs) as Expr1, SUM(qdjs) as Expr2 FROM thglkhfw where 1=1";
        sql2 = sql2 + sql + "GROUP BY sf ORDER BY sf";
        SqlConnection conn2 = new SqlConnection((string)Application["connstr"]);
        conn2.Open();
        SqlDataAdapter adapter2 = new SqlDataAdapter(sql2, conn2);
        adapter2.SelectCommand.Parameters.Add("@cythid", SqlDbType.VarChar).Value = cythid;