Example #1
0
    /// <summary>
    /// 分类查找
    /// 根据分类父物体查找子分类列表
    /// </summary>
    /// <param name="parentid">分类父分类id</param>
    /// <returns></returns>
    public static List <DataCell_classify> SelectClassifyListInfo(int parentid)
    {
        SqliteDbHelper db;

        db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path);
        List <DataCell_classify> dataclassifyList = new List <DataCell_classify>();
        //  db.UpdateInto(SQLInfo.classify_table, dataclassify.Classify_name, dataclassify.Classify_parentID, dataclassify.Classify_numpos)
        string query = "SELECT classify_id,classify_name,classify_parent,classify_pos " + " From " + SQLInfo.classify_table;

        query += " WHERE " + "classify_parent = " + parentid;
        SqliteDataReader sqlData = db.ExecuteQuery(query);

        while (sqlData.Read())
        {
            DataCell_classify dataclassify = new DataCell_classify();
            dataclassify.Classify_id       = sqlData.GetInt32(sqlData.GetOrdinal("classify_id"));
            dataclassify.Classify_name     = sqlData.GetString(sqlData.GetOrdinal("classify_name"));
            dataclassify.Classify_numpos   = sqlData.GetInt32(sqlData.GetOrdinal("classify_pos"));
            dataclassify.Classify_parentID = sqlData.GetInt32(sqlData.GetOrdinal("classify_parent"));
            dataclassifyList.Add(dataclassify);
            // Debug.Log(" Classify_id:" + dataclassify.Classify_id + " Classify_name:" + dataclassify.Classify_name + " Classify_parentID:" + dataclassify.Classify_parentID + " Classify_numpos:" + dataclassify.Classify_numpos + "\n");
        }
        sqlData.Close();
        db.CloseSqlConnection();
        Debug.Log(dataclassifyList.Count);
        return(dataclassifyList);
    }
Example #2
0
    /// <summary>
    /// 分类添加
    /// </summary>
    public static bool AddClassifyInfo(DataCell_classify dataCell_calssify)
    {
        try
        {
            DataCell_classify dataclassify = dataCell_calssify;
            SqliteDbHelper db;
            db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path);

            string querySelect = "SELECT * " + " From " + SQLInfo.classify_table;
            querySelect += " WHERE " + "classify_name = '" + dataclassify.Classify_name + "'";
            SqliteDataReader sqlData = db.ExecuteQuery(querySelect);

            if (sqlData.HasRows)
            {
                //**存在名称一样的**//
                if (sqlData != null)
                {
                    sqlData.Dispose();
                }
                sqlData = null;
                db.CloseSqlConnection();
                return false;
            }
            if (sqlData != null)
            {
                sqlData.Dispose();
            }
            sqlData = null;
            db.CloseSqlConnection();

            SqliteDbHelper db1;
            db1 = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path);
            // string[] aa = new string[] { null, dataclassify.Classify_name, dataclassify.Classify_parentID.ToString(), dataclassify.Classify_numpos.ToString() };
            // db.InsertClassifyInto(SQLInfo.classify_table, dataclassify.Classify_name, dataclassify.Classify_parentID, dataclassify.Classify_numpos);
            string query = "INSERT INTO " + SQLInfo.classify_table + " VALUES (" + "null" + "," + "'" + dataclassify.Classify_name + "'" + "," + dataclassify.Classify_parentID + "," + dataclassify.Classify_numpos;
            query += ")";

            db1.ExecuteQuery(query);
            db1.CloseSqlConnection();
            return true;

        }
        catch (Exception e)
        {
            Debug.Log(e.ToString());
            return false;
        }
        finally
        {

        }
    }
