private DataSet prepareDataSet(OPTION outputOption)
{
DataSet ret = new DataSet();
// Create a new DataTable.
_returnedTable = new DataTable("BondPricer");
_returnedTable.Columns.Add(_ISINColumn);
_returnedTable.Columns.Add(_DATEColumn);
if (outputOption.Equals(OPTION.ALL) || outputOption.Equals(OPTION.DURATION))
{
_returnedTable.Columns.Add(_columns[OPTION.DURATION]);
}
if (outputOption.Equals(OPTION.ALL) || outputOption.Equals(OPTION.ACCRUEDINTEREST))
{
_returnedTable.Columns.Add(_columns[OPTION.ACCRUEDINTEREST]);
}
if (outputOption.Equals(OPTION.ALL) || outputOption.Equals(OPTION.CLEANPRICE))
{
_returnedTable.Columns.Add(_columns[OPTION.CLEANPRICE]);
}
if (outputOption.Equals(OPTION.ALL) || outputOption.Equals(OPTION.DIRTYPRICE))
{
_returnedTable.Columns.Add(_columns[OPTION.DIRTYPRICE]);
}
ret.Tables.Add(_returnedTable);
return(ret);
}
//****************************************************************************************************
//
//****************************************************************************************************
public void Release(ObjectT o, OPTION opt = OPTION.NONE)
{
if (o == null)
{
return;
}
if (m_capacity <= 0)
{
return;
}
if (m_size >= m_capacity)
{
return;
}
if (opt == OPTION.CHECK_DUPLICATES)
{
for (int slot = 0; slot < m_size; ++slot)
{
if (object.ReferenceEquals(m_slots[slot], o))
{
return;
}
}
}
m_slots[m_size++] = o;
}
public void AddOption(string image_source, Color color, string text)
{
AbsoluteLayout absoluteLayout = new AbsoluteLayout
{
Padding = new Thickness(5, 0, 5, 10),
HorizontalOptions = new LayoutOptions(LayoutAlignment.End, true),
IsVisible = false
};
Frame frame = new Frame
{
HeightRequest = 20,
WidthRequest = 20,
BackgroundColor = color,
CornerRadius = 30,
HasShadow = true,
Content = new Image
{
Source = image_source
}
};
frame.GestureRecognizers.Add(SetEventClik(ref frame, text));
absoluteLayout.Children.Add(frame);
if (row == 0)
{
grid_main.Children.Clear();
}
OPTION pTION = new OPTION
{
label = TitleOption(text),
absoluteLayout = absoluteLayout
};
optiones.Add(pTION);
}
public void Set(OPTION option, OBJECT_CATEGORY objectCategory, bool isList, string NS, string objectType, string objectName)
{
this.option = option;
this.objectCategory = objectCategory;
this.isList = isList;
this.NS = NS;
this.objectType = objectType;
this.objectName = objectName;
}
public bool TryExecuteRequest(Guid networkAdapterId, OPTION optionId, out DHCPCAPI_PARAMS result)
{
result = default(DHCPCAPI_PARAMS);
var sendPtr = m_sendHandle.DangerousGetHandle();
var receivePtr = m_receiveHandle.DangerousGetHandle();
var bufferPtr = m_bufferHandle.DangerousGetHandle();
var sendParameter = default(DHCPCAPI_PARAMS);
sendParameter.Flags = 0u;
sendParameter.OptionId = OPTION.PAD;
sendParameter.IsVendor = false;
sendParameter.Data = IntPtr.Zero;
sendParameter.nBytesData = 0u;
Marshal.StructureToPtr(sendParameter, sendPtr, false);
var sendParameters = default(DHCPCAPI_PARAMS_ARRAY);
sendParameters.nParams = 1u;
sendParameters.Params = sendPtr;
var receiveParameter = default(DHCPCAPI_PARAMS);
receiveParameter.Flags = 0u;
receiveParameter.OptionId = optionId;
receiveParameter.IsVendor = false;
receiveParameter.Data = IntPtr.Zero;
receiveParameter.nBytesData = 0u;
Marshal.StructureToPtr(receiveParameter, receivePtr, false);
var receiveParameters = default(DHCPCAPI_PARAMS_ARRAY);
receiveParameters.nParams = 1u;
receiveParameters.Params = receivePtr;
var byteCount = (uint)BufferLength;
var errorCode = NativeMethods.DhcpRequestParams(
DHCPCAPI_REQUEST.SYNCHRONOUS,
IntPtr.Zero,
networkAdapterId.ToString("b"),
IntPtr.Zero,
sendParameters,
receiveParameters,
bufferPtr,
ref byteCount,
null);
if (errorCode != 0u)
{
return(false);
}
result = (DHCPCAPI_PARAMS)Marshal.PtrToStructure(receiveParameters.Params, typeof(DHCPCAPI_PARAMS));
return(true);
}
public void OptionButton(string upOrDown)
{
if (upOrDown == "up")
{
option = OPTION.UP;
}
else if (upOrDown == "down")
{
option = OPTION.DOWN;
}
}
public void Update()
{
if (DayCycleScript.newEvent)
{
DayCycleScript.newEvent = false;
audioManager.GetComponent <SoundManager>().PlayEventFX();
CreateNewEvent();
PopUpEventMenu();
}
if (option != OPTION.NONE)
{
ExecuteEvent();
option = OPTION.NONE;
}
}
public static string ToHexString(byte[] hash, OPTION opt = OPTION.Lower)
{
StringBuilder sb = new StringBuilder(hash.Length * 2);
foreach (Byte b in hash)
{
if (opt == OPTION.Lower)
{
sb.AppendFormat("{0:x2}", b);
}
else
{
sb.AppendFormat("{0:X2}", b);
}
}
return(sb.ToString());
}
public void Add(SIGN sign, OPTION option, string low, string high)
{
if (low.Length >= LengthLimit)
{
low = low.Substring(0, LengthLimit);
}
if (high.Length >= LengthLimit)
{
high = high.Substring(0, LengthLimit);
}
DataRow row = dataTable.NewRow();
row[sSIGN] = sign.ToString();
row[sOPTION] = option.ToString();
row[sLOW] = low;
row[sHIGH] = high;
dataTable.Rows.Add(row);
}
protected void AddOption_Click(object sender, EventArgs e)
{
//MCQQuestion pre = Session["data"] as MCQQuestion;
//MCQOption op = new MCQOption();
// use op with status and option
QuestionBankEntities db = new QuestionBankEntities();
OPTION op = new OPTION();
int id = (int)(ViewState["data"]);
op.QUESTIONS = id;
if (TextBox1.Text != null)
{
op.OOPTION = TextBox1.Text;
Label2.Text = op.OOPTION + "<br/>";
if (CheckBox1.Checked)
{
op.OSTATUS = true;
Label3.Text = "yes";
}
else
{
op.OSTATUS = false;
Label3.Text = "no";
}
db.OPTIONS.Add(op);
db.SaveChanges();
//pre.Options.Add(op);
//Session["data"] = pre;
Panel1.Visible = false;
TextBox1.Visible = true; //panel3 items
AddOption.Visible = true;
CheckBox1.Visible = true;
NoMoreOption.Visible = true;
}
}
public CommonResource resource = new CommonResource(); //!< コモンリソース(オブジェクト読み込み等はこれを使用)
/*******************************************************/
/* !@brief : Awake
* @date : 2014/03/18
* @author : コロソブス(korombus)
*******************************************************/
public virtual void Awake()
{
// システムを登録
SetSystem(this);
OPTION.LoadOption();
}
/// <summary>
/// Remplit la dataset donnée en paramètre avec le resultat du calcul de :
/// OPTION.DURATION , ou ou CLEANPRICE ou DIRTYPRICE ou ACCRUEDPRICE
/// sur la base source
/// </summary>
/// <param name="DS"></param>
public DataSet Execute(DataSet INPUTS, OPTION outputOption = OPTION.ALL)
{
DataRow row;
DataSet ret = prepareDataSet(outputOption);
// lecture input
foreach (DataTable dt in INPUTS.Tables)
{
IntegratorBatch.InfoLogger.Debug("Nb de bonds à pricer :" + dt.Rows.Count);
foreach (DataRow dr in dt.Rows)
{
// calcul pour une oblig
string ISIN = dr.Field <string>("ISIN");
DateTime DATE = dr.Field <DateTime>("DATE");
DateTime maturity = dr.Field <DateTime>("MATURITY");
double ttm = (dr.Field <double?>("TTM") ?? getDays_30E360(DATE, maturity));
double c = dr.Field <double>("COUPON");
double r = dr.Field <double>("RATE");
int nbPeriods;
if (ttm != null)
{
nbPeriods = (int)Math.Truncate((double)ttm);
}
else
{
// Calcul impossible
continue;
}
double?cp = null, ai = null;
row = _returnedTable.NewRow();
row["ISIN"] = ISIN;
row["DATE"] = DATE;
if (outputOption.Equals(OPTION.ALL) || outputOption.Equals(OPTION.CLEANPRICE))
{
cp = CleanPrice(c, nbPeriods, r);
row["CLEANPRICE"] = cp;
}
if (outputOption.Equals(OPTION.ALL) || outputOption.Equals(OPTION.DURATION))
{
if (c == 0 || nbPeriods <= 1)
{
row["DURATION"] = ttm;
}
else
{
cp = cp ?? CleanPrice(c, nbPeriods, r);
double duration = Duration((double)cp, c, nbPeriods, r);
row["DURATION"] = duration;
}
}
if (outputOption.Equals(OPTION.ALL) || outputOption.Equals(OPTION.ACCRUEDINTEREST))
{
ai = AccruedInterest(c, nbPeriods, ttm);
row["ACCRUEDINTEREST"] = ai;
}
if (outputOption.Equals(OPTION.ALL) || outputOption.Equals(OPTION.DIRTYPRICE))
{
cp = cp ?? CleanPrice(c, nbPeriods, r);
ai = ai ?? AccruedInterest(c, nbPeriods, ttm);
row["DIRTYPRICE"] = cp + ai;
}
_returnedTable.Rows.Add(row);
}
}
return(ret);
}
/// <summary>
/// オプション情報をロード
/// </summary>
protected static void LoadOptionData()
{
OPTION.SetVolume(PlayerPrefs.GetFloat(GameDefine.SAVE_KEY_OPTION_BGM_VOLUME), OPTION.Sound.BGM);
OPTION.SetVolume(PlayerPrefs.GetFloat(GameDefine.SAVE_KEY_OPTION_SE_VOLUME), OPTION.Sound.SE);
}
public bool TryExecuteRequest(Guid networkAdapterId, OPTION optionId, out DHCPCAPI_PARAMS result)
{
result = default(DHCPCAPI_PARAMS);
var sendPtr = m_sendHandle.DangerousGetHandle();
var receivePtr = m_receiveHandle.DangerousGetHandle();
var bufferPtr = m_bufferHandle.DangerousGetHandle();
var sendParameter = default(DHCPCAPI_PARAMS);
sendParameter.Flags = 0u;
sendParameter.OptionId = OPTION.PAD;
sendParameter.IsVendor = false;
sendParameter.Data = IntPtr.Zero;
sendParameter.nBytesData = 0u;
Marshal.StructureToPtr(sendParameter, sendPtr, false);
var sendParameters = default(DHCPCAPI_PARAMS_ARRAY);
sendParameters.nParams = 1u;
sendParameters.Params = sendPtr;
var receiveParameter = default(DHCPCAPI_PARAMS);
receiveParameter.Flags = 0u;
receiveParameter.OptionId = optionId;
receiveParameter.IsVendor = false;
receiveParameter.Data = IntPtr.Zero;
receiveParameter.nBytesData = 0u;
Marshal.StructureToPtr(receiveParameter, receivePtr, false);
var receiveParameters = default(DHCPCAPI_PARAMS_ARRAY);
receiveParameters.nParams = 1u;
receiveParameters.Params = receivePtr;
var byteCount = (uint)BufferLength;
var errorCode = NativeMethods.DhcpRequestParams(
DHCPCAPI_REQUEST.SYNCHRONOUS,
IntPtr.Zero,
networkAdapterId.ToString("b"),
IntPtr.Zero,
sendParameters,
receiveParameters,
bufferPtr,
ref byteCount,
null);
if (errorCode != 0u)
{
return false;
}
result = (DHCPCAPI_PARAMS)Marshal.PtrToStructure(receiveParameters.Params, typeof(DHCPCAPI_PARAMS));
return true;
}
/// <summary>
/// Подготовить объект для отправки адресату по его запросу
/// </summary>
/// <param name="s">Событие - идентификатор запрашиваемой информации/операции,действия</param>
/// <param name="error">Признак выполнения операции/действия по запросу</param>
/// <param name="outobj">Объект для отправления адресату как результат запроса</param>
/// <returns>Признак выполнения метода (дополнительный)</returns>
protected override int StateCheckResponse(int s, out bool error, out object outobj)
{
int iRes = -1;
StatesMachine state = (StatesMachine)s;
PACKAGE package;
XmlDocument xmlDocNew;
XmlNode nodeRec;
string debugMsg = string.Empty;
error = true;
outobj = null;
ItemQueue itemQueue = null;
try {
switch (state)
{
case StatesMachine.NEW: // новый пакет
iRes = 0;
error = false;
itemQueue = Peek;
// удалить лишние пакеты
removePackages();
xmlDocNew = (XmlDocument)itemQueue.Pars[1];
if (m_xmlDocRecieved == null)
{
m_xmlDocRecieved = UDPListener.CopyXmlDocument(xmlDocNew);
}
else
{
;
}
foreach (XmlNode nodeNew in xmlDocNew.ChildNodes[1]) //[0] - header, [1] - xml
{
debugMsg += string.Format(@"{0}, ", nodeNew.Name);
if (_dictBuildingParameterRecieved.ContainsKey(nodeNew.Name) == false)
{
_dictBuildingParameterRecieved.Add(nodeNew.Name, new GROUP_PARAMETER(DateTime.UtcNow));
}
else
{
_dictBuildingParameterRecieved[nodeNew.Name].Update(false);
if (_dictBuildingParameterRecieved[nodeNew.Name].IsUpdate == true)
{
nodeRec = m_xmlDocRecieved.ChildNodes[1].SelectSingleNode(nodeNew.Name);
if (nodeRec == null)
{
nodeRec = m_xmlDocRecieved.CreateNode(XmlNodeType.Element, nodeNew.Name, nodeNew.NamespaceURI);
nodeRec.InnerXml = nodeNew.InnerXml;
m_xmlDocRecieved.ChildNodes[1].AppendChild(nodeRec);
}
else
{
//m_xmlDocRecieved.ChildNodes[1].ReplaceChild(xmlNode, node);
nodeRec.InnerXml = nodeNew.InnerXml;
}
}
else
{
;
}
}
}
//Console.WriteLine(string.Format(@"{0} получены: {1}", DateTime.UtcNow, debugMsg));
lock (this) {
if (_dictBuildingParameterRecieved.IsUpdate == true)
{
error = (iRes = addPackage((DateTime)itemQueue.Pars[0], m_xmlDocRecieved)) < 0 ? true : false;
_dictBuildingParameterRecieved.Update(true);
}
else
{
error = false;
}
}
break;
case StatesMachine.LIST_PACKAGE: // список пакетов
iRes = 0;
error = false;
itemQueue = Peek;
outobj = listViewPackageItem;
break;
case StatesMachine.PACKAGE_CONTENT: // пакет
iRes = 0;
error = false;
itemQueue = Peek;
Console.WriteLine(string.Format(@"{0} - Запрос {1}: за [{2}], индекс={3}, состояние={4}" //
, DateTime.UtcNow, state.ToString(), (DateTime)itemQueue.Pars[0], (int)itemQueue.Pars[2], ((DataGridViewElementStates)itemQueue.Pars[3]).ToString())); //
var selectPackages = from p in _listPackage where p.m_dtRecieved == (DateTime)itemQueue.Pars[0] select p;
if (selectPackages.Count() == 1)
{
package = selectPackages.ElementAt(0);
switch ((FormMain.INDEX_CONTROL)itemQueue.Pars[1])
{
case FormMain.INDEX_CONTROL.TABPAGE_VIEW_PACKAGE_XML:
outobj = package.m_xmlSource;
break;
case FormMain.INDEX_CONTROL.TABPAGE_VIEW_PACKAGE_TREE:
outobj = package.m_listXmlTree;
break;
case FormMain.INDEX_CONTROL.TABPAGE_VIEW_PACKAGE_TABLE_VALUE:
outobj = package.m_tableValues;
break;
case FormMain.INDEX_CONTROL.TABPAGE_VIEW_PACKAGE_TABLE_PARAMETER:
outobj = package.m_tableParameters;
break;
default: //??? - ошибка неизвестный тип вкладки просмотра XML-документа
break;
}
}
else
{
; //??? - ошибка пакет не найден либо пакетов много
}
break;
case StatesMachine.STATISTIC: // статистика
iRes = 0;
error = false;
itemQueue = Peek;
//outobj = ??? объект статический
break;
case StatesMachine.OPTION:
iRes = 0;
error = false;
itemQueue = Peek;
s_Option = (OPTION)itemQueue.Pars[0];
m_manualEventSetOption.Set();
//outobj = ??? только в одну сторону: форма -> handler
break;
case StatesMachine.TIMER_TABLERES: // срок отправлять очередной пакет
iRes = 0;
error = false;
itemQueue = Peek;
// отправить строго крайний, при этом XML-пакет д.б. не отправленным
var orderPckages = from p in _listPackage /*where p.m_dtSended == DateTime.MinValue*/ orderby p.m_dtRecieved descending select p;
if (orderPckages.Count() > 0)
{
package = orderPckages.ElementAt(0);
if (package.m_dtSended == DateTime.MinValue)
{
package.m_dtSended = DateTime.UtcNow;
// объект со структурой DATA_SET
outobj = new object[] {
package.m_dtSended
, package.m_tableValues.Copy()
, package.m_tableParameters.Copy()
};
}
else
{
// не отправлять пакет на обработку
outobj = false;
}
}
else
{
//??? - ошибка пакет не найден либо пакетов много
// iRes = -1;
// error = true;
outobj = false;
}
_dictBuildingParameterRecieved.Update(false);
break;
default:
break;
}
} catch (Exception e) {
Logging.Logg().Exception(e, @"PackageHandlerQueue::StateCheckResponse (state=" + state.ToString() + @") - ...", Logging.INDEX_MESSAGE.NOT_SET);
error = true;
iRes = -1 * (int)state;
}
return(iRes);
}
public PlaceMainOptions(string name, OPTION type, string icon, Brush color)
{
Icon = icon;
Name = name;
Background = color;
Type = type;
}
/// <summary>
/// Реализация очереди обработки событий - получение данных
/// </summary>
/// <param name="s">Идентификатор события</param>
/// <param name="error">Признак ошибки при выполнении</param>
/// <param name="outobj">Объект с полученными данными</param>
/// <returns>Результат выполнения метода</returns>
protected override int StateCheckResponse(int s, out bool error, out object outobj)
{
int iRes = -1;
DATASET dataSet;
StatesMachine state = (StatesMachine)s;
string debugMsg = string.Empty;
error = true;
outobj = null;
ItemQueue itemQueue = null;
try {
switch (state)
{
case StatesMachine.NEW: //
iRes = 0;
error = false;
itemQueue = Peek;
error = (iRes = addDataSet(_writer.ListConnSettKey, (DateTime)itemQueue.Pars[0], itemQueue.Pars[1] as DataTable, itemQueue.Pars[2] as DataTable)) < 0 ? true : false;;
debugMsg = string.Format(@"Добавление нового набора [{0}]...", (DateTime)itemQueue.Pars[0]);
if (error == false)
{
// добавленный набор поставить в очередь на запись
outobj = new DATASET_WRITER()
{
m_dtRecieved = _listDataSet[_listDataSet.Count - 1].m_dtRecieved
, m_values = _listDataSet[_listDataSet.Count - 1].m_values
};
Logging.Logg().Debug(MethodBase.GetCurrentMethod(), debugMsg, Logging.INDEX_MESSAGE.NOT_SET);
}
else
{
Logging.Logg().Error(MethodBase.GetCurrentMethod(), debugMsg, Logging.INDEX_MESSAGE.NOT_SET);
}
break;
case StatesMachine.LIST_DEST: // получен спискок объектов с парметрами соединения с БД
iRes = 0;
error = false;
itemQueue = Peek;
// инициализация переданными значениями
initialize(itemQueue.Pars[0] as List <WriterHandlerQueue.ConnectionSettings>);
// установка соединения с источниками данных
_writer.StartDbInterfaces();
// обеспечить готовность к приему событий (TSQL-запросов для выполнения)
_writer.Start(); _writer.Activate(true);
break;
case StatesMachine.LIST_DATASET: // запрос на формирование актуального списка переданных для записи наборов
iRes = 0;
error = false;
itemQueue = Peek;
if (!((int)itemQueue.Pars[0] < 0))
{
outobj = getListViewDataSetItem((int)itemQueue.Pars[0]);
}
else
{
;
}
break;
case StatesMachine.DATASET_CONTENT: // запрос на передачу содержимого набора, выбранного пользователем для отображения
iRes = 0;
error = false;
itemQueue = Peek;
var selectDataSets = from l in _listDataSet where l.m_dtRecieved == (DateTime)itemQueue.Pars[0] select l;
if (selectDataSets.Count() == 1)
{
dataSet = selectDataSets.ElementAt(0);
switch ((FormMain.INDEX_CONTROL)itemQueue.Pars[1])
{
case FormMain.INDEX_CONTROL.TABPAGE_VIEW_DATASET_TABLE_VALUE:
outobj = dataSet.m_tableValues;
break;
case FormMain.INDEX_CONTROL.TABPAGE_VIEW_DATASET_TABLE_PARAMETER:
outobj = dataSet.m_tableParameters;
break;
default: //??? - ошибка неизвестный тип вкладки просмотра набора
break;
}
}
else
{
; //??? - ошибка пакет не найден либо пакетов много
}
break;
//case StatesMachine.STATISTIC: //
// iRes = 0;
// error = false;
// itemQueue = Peek;
// break;
case StatesMachine.CONNSET_USE_CHANGED:
iRes = 0;
error = false;
itemQueue = Peek;
_writer.ChangeConnSettUse((int)itemQueue.Pars[0]);
break;
case StatesMachine.OPTION:
iRes = 0;
error = false;
itemQueue = Peek;
s_Option = (OPTION)itemQueue.Pars[0];
//outobj = ??? только в одну сторону: форма -> handler
break;
default:
break;
}
} catch (Exception e) {
Logging.Logg().Exception(e, @"WriteHandlerQueue::StateCheckResponse (state=" + state.ToString() + @") - ...", Logging.INDEX_MESSAGE.NOT_SET);
error = true;
iRes = -1 * (int)state;
}
return(iRes);
}
