Example #1
0
        public static XQAllOutBlocks Get(char gubun = default, char jnilgubun = default, long jc_num = default, long sprice = default, long eprice = default, long volume = default, long idx = default, long jc_num2 = default)
        {
            using (XQt1463 instance = new XQt1463())
            {
                instance.SetFieldData(XQt1463InBlock.BlockName, XQt1463InBlock.F.gubun, 0, gubun.ToString());                 // char 1
                instance.SetFieldData(XQt1463InBlock.BlockName, XQt1463InBlock.F.jnilgubun, 0, jnilgubun.ToString());         // char 1
                instance.SetFieldData(XQt1463InBlock.BlockName, XQt1463InBlock.F.jc_num, 0, jc_num.ToString("d12"));          // long 12
                instance.SetFieldData(XQt1463InBlock.BlockName, XQt1463InBlock.F.sprice, 0, sprice.ToString("d8"));           // long 8
                instance.SetFieldData(XQt1463InBlock.BlockName, XQt1463InBlock.F.eprice, 0, eprice.ToString("d8"));           // long 8
                instance.SetFieldData(XQt1463InBlock.BlockName, XQt1463InBlock.F.volume, 0, volume.ToString("d12"));          // long 12
                instance.SetFieldData(XQt1463InBlock.BlockName, XQt1463InBlock.F.idx, 0, idx.ToString("d4"));                 // long 4
                instance.SetFieldData(XQt1463InBlock.BlockName, XQt1463InBlock.F.jc_num2, 0, jc_num2.ToString("d12"));        // long 12

                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);
            }
        }
Example #2
0
        public static XQAllOutBlocks ReadFromDB(string tableNamePostfix = null /*, char gubun = default,char jnilgubun = default,long jc_num = default,long sprice = default,long eprice = default,long volume = default,long idx = default,long jc_num2 = default */)
        {
            using (XQt1463 instance = new XQt1463())
            {
                XQAllOutBlocks results = new XQAllOutBlocks();

                string      tableName = (tableNamePostfix == null) ? "XQt1463OutBlock" : $"XQt1463OutBlock_{tableNamePostfix}";
                QueryOption qo        = new QueryOption(tableName);
                results.OutBlock = instance.Select <XQt1463OutBlock>(qo);

                tableName         = (tableNamePostfix == null) ? "XQt1463OutBlock1" : $"XQt1463OutBlock1_{tableNamePostfix}";
                qo                = new QueryOption(tableName);
                results.OutBlock1 = instance.SelectMany <XQt1463OutBlock1>(qo);
                return(results);
            }
        }
Example #3
0
        public static XQt1463OutBlock FromQuery(XQt1463 query)
        {
            XQt1463OutBlock block = new XQt1463OutBlock();

            block.IsValidData   = true;
            block.InvalidReason = "";
            if (query.QueryResult != null && query.QueryResult.IsSystemError == true)
            {
                block.IsValidData   = false;
                block.InvalidReason = query.ReceiveMessage;
                return(block);
            }
            try
            {
                block.idx = query.GetFieldData(block.GetBlockName(), "idx", 0).ParseLong("idx");                 // long 4
            } catch (InvalidDataFormatException e) {
                block.IsValidData   = false;
                block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\"";
            }
            return(block);
        }
Example #4
0
        public static XQt1463OutBlock1[] ListFromQuery(XQt1463 query)
        {
            int count = query.GetBlockCount(XQt1463OutBlock1.BlockName);
            List <XQt1463OutBlock1> list = new List <XQt1463OutBlock1>();

            if (query.QueryResult != null && query.QueryResult.IsSystemError == true)
            {
                return(list.ToArray());
            }
            for (int i = 0; i < count; i++)
            {
                XQt1463OutBlock1 block = new XQt1463OutBlock1();
                block.IsValidData   = true;
                block.InvalidReason = "";
                try
                {
                    block.hname      = query.GetFieldData(block.GetBlockName(), "hname", i).TrimEnd('?');                 // char 20
                    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.value      = query.GetFieldData(block.GetBlockName(), "value", i).ParseLong("value");           // long 12
                    block.jnilvalue  = query.GetFieldData(block.GetBlockName(), "jnilvalue", i).ParseLong("jnilvalue");   // long 12
                    block.bef_diff   = query.GetFieldData(block.GetBlockName(), "bef_diff", i).ParseFloat("bef_diff");    // float 10.2
                    block.shcode     = query.GetFieldData(block.GetBlockName(), "shcode", i).TrimEnd('?');                // char 6
                    block.filler     = query.GetFieldData(block.GetBlockName(), "filler", i).FirstOrDefault();            // char 1
                    block.jnilvolume = query.GetFieldData(block.GetBlockName(), "jnilvolume", i).ParseLong("jnilvolume"); // long 12
                } catch (InvalidDataFormatException e) {
                    block.IsValidData   = false;
                    block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\"";
                }
                list.Add(block);
            }
            return(list.ToArray());
        }