예제 #1
0
    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);
        }
    }
예제 #2
0
    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("添加失败");
        }
    }