protected void Page_Load(object sender, EventArgs e) { BuildingTableAdapter bu = new BuildingTableAdapter(); SensorTableAdapter ss = new SensorTableAdapter(); Type_sensorTableAdapter Tys = new Type_sensorTableAdapter(); if (Request.QueryString["NameFarm"] != null) { // Label1.Text = " : " + Request.QueryString["NameFarm"].ToString(); Label2.Text = Request.QueryString["NameBu"].ToString(); Label3.Text = "ชื่อเจ้าหน้าที่ : " + Request.QueryString["NameOF"].ToString(); Session["S_Bu"] = bu.GetDataBy2(Request.QueryString["NameBu"].ToString()).Rows[0][4].ToString(); string idbu = bu.GetDataBy2(Request.QueryString["NameBu"].ToString()).Rows[0][0].ToString(); Session["ID_Bu"] = idbu; int ns = Convert.ToInt32(ss.ScalarQuery(idbu)); Session["fr"] = ns; Session["Pic_bui"] = bu.GetDataBy2(Request.QueryString["NameBu"].ToString()).Rows[0][6].ToString(); for (int i = 0; i < ns; i++) { Session["ID_Sensor" + i] = ss.GetDataBy1(idbu).Rows[i][0].ToString(); Session["Name_Sensor" + i] = ss.GetDataBy1(idbu).Rows[i][1].ToString(); Session["Type_Sensor" + i] = ss.GetDataBy1(idbu).Rows[i][3].ToString(); Session["Unit_Ty" + i] = Tys.GetDataBy(Session["Type_Sensor" + i].ToString()).Rows[0][2].ToString(); } Session["In_Ch"] = bu.GetDataBy2(Request.QueryString["NameBu"].ToString()).Rows[0][2].ToString(); Session["ChhhD"] = bu.GetDataBy2(Request.QueryString["NameBu"].ToString()).Rows[0][9].ToString(); Label1.Text = bu.GetDataBy2(Request.QueryString["NameBu"].ToString()).Rows[0][9].ToString() + " ตัว"; } else { } }
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { BuildingTableAdapter buu = new BuildingTableAdapter(); SensorTableAdapter ssn = new SensorTableAdapter(); Type_sensorTableAdapter tys = new Type_sensorTableAdapter(); string idbu = buu.GetDataBy2(DropDownList2.SelectedItem.Text).Rows[0][0].ToString(); int iss = Convert.ToInt32(ssn.ScalarQuery(idbu)); Session["iss"] = iss; for (int i = 0; i < iss; i++) { Session["name_sensor" + i] = ssn.GetDataBy1(idbu).Rows[i][1].ToString(); Session["de_sensor" + i] = ssn.GetDataBy1(idbu).Rows[i][2].ToString(); string dd = ssn.GetDataBy1(idbu).Rows[i][3].ToString(); Session["idtype_sensor" + i] = dd; Session["type_sensor" + i] = tys.GetDataBy(dd).Rows[0][1].ToString(); Session["unit_sensor" + i] = tys.GetDataBy(dd).Rows[0][2].ToString(); } }