Example #1
0
        public static XQt1717OutBlock[] ListFromQuery(XQt1717 query)
        {
            int count = query.GetBlockCount(XQt1717OutBlock.BlockName);
            List <XQt1717OutBlock> list = new List <XQt1717OutBlock>();

            if (query.QueryResult != null && query.QueryResult.IsSystemError == true)
            {
                return(list.ToArray());
            }
            for (int i = 0; i < count; i++)
            {
                XQt1717OutBlock block = new XQt1717OutBlock();
                block.IsValidData   = true;
                block.InvalidReason = "";
                try
                {
                    block.date        = query.GetFieldData(block.GetBlockName(), "date", i).TrimEnd('?');                    // char 8
                    block.close       = query.GetFieldData(block.GetBlockName(), "close", i).ParseLong("close");             // 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.tjj0000_vol = query.GetFieldData(block.GetBlockName(), "tjj0000_vol", i).ParseLong("tjj0000_vol"); // long 12
                    block.tjj0001_vol = query.GetFieldData(block.GetBlockName(), "tjj0001_vol", i).ParseLong("tjj0001_vol"); // long 12
                    block.tjj0002_vol = query.GetFieldData(block.GetBlockName(), "tjj0002_vol", i).ParseLong("tjj0002_vol"); // long 12
                    block.tjj0003_vol = query.GetFieldData(block.GetBlockName(), "tjj0003_vol", i).ParseLong("tjj0003_vol"); // long 12
                    block.tjj0004_vol = query.GetFieldData(block.GetBlockName(), "tjj0004_vol", i).ParseLong("tjj0004_vol"); // long 12
                    block.tjj0005_vol = query.GetFieldData(block.GetBlockName(), "tjj0005_vol", i).ParseLong("tjj0005_vol"); // long 12
                    block.tjj0006_vol = query.GetFieldData(block.GetBlockName(), "tjj0006_vol", i).ParseLong("tjj0006_vol"); // long 12
                    block.tjj0007_vol = query.GetFieldData(block.GetBlockName(), "tjj0007_vol", i).ParseLong("tjj0007_vol"); // long 12
                    block.tjj0008_vol = query.GetFieldData(block.GetBlockName(), "tjj0008_vol", i).ParseLong("tjj0008_vol"); // long 12
                    block.tjj0009_vol = query.GetFieldData(block.GetBlockName(), "tjj0009_vol", i).ParseLong("tjj0009_vol"); // long 12
                    block.tjj0010_vol = query.GetFieldData(block.GetBlockName(), "tjj0010_vol", i).ParseLong("tjj0010_vol"); // long 12
                    block.tjj0011_vol = query.GetFieldData(block.GetBlockName(), "tjj0011_vol", i).ParseLong("tjj0011_vol"); // long 12
                    block.tjj0018_vol = query.GetFieldData(block.GetBlockName(), "tjj0018_vol", i).ParseLong("tjj0018_vol"); // long 12
                    block.tjj0016_vol = query.GetFieldData(block.GetBlockName(), "tjj0016_vol", i).ParseLong("tjj0016_vol"); // long 12
                    block.tjj0017_vol = query.GetFieldData(block.GetBlockName(), "tjj0017_vol", i).ParseLong("tjj0017_vol"); // long 12
                    block.tjj0000_dan = query.GetFieldData(block.GetBlockName(), "tjj0000_dan", i).ParseLong("tjj0000_dan"); // long 12
                    block.tjj0001_dan = query.GetFieldData(block.GetBlockName(), "tjj0001_dan", i).ParseLong("tjj0001_dan"); // long 12
                    block.tjj0002_dan = query.GetFieldData(block.GetBlockName(), "tjj0002_dan", i).ParseLong("tjj0002_dan"); // long 12
                    block.tjj0003_dan = query.GetFieldData(block.GetBlockName(), "tjj0003_dan", i).ParseLong("tjj0003_dan"); // long 12
                    block.tjj0004_dan = query.GetFieldData(block.GetBlockName(), "tjj0004_dan", i).ParseLong("tjj0004_dan"); // long 12
                    block.tjj0005_dan = query.GetFieldData(block.GetBlockName(), "tjj0005_dan", i).ParseLong("tjj0005_dan"); // long 12
                    block.tjj0006_dan = query.GetFieldData(block.GetBlockName(), "tjj0006_dan", i).ParseLong("tjj0006_dan"); // long 12
                    block.tjj0007_dan = query.GetFieldData(block.GetBlockName(), "tjj0007_dan", i).ParseLong("tjj0007_dan"); // long 12
                    block.tjj0008_dan = query.GetFieldData(block.GetBlockName(), "tjj0008_dan", i).ParseLong("tjj0008_dan"); // long 12
                    block.tjj0009_dan = query.GetFieldData(block.GetBlockName(), "tjj0009_dan", i).ParseLong("tjj0009_dan"); // long 12
                    block.tjj0010_dan = query.GetFieldData(block.GetBlockName(), "tjj0010_dan", i).ParseLong("tjj0010_dan"); // long 12
                    block.tjj0011_dan = query.GetFieldData(block.GetBlockName(), "tjj0011_dan", i).ParseLong("tjj0011_dan"); // long 12
                    block.tjj0018_dan = query.GetFieldData(block.GetBlockName(), "tjj0018_dan", i).ParseLong("tjj0018_dan"); // long 12
                    block.tjj0016_dan = query.GetFieldData(block.GetBlockName(), "tjj0016_dan", i).ParseLong("tjj0016_dan"); // long 12
                    block.tjj0017_dan = query.GetFieldData(block.GetBlockName(), "tjj0017_dan", i).ParseLong("tjj0017_dan"); // long 12
                } catch (InvalidDataFormatException e) {
                    block.IsValidData   = false;
                    block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\"";
                }
                list.Add(block);
            }
            return(list.ToArray());
        }
Example #2
0
        public static XQt1717OutBlock[] ReadFromDB(string tableNamePostfix = null /*, string shcode = default,char gubun = default,string fromdt = default,string todt = default */)
        {
            using (XQt1717 instance = new XQt1717())
            {
                string      tableName = (tableNamePostfix == null) ? "XQt1717OutBlock" : $"XQt1717OutBlock_{tableNamePostfix}";
                QueryOption qo        = new QueryOption(tableName);
                // if (shcode != default) qo.Add("shcode", shcode);
                // if (gubun != default) qo.Add("gubun", gubun);
                // if (fromdt != default) qo.Add("fromdt", fromdt);
                // if (todt != default) qo.Add("todt", todt);


                var outBlock = instance.SelectMany <XQt1717OutBlock>(qo);
                return(outBlock);
            }
        }
Example #3
0
        public static XQt1717OutBlock[] Get(string shcode = default, char gubun = default, string fromdt = default, string todt = default)
        {
            using (XQt1717 instance = new XQt1717())
            {
                instance.SetFieldData(XQt1717InBlock.BlockName, XQt1717InBlock.F.shcode, 0, shcode);             // char 6
                instance.SetFieldData(XQt1717InBlock.BlockName, XQt1717InBlock.F.gubun, 0, gubun.ToString());    // char 1
                instance.SetFieldData(XQt1717InBlock.BlockName, XQt1717InBlock.F.fromdt, 0, fromdt);             // char 8
                instance.SetFieldData(XQt1717InBlock.BlockName, XQt1717InBlock.F.todt, 0, todt);                 // char 8

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

                var outBlock = instance.GetBlocks();
                return(outBlock);
            }
        }