protected override void InsertSql(OpenMarketOperation data)
{
string seprator = "";
string quot = "";
StringBuilder sqlColNames = new StringBuilder();
StringBuilder sqlValues = new StringBuilder();
for (int i = 0; i < data._dataTypes.Count; i++)
{
if (sqlColNames.Length > 0)
{
seprator = ",";
}
if (data._dataTypes[i] == "FLOAT" || data._dataTypes[i] == "INT" || data._values[i] == "null")
{
quot = "";
}
else
{
quot = "'";
}
sqlColNames.Append(seprator + data._colNames[i]);
if (data._colNames[i] == "issueAmount" || data._colNames[i] == "accumulatedVolumn")
{
sqlValues.Append(seprator + quot + "10000*" + data._values[i].ToString().Trim() + quot);
}
else
{
sqlValues.Append(seprator + quot + data._values[i].ToString().Trim() + quot);
}
}
sqlColNames.Append(seprator + "CREDATE");
sqlValues.Append(seprator + "to_date('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-mm-dd hh24:mi:ss')");
string sql = "INSERT INTO " + data._tabName + "(RIC," + sqlColNames + ")"
+ " VALUES('" + data._ric + "', " + sqlValues + ")";
data._bulkSqlStatments.Append(sql);
data._values.Clear();
data.setRic(null);
}
private void ProcessMarketPrice(RespMsg respMsg)
{
Console.WriteLine("<- Received Market Price " + respMsg.RespType.ToString());
// ==========================================================================
// Display AttribInfo
if ((respMsg.HintMask & RespMsg.HintMaskFlag.AttribInfo) != 0)
{
if ((respMsg.AttribInfo.HintMask & AttribInfo.HintMaskFlag.ServiceName) != 0)
{
Console.WriteLine("Service name: " + respMsg.AttribInfo.ServiceName.ToString());
}
if ((respMsg.AttribInfo.HintMask & AttribInfo.HintMaskFlag.Name) != 0)
{
Console.WriteLine("Symbol name: " + respMsg.AttribInfo.Name.ToString());
}
}
// ==========================================================================
// Decode Payload
if ((respMsg.HintMask & RespMsg.HintMaskFlag.Payload) != 0)
{
_responseRic = respMsg.AttribInfo.Name.ToString();
Data payload = respMsg.Payload;
if (payload.DataType == DataEnum.FieldList)
{
FieldList fieldList = payload as FieldList;
//Console.WriteLine("FieldList's entry count: " + fieldList.StandardDataCount);
var currentRicType =
_rics.Where(re => re.Ric == respMsg.AttribInfo.Name.ToString()).Select(re => re.Rictype).First();
OpenMarketOperation bs = new OpenMarketOperation(_fids.Where(re => re.Rictype == currentRicType).Select(re => re.TabName).First());
bs.setRic(respMsg.AttribInfo.Name.ToString());
if (fieldList != null)
{
foreach (FieldEntry fieldEntry in fieldList)
{
var fieldId = fieldEntry.FieldID;
try
{
RDMFidDef fidDef = _rdmFieldDictionary.GetFidDef(fieldId);
Data dataEntry = fieldEntry.GetData(fidDef.OMMType);
if (dataEntry.DataType == DataEnum.DataBuffer)
{
if (!_currentFids.Contains(fidDef.Name.ToString()))
{
continue;
}
DataBuffer dataBuffer = dataEntry as DataBuffer;
//Console.Write("\tFieldEntry: {0,-10} {1,-8}\t", fidDef.Name, "(" + fieldId + ")");
if (dataBuffer != null)
{
string fidValue = dataBuffer.GetAsString().ToString();
//Console.WriteLine(fidValue);
var fid =
_fids.First(re => re.Rictype == currentRicType && re.FidName == fidDef.Name);
string colName = fid.ColName;
if (fid.ColName.ToUpper() == "BONDLOCALNAME")
{
RMTESConverter conv = new RMTESConverter();
conv.SetBuffer(dataBuffer.GetBuffer());
// For refresh msg display
fidValue = ToSimplifiedChinese(conv.ToString());
}
if (colName != null)
{
bs.getColIdx(colName);
}
bs.appendColNames(fid.ColName, fid.ColType);
if (fid.ColType == "DATE")
{
fidValue = string.IsNullOrEmpty(fidValue) ? "null" : fidValue.Replace(' ', '-');
}
else if (fid.ColType == "FLOAT")
{
fidValue = string.IsNullOrEmpty(fidValue) ? "0" : float.Parse(fidValue).ToString(CultureInfo.InvariantCulture);
}
else if (fid.ColType == "INT")
{
fidValue = string.IsNullOrEmpty(fidValue) ? "0" : Convert.ToInt32(fidValue).ToString();
}
bs.appendValues(fidValue);
}
}
if (_responseRic == _requestRic)
{
CtrlBreakHandler.SetTerminated(true);
}
}
catch (InvalidUsageException)
{
}
}
}
ExecuteSqlByRicType(currentRicType, bs);
}
}
}
