public static XQt1964OutBlock1[] Get(string item = default, string issuercd = default, string lastmonth = default, char elwopt = default, char atmgubun = default, string elwtype = default, string settletype = default, char elwexecgubun = default, string fromrat = default, string torat = default, string volume = default)
{
using (XQt1964 instance = new XQt1964())
{
instance.SetFieldData(XQt1964InBlock.BlockName, XQt1964InBlock.F.item, 0, item); // char 12
instance.SetFieldData(XQt1964InBlock.BlockName, XQt1964InBlock.F.issuercd, 0, issuercd); // char 12
instance.SetFieldData(XQt1964InBlock.BlockName, XQt1964InBlock.F.lastmonth, 0, lastmonth); // char 6
instance.SetFieldData(XQt1964InBlock.BlockName, XQt1964InBlock.F.elwopt, 0, elwopt.ToString()); // char 1
instance.SetFieldData(XQt1964InBlock.BlockName, XQt1964InBlock.F.atmgubun, 0, atmgubun.ToString()); // char 1
instance.SetFieldData(XQt1964InBlock.BlockName, XQt1964InBlock.F.elwtype, 0, elwtype); // char 2
instance.SetFieldData(XQt1964InBlock.BlockName, XQt1964InBlock.F.settletype, 0, settletype); // char 2
instance.SetFieldData(XQt1964InBlock.BlockName, XQt1964InBlock.F.elwexecgubun, 0, elwexecgubun.ToString()); // char 1
instance.SetFieldData(XQt1964InBlock.BlockName, XQt1964InBlock.F.fromrat, 0, fromrat); // char 5
instance.SetFieldData(XQt1964InBlock.BlockName, XQt1964InBlock.F.torat, 0, torat); // char 5
instance.SetFieldData(XQt1964InBlock.BlockName, XQt1964InBlock.F.volume, 0, volume); // char 12
if (instance.Request() < 0)
{
return(null);
}
var outBlock = instance.GetBlock1s();
return(outBlock);
}
}
public static XQt1964OutBlock1[] ReadFromDB(string tableNamePostfix = null /*, string item = default,string issuercd = default,string lastmonth = default,char elwopt = default,char atmgubun = default,string elwtype = default,string settletype = default,char elwexecgubun = default,string fromrat = default,string torat = default,string volume = default */)
{
using (XQt1964 instance = new XQt1964())
{
string tableName = (tableNamePostfix == null) ? "XQt1964OutBlock1" : $"XQt1964OutBlock1_{tableNamePostfix}";
QueryOption qo = new QueryOption(tableName);
// if (item != default) qo.Add("item", item);
// if (issuercd != default) qo.Add("issuercd", issuercd);
// if (lastmonth != default) qo.Add("lastmonth", lastmonth);
// if (elwopt != default) qo.Add("elwopt", elwopt);
// if (atmgubun != default) qo.Add("atmgubun", atmgubun);
// if (elwtype != default) qo.Add("elwtype", elwtype);
// if (settletype != default) qo.Add("settletype", settletype);
// if (elwexecgubun != default) qo.Add("elwexecgubun", elwexecgubun);
// if (fromrat != default) qo.Add("fromrat", fromrat);
// if (torat != default) qo.Add("torat", torat);
// if (volume != default) qo.Add("volume", volume);
var outBlock = instance.SelectMany <XQt1964OutBlock1>(qo);
return(outBlock);
}
}
public static XQt1964OutBlock1[] ListFromQuery(XQt1964 query)
{
int count = query.GetBlockCount(XQt1964OutBlock1.BlockName);
List <XQt1964OutBlock1> list = new List <XQt1964OutBlock1>();
if (query.QueryResult != null && query.QueryResult.IsSystemError == true)
{
return(list.ToArray());
}
for (int i = 0; i < count; i++)
{
XQt1964OutBlock1 block = new XQt1964OutBlock1();
block.IsValidData = true;
block.InvalidReason = "";
try
{
block.shcode = query.GetFieldData(block.GetBlockName(), "shcode", i).TrimEnd('?'); // char 6
block.hname = query.GetFieldData(block.GetBlockName(), "hname", i).TrimEnd('?'); // char 40
block.item1 = query.GetFieldData(block.GetBlockName(), "item1", i).TrimEnd('?'); // char 6
block.itemnm = query.GetFieldData(block.GetBlockName(), "itemnm", i).TrimEnd('?'); // char 20
block.issuernmk = query.GetFieldData(block.GetBlockName(), "issuernmk", i).TrimEnd('?'); // char 40
block.elwopt = query.GetFieldData(block.GetBlockName(), "elwopt", i).TrimEnd('?'); // char 4
block.price = query.GetFieldData(block.GetBlockName(), "price", i).ParseLong("price"); // long 8
block.sign = query.GetFieldData(block.GetBlockName(), "sign", i).FirstOrDefault(); // char 1
block.change = query.GetFieldData(block.GetBlockName(), "change", i).ParseLong("change"); // long 8
block.diff = query.GetFieldData(block.GetBlockName(), "diff", i).ParseFloat("diff"); // float 6.2
block.volume = query.GetFieldData(block.GetBlockName(), "volume", i).ParseLong("volume"); // long 12
block.elwexec = query.GetFieldData(block.GetBlockName(), "elwexec", i).ParseFloat("elwexec"); // float 10.2
block.jandatecnt = query.GetFieldData(block.GetBlockName(), "jandatecnt", i).ParseLong("jandatecnt"); // long 8
block.convrate = query.GetFieldData(block.GetBlockName(), "convrate", i).ParseFloat("convrate"); // float 8.4
block.lastdate = query.GetFieldData(block.GetBlockName(), "lastdate", i).TrimEnd('?'); // char 8
block.mmsdate = query.GetFieldData(block.GetBlockName(), "mmsdate", i).TrimEnd('?'); // char 8
block.payday = query.GetFieldData(block.GetBlockName(), "payday", i).TrimEnd('?'); // char 8
block.listing = query.GetFieldData(block.GetBlockName(), "listing", i).ParseLong("listing"); // long 8
block.atmgbnm = query.GetFieldData(block.GetBlockName(), "atmgbnm", i).TrimEnd('?'); // char 10
block.parity = query.GetFieldData(block.GetBlockName(), "parity", i).ParseFloat("parity"); // float 6.2
block.preminum = query.GetFieldData(block.GetBlockName(), "preminum", i).ParseFloat("preminum"); // float 10.2
block.spread = query.GetFieldData(block.GetBlockName(), "spread", i).ParseFloat("spread"); // float 3.2
block.berate = query.GetFieldData(block.GetBlockName(), "berate", i).ParseFloat("berate"); // float 6.2
block.capt = query.GetFieldData(block.GetBlockName(), "capt", i).ParseFloat("capt"); // float 6.2
block.gearing = query.GetFieldData(block.GetBlockName(), "gearing", i).ParseFloat("gearing"); // float 6.2
block.egearing = query.GetFieldData(block.GetBlockName(), "egearing", i).ParseFloat("egearing"); // float 6.2
block.itemprice = query.GetFieldData(block.GetBlockName(), "itemprice", i).ParseLong("itemprice"); // long 8
block.itemsign = query.GetFieldData(block.GetBlockName(), "itemsign", i).FirstOrDefault(); // char 1
block.itemchange = query.GetFieldData(block.GetBlockName(), "itemchange", i).ParseLong("itemchange"); // long 8
block.itemdiff = query.GetFieldData(block.GetBlockName(), "itemdiff", i).ParseFloat("itemdiff"); // float 6.2
block.itemvolume = query.GetFieldData(block.GetBlockName(), "itemvolume", i).ParseLong("itemvolume"); // long 12
block.jnilvolume = query.GetFieldData(block.GetBlockName(), "jnilvolume", i).ParseLong("jnilvolume"); // long 12
block.theoryprice = query.GetFieldData(block.GetBlockName(), "theoryprice", i).ParseFloat("theoryprice"); // float 10.2
block.lp_rate = query.GetFieldData(block.GetBlockName(), "lp_rate", i).ParseFloat("lp_rate"); // float 5.2
block.impv = query.GetFieldData(block.GetBlockName(), "impv", i).ParseFloat("impv"); // float 6.2
block.delta = query.GetFieldData(block.GetBlockName(), "delta", i).ParseFloat("delta"); // float 10.6
block.theta = query.GetFieldData(block.GetBlockName(), "theta", i).ParseFloat("theta"); // float 10.6
} catch (InvalidDataFormatException e) {
block.IsValidData = false;
block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\"";
}
list.Add(block);
}
return(list.ToArray());
}
