csharp.cs

根据listbox

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using qcbb;
public partial class _111_1 : System.Web.UI.Page
{
    string SJNO2 = "";
    string SJNO1 = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            bind1();
            if (Request.Params["SJNO1"] != null)
            {
                SJNO1 = Request.Params["SJNO1"].ToString();
                DateOperate1(SJNO1);
            }
            if (Request.Params["SJNO2"] != null)
            {
                SJNO2 = Request.Params["SJNO2"].ToString();
                DateOperate2(SJNO2);
            }
        }
    }
    public void bind1()
    {
        SqlConnection Conn = qcbbclass.createConnection();
        Conn.Open();
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from well_paraitem where para_sort_name='水井号'", Conn);
        DataSet ds = new DataSet();
        sda.Fill(ds, "well_paraitem");
        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            ListBox1.Items.Add(new ListItem(ds.Tables[0].Rows[i]["para_item_name"].ToString(), ds.Tables[0].Rows[i]["paraitem_id"].ToString()));
        }
        Conn.Close();
        ds.Dispose();

    }
    public void DateOperate1(string SJNO1)
    {
        SqlConnection myConnectiona = qcbbclass.createConnection();
        string mySelectQuerya = "SELECT * FROM tab3_cont WHERE tab_date='" + System.DateTime.Today.Date.ToShortDateString() + "' AND well_id=" + SJNO1;


        SqlCommand myCommanda = new SqlCommand(mySelectQuerya, myConnectiona);
        myConnectiona.Open();
        SqlDataReader myReadera;
        myReadera = myCommanda.ExecuteReader();

        if (myReadera.HasRows)
        {
            while (myReadera.Read())
            {

                //注水时间
                if (!myReadera.IsDBNull(2))
                {
                    Label2.Text = myReadera.GetDouble(2).ToString();
                }
                else { Label2.Text = "无记录"; }
                //检查时间
                if (!myReadera.IsDBNull(3))
                {
                    Label3.Text = myReadera.GetDouble(3).ToString();
                }
                else { Label3.Text = "无记录"; }

                //注水时间
                if (!myReadera.IsDBNull(4))
                {
                    Label4.Text = myReadera.GetDouble(4).ToString();
                }
                else { Label4.Text = "无记录"; }

                //注水时间
                if (!myReadera.IsDBNull(5))
                {
                    Label5.Text = myReadera.GetDouble(5).ToString();
                }
                else { Label5.Text = "无记录"; }

                //油压开
                if (!myReadera.IsDBNull(6))
                {
                    Label6.Text = myReadera.GetDouble(6).ToString();
                }
                else { Label6.Text = "无记录"; }

                //油压关
                if (!myReadera.IsDBNull(7))
                {
                    Label7.Text = myReadera.GetDouble(7).ToString();
                }
                else { Label7.Text = "无记录"; }
                //套压开
                if (!myReadera.IsDBNull(8))
                {
                    Label8.Text = myReadera.GetDouble(8).ToString();
                }
                else { Label8.Text = "无记录"; }

                if (!myReadera.IsDBNull(9))
                {
                    Label9.Text = myReadera.GetDouble(9).ToString();
                }//套压关
                else { Label9.Text = "无记录"; }
                //水表读数始
                if (!myReadera.IsDBNull(10))
                {
                    Label10.Text = myReadera.GetDouble(10).ToString();
                }
                else { Label10.Text = "无记录"; }
                //水表读数终
                if (!myReadera.IsDBNull(11))
                {
                    Label11.Text = myReadera.GetDouble(11).ToString();
                }
                else { Label11.Text = "无记录"; }
                //瞬时水量
                if (!myReadera.IsDBNull(12))
                {
                    Label12.Text = myReadera.GetDouble(12).ToString();
                }
                else { Label12.Text = "无记录"; }
                //配注量
                if (!myReadera.IsDBNull(13))
                {
                    Label13.Text = myReadera.GetDouble(13).ToString();
                }
                else { Label13.Text = "无记录"; }

                //注水量

                if (!myReadera.IsDBNull(14))
                {
                    Label14.Text = myReadera.GetDouble(14).ToString();
                }
                else { Label14.Text = "无记录"; }
                //小层吸水量1
                if (!myReadera.IsDBNull(15))
                {
                    Label15.Text = myReadera.GetDouble(15).ToString();
                }
                else { Label15.Text = "无记录"; }
                //小层吸水量2
                if (!myReadera.IsDBNull(16))
                {
                    Label16.Text = myReadera.GetDouble(16).ToString();
                }
                else { Label16.Text = "无记录"; }
                //小层吸水量3
                if (!myReadera.IsDBNull(17))
                {
                    Label17.Text = myReadera.GetDouble(17).ToString();
                }
                else { Label17.Text = "无记录"; }
                //小层吸水量4
                if (!myReadera.IsDBNull(18))
                {
                    Label18.Text = myReadera.GetDouble(18).ToString();
                }
                else { Label18.Text = "无记录"; }
                //小层吸水量5
                if (!myReadera.IsDBNull(19))
                {
                    Label19.Text = myReadera.GetDouble(19).ToString();
                }
                else { Label19.Text = "无记录"; }
                //小层吸水量6
                if (!myReadera.IsDBNull(20))
                {
                    Label20.Text = myReadera.GetDouble(20).ToString();
                }
                else { Label20.Text = "无记录"; }
                //溢流量
                if (!myReadera.IsDBNull(21))
                {
                    Label21.Text = myReadera.GetDouble(21).ToString();
                }
                else { Label21.Text = "无记录"; }
                //备注
                if (!myReadera.IsDBNull(22))
                {
                    Label22.Text = myReadera.GetString(22);
                }
                else { Label22.Text = "无记录"; }
            }

        }
        else
        {
            Label2.Text = "无记录";
            Label3.Text = "无记录";
            Label4.Text = "无记录";
            Label5.Text = "无记录";
            Label6.Text = "无记录";

            Label7.Text = "无记录";
            Label8.Text = "无记录";
            Label9.Text = "无记录";
            Label10.Text = "无记录";
            Label11.Text = "无记录";

            Label12.Text = "无记录";
            Label13.Text = "无记录";
            Label14.Text = "无记录";
            Label15.Text = "无记录";
            Label16.Text = "无记录";

            Label17.Text = "无记录";
            Label18.Text = "无记录";
            Label19.Text = "无记录";
            Label20.Text = "无记录";
            Label21.Text = "无记录";
            Label22.Text = "无记录";

        }
        // always call Close when done reading.
        myReadera.Close();
        // Close the connection when done with it.
        myConnectiona.Close();
    }
    public void DateOperate2(string SJNO2)
    {
        SqlConnection myConnectiona = qcbbclass.createConnection();
        int i = 0;
        int nyear = System.DateTime.Today.Date.Year;
        int nmonth = System.DateTime.Today.Date.Month;