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()); }