public static List <T> ExecuteQuery <T>(string sql, object[] ParamsList = null) where T : new()
{
List <SQLiteParameter> list = GetPara(sql, ParamsList);
DataTable dt = Sqlite.ExecuteQuery(sql, list != null ? list.ToArray() : null);
return(dt.Rows.Count > 0 ? ExcuteInfo <T> .TableToList(dt) : new List <T>());
}
public static Process StartProcess(ExcuteInfo excuteInfo, DataReceivedEventHandler outputHandler)
{
var startInfo = new ProcessStartInfo()
{
FileName = excuteInfo.FileName,
Arguments = excuteInfo.Args,
CreateNoWindow = true,
RedirectStandardInput = true,
RedirectStandardOutput = true,
StandardOutputEncoding = Encoding.Default,
WindowStyle = ProcessWindowStyle.Hidden,
UseShellExecute = false
};
var process = new Process()
{
StartInfo = startInfo,
};
process.OutputDataReceived += outputHandler;
process.ErrorDataReceived += outputHandler;
process.EnableRaisingEvents = true;
process.Start();
process.BeginOutputReadLine();
return(process);
}
private void menuUninstallDevice_Click(object sender, RoutedEventArgs e)
{
RefreshInstallStatus(false);
new Thread(() =>
{
var excuteInfo = new ExcuteInfo()
{
FileName = "Driver\\tapinstall.exe",
Args = "remove tap0901"
};
Process process = ProcessHelper.StartProcess(excuteInfo, (a, b) => Trace.WriteLine(b.Data));
process.Exited += (a, b) =>
{
RefreshInstallStatus(true);
MessageBox.Show("卸载完毕", "卸载驱动");
};
}).Start();
}
public static List <T> Get <T>(string sqlWhere, object[] ParamsList = null) where T : new()
{
try
{
Type = typeof(T);
string displayName = Type.GetCustomAttribute <DisplayNameAttribute>().DisplayName;
StringBuilder Sqlsb = new StringBuilder();
Sqlsb.Append("select * from ").Append(displayName);
if (!string.IsNullOrEmpty(sqlWhere))
{
Sqlsb.Append(" where ").Append(sqlWhere);
}
List <SQLiteParameter> list = GetPara(Sqlsb.ToString(), ParamsList);
DataTable dt = Sqlite.ExecuteQuery(Sqlsb.ToString(), list != null ? list.ToArray() : null);
return(dt.Rows.Count > 0 ? ExcuteInfo <T> .TableToList(dt) : new List <T>());
}
catch (Exception e)
{
return(new List <T>());
}
}
