public static XQt2801OutBlock FromQuery(XQt2801 query)
{
XQt2801OutBlock block = new XQt2801OutBlock();
block.IsValidData = true;
block.InvalidReason = "";
if (query.QueryResult != null && query.QueryResult.IsSystemError == true)
{
block.IsValidData = false;
block.InvalidReason = query.ReceiveMessage;
return(block);
}
try
{
block.hname = query.GetFieldData(block.GetBlockName(), "hname", 0).TrimEnd('?'); // char 20
block.price = query.GetFieldData(block.GetBlockName(), "price", 0).ParseFloat("price"); // float 6.2
block.sign = query.GetFieldData(block.GetBlockName(), "sign", 0).FirstOrDefault(); // char 1
block.change = query.GetFieldData(block.GetBlockName(), "change", 0).ParseFloat("change"); // float 6.2
block.jnilclose = query.GetFieldData(block.GetBlockName(), "jnilclose", 0).ParseFloat("jnilclose"); // float 6.2
block.diff = query.GetFieldData(block.GetBlockName(), "diff", 0).ParseFloat("diff"); // float 6.2
block.volume = query.GetFieldData(block.GetBlockName(), "volume", 0).ParseLong("volume"); // long 12
block.value = query.GetFieldData(block.GetBlockName(), "value", 0).ParseLong("value"); // long 12
block.mgjv = query.GetFieldData(block.GetBlockName(), "mgjv", 0).ParseLong("mgjv"); // long 8
block.mgjvdiff = query.GetFieldData(block.GetBlockName(), "mgjvdiff", 0).ParseLong("mgjvdiff"); // long 8
block.open = query.GetFieldData(block.GetBlockName(), "open", 0).ParseFloat("open"); // float 6.2
block.high = query.GetFieldData(block.GetBlockName(), "high", 0).ParseFloat("high"); // float 6.2
block.low = query.GetFieldData(block.GetBlockName(), "low", 0).ParseFloat("low"); // float 6.2
block.uplmtprice = query.GetFieldData(block.GetBlockName(), "uplmtprice", 0).ParseFloat("uplmtprice"); // float 6.2
block.dnlmtprice = query.GetFieldData(block.GetBlockName(), "dnlmtprice", 0).ParseFloat("dnlmtprice"); // float 6.2
block.high52w = query.GetFieldData(block.GetBlockName(), "high52w", 0).ParseFloat("high52w"); // float 6.2
block.low52w = query.GetFieldData(block.GetBlockName(), "low52w", 0).ParseFloat("low52w"); // float 6.2
block.basis = query.GetFieldData(block.GetBlockName(), "basis", 0).ParseFloat("basis"); // float 6.2
block.recprice = query.GetFieldData(block.GetBlockName(), "recprice", 0).ParseFloat("recprice"); // float 6.2
block.theoryprice = query.GetFieldData(block.GetBlockName(), "theoryprice", 0).ParseFloat("theoryprice"); // float 6.2
block.glyl = query.GetFieldData(block.GetBlockName(), "glyl", 0).ParseFloat("glyl"); // float 6.3
block.cbhprice = query.GetFieldData(block.GetBlockName(), "cbhprice", 0).ParseFloat("cbhprice"); // float 6.2
block.cblprice = query.GetFieldData(block.GetBlockName(), "cblprice", 0).ParseFloat("cblprice"); // float 6.2
block.lastmonth = query.GetFieldData(block.GetBlockName(), "lastmonth", 0).TrimEnd('?'); // char 8
block.jandatecnt = query.GetFieldData(block.GetBlockName(), "jandatecnt", 0).ParseLong("jandatecnt"); // long 8
block.pricejisu = query.GetFieldData(block.GetBlockName(), "pricejisu", 0).ParseFloat("pricejisu"); // float 6.2
block.jisusign = query.GetFieldData(block.GetBlockName(), "jisusign", 0).FirstOrDefault(); // char 1
block.jisuchange = query.GetFieldData(block.GetBlockName(), "jisuchange", 0).ParseFloat("jisuchange"); // float 6.2
block.jisudiff = query.GetFieldData(block.GetBlockName(), "jisudiff", 0).ParseFloat("jisudiff"); // float 6.2
block.kospijisu = query.GetFieldData(block.GetBlockName(), "kospijisu", 0).ParseFloat("kospijisu"); // float 6.2
block.kospisign = query.GetFieldData(block.GetBlockName(), "kospisign", 0).FirstOrDefault(); // char 1
block.kospichange = query.GetFieldData(block.GetBlockName(), "kospichange", 0).ParseFloat("kospichange"); // float 6.2
block.kospidiff = query.GetFieldData(block.GetBlockName(), "kospidiff", 0).ParseFloat("kospidiff"); // float 6.2
block.listhprice = query.GetFieldData(block.GetBlockName(), "listhprice", 0).ParseFloat("listhprice"); // float 6.2
block.listlprice = query.GetFieldData(block.GetBlockName(), "listlprice", 0).ParseFloat("listlprice"); // float 6.2
block.sbasis = query.GetFieldData(block.GetBlockName(), "sbasis", 0).ParseFloat("sbasis"); // float 6.2
block.ibasis = query.GetFieldData(block.GetBlockName(), "ibasis", 0).ParseFloat("ibasis"); // float 6.2
block.jnilvolume = query.GetFieldData(block.GetBlockName(), "jnilvolume", 0).ParseLong("jnilvolume"); // long 12
block.jnilvalue = query.GetFieldData(block.GetBlockName(), "jnilvalue", 0).ParseLong("jnilvalue"); // long 12
} catch (InvalidDataFormatException e) {
block.IsValidData = false;
block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\"";
}
return(block);
}
public static XQt2801OutBlock ReadFromDB(string tableNamePostfix = null /*, string focode = default */)
{
using (XQt2801 instance = new XQt2801())
{
string tableName = (tableNamePostfix == null) ? "XQt2801OutBlock" : $"XQt2801OutBlock_{tableNamePostfix}";
QueryOption qo = new QueryOption(tableName);
// if (focode != default) qo.Add("focode", focode);
var outBlock = instance.Select <XQt2801OutBlock>(qo);
return(outBlock);
}
}
public static XQt2801OutBlock Get(string focode = default)
{
using (XQt2801 instance = new XQt2801())
{
instance.SetFieldData(XQt2801InBlock.BlockName, XQt2801InBlock.F.focode, 0, focode); // char 8
if (instance.Request() < 0)
{
return(null);
}
var outBlock = instance.GetBlock();
if (outBlock.IsValidData == false)
{
return(null);
}
return(outBlock);
}
}
