/// <summary> /// 模糊搜索 /// </summary> /// <param name="strSearch">搜索内容</param> /// <returns></returns> public static List <DataCell_model> FuzzySelectModelListInfo(string strSearch) { SqliteDbHelper db; db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path); List <DataCell_model> datamodelyList = new List <DataCell_model>(); string query = "SELECT * " + " From " + SQLInfo.model_table; query += " WHERE " + "model_name like '%" + strSearch + "%'"; SqliteDataReader sqlData = db.ExecuteQuery(query); while (sqlData.Read()) { DataCell_model datamode = new DataCell_model(); datamode.Model_id = sqlData.GetInt32(sqlData.GetOrdinal("model_ID")); datamode.Model_num = sqlData.GetString(sqlData.GetOrdinal("model_num")); datamode.Model_name = sqlData.GetString(sqlData.GetOrdinal("model_name")); datamode.Model_address = sqlData.GetString(sqlData.GetOrdinal("model_address")); datamode.Modle_ThumbnailAddress = sqlData.GetString(sqlData.GetOrdinal("modle_ThumbnailAddress")); datamode.Model_Introduction = sqlData.GetString(sqlData.GetOrdinal("model_Introduction")); datamode.Model_classify_name = sqlData.GetString(sqlData.GetOrdinal("model_classify_name")); datamode.Model_type = sqlData.GetString(sqlData.GetOrdinal("model_type")); datamodelyList.Add(datamode); } sqlData.Close(); db.CloseSqlConnection(); Debug.Log(datamodelyList.Count); return(datamodelyList); }
/// <summary> /// 分类查找 /// 根据元件编号查找子分类列表 /// </summary> /// <param name="model_num">元件编号</param> /// <returns></returns> public static DataCell_model SelectModelInfoByNum(string model_num) { SqliteDbHelper db; db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path); string query = "SELECT * " + " From " + SQLInfo.model_table; query += " WHERE " + "model_num = '" + model_num + "'"; DataCell_model datamode = new DataCell_model(); SqliteDataReader sqlData = db.ExecuteQuery(query); while (sqlData.Read()) { datamode.Model_id = sqlData.GetInt32(sqlData.GetOrdinal("model_ID")); datamode.Model_num = sqlData.GetString(sqlData.GetOrdinal("model_num")); datamode.Model_name = sqlData.GetString(sqlData.GetOrdinal("model_name")); datamode.Model_address = sqlData.GetString(sqlData.GetOrdinal("model_address")); datamode.Modle_ThumbnailAddress = sqlData.GetString(sqlData.GetOrdinal("modle_ThumbnailAddress")); datamode.Model_Introduction = sqlData.GetString(sqlData.GetOrdinal("model_Introduction")); datamode.Model_classify_name = sqlData.GetString(sqlData.GetOrdinal("model_classify_name")); } sqlData.Close(); db.CloseSqlConnection(); return(datamode); }
/// <summary> /// 元件模型删除 /// </summary> public static void DeleteModelInfo(DataCell_model dataCell_model) { SqliteDbHelper db; db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path); DataCell_model datamodel = dataCell_model; string query = "Delete From" + SQLInfo.model_table; query += " WHERE " + "model_id = " + datamodel.Model_id; db.ExecuteQuery(query); db.CloseSqlConnection(); }
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="dataCell_model"> 模型类对象</param> public static bool AddModelInfo(DataCell_model dataCell_model) { try { SqliteDbHelper db; db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path); DataCell_model datamodel = dataCell_model; string querySelect = "SELECT * " + " From " + SQLInfo.model_table; querySelect += " WHERE " + "model_num = '" + datamodel.Model_num + "'"; SqliteDataReader sqlData = db.ExecuteQuery(querySelect); // 有 true 没有 false if (sqlData.HasRows) { //**存在名称一样的**// Debug.Log("该名称已经存在" + sqlData.HasRows); if (sqlData != null) { sqlData.Dispose(); } sqlData = null; db.CloseSqlConnection(); return false; } if (sqlData != null) { sqlData.Dispose(); } sqlData = null; db.CloseSqlConnection(); if (datamodel.Model_address != "") { Debug.Log("dataCell_model.Model_address:" + dataCell_model.Model_address); string targetPath = Application.dataPath + SQLInfo.Model_path; if (datamodel.Model_address != targetPath) { string path = datamodel.Model_address; if (!FileHelper.CopyDir(ref path, targetPath)) return false; datamodel.Model_address = path; } } if (datamodel.Modle_ThumbnailAddress != "") { Debug.Log("dataCell_model.Modle_ThumbnailAddress:" + dataCell_model.Modle_ThumbnailAddress + " Path:" + Path.GetFileName(dataCell_model.Modle_ThumbnailAddress)); string targetPath = Application.dataPath + SQLInfo.Texture_path; if (datamodel.Modle_ThumbnailAddress != targetPath) { string path = datamodel.Modle_ThumbnailAddress; if (!FileHelper.CopyDir(ref path, targetPath)) return false; datamodel.Modle_ThumbnailAddress = path; } } SqliteDbHelper db1; db1 = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path); string query = "INSERT INTO " + SQLInfo.model_table + " VALUES (" + "null" + ",'" + datamodel.Model_num + "','" + datamodel.Model_name + "','" + datamodel.Model_address; query += "','" + datamodel.Modle_ThumbnailAddress + "','" + datamodel.Model_Introduction + "','" + datamodel.Model_classify_name + "','" + datamodel.Model_type + "')"; db1.ExecuteQuery(query); db1.CloseSqlConnection(); return true; } catch (Exception e) { Debug.Log(e.ToString()); return false; } finally { } }
/// <summary> /// 模型元件查找 /// 根据分类父物体查找子分类列表 /// </summary> /// <param name="model_classify_name">分类名称</param> /// <returns></returns> public static List<DataCell_model> SelectModelListInfo(string model_classify_name) { SqliteDbHelper db; db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path); List<DataCell_model> datamodelyList = new List<DataCell_model>(); string query = "SELECT * " + " From " + SQLInfo.model_table; query += " WHERE " + "model_classify_name = '" + model_classify_name + "'"; SqliteDataReader sqlData = db.ExecuteQuery(query); while (sqlData.Read()) { DataCell_model datamode = new DataCell_model(); datamode.Model_id = sqlData.GetInt32(sqlData.GetOrdinal("model_ID")); datamode.Model_num = sqlData.GetString(sqlData.GetOrdinal("model_num")); datamode.Model_name = sqlData.GetString(sqlData.GetOrdinal("model_name")); datamode.Model_address = sqlData.GetString(sqlData.GetOrdinal("model_address")); datamode.Modle_ThumbnailAddress = sqlData.GetString(sqlData.GetOrdinal("modle_ThumbnailAddress")); datamode.Model_Introduction = sqlData.GetString(sqlData.GetOrdinal("model_Introduction")); datamode.Model_classify_name = sqlData.GetString(sqlData.GetOrdinal("model_classify_name")); datamode.Model_type = sqlData.GetString(sqlData.GetOrdinal("model_type")); datamodelyList.Add(datamode); } sqlData.Close(); db.CloseSqlConnection(); Debug.Log(datamodelyList.Count); return datamodelyList; }
/// <summary> /// 分类查找 /// 根据元件编号查找子分类列表 /// </summary> /// <param name="model_num">元件编号</param> /// <returns></returns> public static DataCell_model SelectModelInfoByNum(string model_num) { SqliteDbHelper db; db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path); string query = "SELECT * " + " From " + SQLInfo.model_table; query += " WHERE " + "model_num = '" + model_num + "'"; DataCell_model datamode = new DataCell_model(); SqliteDataReader sqlData = db.ExecuteQuery(query); while (sqlData.Read()) { datamode.Model_id = sqlData.GetInt32(sqlData.GetOrdinal("model_ID")); datamode.Model_num = sqlData.GetString(sqlData.GetOrdinal("model_num")); datamode.Model_name = sqlData.GetString(sqlData.GetOrdinal("model_name")); datamode.Model_address = sqlData.GetString(sqlData.GetOrdinal("model_address")); datamode.Modle_ThumbnailAddress = sqlData.GetString(sqlData.GetOrdinal("modle_ThumbnailAddress")); datamode.Model_Introduction = sqlData.GetString(sqlData.GetOrdinal("model_Introduction")); datamode.Model_classify_name = sqlData.GetString(sqlData.GetOrdinal("model_classify_name")); } sqlData.Close(); db.CloseSqlConnection(); return datamode; }
// CREATE TABLE "modelcell" ( //[model_ID] INT, //[model_num] VARCHAR(32), //[model_name] VARCHAR(100), //[model_address] VARCHAR(300), //[modle_ThumbnailAddress] VARCHAR(300), //[model_Introduction] VARCHAR(3000), //[model_classify_name] VARCHAR(300), //CONSTRAINT [] PRIMARY KEY ([model_ID])); /// <summary> /// 元件模型修改 /// </summary> public static bool UpdateModelInfo(DataCell_model dataCell_model) { try { SqliteDbHelper db; db = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path); DataCell_model datamodel = dataCell_model; string querySelect = "SELECT * " + " From " + SQLInfo.model_table; querySelect += " WHERE " + "model_num = '" + datamodel.Model_num + "'"; 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(); if (datamodel.Model_address != "") { Debug.Log("dataCell_model.Model_address:" + dataCell_model.Model_address); string targetPath = Application.dataPath + SQLInfo.Model_path; if (datamodel.Model_address != targetPath) { string path = datamodel.Model_address; if (!FileHelper.CopyDir(ref path, targetPath)) { return(false); } datamodel.Model_address = path; } } if (datamodel.Modle_ThumbnailAddress != "") { Debug.Log("dataCell_model.Modle_ThumbnailAddress:" + dataCell_model.Modle_ThumbnailAddress + " Path:" + Path.GetFileName(dataCell_model.Modle_ThumbnailAddress)); string targetPath = Application.dataPath + SQLInfo.Texture_path; if (datamodel.Modle_ThumbnailAddress != targetPath) { string path = datamodel.Modle_ThumbnailAddress; if (!FileHelper.CopyDir(ref path, targetPath)) { return(false); } datamodel.Modle_ThumbnailAddress = path; } } SqliteDbHelper db1; db1 = new SqliteDbHelper("Data Source=" + Application.dataPath + SQLInfo.SQL_path); string query = "UPDATE " + SQLInfo.model_table + " SET " + "model_num = '" + datamodel.Model_num + "'," + "model_name = '" + datamodel.Model_name + "'," + "model_address = '" + datamodel.Model_address; query += "'," + "modle_ThumbnailAddress = '" + datamodel.Modle_ThumbnailAddress + "'," + "model_Introduction = '" + datamodel.Model_Introduction + "'," + "model_classify_name = '" + datamodel.Model_classify_name + "' + " + " model_type = '" + datamodel.Model_type + "'"; query += " WHERE " + "model_id = " + datamodel.Model_id; db1.ExecuteQuery(query); db1.CloseSqlConnection(); return(true); } catch (Exception e) { Debug.Log(e.ToString()); return(false); } finally { } }