public static XQt1926OutBlock ReadFromDB(string tableNamePostfix = null /*, string shcode = default */)
{
using (XQt1926 instance = new XQt1926())
{
string tableName = (tableNamePostfix == null) ? "XQt1926OutBlock" : $"XQt1926OutBlock_{tableNamePostfix}";
QueryOption qo = new QueryOption(tableName);
// if (shcode != default) qo.Add("shcode", shcode);
var outBlock = instance.Select <XQt1926OutBlock>(qo);
return(outBlock);
}
}
public static XQt1926OutBlock FromQuery(XQt1926 query)
{
XQt1926OutBlock block = new XQt1926OutBlock();
block.IsValidData = true;
block.InvalidReason = "";
if (query.QueryResult != null && query.QueryResult.IsSystemError == true)
{
block.IsValidData = false;
block.InvalidReason = query.ReceiveMessage;
return(block);
}
try
{
block.ynvolume = query.GetFieldData(block.GetBlockName(), "ynvolume", 0).ParseLong("ynvolume"); // long 8
block.ysvolume = query.GetFieldData(block.GetBlockName(), "ysvolume", 0).ParseLong("ysvolume"); // long 8
block.yjvolume = query.GetFieldData(block.GetBlockName(), "yjvolume", 0).ParseLong("yjvolume"); // long 8
block.yvchange = query.GetFieldData(block.GetBlockName(), "yvchange", 0).ParseLong("yvchange"); // long 8
block.ygrate = query.GetFieldData(block.GetBlockName(), "ygrate", 0).ParseFloat("ygrate"); // float 9.2
block.yjrate = query.GetFieldData(block.GetBlockName(), "yjrate", 0).ParseFloat("yjrate"); // float 9.2
block.ynprice = query.GetFieldData(block.GetBlockName(), "ynprice", 0).ParseLong("ynprice"); // long 8
block.ysprice = query.GetFieldData(block.GetBlockName(), "ysprice", 0).ParseLong("ysprice"); // long 8
block.yjprice = query.GetFieldData(block.GetBlockName(), "yjprice", 0).ParseLong("yjprice"); // long 8
block.yachange = query.GetFieldData(block.GetBlockName(), "yachange", 0).ParseLong("yachange"); // long 8
block.dnvolume = query.GetFieldData(block.GetBlockName(), "dnvolume", 0).ParseLong("dnvolume"); // long 8
block.dsvolume = query.GetFieldData(block.GetBlockName(), "dsvolume", 0).ParseLong("dsvolume"); // long 8
block.djvolume = query.GetFieldData(block.GetBlockName(), "djvolume", 0).ParseLong("djvolume"); // long 8
block.dvchange = query.GetFieldData(block.GetBlockName(), "dvchange", 0).ParseLong("dvchange"); // long 8
block.dgrate = query.GetFieldData(block.GetBlockName(), "dgrate", 0).ParseFloat("dgrate"); // float 9.2
block.djrate = query.GetFieldData(block.GetBlockName(), "djrate", 0).ParseFloat("djrate"); // float 9.2
block.dnprice = query.GetFieldData(block.GetBlockName(), "dnprice", 0).ParseLong("dnprice"); // long 8
block.dsprice = query.GetFieldData(block.GetBlockName(), "dsprice", 0).ParseLong("dsprice"); // long 8
block.djprice = query.GetFieldData(block.GetBlockName(), "djprice", 0).ParseLong("djprice"); // long 8
block.dachange = query.GetFieldData(block.GetBlockName(), "dachange", 0).ParseLong("dachange"); // long 8
block.mmdate = query.GetFieldData(block.GetBlockName(), "mmdate", 0).TrimEnd('?'); // char 8
block.close = query.GetFieldData(block.GetBlockName(), "close", 0).ParseLong("close"); // long 8
block.volume = query.GetFieldData(block.GetBlockName(), "volume", 0).ParseLong("volume"); // long 10
block.value = query.GetFieldData(block.GetBlockName(), "value", 0).ParseLong("value"); // long 12
block.pr5days = query.GetFieldData(block.GetBlockName(), "pr5days", 0).ParseFloat("pr5days"); // float 9.2
block.pr20days = query.GetFieldData(block.GetBlockName(), "pr20days", 0).ParseFloat("pr20days"); // float 9.2
block.yj5days = query.GetFieldData(block.GetBlockName(), "yj5days", 0).ParseFloat("yj5days"); // float 9.2
block.yj20days = query.GetFieldData(block.GetBlockName(), "yj20days", 0).ParseFloat("yj20days"); // float 9.2
block.dj5days = query.GetFieldData(block.GetBlockName(), "dj5days", 0).ParseFloat("dj5days"); // float 9.2
block.dj20days = query.GetFieldData(block.GetBlockName(), "dj20days", 0).ParseFloat("dj20days"); // float 9.2
} catch (InvalidDataFormatException e) {
block.IsValidData = false;
block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\"";
}
return(block);
}
public static XQt1926OutBlock Get(string shcode = default)
{
using (XQt1926 instance = new XQt1926())
{
instance.SetFieldData(XQt1926InBlock.BlockName, XQt1926InBlock.F.shcode, 0, shcode); // char 6
if (instance.Request() < 0)
{
return(null);
}
var outBlock = instance.GetBlock();
if (outBlock.IsValidData == false)
{
return(null);
}
return(outBlock);
}
}
