Beispiel #1
0
        public static XQAllOutBlocks Get(char gubun = default, string styymm = default, string enyymm = default, long idx = default)
        {
            using (XQt1403 instance = new XQt1403())
            {
                instance.SetFieldData(XQt1403InBlock.BlockName, XQt1403InBlock.F.gubun, 0, gubun.ToString());        // char 1
                instance.SetFieldData(XQt1403InBlock.BlockName, XQt1403InBlock.F.styymm, 0, styymm);                 // char 6
                instance.SetFieldData(XQt1403InBlock.BlockName, XQt1403InBlock.F.enyymm, 0, enyymm);                 // char 6
                instance.SetFieldData(XQt1403InBlock.BlockName, XQt1403InBlock.F.idx, 0, idx.ToString("d4"));        // long 4

                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);
            }
        }
Beispiel #2
0
        public static XQAllOutBlocks ReadFromDB(string tableNamePostfix = null /*, char gubun = default,string styymm = default,string enyymm = default,long idx = default */)
        {
            using (XQt1403 instance = new XQt1403())
            {
                XQAllOutBlocks results = new XQAllOutBlocks();

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

                tableName         = (tableNamePostfix == null) ? "XQt1403OutBlock1" : $"XQt1403OutBlock1_{tableNamePostfix}";
                qo                = new QueryOption(tableName);
                results.OutBlock1 = instance.SelectMany <XQt1403OutBlock1>(qo);
                return(results);
            }
        }
Beispiel #3
0
        public static XQt1403OutBlock1[] Get(char gubun = default, string styymm = default, string enyymm = default, long idx = default)
        {
            using (XQt1403 instance = new XQt1403())
            {
                instance.SetFieldData(XQt1403InBlock.BlockName, XQt1403InBlock.F.gubun, 0, gubun.ToString());        // char 1
                instance.SetFieldData(XQt1403InBlock.BlockName, XQt1403InBlock.F.styymm, 0, styymm);                 // char 6
                instance.SetFieldData(XQt1403InBlock.BlockName, XQt1403InBlock.F.enyymm, 0, enyymm);                 // char 6
                instance.SetFieldData(XQt1403InBlock.BlockName, XQt1403InBlock.F.idx, 0, idx.ToString("d4"));        // long 4

                if (instance.Request() < 0)
                {
                    return(null);
                }

                var outBlock = instance.GetBlock1s();
                return(outBlock);
            }
        }
Beispiel #4
0
        public static XQt1403OutBlock FromQuery(XQt1403 query)
        {
            XQt1403OutBlock block = new XQt1403OutBlock();

            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);
        }
Beispiel #5
0
        public static XQt1403OutBlock1[] ListFromQuery(XQt1403 query)
        {
            int count = query.GetBlockCount(XQt1403OutBlock1.BlockName);
            List <XQt1403OutBlock1> list = new List <XQt1403OutBlock1>();

            if (query.QueryResult != null && query.QueryResult.IsSystemError == true)
            {
                return(list.ToArray());
            }
            for (int i = 0; i < count; i++)
            {
                XQt1403OutBlock1 block = new XQt1403OutBlock1();
                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.kmprice  = query.GetFieldData(block.GetBlockName(), "kmprice", i).ParseLong("kmprice");      // long 8
                    block.date     = query.GetFieldData(block.GetBlockName(), "date", i).TrimEnd('?');                 // char 8
                    block.recprice = query.GetFieldData(block.GetBlockName(), "recprice", i).ParseLong("recprice");    // long 8
                    block.kmdiff   = query.GetFieldData(block.GetBlockName(), "kmdiff", i).ParseFloat("kmdiff");       // float 6.2
                    block.close    = query.GetFieldData(block.GetBlockName(), "close", i).ParseLong("close");          // long 8
                    block.recdiff  = query.GetFieldData(block.GetBlockName(), "recdiff", i).ParseFloat("recdiff");     // float 6.2
                    block.shcode   = query.GetFieldData(block.GetBlockName(), "shcode", i).TrimEnd('?');               // char 6
                } catch (InvalidDataFormatException e) {
                    block.IsValidData   = false;
                    block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\"";
                }
                list.Add(block);
            }
            return(list.ToArray());
        }