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(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["Name_Login"] == null) { Response.Redirect("Login.aspx"); } FarmTableAdapter Fr = new FarmTableAdapter(); BuildingTableAdapter bui = new BuildingTableAdapter(); SensorTableAdapter sen = new SensorTableAdapter(); OfficerTableAdapter offi = new OfficerTableAdapter(); FarmerTableAdapter ffff = new FarmerTableAdapter(); string idf = Session["ID_Login"].ToString(); idf = idf.Substring(0, 1); if (idf == "F") { int nFr1 = Convert.ToInt32(Fr.ScalarQuery(Session["ID_Login"].ToString())); Session["nFrNav"] = nFr1; for (int ii = 0; ii < nFr1; ii++) { Session["idFarmNav" + ii] = Fr.GetDataBy5(Session["ID_Login"].ToString()).Rows[ii][0].ToString(); Session["nameFarmNav" + ii] = Fr.GetDataBy5(Session["ID_Login"].ToString()).Rows[ii][1].ToString(); string OFFFf = Fr.GetDataBy5(Session["ID_Login"].ToString()).Rows[ii][4].ToString(); Session["nameOfNav" + ii] = offi.GetDataBy3(OFFFf).Rows[0][2].ToString(); int nBu1 = Convert.ToInt32(bui.ScalarQuery(Session["idFarmNav" + ii].ToString())); Session["nBuNav" + ii] = nBu1; //string[,] idBuiPro = new string[,] { }; //string[,] nameBuiPro = new string[,] { }; for (int iii = 0; iii < nBu1; iii++) { Session["idBuiNav[" + ii + "," + iii + "]"] = bui.GetDataBy1(Session["idFarmNav" + ii].ToString()).Rows[iii][0].ToString(); Session["nameBuiNav[" + ii + "," + iii + "]"] = bui.GetDataBy1(Session["idFarmNav" + ii].ToString()).Rows[iii][1].ToString(); int nSe1 = Convert.ToInt32(sen.ScalarQuery(Session["idBuiNav[" + ii + "," + iii + "]"].ToString())); // int[,] nSe1 = new int[,] { }; Session["nSe1Nav[" + ii + "," + iii + "]"] = nSe1; for (int iiii = 0; iiii < nSe1; iiii++) { Session["idSenNav" + ii + "," + iii + "," + iiii] = sen.GetDataBy1(Session["idBuiNav[" + ii + "," + iii + "]"].ToString()).Rows[iiii][0].ToString(); Session["nameSenNav" + ii + "," + iii + "," + iiii] = sen.GetDataBy1(Session["idBuiNav[" + ii + "," + iii + "]"].ToString()).Rows[iiii][1].ToString(); } } } } else { int nFr1 = Convert.ToInt32(Fr.ScalarQuery1(Session["ID_Login"].ToString())); Session["nFrNav"] = nFr1; for (int ii = 0; ii < nFr1; ii++) { Session["idFarmNav" + ii] = Fr.GetDataBy3(Session["ID_Login"].ToString()).Rows[ii][0].ToString(); Session["nameFarmNav" + ii] = Fr.GetDataBy3(Session["ID_Login"].ToString()).Rows[ii][1].ToString(); string OFFFf = Fr.GetDataBy3(Session["ID_Login"].ToString()).Rows[ii][3].ToString(); Session["nameFrrNav" + ii] = ffff.GetDataBy3(OFFFf).Rows[0][2].ToString(); int nBu1 = Convert.ToInt32(bui.ScalarQuery(Session["idFarmNav" + ii].ToString())); Session["nBuNav" + ii] = nBu1; //string[,] idBuiPro = new string[,] { }; //string[,] nameBuiPro = new string[,] { }; for (int iii = 0; iii < nBu1; iii++) { Session["idBuiNav[" + ii + "," + iii + "]"] = bui.GetDataBy1(Session["idFarmNav" + ii].ToString()).Rows[iii][0].ToString(); Session["nameBuiNav[" + ii + "," + iii + "]"] = bui.GetDataBy1(Session["idFarmNav" + ii].ToString()).Rows[iii][1].ToString(); int nSe1 = Convert.ToInt32(sen.ScalarQuery(Session["idBuiNav[" + ii + "," + iii + "]"].ToString())); // int[,] nSe1 = new int[,] { }; Session["nSe1Nav[" + ii + "," + iii + "]"] = nSe1; for (int iiii = 0; iiii < nSe1; iiii++) { Session["idSenNav" + ii + "," + iii + "," + iiii] = sen.GetDataBy1(Session["idBuiNav[" + ii + "," + iii + "]"].ToString()).Rows[iiii][0].ToString(); Session["nameSenNav" + ii + "," + iii + "," + iiii] = sen.GetDataBy1(Session["idBuiNav[" + ii + "," + iii + "]"].ToString()).Rows[iiii][1].ToString(); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["ID_Login"] == null) { Response.Redirect("Login.aspx"); } string idf = Session["ID_Login"].ToString(); idf = idf.Substring(0, 1); FarmTableAdapter Fr = new FarmTableAdapter(); BuildingTableAdapter bui = new BuildingTableAdapter(); SensorTableAdapter sen = new SensorTableAdapter(); OfficerTableAdapter offi = new OfficerTableAdapter(); FarmerTableAdapter fff = new FarmerTableAdapter(); if (idf == "F") { int nFr = Convert.ToInt32(Fr.ScalarQuery(Session["ID_Login"].ToString())); Session["nFr"] = nFr; for (int i = 0; i < nFr; i++) { Session["idFarmPro" + i] = Fr.GetDataBy2(Session["ID_Login"].ToString()).Rows[i][0].ToString(); Session["nameFarmPro" + i] = Fr.GetDataBy2(Session["ID_Login"].ToString()).Rows[i][1].ToString(); string OFFF = Fr.GetDataBy2(Session["ID_Login"].ToString()).Rows[i][4].ToString(); Session["nameOfPro" + i] = offi.GetDataBy3(OFFF).Rows[0][2].ToString(); int nBu = Convert.ToInt32(bui.ScalarQuery(Session["idFarmPro" + i].ToString())); Session["nBu" + i] = nBu; //string[,] idBuiPro = new string[,] { }; //string[,] nameBuiPro = new string[,] { }; for (int i1 = 0; i1 < nBu; i1++) { Session["idBuiPro[" + i + "," + i1 + "]"] = bui.GetDataBy1(Session["idFarmPro" + i].ToString()).Rows[i1][0].ToString(); Session["nameBuiPro[" + i + "," + i1 + "]"] = bui.GetDataBy1(Session["idFarmPro" + i].ToString()).Rows[i1][1].ToString(); int nSe = Convert.ToInt32(sen.ScalarQuery(Session["idBuiPro[" + i + "," + i1 + "]"].ToString())); // int[,] nSe1 = new int[,] { }; Session["nSe1[" + i + "," + i1 + "]"] = nSe; Session["Pic_buii[" + i + "," + i1 + "]"] = bui.GetDataBy1(Session["idFarmPro" + i].ToString()).Rows[i1][6].ToString(); for (int i2 = 0; i2 < nSe; i2++) { Session["idSenPro" + i + "," + i1 + "," + i2] = sen.GetDataBy1(Session["idBuiPro[" + i + "," + i1 + "]"].ToString()).Rows[i2][0].ToString(); Session["nameSenPro" + i + "," + i1 + "," + i2] = sen.GetDataBy1(Session["idBuiPro[" + i + "," + i1 + "]"].ToString()).Rows[i2][1].ToString(); } } } } else { int nFr = Convert.ToInt32(Fr.ScalarQuery1(Session["ID_Login"].ToString())); Session["nFr"] = nFr; for (int i = 0; i < nFr; i++) { Session["idFarmPro" + i] = Fr.GetDataBy3(Session["ID_Login"].ToString()).Rows[i][0].ToString(); Session["nameFarmPro" + i] = Fr.GetDataBy3(Session["ID_Login"].ToString()).Rows[i][1].ToString(); string OFFF = Fr.GetDataBy3(Session["ID_Login"].ToString()).Rows[i][3].ToString(); Session["nameOfPro" + i] = fff.GetDataBy3(OFFF).Rows[0][1].ToString(); int nBu = Convert.ToInt32(bui.ScalarQuery(Session["idFarmPro" + i].ToString())); Session["nBu" + i] = nBu; //string[,] idBuiPro = new string[,] { }; //string[,] nameBuiPro = new string[,] { }; for (int i1 = 0; i1 < nBu; i1++) { Session["idBuiPro[" + i + "," + i1 + "]"] = bui.GetDataBy1(Session["idFarmPro" + i].ToString()).Rows[i1][0].ToString(); Session["nameBuiPro[" + i + "," + i1 + "]"] = bui.GetDataBy1(Session["idFarmPro" + i].ToString()).Rows[i1][1].ToString(); int nSe = Convert.ToInt32(sen.ScalarQuery(Session["idBuiPro[" + i + "," + i1 + "]"].ToString())); // int[,] nSe1 = new int[,] { }; Session["nSe1[" + i + "," + i1 + "]"] = nSe; Session["Pic_buii[" + i + "," + i1 + "]"] = bui.GetDataBy1(Session["idFarmPro" + i].ToString()).Rows[i1][6].ToString(); for (int i2 = 0; i2 < nSe; i2++) { Session["idSenPro" + i + "," + i1 + "," + i2] = sen.GetDataBy1(Session["idBuiPro[" + i + "," + i1 + "]"].ToString()).Rows[i2][0].ToString(); Session["nameSenPro" + i + "," + i1 + "," + i2] = sen.GetDataBy1(Session["idBuiPro[" + i + "," + i1 + "]"].ToString()).Rows[i2][1].ToString(); } } } } }