private static string GetExePathByExeName(string exeName)
{
string sql = "SELECT ExePath FROM " + TABLE_NAME + " WHERE ExePath LIKE '%" + exeName + "%' AND Enabled = '1'";
System.Data.DataSet transData = SqliteDbHelper.GetData(sql);
if (transData != null)
{
if (transData.Tables.Count > 0)
{
if (transData.Tables[0].Rows.Count > 0)
{
foreach (System.Data.DataRow dr in transData.Tables[0].Rows)
{
string exePath = SqliteDbHelper.ToString(dr["ExePath"]);
if (!string.IsNullOrEmpty(exePath))
{
if (System.IO.Path.GetFileName(exePath).Equals(exeName))
{
return(exePath);
}
}
throw new Exception("Error while getting exe Name.");
}
}
}
}
return(string.Empty);
}
/// <summary>
/// Get licence info of a licences by id
/// </summary>
/// <param name="id">Id</param>
/// <returns></returns>
public static Licence GetInfo(string exePath)
{
string sql = "SELECT ExePath, Type, TimeInterval,MaxTime, ConcurrentLicences ,LastRunStart,LastRunEnd , Enabled FROM " + TABLE_NAME + " WHERE ExePath = {0} ";
sql = string.Format(sql, SqliteDbHelper.SQLString(exePath));
System.Data.DataSet transData = SqliteDbHelper.GetData(sql);
if (transData != null)
{
if (transData.Tables.Count > 0)
{
if (transData.Tables[0].Rows.Count > 0)
{
System.Data.DataRow dr = transData.Tables[0].Rows[0];
Licence Licence = new Licence(SqliteDbHelper.ToString(dr["ExePath"]));
Licence.Type = (LicenceType)Enum.Parse(typeof(LicenceType), SqliteDbHelper.ToString(dr["Type"]));
Licence.TimeInterval = SqliteDbHelper.ToInt(dr["TimeInterval"]);
Licence.MaxTime = SqliteDbHelper.ToInt(dr["MaxTime"]);
Licence.ConcurrentLicences = SqliteDbHelper.ToInt(dr["ConcurrentLicences"]);
Licence.LastRunStart = SqliteDbHelper.ToNullableDateTime(dr["LastRunStart"]);
Licence.LastRunEnd = SqliteDbHelper.ToNullableDateTime(dr["LastRunEnd"]);
Licence.Enabled = SqliteDbHelper.ToBoolean(dr["Enabled"]);
return(Licence);
}
}
}
return(null);
}
public static List <Transaction> GetAllRunning(string exePath)
{
List <Transaction> list = new List <Transaction>();
string sql = "SELECT Guid, ExePath,ProcessId, StartedAt, Application, EndedAt, Enabled FROM Transactions WHERE Enabled =" + SqliteDbHelper.SQLBoolean(true);
if (!string.IsNullOrEmpty(exePath))
{
sql += " AND ExePath =" + SqliteDbHelper.SQLString(exePath);
}
System.Data.DataSet transData = SqliteDbHelper.GetData(sql);
if (transData != null)
{
if (transData.Tables.Count > 0)
{
if (transData.Tables[0].Rows.Count > 0)
{
foreach (System.Data.DataRow dr in transData.Tables[0].Rows)
{
Transaction transaction = new Transaction(SqliteDbHelper.ToString(dr["Guid"]));
transaction.ProcessId = SqliteDbHelper.ToInt(dr["ProcessId"]);
transaction.Application = SqliteDbHelper.ToString(dr["Application"]);
transaction.ExeName = SqliteDbHelper.ToString(dr["ExePath"]);
transaction.StartedAt = SqliteDbHelper.ToNullableDateTime(dr["StartedAt"]);
transaction.EndedAt = SqliteDbHelper.ToNullableDateTime(dr["EndedAt"]);
transaction.Enabled = SqliteDbHelper.ToBoolean(dr["Enabled"]);
list.Add(transaction);
}
}
}
}
return(list);
}
public static Transaction Get(string guid)
{
string sql = "SELECT Guid, ExePath,Application,ProcessId, StartedAt, EndedAt, Enabled FROM Transactions WHERE Guid = {0} AND Enabled =" + SqliteDbHelper.SQLBoolean(true);
sql = string.Format(sql, SqliteDbHelper.SQLString(guid));
System.Data.DataSet transData = SqliteDbHelper.GetData(sql);
if (transData != null)
{
if (transData.Tables.Count > 0)
{
if (transData.Tables[0].Rows.Count == 1)
{
System.Data.DataRow dr = transData.Tables[0].Rows[0];
Transaction transaction = new Transaction(SqliteDbHelper.ToString(dr["Guid"]));
transaction.ProcessId = SqliteDbHelper.ToInt(dr["ProcessId"]);
transaction.Application = SqliteDbHelper.ToString(dr["Application"]);
transaction.ExeName = SqliteDbHelper.ToString(dr["ExePath"]);
transaction.StartedAt = SqliteDbHelper.ToNullableDateTime(dr["StartedAt"]);
transaction.EndedAt = SqliteDbHelper.ToNullableDateTime(dr["EndedAt"]);
transaction.Enabled = SqliteDbHelper.ToBoolean(dr["Enabled"]);
return(transaction);
}
}
}
return(null);
}
void Start()
{
Debug.LogError(Application.streamingAssetsPath);
db = new SqliteDbHelper("Data Source=" + Application.streamingAssetsPath + "/tttt.db");
Debug.Log(db.ToString());
/*
* SqliteDbAccess db = new SqliteDbAccess("data source=mydb1.db");
* db.CreateTable("momo",new string[]{"name","qq","email","blog"},
* new string[]{"text","text","text","text"});
* db.CloseSqlConnection();
*/
}
// Use this for initialization
void Start()
{
m_audio = GetComponent <AudioSource> ();
//得到主角
GameObject obj = GameObject.FindGameObjectWithTag("Player");
if (obj != null)
{
m_player = obj.GetComponent <Player> ();
}
//连接数据库
db = new SqliteDbHelper("Data Source=C:/sqlite/database/plane.db");
Debug.Log(db.ToString());
//获取前五的成绩
if (GetScore())
{
IntScore = new int[score.Count];
score.CopyTo(IntScore);
}
}
/// <summary>
/// Get all Licences
/// </summary>
/// <returns></returns>
private static List <Licence> GetAllLicences(LicenceType type, bool?enabled = null)
{
List <Licence> Licences = new List <Licence>();
string sWHERE = " WHERE ";
string sAND = string.Empty;
string sql = "SELECT ExePath, Type, TimeInterval,MaxTime, ConcurrentLicences ,LastRunStart,LastRunEnd , Enabled FROM " + TABLE_NAME;
switch (type)
{
case LicenceType.TRIGGERBASE:
sql = sql + sWHERE + sAND + " Type = 'TRIGGERBASE' ";
sWHERE = string.Empty;
sAND = " AND ";
break;
case LicenceType.PERIODIC:
sql = sql + sWHERE + sAND + " Type = 'PERIODIC' ";
sWHERE = string.Empty;
sAND = " AND ";
break;
case LicenceType.NONE:
break;
}
if (enabled.HasValue)
{
if (enabled.Value)
{
sql = sql + sWHERE + sAND + " Enabled = '1'";
}
else
{
sql = sql + sWHERE + sAND + " Enabled = '0'";
}
sWHERE = string.Empty;
sAND = " AND ";
}
System.Data.DataSet transData = SqliteDbHelper.GetData(sql);
if (transData != null)
{
if (transData.Tables.Count > 0)
{
if (transData.Tables[0].Rows.Count > 0)
{
foreach (System.Data.DataRow dr in transData.Tables[0].Rows)
{
Licence Licence = new Licence(SqliteDbHelper.ToString(dr["ExePath"]));
Licence.Type = (LicenceType)Enum.Parse(typeof(LicenceType), SqliteDbHelper.ToString(dr["Type"]));
Licence.TimeInterval = SqliteDbHelper.ToInt(dr["TimeInterval"]);
Licence.MaxTime = SqliteDbHelper.ToInt(dr["MaxTime"]);
Licence.ConcurrentLicences = SqliteDbHelper.ToInt(dr["ConcurrentLicences"]);
Licence.LastRunStart = SqliteDbHelper.ToNullableDateTime(dr["LastRunStart"]);
Licence.LastRunEnd = SqliteDbHelper.ToNullableDateTime(dr["LastRunEnd"]);
Licence.Enabled = SqliteDbHelper.ToBoolean(dr["Enabled"]);
Licences.Add(Licence);
}
}
}
}
return(Licences);
}