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