void OnGUI()
{
if (GUILayout.Button("insert data"))
{
DataCell_classify data = new DataCell_classify();
data.Classify_name = "aaaabbbbb6666";
data.Classify_numpos = 5;
data.Classify_parentID = 3;
SQLDataInterface.AddClassifyInfo(data);
}
if (GUILayout.Button("update data"))
{
DataCell_classify data = new DataCell_classify();
data.Classify_name = "bbb";
data.Classify_numpos = 15;
data.Classify_parentID = 13;
data.Classify_id = 4;
SQLDataInterface.UpdateClassifyInfo(data);
}
if (GUILayout.Button("search database From ParentID"))
{
int id = 3;
List <DataCell_classify> dataList = SQLDataInterface.SelectClassifyListInfo(id);
for (int i = 0; i < dataList.Count; i++)
{
Debug.Log(" Classify_id:" + dataList[i].Classify_id + " Classify_name:" + dataList[i].Classify_name + " Classify_parentID:" + dataList[i].Classify_parentID + " Classify_numpos:" + dataList[i].Classify_numpos + "\n");
}
}
if (GUILayout.Button("search database From ClassifyID"))
{
int id = 3;
DataCell_classify data = SQLDataInterface.SelectClassifyInfo(id);
Debug.Log(" Classify_id:" + data.Classify_id + " Classify_name:" + data.Classify_name + " Classify_parentID:" + data.Classify_parentID + " Classify_numpos:" + data.Classify_numpos + "\n");
}
if (GUILayout.Button("insert model data"))
{
DataCell_model data = new DataCell_model();
data.Model_name = "aaaa111sfsdg";
data.Model_num = "testsdfsssdd1";
data.Model_classify_name = "bbb111";
data.Modle_ThumbnailAddress = "E:/myselfWork/Git/IMG_0001.JPG";
data.Model_address = "E:/myselfWork/Git/Prefab.unity3d";
SQLDataInterface.AddModelInfo(data);
}
}
/// <summary>
/// 更新一级菜单内容
/// </summary>
void UpdateClassifyOnePanel()
{
classifyOnePanel.CassifyContent.Clear();
List <DataCell_classify> classifyOneList = SQLDataInterface.SelectClassifyListInfo(0);
for (int i = 0; i < classifyOneList.Count; i++)
{
ClassifyInfo ci = new ClassifyInfo();
ci.Index = i;// classifyOneList[i].Classify_numpos;
ci.ID = classifyOneList[i].Classify_id.ToString();
ci.Name = classifyOneList[i].Classify_name;
ci.ParentID = classifyOneList[i].Classify_parentID.ToString();
classifyOnePanel.CassifyContent.Add(ci);
}
classifyOnePanel.CreateScrollView();
}
