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>
/// <param name="classifyname"></param>
void UpdateElementsPanel(string classifyname)
{
elementsScrollView.ElementsContent.Clear();
List <DataCell_model> elements = SQLDataInterface.SelectModelListInfo(classifyname);
for (int i = 0; i < elements.Count; i++)
{
ElementsItemInfo ei = new ElementsItemInfo();
ei.Index = i;// elements[i].Classify_numpos;
ei.ID = elements[i].Model_id.ToString();
ei.Name = elements[i].Model_name;
//ei.Image = elements[i].Modle_ThumbnailAddress;
elementsScrollView.ElementsContent.Add(ei);
}
elementsScrollView.CreateScrollView();
}
/// <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();
}
private void AddClassifyToDatabase()
{
DataCell_classify dc = new DataCell_classify();
dc.Classify_name = classifyName.text;
dc.Classify_parentID = int.Parse(parentID);
if (SQLDataInterface.AddClassifyInfo(dc))
{
MessageBox.Display("添加成功", 1.5f, null);
}
else
{
MessageBox.Display("添加失败");
}
}
