public static XQAllOutBlocks Get(string focode = default, char bgubun = default, int nmin = default, string etime = default, char hgubun = default, int cnt = default, string cts_time = default) { using (XQt2405 instance = new XQt2405()) { instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.F.focode, 0, focode); // char 8 instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.F.bgubun, 0, bgubun.ToString()); // char 1 instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.F.nmin, 0, nmin.ToString("d2")); // int 2 instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.F.etime, 0, etime); // char 4 instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.F.hgubun, 0, hgubun.ToString()); // char 1 instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.F.cnt, 0, cnt.ToString("d3")); // int 3 instance.SetFieldData(XQt2405InBlock.BlockName, XQt2405InBlock.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 XQt2405OutBlock FromQuery(XQt2405 query) { XQt2405OutBlock block = new XQt2405OutBlock(); block.IsValidData = true; block.InvalidReason = ""; if (query.QueryResult != null && query.QueryResult.IsSystemError == true) { block.IsValidData = false; block.InvalidReason = query.ReceiveMessage; return(block); } try { block.mdvolume = query.GetFieldData(block.GetBlockName(), "mdvolume", 0).ParseDouble("mdvolume"); // double 12.0 block.mdchecnt = query.GetFieldData(block.GetBlockName(), "mdchecnt", 0).ParseLong("mdchecnt"); // long 8 block.msvolume = query.GetFieldData(block.GetBlockName(), "msvolume", 0).ParseDouble("msvolume"); // double 12.0 block.mschecnt = query.GetFieldData(block.GetBlockName(), "mschecnt", 0).ParseLong("mschecnt"); // long 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); }
public static XQAllOutBlocks ReadFromDB(string tableNamePostfix = null /*, string focode = default,char bgubun = default,int nmin = default,string etime = default,char hgubun = default,int cnt = default,string cts_time = default */) { using (XQt2405 instance = new XQt2405()) { XQAllOutBlocks results = new XQAllOutBlocks(); string tableName = (tableNamePostfix == null) ? "XQt2405OutBlock" : $"XQt2405OutBlock_{tableNamePostfix}"; QueryOption qo = new QueryOption(tableName); results.OutBlock = instance.Select <XQt2405OutBlock>(qo); tableName = (tableNamePostfix == null) ? "XQt2405OutBlock1" : $"XQt2405OutBlock1_{tableNamePostfix}"; qo = new QueryOption(tableName); results.OutBlock1 = instance.SelectMany <XQt2405OutBlock1>(qo); return(results); } }
public static XQt2405OutBlock1[] ListFromQuery(XQt2405 query) { int count = query.GetBlockCount(XQt2405OutBlock1.BlockName); List <XQt2405OutBlock1> list = new List <XQt2405OutBlock1>(); if (query.QueryResult != null && query.QueryResult.IsSystemError == true) { return(list.ToArray()); } for (int i = 0; i < count; i++) { XQt2405OutBlock1 block = new XQt2405OutBlock1(); block.IsValidData = true; block.InvalidReason = ""; try { block.time = query.GetFieldData(block.GetBlockName(), "time", i).TrimEnd('?'); // char 6 block.price = query.GetFieldData(block.GetBlockName(), "price", i).ParseFloat("price"); // float 6.2 block.sign = query.GetFieldData(block.GetBlockName(), "sign", i).FirstOrDefault(); // char 1 block.change = query.GetFieldData(block.GetBlockName(), "change", i).ParseFloat("change"); // float 6.2 block.volume = query.GetFieldData(block.GetBlockName(), "volume", i).ParseDouble("volume"); // double 12.0 block.cvolume = query.GetFieldData(block.GetBlockName(), "cvolume", i).ParseLong("cvolume"); // long 8 block.offerho1 = query.GetFieldData(block.GetBlockName(), "offerho1", i).ParseFloat("offerho1"); // float 6.2 block.bidho1 = query.GetFieldData(block.GetBlockName(), "bidho1", i).ParseFloat("bidho1"); // float 6.2 block.offerrem = query.GetFieldData(block.GetBlockName(), "offerrem", i).ParseLong("offerrem"); // long 8 block.bidrem = query.GetFieldData(block.GetBlockName(), "bidrem", i).ParseLong("bidrem"); // long 8 block.offercnt = query.GetFieldData(block.GetBlockName(), "offercnt", i).ParseLong("offercnt"); // long 8 block.bidcnt = query.GetFieldData(block.GetBlockName(), "bidcnt", i).ParseLong("bidcnt"); // long 8 block.c_offerrem = query.GetFieldData(block.GetBlockName(), "c_offerrem", i).ParseLong("c_offerrem"); // long 8 block.c_bidrem = query.GetFieldData(block.GetBlockName(), "c_bidrem", i).ParseLong("c_bidrem"); // long 8 block.c_offercnt = query.GetFieldData(block.GetBlockName(), "c_offercnt", i).ParseLong("c_offercnt"); // long 8 block.c_bidcnt = query.GetFieldData(block.GetBlockName(), "c_bidcnt", i).ParseLong("c_bidcnt"); // long 8 block.r_bidrem = query.GetFieldData(block.GetBlockName(), "r_bidrem", i).ParseFloat("r_bidrem"); // float 6.2 block.r_bidcnt = query.GetFieldData(block.GetBlockName(), "r_bidcnt", i).ParseFloat("r_bidcnt"); // float 6.2 block.r_sign = query.GetFieldData(block.GetBlockName(), "r_sign", i).FirstOrDefault(); // char 1 block.date = query.GetFieldData(block.GetBlockName(), "date", i).TrimEnd('?'); // date 8 } catch (InvalidDataFormatException e) { block.IsValidData = false; block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\""; } list.Add(block); } return(list.ToArray()); }