csharp.cs

根据listbox

        int nday = System.DateTime.Today.Date.Day;
        string mySelectQuerya = "SELECT * FROM well_time WHERE well_year='" + nyear + "' AND well_month='" + nmonth + "' AND well_date='" + nday + "' AND well_control='" + SJNO2 + "'";

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


        Label[] mylabel = new Label[600];
        mylabel[0] = Label23; mylabel[1] = Label24; mylabel[2] = Label25; mylabel[3] = Label26; mylabel[4] = Label27; mylabel[5] = Label28; mylabel[6] = Label29; mylabel[7] = Label30;
        mylabel[8] = Label31; mylabel[9] = Label32; mylabel[10] = Label33; mylabel[11] = Label34; mylabel[12] = Label35; mylabel[13] = Label36; mylabel[14] = Label37; mylabel[15] = Label38;
        mylabel[16] = Label39; mylabel[17] = Label40; mylabel[18] = Label41; mylabel[19] = Label42; mylabel[20] = Label43; mylabel[21] = Label44; mylabel[22] = Label45; mylabel[23] = Label46;
        mylabel[24] = Label47; mylabel[25] = Label48; mylabel[26] = Label49; mylabel[27] = Label50; mylabel[28] = Label51; mylabel[29] = Label52; mylabel[30] = Label53;


        if (myReadera.HasRows)
        {
            while (myReadera.Read())
            {
                if (!myReadera.IsDBNull(4))
                {
                    mylabel[i].Text = myReadera.GetString(4);
                }
                else { mylabel[i].Text = "无记录"; }
                i++;
                if (!myReadera.IsDBNull(5))
                {
                    mylabel[i].Text = myReadera.GetString(5);
                }
                else { mylabel[i].Text = "无记录"; }
                i++;
            }
        }
        else
        {
            Label23.Text = "无记录"; Label24.Text = "无记录"; Label25.Text = "无记录"; Label26.Text = "无记录"; Label27.Text = "无记录"; Label28.Text = "无记录"; Label29.Text = "无记录"; Label30.Text = "无记录"; Label31.Text = "无记录";
            Label32.Text = "无记录"; Label33.Text = "无记录"; Label34.Text = "无记录"; Label35.Text = "无记录"; Label36.Text = "无记录"; Label37.Text = "无记录"; Label38.Text = "无记录"; Label39.Text = "无记录"; Label40.Text = "无记录";
            Label41.Text = "无记录"; Label42.Text = "无记录"; Label43.Text = "无记录"; Label44.Text = "无记录"; Label45.Text = "无记录"; Label46.Text = "无记录";
        }
        for (int k = 0; k < 24; k++)
        {
            if (mylabel[k].Text == "")
            {
                mylabel[k].Text = "无记录";
            }
        }
        myReadera.Close();
        myConnectiona.Close();


        //
        //字符串拆分
        //
        /*string[] str = new string[10];
        int p = 0;
        string s="abcd";
        string[] sArray=s.Split('c');
        foreach (string w in sArray)
        {
            str[p] = w.ToString();
            p++;
        }*/
        //
        //2007-10-15
        //连接
        //
        SqlConnection myConnectionb = qcbbclass.createConnection();
        string mySelectQueryb = "SELECT * FROM well_pressure WHERE well_code='" + SJNO2 + "' and well_recode  like '" + System.DateTime.Today.Date.Year + System.DateTime.Today.Date.Month + System.DateTime.Today.Date.Day + "%'";

        SqlCommand myCommandb = new SqlCommand(mySelectQueryb, myConnectionb);
        myConnectionb.Open();
        SqlDataReader myReaderb;
        myReaderb = myCommandb.ExecuteReader();
        if (myReaderb.HasRows)
        {
            while (myReaderb.Read())
            {
                i = 24;
                if (!myReaderb.IsDBNull(3))
                {
                    mylabel[i].Text = myReaderb.GetString(3);
                }
                else { mylabel[i].Text = "无记录"; }
                i++;
                if (!myReaderb.IsDBNull(4))
                {
                    mylabel[i].Text = myReaderb.GetString(4);
                }
                else { mylabel[i].Text = "无记录"; }
                i++;
                if (!myReaderb.IsDBNull(5))
                {
                    mylabel[i].Text = myReaderb.GetString(5);
                }
                else { mylabel[i].Text = "无记录"; }
                i++;
                if (!myReaderb.IsDBNull(6))
                {
                    mylabel[i].Text = myReaderb.GetString(6);
                }
                else { mylabel[i].Text = "无记录"; }
                i++;
                if (!myReaderb.IsDBNull(7))
                {
                    mylabel[i].Text = myReaderb.GetString(7);
                }
                else { mylabel[i].Text = "无记录"; }
                i++;
                if (!myReaderb.IsDBNull(8))
                {
                    mylabel[i].Text = myReaderb.GetString(8);
                }
                else { mylabel[i].Text = "无记录"; }
                i++;
                if (!myReaderb.IsDBNull(9))
                {
                    mylabel[i].Text = myReaderb.GetString(9);
                }
                else { mylabel[i].Text = "无记录"; }
            }
        }
        else
        {
            Label47.Text = "无记录"; Label48.Text = "无记录"; Label49.Text = "无记录"; Label50.Text = "无记录"; Label51.Text = "无记录"; Label52.Text = "无记录"; Label53.Text = "无记录";
        }
        myReaderb.Close();
        myConnectionb.Close();


        //---------------------------------------------------------------------





        int wl_id = 9999;
        int wl_jdID = 9999;


        //string date_str = year.SelectedItem + "-" + month.SelectedItem + "-" + day.SelectedItem;

        SqlConnection myConnection = qcbbclass.createConnection();
        string mySelectQuery = "SELECT * FROM well_zrzset WHERE wl_jdname='" + SJNO2 + "'";
        SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
        myConnection.Open();
        SqlDataReader myReader;
        myReader = myCommand.ExecuteReader();
        // Always call Read before accessing data.
        if (myReader.HasRows)
        {
            myReader.Read();
            try
            {
                wl_id = myReader.GetInt32(0);
                wl_jdID = myReader.GetInt32(1);
            }
            catch { }
        }

        myReader.Close();

        mySelectQuery = "SELECT top 1 wl_youya,wl_taoya,wl_ssll1 FROM well_ZSJ WHERE  wl_ZSJID=" + wl_jdID.ToString() + "and year(wl_time)=" + System.DateTime.Today.Date.Year.ToString() + "and month(wl_time)=" + System.DateTime.Today.Date.Month.ToString() + "and day(wl_time)=" + System.DateTime.Today.Date.Day.ToString() + "order by wl_time desc";
        myCommand = new SqlCommand(mySelectQuery, myConnection);
        myReader = myCommand.ExecuteReader();

        if (myReader.HasRows)
        {
            myReader.Read();
            try
            {

                Label6.Text = myReader.GetDecimal(0).ToString();
            }
            catch { Label6.Text = "无记录"; }

            try
            {
                Label8.Text = myReader.GetDecimal(1).ToString();
            }
            catch { Label8.Text = "无记录"; }
            try
            {
                Label12.Text = myReader.GetDecimal(2).ToString();

            }
            catch
            {

                Label12.Text = "无记录";
            }

        }


        myReader.Close();
        myConnection.Close();












    }
    #region 注水部分代码
    protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string SJNO1 = ListBox1.SelectedValue.ToString();
        DateOperate1(SJNO1);
        string SJNO2 = ListBox1.SelectedItem.ToString();
        DateOperate2(SJNO2);


    }
    #endregion

    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Redirect("Default.aspx");
    }


    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        Response.Redirect("show.aspx");
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        Response.Redirect("datasearch.aspx");

    }
}