public static XQt0167OutBlock ReadFromDB(string tableNamePostfix = null /*, string id = default */)
{
using (XQt0167 instance = new XQt0167())
{
string tableName = (tableNamePostfix == null) ? "XQt0167OutBlock" : $"XQt0167OutBlock_{tableNamePostfix}";
QueryOption qo = new QueryOption(tableName);
// if (id != default) qo.Add("id", id);
var outBlock = instance.Select <XQt0167OutBlock>(qo);
return(outBlock);
}
}
public static XQt0167OutBlock Get(string id = default)
{
using (XQt0167 instance = new XQt0167())
{
instance.SetFieldData(XQt0167InBlock.BlockName, XQt0167InBlock.F.id, 0, id); // char 8
if (instance.Request() < 0)
{
return(null);
}
var outBlock = instance.GetBlock();
if (outBlock.IsValidData == false)
{
return(null);
}
return(outBlock);
}
}
public static XQt0167OutBlock FromQuery(XQt0167 query)
{
XQt0167OutBlock block = new XQt0167OutBlock();
block.IsValidData = true;
block.InvalidReason = "";
if (query.QueryResult != null && query.QueryResult.IsSystemError == true)
{
block.IsValidData = false;
block.InvalidReason = query.ReceiveMessage;
return(block);
}
try
{
block.dt = query.GetFieldData(block.GetBlockName(), "dt", 0).TrimEnd('?'); // char 8
block.time = query.GetFieldData(block.GetBlockName(), "time", 0).TrimEnd('?'); // char 12
} catch (InvalidDataFormatException e) {
block.IsValidData = false;
block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\"";
}
return(block);
}