Example #3
0
    /// <summary>
    /// 分类添加
    /// </summary>
    public static bool AddClassifyInfo(DataCell_classify dataCell_calssify)
    {
        try
        {
            DataCell_classify dataclassify = dataCell_calssify;
            SqliteDbHelper    db;
            db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path);

            string querySelect = "SELECT * " + " From " + SQLInfo.classify_table;
            querySelect += " WHERE " + "classify_name = '" + dataclassify.Classify_name + "'";
            SqliteDataReader sqlData = db.ExecuteQuery(querySelect);

            if (sqlData.HasRows)
            {
                //**存在名称一样的**//
                if (sqlData != null)
                {
                    sqlData.Dispose();
                }
                sqlData = null;
                db.CloseSqlConnection();
                return(false);
            }
            if (sqlData != null)
            {
                sqlData.Dispose();
            }
            sqlData = null;
            db.CloseSqlConnection();



            SqliteDbHelper db1;
            db1 = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path);
            // string[] aa = new string[] { null, dataclassify.Classify_name, dataclassify.Classify_parentID.ToString(), dataclassify.Classify_numpos.ToString() };
            // db.InsertClassifyInto(SQLInfo.classify_table, dataclassify.Classify_name, dataclassify.Classify_parentID, dataclassify.Classify_numpos);
            string query = "INSERT INTO " + SQLInfo.classify_table + " VALUES (" + "null" + "," + "'" + dataclassify.Classify_name + "'" + "," + dataclassify.Classify_parentID + "," + dataclassify.Classify_numpos;
            query += ")";

            db1.ExecuteQuery(query);
            db1.CloseSqlConnection();
            return(true);
        }
        catch (Exception e)
        {
            Debug.Log(e.ToString());
            return(false);
        }
        finally
        {
        }
    }
Example #4
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);
        }
    }
    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("添加失败");

        }
    }
    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("添加失败");
        }
    }
Example #7
0
 /// <summary>
 /// 分类修改
 /// </summary>
 public static bool UpdateClassifyInfo(DataCell_classify dataCell_calssify)
 {
     try
     {
         SqliteDbHelper db;
         db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path);
         DataCell_classify dataclassify = dataCell_calssify;
         string            querySelect  = "SELECT * " + " From " + SQLInfo.classify_table;
         querySelect += " WHERE " + "classify_name = '" + dataclassify.Classify_name + "'";
         SqliteDataReader sqlData = db.ExecuteQuery(querySelect);
         if (sqlData.HasRows)
         {
             if (sqlData != null)
             {
                 sqlData.Dispose();
             }
             sqlData = null;
             db.CloseSqlConnection();
             return(false);
         }
         if (sqlData != null)
         {
             sqlData.Dispose();
         }
         sqlData = null;
         db.CloseSqlConnection();
         SqliteDbHelper db2;
         db2 = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path);
         //  db.UpdateInto(SQLInfo.classify_table, dataclassify.Classify_name, dataclassify.Classify_parentID, dataclassify.Classify_numpos)
         string query = "UPDATE " + SQLInfo.classify_table + " SET " + "classify_name = " + "'" + dataclassify.Classify_name + "'" + "," + "classify_parent = " + dataclassify.Classify_parentID + "," + "classify_pos =" + dataclassify.Classify_numpos;
         query += " WHERE " + "classify_id = " + dataclassify.Classify_id;
         db2.ExecuteQuery(query);
         db2.CloseSqlConnection();
         return(true);
     }
     catch (Exception e)
     {
         Debug.Log(e.ToString());
         return(false);
     }
     finally
     {
     }
 }
Example #8
0
    /// <summary>
    /// 分类修改
    /// </summary>
    public static bool UpdateClassifyInfo(DataCell_classify dataCell_calssify)
    {
        try
        {
            SqliteDbHelper db;
            db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path);
            DataCell_classify dataclassify = dataCell_calssify;
            string querySelect = "SELECT * " + " From " + SQLInfo.classify_table;
            querySelect += " WHERE " + "classify_name = '" + dataclassify.Classify_name + "'";
            SqliteDataReader sqlData = db.ExecuteQuery(querySelect);
            if (sqlData.HasRows)
            {
                if (sqlData != null)
                {
                    sqlData.Dispose();
                }
                sqlData = null;
                db.CloseSqlConnection();
                return false;
            }
            if (sqlData != null)
            {
                sqlData.Dispose();
            }
            sqlData = null;
            db.CloseSqlConnection();
            SqliteDbHelper db2;
            db2 = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path);
            //  db.UpdateInto(SQLInfo.classify_table, dataclassify.Classify_name, dataclassify.Classify_parentID, dataclassify.Classify_numpos)
            string query = "UPDATE " + SQLInfo.classify_table + " SET " + "classify_name = " + "'" + dataclassify.Classify_name + "'" + "," + "classify_parent = " + dataclassify.Classify_parentID + "," + "classify_pos =" + dataclassify.Classify_numpos;
            query += " WHERE " + "classify_id = " + dataclassify.Classify_id;
            db2.ExecuteQuery(query);
            db2.CloseSqlConnection();
            return true;

        }
        catch (Exception e)
        {
            Debug.Log(e.ToString());
            return false;
        }
        finally
        {

        }
    }
