public static int SelectCount(string tableName, string columnName, object value) { string query; if (value == null || value == DBNull.Value) { query = string.Format("select count(1) from {0} where {1} is null", tableName, columnName); } else { query = string.Format("select count(1) from {0} where {1} = '{2}'", tableName, columnName, value); } var count = ExecuteScalar(query); var result = -1; if (SupportUtils.IsNumber(count)) { if (count is int) { result = (int)count; } else { result = Convert.ToInt32(count); } } return(result); }
public static PatternItem getByType(Type type, int length) { if (SupportUtils.IsNumber(type)) { return(new PatternItem(SupportUtils.RangeString("#", length), "integer")); } return(null); }
public void Dispose() { _sessionWatcher.CancelAsync(); while (_sessionWatcher.IsBusy) { SupportUtils.DoEvents(); } }
private void LoggerMessageListChanged(object sender, string e) { if (!string.IsNullOrWhiteSpace(e)) { SupportUtils.DoEvents(new Action(() => { _messageList.Add(e); MessageList.ScrollIntoView(e); })); } }
public void StopAll() { foreach (var worker in _workers.Values) { worker.CancelAsync(); } while (_workers.Values.Any(t => t.IsBusy)) { SupportUtils.DoEvents(); } }
public void StopWorker(int siteId) { if (_workers.ContainsKey(siteId)) { var worker = _workers[siteId]; worker.CancelAsync(); while (worker.IsBusy) { SupportUtils.DoEvents(); } } }
private static string getRule(string columnName, Type dataType, bool isNotNull) { if (SupportUtils.IsNumber(dataType)) { return("isNumber"); } if (isNotNull) { return("isNotEmpty"); } return(string.Empty); }
private void ServerStart(object obj) { if (!SupportUtils.CheckOperationSytem()) { UnsupportingVersion(); return; } var server = new RdpSessionServer(); server.Open(); ServerConnectionText = server.CreateInvitation(GroupName, Password); ServerStarted(); }
private static void ChangeTypesAfterRead(DataTable table) { for (int i = 0; i < table.Columns.Count; i++) { var column = table.Columns[i]; if (_typeConvertAfterExecDict.ContainsKey(column.DataType)) { var columnName = column.ColumnName; var tmpColumn = new DataColumn(columnName + "_TMP", _typeConvertAfterExecDict[column.DataType]); table.Columns.Add(tmpColumn); foreach (DataRow row in table.Rows) { row[tmpColumn] = SupportUtils.ChangeType(row[column], tmpColumn.DataType); } table.Columns.Remove(column); tmpColumn.ColumnName = columnName; } } }
void WorkerDoWork(object sender, DoWorkEventArgs e) { var worker = sender as BackgroundWorker; var data = e.Argument as WebSiteItem; if (worker != null && data != null) { while (worker.CancellationPending == false) { var ping = new Ping(); try { var result = ping.Send(data.Url, PING_TIMEOUT); if (worker.CancellationPending) { continue; } if (result.Status == IPStatus.Success) { worker.ReportProgress((int)result.RoundtripTime, data); } else { worker.ReportProgress(0, data); } } catch (PingException ex) { if (ex.InnerException != null) { throw new Exception(ex.Message + " " + ex.InnerException.Message + " " + data.Url); } } if (worker.CancellationPending) { continue; } SupportUtils.DoEvents(); Thread.Sleep(data.PingInterval * MS_IN_SECOND); } e.Result = null; } }
private static string CreateDeleteQuery(string tableName, string columnName, string value) { var source = GetTable(tableName); var columnType = source.Columns[columnName].DataType; string query; if (columnType == typeof(DateTime)) { var date = DateTime.Parse(value); query = string.Format("delete from {0} where {1} = ADDDATE('{2}',0)", tableName, columnName, date.ToString("yyyy.MM.dd")); } else { if (SupportUtils.IsFloatNumber(columnType)) { value = value.Replace(',', '.'); } query = string.Format("delete from {0} where {1} = '{2}'", tableName, columnName, value); } return(query); }
private void SingleStart(object obj) { if (!SupportUtils.CheckOperationSytem()) { UnsupportingVersion(); return; } var server = new RdpSessionServer(); server.Open(); var executableName = GetApplicationName(AppDomain.CurrentDomain.FriendlyName); server.ApplicationFilterEnabled = true; foreach (RDPSRAPIApplication application in server.ApplicationList) { application.Shared = GetApplicationName(application.Name) == executableName; } ServerConnectionText = server.CreateInvitation(GroupName, Password); ServerStarted(); }