public static XQAllOutBlocks Get(string focode = default, char bgubun = default, int nmin = default, string etime = default, char hgubun = default, int cnt = default, string cts_time = default)
{
using (XQt2405 instance = new XQt2405())
{
instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.F.focode, 0, focode); // char 8
instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.F.bgubun, 0, bgubun.ToString()); // char 1
instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.F.nmin, 0, nmin.ToString("d2")); // int 2
instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.F.etime, 0, etime); // char 4
instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.F.hgubun, 0, hgubun.ToString()); // char 1
instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.F.cnt, 0, cnt.ToString("d3")); // int 3
instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.F.cts_time, 0, cts_time); // char 6
if (instance.Request() < 0)
{
return(null);
}
XQAllOutBlocks results = new XQAllOutBlocks();
results.OutBlock = instance.GetBlock();
if (results.OutBlock.IsValidData == false)
{
return(null);
}
results.OutBlock1 = instance.GetBlock1s();
return(results);
}
}
public static XQt2405OutBlock FromQuery(XQt2405 query)
{
XQt2405OutBlock block = new XQt2405OutBlock();
block.IsValidData = true;
block.InvalidReason = "";
if (query.QueryResult != null && query.QueryResult.IsSystemError == true)
{
block.IsValidData = false;
block.InvalidReason = query.ReceiveMessage;
return(block);
}
try
{
block.mdvolume = query.GetFieldData(block.GetBlockName(), "mdvolume", 0).ParseDouble("mdvolume"); // double 12.0
block.mdchecnt = query.GetFieldData(block.GetBlockName(), "mdchecnt", 0).ParseLong("mdchecnt"); // long 8
block.msvolume = query.GetFieldData(block.GetBlockName(), "msvolume", 0).ParseDouble("msvolume"); // double 12.0
block.mschecnt = query.GetFieldData(block.GetBlockName(), "mschecnt", 0).ParseLong("mschecnt"); // long 8
block.cts_time = query.GetFieldData(block.GetBlockName(), "cts_time", 0).TrimEnd('?'); // char 6
} catch (InvalidDataFormatException e) {
block.IsValidData = false;
block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\"";
}
return(block);
}
public static XQAllOutBlocks ReadFromDB(string tableNamePostfix = null /*, string focode = default,char bgubun = default,int nmin = default,string etime = default,char hgubun = default,int cnt = default,string cts_time = default */)
{
using (XQt2405 instance = new XQt2405())
{
XQAllOutBlocks results = new XQAllOutBlocks();
string tableName = (tableNamePostfix == null) ? "XQt2405OutBlock" : $"XQt2405OutBlock_{tableNamePostfix}";
QueryOption qo = new QueryOption(tableName);
results.OutBlock = instance.Select <XQt2405OutBlock>(qo);
tableName = (tableNamePostfix == null) ? "XQt2405OutBlock1" : $"XQt2405OutBlock1_{tableNamePostfix}";
qo = new QueryOption(tableName);
results.OutBlock1 = instance.SelectMany <XQt2405OutBlock1>(qo);
return(results);
}
}
public static XQt2405OutBlock1[] ListFromQuery(XQt2405 query)
{
int count = query.GetBlockCount(XQt2405OutBlock1.BlockName);
List <XQt2405OutBlock1> list = new List <XQt2405OutBlock1>();
if (query.QueryResult != null && query.QueryResult.IsSystemError == true)
{
return(list.ToArray());
}
for (int i = 0; i < count; i++)
{
XQt2405OutBlock1 block = new XQt2405OutBlock1();
block.IsValidData = true;
block.InvalidReason = "";
try
{
block.time = query.GetFieldData(block.GetBlockName(), "time", i).TrimEnd('?'); // char 6
block.price = query.GetFieldData(block.GetBlockName(), "price", i).ParseFloat("price"); // float 6.2
block.sign = query.GetFieldData(block.GetBlockName(), "sign", i).FirstOrDefault(); // char 1
block.change = query.GetFieldData(block.GetBlockName(), "change", i).ParseFloat("change"); // float 6.2
block.volume = query.GetFieldData(block.GetBlockName(), "volume", i).ParseDouble("volume"); // double 12.0
block.cvolume = query.GetFieldData(block.GetBlockName(), "cvolume", i).ParseLong("cvolume"); // long 8
block.offerho1 = query.GetFieldData(block.GetBlockName(), "offerho1", i).ParseFloat("offerho1"); // float 6.2
block.bidho1 = query.GetFieldData(block.GetBlockName(), "bidho1", i).ParseFloat("bidho1"); // float 6.2
block.offerrem = query.GetFieldData(block.GetBlockName(), "offerrem", i).ParseLong("offerrem"); // long 8
block.bidrem = query.GetFieldData(block.GetBlockName(), "bidrem", i).ParseLong("bidrem"); // long 8
block.offercnt = query.GetFieldData(block.GetBlockName(), "offercnt", i).ParseLong("offercnt"); // long 8
block.bidcnt = query.GetFieldData(block.GetBlockName(), "bidcnt", i).ParseLong("bidcnt"); // long 8
block.c_offerrem = query.GetFieldData(block.GetBlockName(), "c_offerrem", i).ParseLong("c_offerrem"); // long 8
block.c_bidrem = query.GetFieldData(block.GetBlockName(), "c_bidrem", i).ParseLong("c_bidrem"); // long 8
block.c_offercnt = query.GetFieldData(block.GetBlockName(), "c_offercnt", i).ParseLong("c_offercnt"); // long 8
block.c_bidcnt = query.GetFieldData(block.GetBlockName(), "c_bidcnt", i).ParseLong("c_bidcnt"); // long 8
block.r_bidrem = query.GetFieldData(block.GetBlockName(), "r_bidrem", i).ParseFloat("r_bidrem"); // float 6.2
block.r_bidcnt = query.GetFieldData(block.GetBlockName(), "r_bidcnt", i).ParseFloat("r_bidcnt"); // float 6.2
block.r_sign = query.GetFieldData(block.GetBlockName(), "r_sign", i).FirstOrDefault(); // char 1
block.date = query.GetFieldData(block.GetBlockName(), "date", i).TrimEnd('?'); // date 8
} catch (InvalidDataFormatException e) {
block.IsValidData = false;
block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\"";
}
list.Add(block);
}
return(list.ToArray());
}
