/// <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;
}
/// <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();
}
// 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
{
}
}
