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