private void GetField6(string table) { Optionsfield6.Clear(); using (IDbConnection dbConnection = new SqliteConnection(DB_Manager.connectionString)) { dbConnection.Open(); using (IDbCommand dbCmd = dbConnection.CreateCommand()) { string sqlQuery = String.Format("SELECT * FROM \"{0}\"", table); dbCmd.CommandText = sqlQuery; using (IDataReader reader = dbCmd.ExecuteReader()) { while (reader.Read()) { if (table == "Тип_памяти") { Optionsfield6.Add(reader.GetString(1)); } else { Optionsfield6.Add(reader.GetInt32(1).ToString()); } } dbConnection.Close(); reader.Close(); } } } }
public void EditThisDataCell() { EditWindow.transform.SetParent(Main.GetComponent <Transform>()); EditWindow.GetComponent <Transform>().localPosition = new Vector3(1, 1, 1); curFields = curObj.GetComponentsInChildren <Text>(); ID.GetComponent <Text>().text = curFields[0].text; if (Scripts.GetComponent <DB_Manager>().DelTuggle == 1) { table = "Процессор"; f1.GetComponent <Text>().text = "Процессор"; f2.GetComponent <Text>().text = curFields[1].text; f3.GetComponent <InputField>().text = curFields[2].text; f4.GetComponent <InputField>().text = curFields[3].text; f5.GetComponent <Dropdown>().ClearOptions(); f6.GetComponent <Dropdown>().ClearOptions(); GetField5("Число_ядер", 0); GetField6("Объём_памяти"); f5.GetComponent <Dropdown>().AddOptions(Optionsfield5); f6.GetComponent <Dropdown>().AddOptions(Optionsfield6); f5.GetComponent <Dropdown>().value = Optionsfield5.IndexOf(curFields[4].text); f6.GetComponent <Dropdown>().value = Optionsfield6.IndexOf(curFields[5].text); f7.GetComponent <InputField>().text = curFields[6].text; f8.GetComponent <InputField>().text = curFields[7].text; f9.GetComponent <InputField>().interactable = false; f9.GetComponent <InputField>().text = ""; f10.GetComponent <InputField>().interactable = false; f10.GetComponent <InputField>().text = ""; } else if (Scripts.GetComponent <DB_Manager>().DelTuggle == 2) { table = "Материнская_плата"; f1.GetComponent <Text>().text = "Материнская плата"; f2.GetComponent <Text>().text = curFields[1].text; f3.GetComponent <InputField>().text = curFields[2].text; f4.GetComponent <InputField>().text = curFields[3].text; f5.GetComponent <Dropdown>().ClearOptions(); f6.GetComponent <Dropdown>().ClearOptions(); GetField5("Тип_памяти", 1); GetField6("Объём_памяти"); f5.GetComponent <Dropdown>().AddOptions(Optionsfield5); f6.GetComponent <Dropdown>().AddOptions(Optionsfield6); f5.GetComponent <Dropdown>().value = Optionsfield5.IndexOf(curFields[4].text); f6.GetComponent <Dropdown>().value = Optionsfield6.IndexOf(curFields[5].text); f7.GetComponent <InputField>().text = curFields[6].text; f8.GetComponent <InputField>().text = curFields[7].text; f9.GetComponent <InputField>().interactable = true; f9.GetComponent <InputField>().text = curFields[8].text; f10.GetComponent <InputField>().interactable = false; f10.GetComponent <InputField>().text = ""; } else if (Scripts.GetComponent <DB_Manager>().DelTuggle == 3) { table = "Видеокарта"; f1.GetComponent <Text>().text = "Видеокарта"; f2.GetComponent <Text>().text = curFields[1].text; f3.GetComponent <InputField>().text = curFields[2].text; f4.GetComponent <InputField>().text = curFields[3].text; f5.GetComponent <Dropdown>().ClearOptions(); f6.GetComponent <Dropdown>().ClearOptions(); GetField5("Тип_памяти", 2); GetField6("Объём_памяти"); f5.GetComponent <Dropdown>().AddOptions(Optionsfield5); f6.GetComponent <Dropdown>().AddOptions(Optionsfield6); f5.GetComponent <Dropdown>().value = Optionsfield5.IndexOf(curFields[4].text); f6.GetComponent <Dropdown>().value = Optionsfield6.IndexOf(curFields[5].text); f7.GetComponent <InputField>().text = curFields[6].text; f8.GetComponent <InputField>().text = curFields[7].text; f9.GetComponent <InputField>().interactable = true; f9.GetComponent <InputField>().text = curFields[8].text; f10.GetComponent <InputField>().interactable = false; f10.GetComponent <InputField>().text = ""; } else if (Scripts.GetComponent <DB_Manager>().DelTuggle == 4) { table = "Оперативная_память"; f1.GetComponent <Text>().text = "Оперативная память"; f2.GetComponent <Text>().text = curFields[1].text; f3.GetComponent <InputField>().text = curFields[2].text; f4.GetComponent <InputField>().text = curFields[3].text; f5.GetComponent <Dropdown>().ClearOptions(); f6.GetComponent <Dropdown>().ClearOptions(); GetField5("Тип_памяти", 1); GetField6("Объём_памяти"); f5.GetComponent <Dropdown>().AddOptions(Optionsfield5); f6.GetComponent <Dropdown>().AddOptions(Optionsfield6); f5.GetComponent <Dropdown>().value = Optionsfield5.IndexOf(curFields[4].text); f6.GetComponent <Dropdown>().value = Optionsfield6.IndexOf(curFields[5].text); f7.GetComponent <InputField>().text = curFields[6].text; f8.GetComponent <InputField>().text = curFields[7].text; f9.GetComponent <InputField>().interactable = true; f9.GetComponent <InputField>().text = curFields[8].text; f10.GetComponent <InputField>().interactable = true; f10.GetComponent <InputField>().text = curFields[9].text; } }