public static XQt1105OutBlock FromQuery(XQt1105 query)
{
XQt1105OutBlock block = new XQt1105OutBlock();
block.IsValidData = true;
block.InvalidReason = "";
if (query.QueryResult != null && query.QueryResult.IsSystemError == true)
{
block.IsValidData = false;
block.InvalidReason = query.ReceiveMessage;
return(block);
}
try
{
block.shcode = query.GetFieldData(block.GetBlockName(), "shcode", 0).TrimEnd('?'); // char 6
block.pbot = query.GetFieldData(block.GetBlockName(), "pbot", 0).ParseLong("pbot"); // long 8
block.offer1 = query.GetFieldData(block.GetBlockName(), "offer1", 0).ParseLong("offer1"); // long 8
block.supp1 = query.GetFieldData(block.GetBlockName(), "supp1", 0).ParseLong("supp1"); // long 8
block.offer2 = query.GetFieldData(block.GetBlockName(), "offer2", 0).ParseLong("offer2"); // long 8
block.supp2 = query.GetFieldData(block.GetBlockName(), "supp2", 0).ParseLong("supp2"); // long 8
block.stdprc = query.GetFieldData(block.GetBlockName(), "stdprc", 0).ParseLong("stdprc"); // long 8
block.offerd = query.GetFieldData(block.GetBlockName(), "offerd", 0).ParseLong("offerd"); // long 8
block.suppd = query.GetFieldData(block.GetBlockName(), "suppd", 0).ParseLong("suppd"); // long 8
} catch (InvalidDataFormatException e) {
block.IsValidData = false;
block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\"";
}
return(block);
}
public static XQt1105OutBlock ReadFromDB(string tableNamePostfix = null /*, string shcode = default */)
{
using (XQt1105 instance = new XQt1105())
{
string tableName = (tableNamePostfix == null) ? "XQt1105OutBlock" : $"XQt1105OutBlock_{tableNamePostfix}";
QueryOption qo = new QueryOption(tableName);
// if (shcode != default) qo.Add("shcode", shcode);
var outBlock = instance.Select <XQt1105OutBlock>(qo);
return(outBlock);
}
}
public static XQt1105OutBlock Get(string shcode = default)
{
using (XQt1105 instance = new XQt1105())
{
instance.SetFieldData(XQt1105InBlock.BlockName, XQt1105InBlock.F.shcode, 0, shcode); // char 6
if (instance.Request() < 0)
{
return(null);
}
var outBlock = instance.GetBlock();
if (outBlock.IsValidData == false)
{
return(null);
}
return(outBlock);
}
}