Example #9
0
    /// <summary>
    /// 分类查找
    /// 根据分类父物体查找子分类列表
    /// </summary>
    /// <param name="parentid">分类父分类id</param>
    /// <returns></returns>
    public static List<DataCell_classify> SelectClassifyListInfo(int parentid)
    {
        SqliteDbHelper db;
        db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path);
        List<DataCell_classify> dataclassifyList = new List<DataCell_classify>();
        //  db.UpdateInto(SQLInfo.classify_table, dataclassify.Classify_name, dataclassify.Classify_parentID, dataclassify.Classify_numpos)
        string query = "SELECT classify_id,classify_name,classify_parent,classify_pos " + " From " + SQLInfo.classify_table;
        query += " WHERE " + "classify_parent = " + parentid;
        SqliteDataReader sqlData = db.ExecuteQuery(query);
        while (sqlData.Read())
        {
            DataCell_classify dataclassify = new DataCell_classify();
            dataclassify.Classify_id = sqlData.GetInt32(sqlData.GetOrdinal("classify_id"));
            dataclassify.Classify_name = sqlData.GetString(sqlData.GetOrdinal("classify_name"));
            dataclassify.Classify_numpos = sqlData.GetInt32(sqlData.GetOrdinal("classify_pos"));
            dataclassify.Classify_parentID = sqlData.GetInt32(sqlData.GetOrdinal("classify_parent"));
            dataclassifyList.Add(dataclassify);
            // Debug.Log(" Classify_id:" + dataclassify.Classify_id + " Classify_name:" + dataclassify.Classify_name + " Classify_parentID:" + dataclassify.Classify_parentID + " Classify_numpos:" + dataclassify.Classify_numpos + "\n");

        }
        sqlData.Close();
        db.CloseSqlConnection();
        Debug.Log(dataclassifyList.Count);
        return dataclassifyList;
    }
Example #10
0
    /// <summary>
    /// 分类查找
    /// 根据ID查找子分类列表
    /// </summary>
    public static DataCell_classify SelectClassifyInfo(int classify_id)
    {
        SqliteDbHelper db;
        db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path);
        //  List<DataCell_classify> dataclassifyList = new List<DataCell_classify>();
        //  db.UpdateInto(SQLInfo.classify_table, dataclassify.Classify_name, dataclassify.Classify_parentID, dataclassify.Classify_numpos)
        string query = "SELECT classify_id,classify_name,classify_parent,classify_pos " + " From " + SQLInfo.classify_table;
        query += " WHERE " + "classify_id = " + classify_id;
        DataCell_classify dataclassify = new DataCell_classify();
        SqliteDataReader sqlData = db.ExecuteQuery(query);
        while (sqlData.Read())
        {

            dataclassify.Classify_id = sqlData.GetInt32(sqlData.GetOrdinal("classify_id"));
            dataclassify.Classify_name = sqlData.GetString(sqlData.GetOrdinal("classify_name"));
            dataclassify.Classify_numpos = sqlData.GetInt32(sqlData.GetOrdinal("classify_pos"));
            dataclassify.Classify_parentID = sqlData.GetInt32(sqlData.GetOrdinal("classify_parent"));
        }
        sqlData.Close();
        db.CloseSqlConnection();
        return dataclassify;
    }