System.Collections.IEnumerator RunCustomQuery(string queryText, QueryResultHandler handlerFunc, int takeLimit)
{
if (takeLimit < 0)
{
takeLimit = ConfiguredtakeLimit;
}
using (UnityWebRequest Request = CreateRequest(handlerFunc, takeLimit))
{
Request.method = UnityWebRequest.kHttpVerbPOST;
var bytes = System.Text.Encoding.UTF8.GetBytes(queryText);
Request.uploadHandler = new UploadHandlerRaw(bytes);
Request.downloadHandler = new DownloadHandlerBuffer();
yield return(Request.SendWebRequest());
if (Request.isNetworkError || Request.isHttpError)
{
Debug.Log(Request.error);
}
else if (handlerFunc != null)
{
QueryResult Result = new QueryResult(Request.downloadHandler.text);
handlerFunc(Result);
}
}
}
System.Collections.IEnumerator RunDefaultQuery(QueryResultHandler handlerFunc, int takeLimit)
{
if (takeLimit < 0)
{
takeLimit = ConfiguredtakeLimit;
}
using (UnityWebRequest request = CreateRequest(handlerFunc, takeLimit))
{
request.method = UnityWebRequest.kHttpVerbGET;
request.downloadHandler = new DownloadHandlerBuffer();
yield return(request.SendWebRequest());
if (request.isNetworkError || request.isHttpError)
{
Debug.Log(request.error);
}
else if (handlerFunc != null)
{
QueryResult Result = new QueryResult(request.downloadHandler.text);
handlerFunc(Result);
}
}
}
private void StaffStats()
{
DateTime fromDate;
DateTime tillDate;
GetTimePeriod(out fromDate, out tillDate);
var result = _context.Waiters
.Select(w => new QueryResult
{
Name = w.Name,
NumberOfOrders = w.Orders.Where(o => o.OrderTime >= fromDate && o.OrderTime <= tillDate && o.Status_Id == 2).Count(),
Profit = w.Orders
.Where(o => o.OrderTime >= fromDate && o.OrderTime <= tillDate && o.Status_Id == 2)
.Select(o => new
{
ProfitPerOrder = o.OrderedDishes
.Select(d => new
{
ProfitPerDish = (d.Dish.Price - d.Dish.Cost) * d.Quantity
})
.Sum(a => a.ProfitPerDish)
})
.DefaultIfEmpty(new { ProfitPerOrder = Decimal.Zero })
.Sum(a => a.ProfitPerOrder)
});
QueryResultHandler?.Invoke(result);
}
private void CreateListeners()
{
_pipeline = new Pipeline();
_resultHandler = new QueryResultHandler(this);
_webResourceManager = new WebResourceManager(_pipeline, _resultHandler);
_pipeline.InputTextSubscriberManager.AddSubscriber(_webResourceManager);
_webResourceManager.AddSearchEngine(new GoogleSearchEngine());
_webResourceManager.AddSearchEngine(new BaiduSearchEngine());
_webResourceManager.AddSearchEngine(new SogouSearchEngine());
_webResourceManager.AddSearchEngine(new WikipediaSearchEngine());
//_webResourceManager.AddSearchEngine( new GoogleSuggestion() );
_webResourceManager.AddSearchEngine(new DictCn());
InputQueryObsoletedTime = _defaultInputQueryObsoletedTime;
//_inputQueryRecordManager = new InputQueryRecordManager(
// "data\\query.xml", InputQueryObsoletedTime);
_pipeline.InputTextSubscriberManager.AddSubscriber(_inputQueryRecordManager);
_queryResultRecordManager =
new QueryResultRecordManager(
"data", new TimeSpan(30, 0, 0, 0));
_pipeline.QueryResultSubscriberManager.AddSubscriber(_queryResultRecordManager);
}
/// <summary>
/// 显示历史记录
/// </summary>
/// <param name="result">记录</param>
private void ShowHistoryResult(QueryResult result)
{
if (ChangeText != null)
{
ChangeText(result.Query.ToString());
}
QueryResultHandler.OnResultNew(result);
QueryResultHandler.OnResultUpdate(result);
QueryResultHandler.OnResultCompleted(result);
}
private QueryResult Export(NeweggAmbassadorOrderQueryFilter filter, QueryResultHandler fun)
{
int totalCount;
DataSet ds = fun(filter, out totalCount);
DataTable firstTableInfo = ds.Tables[0];//第一个DataTable
QueryResult listInfo = new QueryResult();
listInfo.Data = firstTableInfo;
listInfo.TotalCount = totalCount;
return(listInfo);
}
private UnityWebRequest CreateRequest(QueryResultHandler handlerFunc, int takeLimit)
{
UnityWebRequest wr = new UnityWebRequest();
wr.url = TelemetrySettings.QueryUrl + "?take=" + takeLimit;
if (TelemetrySettings.AuthenticationKey.Length > 0)
{
wr.SetRequestHeader("x-functions-key", TelemetrySettings.AuthenticationKey);
}
wr.SetRequestHeader("Content-Type", "application/json");
wr.SetRequestHeader("x-ms-payload-type", "batch");
wr.SetRequestHeader("User-Agent", "X-UnityEngine-Agent");
wr.timeout = 30;
return(wr);
}
private void CreateListeners()
{
_pipeline = new Pipeline();
_resultHandler = new QueryResultHandler(this);
_webResourceManager = new WebResourceManager(_pipeline, _resultHandler);
_pipeline.InputTextSubscriberManager.AddSubscriber(_webResourceManager);
_webResourceManager.AddSearchEngine(new GoogleSearchEngine());
_webResourceManager.AddSearchEngine(new BaiduSearchEngine());
_webResourceManager.AddSearchEngine(new SogouSearchEngine());
_webResourceManager.AddSearchEngine(new WikipediaSearchEngine());
//_webResourceManager.AddSearchEngine( new GoogleSuggestion() );
_webResourceManager.AddSearchEngine( new DictCn() );
InputQueryObsoletedTime = _defaultInputQueryObsoletedTime;
//_inputQueryRecordManager = new InputQueryRecordManager(
// "data\\query.xml", InputQueryObsoletedTime);
_pipeline.InputTextSubscriberManager.AddSubscriber(_inputQueryRecordManager);
_queryResultRecordManager =
new QueryResultRecordManager(
"data", new TimeSpan(30, 0, 0, 0));
_pipeline.QueryResultSubscriberManager.AddSubscriber(_queryResultRecordManager);
}
public QueryTableEntry(string queryString, Regex regex, QueryResultHandler resultHandler)
{
m_queryString = queryString;
m_resultHandler = resultHandler;
m_regex = regex;
}
public void ExecuteDefaultQuery(QueryResultHandler handlerFunc, int takeLimit)
{
StartCoroutine(RunDefaultQuery(handlerFunc, takeLimit));
}
public void ExecuteCustomQuery(QueryResultHandler handlerFunc)
{
ExecuteDefaultQuery(handlerFunc, -1);
}
public void ExecuteCustomQuery(string queryText, QueryResultHandler handlerFunc, int takeLimit)
{
StartCoroutine(RunCustomQuery(queryText, handlerFunc, takeLimit));
}
public void ExecuteCustomQuery(string queryText, QueryResultHandler handlerFunc)
{
ExecuteCustomQuery(queryText, handlerFunc, -1);
}
private QueryResultList GetQueryResult(NeweggAmbassadorOrderQueryFilter filter, QueryResultHandler fun)
{
int totalCount;
DataSet ds = fun(filter, out totalCount);
DataTable firstTableInfo = ds.Tables[0]; //第一个DataTable
DataTable secondTableInfo = ds.Tables[1]; //第二个DataTable
QueryResult listInfo = new QueryResult();
listInfo.Data = firstTableInfo;
listInfo.TotalCount = totalCount;
QueryResult summaryResult = new QueryResult();
summaryResult.Data = secondTableInfo;
QueryResultList result = new QueryResultList();
result.Add(listInfo);
result.Add(summaryResult);
return(result);
}
