public static XQAllOutBlocks Get(char kind = default, string symbol = default, long cnt = default, char jgbn = default, long nmin = default, string cts_date = default, string cts_time = default) { using (XQt3518 instance = new XQt3518()) { instance.SetFieldData(XQt3518InBlock.BlockName, XQt3518InBlock.F.kind, 0, kind.ToString()); // char 1 instance.SetFieldData(XQt3518InBlock.BlockName, XQt3518InBlock.F.symbol, 0, symbol); // char 16 instance.SetFieldData(XQt3518InBlock.BlockName, XQt3518InBlock.F.cnt, 0, cnt.ToString("d4")); // long 4 instance.SetFieldData(XQt3518InBlock.BlockName, XQt3518InBlock.F.jgbn, 0, jgbn.ToString()); // char 1 instance.SetFieldData(XQt3518InBlock.BlockName, XQt3518InBlock.F.nmin, 0, nmin.ToString("d3")); // long 3 instance.SetFieldData(XQt3518InBlock.BlockName, XQt3518InBlock.F.cts_date, 0, cts_date); // char 8 instance.SetFieldData(XQt3518InBlock.BlockName, XQt3518InBlock.F.cts_time, 0, cts_time); // char 6 if (instance.Request() < 0) { return(null); } XQAllOutBlocks results = new XQAllOutBlocks(); results.OutBlock = instance.GetBlock(); if (results.OutBlock.IsValidData == false) { return(null); } results.OutBlock1 = instance.GetBlock1s(); return(results); } }
public static XQAllOutBlocks ReadFromDB(string tableNamePostfix = null /*, char kind = default,string symbol = default,long cnt = default,char jgbn = default,long nmin = default,string cts_date = default,string cts_time = default */) { using (XQt3518 instance = new XQt3518()) { XQAllOutBlocks results = new XQAllOutBlocks(); string tableName = (tableNamePostfix == null) ? "XQt3518OutBlock" : $"XQt3518OutBlock_{tableNamePostfix}"; QueryOption qo = new QueryOption(tableName); results.OutBlock = instance.Select <XQt3518OutBlock>(qo); tableName = (tableNamePostfix == null) ? "XQt3518OutBlock1" : $"XQt3518OutBlock1_{tableNamePostfix}"; qo = new QueryOption(tableName); results.OutBlock1 = instance.SelectMany <XQt3518OutBlock1>(qo); return(results); } }
public static XQt3518OutBlock1[] ListFromQuery(XQt3518 query) { int count = query.GetBlockCount(XQt3518OutBlock1.BlockName); List <XQt3518OutBlock1> list = new List <XQt3518OutBlock1>(); if (query.QueryResult != null && query.QueryResult.IsSystemError == true) { return(list.ToArray()); } for (int i = 0; i < count; i++) { XQt3518OutBlock1 block = new XQt3518OutBlock1(); block.IsValidData = true; block.InvalidReason = ""; try { block.date = query.GetFieldData(block.GetBlockName(), "date", i).TrimEnd('?'); // char 8 block.time = query.GetFieldData(block.GetBlockName(), "time", i).TrimEnd('?'); // char 8 block.open = query.GetFieldData(block.GetBlockName(), "open", i).ParseDouble("open"); // double 9.4 block.high = query.GetFieldData(block.GetBlockName(), "high", i).ParseDouble("high"); // double 9.4 block.low = query.GetFieldData(block.GetBlockName(), "low", i).ParseDouble("low"); // double 9.4 block.price = query.GetFieldData(block.GetBlockName(), "price", i).ParseDouble("price"); // double 9.4 block.sign = query.GetFieldData(block.GetBlockName(), "sign", i).FirstOrDefault(); // char 1 block.change = query.GetFieldData(block.GetBlockName(), "change", i).ParseDouble("change"); // double 9.4 block.uprate = query.GetFieldData(block.GetBlockName(), "uprate", i).ParseDouble("uprate"); // double 9.4 block.volume = query.GetFieldData(block.GetBlockName(), "volume", i).ParseDouble("volume"); // double 12.0 block.bidho = query.GetFieldData(block.GetBlockName(), "bidho", i).ParseDouble("bidho"); // double 9.4 block.offerho = query.GetFieldData(block.GetBlockName(), "offerho", i).ParseDouble("offerho"); // double 9.4 block.bidrem = query.GetFieldData(block.GetBlockName(), "bidrem", i).ParseDouble("bidrem"); // double 12.0 block.offerrem = query.GetFieldData(block.GetBlockName(), "offerrem", i).ParseDouble("offerrem"); // double 12.0 block.kind = query.GetFieldData(block.GetBlockName(), "kind", i).FirstOrDefault(); // char 1 block.symbol = query.GetFieldData(block.GetBlockName(), "symbol", i).TrimEnd('?'); // char 16 block.exid = query.GetFieldData(block.GetBlockName(), "exid", i).TrimEnd('?'); // char 4 block.kodate = query.GetFieldData(block.GetBlockName(), "kodate", i).TrimEnd('?'); // char 8 block.kotime = query.GetFieldData(block.GetBlockName(), "kotime", i).TrimEnd('?'); // char 8 } catch (InvalidDataFormatException e) { block.IsValidData = false; block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\""; } list.Add(block); } return(list.ToArray()); }
public static XQt3518OutBlock FromQuery(XQt3518 query) { XQt3518OutBlock block = new XQt3518OutBlock(); block.IsValidData = true; block.InvalidReason = ""; if (query.QueryResult != null && query.QueryResult.IsSystemError == true) { block.IsValidData = false; block.InvalidReason = query.ReceiveMessage; return(block); } try { block.cts_date = query.GetFieldData(block.GetBlockName(), "cts_date", 0).TrimEnd('?'); // char 8 block.cts_time = query.GetFieldData(block.GetBlockName(), "cts_time", 0).TrimEnd('?'); // char 6 } catch (InvalidDataFormatException e) { block.IsValidData = false; block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\""; } return(block); }