/// <summary>
/// 获取计量任务流水数据
/// </summary>
private void getTaskDoResult()
{
if (SelectedUser == null || string.IsNullOrWhiteSpace(SelectedUser.LogName))
{
return;
}
string serviceUrl = ConfigurationManager.AppSettings["getTaskDoResult"].Trim();
var temp = new
{
equcode = "",
equname = "",
equtype = "",
opname = "",
opcode = SelectedUser.LogName,
carno = "",
taskdoresult = "",
memo = "",
taskbegintime = DateTimeBegin.ToString("yyyy-MM-dd HH:mm:ss"),
taskendtime = DateTimeEnd.ToString("yyyy-MM-dd HH:mm:ss")
};
string jsonStr = "[" + InfoExchange.ConvertToJsonIgnoreRef1(temp) + "]";
serviceUrl = string.Format(serviceUrl, jsonStr);
HttpWebRequest request = WebRequestCommon.GetHttpGetWebRequest(serviceUrl, 10);
request.BeginGetResponse(new AsyncCallback(BindTaskDoResult), request);
}
/// <summary>
/// Установить содержание для запроса
/// </summary>
protected override void setQuery()
{
m_strQuery = string.Empty;
long secUTCOffsetToData = m_msecUTCOffsetToServer / 1000;
//DateTimeBegin = DateTimeBegin.AddSeconds(-1 * secUTCOffsetToData);
string strIds = "SELECT ДатаВремя, ";
foreach (SIGNALMSTKKSNAMEsql sgnl in m_arSignals)
{
if (sgnl.IsFormula == false)
{
strIds += @"" + sgnl.m_kks_name + @",";
}
else
{
; // формула
}
}
// удалить "лишнюю" запятую
strIds = strIds.Substring(0, strIds.Length - 1);
m_strQuery = strIds
+ @" FROM " + NameTable + " WHERE [ДатаВремя] >='" + DateTimeBegin + @"'"
+ @" AND [ДатаВремя] <'" + DateTimeBegin.AddSeconds(PeriodMain.TotalSeconds) + @"'"
;
}
/// <summary>
/// Установить содержание для запроса
/// </summary>
protected override void setQuery()
{
m_strQuery = string.Empty;
//long secOffsetUTCToData = m_secOffsetUTCToData; //OFFSET
//DateTimeBegin = DateTimeBegin.AddSeconds(-1 * secUTCOffsetToData);
string strIds = "SELECT ДатаВремя, ";
foreach (SIGNALMSTKKSNAMEsql sgnl in m_arSignals)
{
if (sgnl.IsFormula == false)
{
strIds += $"{sgnl.m_kks_name},";
}
else
{
; // формула
}
}
// удалить "лишнюю" запятую
strIds = strIds.Substring(0, strIds.Length - 1);
m_strQuery = strIds
+ $" FROM {NameTable}"
+ $" WHERE [ДатаВремя] >='{DateTimeBegin}'"
+ $" AND [ДатаВремя] <'{DateTimeBegin.AddSeconds(PeriodMain.TotalSeconds)}'"
;
}
public string ToCsvAll()
{
return(string.Format("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{24}",
DateTimeBegin.ToString("MM/dd/yyyy HH:mm"),
DateTimeEnd.ToString("MM/dd/yyyy HH:mm"),
SymbolId, Symbol, Open, High, Low, Close, BidOpen, BidHigh, BidLow, BidClose, AskOpen, AskHigh, AskLow, AskClose,
PipsHigh, PipsLow, PipsRange, PipsHighBid, PipsLowBid, PipsRangeBid, PipsHighAsk, PipsLowAsk, PipsRangeAsk));
}
public string ToTimeStatCsv()
{
return(string.Format("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9}",
DateTimeBegin.ToString("MM/dd/yyyy HH:mm"),
DateTimeEnd.ToString("MM/dd/yyyy HH:mm"),
Symbol, Open, High, Low, Close,
PipsHigh, PipsLow, PipsRange));
}
public void ClearValues()
{
int iPrev = 0,iDel = 0,iCur = 0;
lock (m_lockData)
{
iPrev = m_tableTorIs.Rows.Count;
string strSel =
@"DATETIME<'" + DateTimeBegin.AddSeconds(-(PeriodLocal.TotalSeconds + 15)).ToUniversalTime().ToString(@"yyyy/MM/dd HH:mm:ss.fff") + @"' OR DATETIME>='" + DateTimeBegin.AddSeconds(PeriodLocal.TotalSeconds + 5).ToUniversalTime().ToString(@"yyyy/MM/dd HH:mm:ss.fff") + @"'"
//@"DATETIME BETWEEN '" + m_dtStart.ToString(@"yyyy/MM/dd HH:mm:ss") + @"' AND '" + m_dtStart.AddSeconds(m_tmSpanPeriod.Seconds).ToString(@"yyyy/MM/dd HH:mm:ss") + @"'"
;
DataRow[] rowsDel = null;
try { rowsDel = m_tableTorIs.Select(strSel); }
catch (Exception e)
{
Logging.Logg().Exception(e,@"SrcMSTKKSNAMEtoris.GroupSignalsMSTKKSNAMEtoris::ClearValues () - ...",Logging.INDEX_MESSAGE.NOT_SET);
}
if (!(rowsDel == null))
{
iDel = rowsDel.Length;
if (rowsDel.Length > 0)
{
foreach (DataRow r in rowsDel)
{
//Debug.Print("Удалено значение для сигнала:" + r[0].ToString() + "(" + r[1].ToString() + "," + r[2].ToString() + ") " +DateTime.Now.ToString());
//Logging.Logg().Action("StateCheckResponse:m_tableTorIs.Rows.Remove()", Logging.INDEX_MESSAGE.NOT_SET);
m_tableTorIs.Rows.Remove(r);
}
//Debug.Print(strSel);
//m_tableTorIs = returnTable(m_tableTorIs);
//??? Обязательно ли...
//Logging.Logg().Action("StateCheckResponse:m_tableTorIs.AcceptChanges()", Logging.INDEX_MESSAGE.NOT_SET);
m_tableTorIs.AcceptChanges();
}
else
{
;
}
}
else
{
;
}
//m_tableTorIs = returnTable(m_tableTorIs);
iCur = m_tableTorIs.Rows.Count;
}
//Console.WriteLine(@"Обновление рез-та [ID=" + m_Id + @"]: " + @"(было=" + iPrev + @", удалено=" + iDel + @", осталось=" + iCur + @")");
}
/// <summary>
/// 获取计量员集合
/// </summary>
private void getAllTaskDoResultAvgTime()
{
string serviceUrl = ConfigurationManager.AppSettings["getAllTaskDoResultAvgTime"].Trim();
var temp = new { taskbegintime = DateTimeBegin.ToString("yyyy-MM-dd HH:mm:ss"), taskendtime = DateTimeEnd.ToString("yyyy-MM-dd HH:mm:ss") };
string jsonStr = "[" + InfoExchange.ConvertToJsonIgnoreRef1(temp) + "]";
serviceUrl = string.Format(serviceUrl, jsonStr);
HttpWebRequest request = WebRequestCommon.GetHttpGetWebRequest(serviceUrl, 10);
request.BeginGetResponse(new AsyncCallback(BindAllTaskDoResultAvgTime), request);
}
/// <summary>
/// 获取计量员集合
/// </summary>
private void getCarWeightTaskCount()
{
string serviceUrl = ConfigurationManager.AppSettings["getCarWeightTaskCount"].Trim();
var temp = new { equcode = "", equname = "", begintime = DateTimeBegin.ToString("yyyy-MM-dd HH:mm:ss"), endtime = DateTimeEnd.ToString("yyyy-MM-dd HH:mm:ss") };
string jsonStr = InfoExchange.ConvertToJsonIgnoreRef1(temp);
serviceUrl = string.Format(serviceUrl, jsonStr);
HttpWebRequest request = WebRequestCommon.GetHttpGetWebRequest(serviceUrl, 10);
request.BeginGetResponse(new AsyncCallback(BindCarWeightTaskCount), request);
}
public bool TryReserveAircraft(Aircraft aircraft, IEnumerable <Flight> flights)
{
// Ajout du temps de préparation de l'avion !
DateTime dateTimeBegin = DateTimeBegin.Subtract(aircraft.PreparationTimeSpan);
if (aircraft.CanBeReserved(dateTimeBegin, DateTimeEnd, flights))
{
this.AircraftGuid = aircraft.Id;
this.Aircraft = aircraft;
return(true);
}
else
{
return(false);
}
}
public void ClearValues()
{
int iPrev = 0,iDel = 0,iCur = 0;
lock (this)
{
iPrev = m_tableTorIs.Rows.Count;
string strSel =
@"DATETIME<'" + DateTimeBegin.ToString(@"yyyy/MM/dd HH:mm:ss.fff") + @"' OR DATETIME>='" + DateTimeBegin.AddSeconds(PeriodMain.TotalSeconds).ToString(@"yyyy/MM/dd HH:mm:ss.fff") + @"'"
//@"DATETIME BETWEEN '" + m_dtStart.ToString(@"yyyy/MM/dd HH:mm:ss") + @"' AND '" + m_dtStart.AddSeconds(m_tmSpanPeriod.Seconds).ToString(@"yyyy/MM/dd HH:mm:ss") + @"'"
;
DataRow[] rowsDel = null;
try { rowsDel = m_tableTorIs.Select(strSel); }
catch (Exception e)
{
Logging.Logg().Exception(e,@"SrcMSTKKSNAMEtoris.GroupSignalsMSTKKSNAMEtoris::ClearValues () - ...",Logging.INDEX_MESSAGE.NOT_SET);
}
if (!(rowsDel == null))
{
iDel = rowsDel.Length;
if (rowsDel.Length > 0)
{
foreach (DataRow r in rowsDel)
{
m_tableTorIs.Rows.Remove(r);
}
//??? Обязательно ли...
m_tableTorIs.AcceptChanges();
}
else
{
;
}
}
else
{
;
}
iCur = m_tableTorIs.Rows.Count;
}
Console.WriteLine(@"Обновление рез-та [ID=" + m_Id + @"]: " + @"(было=" + iPrev + @", удалено=" + iDel + @", осталось=" + iCur + @")");
}
protected override int StateRequest(int state)
{
int iRes = 0;
switch (state)
{
case (int)StatesMachine.Values:
// toris-instance выполняется только на сервере
m_datetimeServer.Value = DateTime.Now;
m_datetimeServer.BaseUTCOffset = DateTime.Now - DateTime.UtcNow;
// округлить до минут
SetDatetimeBegin(DateTimeBegin.Round(TimeSpan.FromMinutes(1),MidpointRounding.AwayFromZero));
//DateTimeBegin = m_dtServer.AddMilliseconds(-1 * (m_dtServer.Second * 1000 + m_dtServer.Millisecond));
//Запрос на выборку данных не требуется
ClearValues();
break;
default:
break;
}
return(iRes);
}
/// <summary>
/// Установить содержание для запроса
/// </summary>
protected override void setQuery()
{
int idReq = HMath.GetRandomNumber()
, i = -1;
string cmd = string.Empty;
//перевод даты для суточного набора
if (DateTimeStart != DateTimeBegin)
{
DateTimeBegin = (DateTimeBegin - DateTimeBegin.TimeOfDay).AddHours(23);
}
else
{
DateTimeBegin = (DateTimeStart - DateTimeStart.TimeOfDay).AddHours(-1);
}
//Формировать запрос
i = 0;
m_strQuery = "SELECT ДатаВремя, ";
foreach (GroupSignalsVzletNativeDSql.SIGNALMSTKKSNAMEsql s in m_arSignals)
{
m_strQuery += s.m_kks_name + ", ";
}
m_strQuery = m_strQuery.Remove(m_strQuery.Length - 2, 1);
m_strQuery += " FROM " + NameTable + " ";
m_strQuery += @"WHERE ДатаВремя > '" + DateTimeBegin + "' and ДатаВремя <= '" + DateTimeBegin.AddSeconds(PeriodMain.TotalSeconds) + "'";
//DateTimeBegin = DateTimeBegin.AddSeconds(secUTCOffsetToData);
}
/// <summary>
/// Строковое описание события расписания в особом - подходящем для файлов почасовки - формате.
/// </summary>
/// <returns>Строка, включающая в себя дату проведения, время занятия, набор групп.</returns>
public override string ToString()
{
return(DateTimeBegin.ToShortDateString() + "\t" + PairTimeByNumber(PairNumber) + ",\t" + Groups);
}
