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;
}
}
