/// <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); }
/// <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 { } }
/// <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 { } }
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("添加失败"); } }
/// <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 { } }
/// <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 { } }
/// <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; }
/// <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; }