public static XQt1531OutBlock[] ListFromQuery(XQt1531 query) { int count = query.GetBlockCount(XQt1531OutBlock.BlockName); List <XQt1531OutBlock> list = new List <XQt1531OutBlock>(); if (query.QueryResult != null && query.QueryResult.IsSystemError == true) { return(list.ToArray()); } for (int i = 0; i < count; i++) { XQt1531OutBlock block = new XQt1531OutBlock(); block.IsValidData = true; block.InvalidReason = ""; try { block.tmname = query.GetFieldData(block.GetBlockName(), "tmname", i).TrimEnd('?'); // char 36 block.avgdiff = query.GetFieldData(block.GetBlockName(), "avgdiff", i).ParseFloat("avgdiff"); // float 6.2 block.tmcode = query.GetFieldData(block.GetBlockName(), "tmcode", i).TrimEnd('?'); // char 4 } catch (InvalidDataFormatException e) { block.IsValidData = false; block.InvalidReason = $"FieldName == {e.DataFieldName}, FieldData == \"{e.DataValue}\""; } list.Add(block); } return(list.ToArray()); }
public static XQt1531OutBlock[] ReadFromDB(string tableNamePostfix = null /*, string tmname = default,string tmcode = default */) { using (XQt1531 instance = new XQt1531()) { string tableName = (tableNamePostfix == null) ? "XQt1531OutBlock" : $"XQt1531OutBlock_{tableNamePostfix}"; QueryOption qo = new QueryOption(tableName); // if (tmname != default) qo.Add("tmname", tmname); // if (tmcode != default) qo.Add("tmcode", tmcode); var outBlock = instance.SelectMany <XQt1531OutBlock>(qo); return(outBlock); } }
public static XQt1531OutBlock[] Get(string tmname = default, string tmcode = default) { using (XQt1531 instance = new XQt1531()) { instance.SetFieldData(XQt1531InBlock.BlockName, XQt1531InBlock.F.tmname, 0, tmname); // char 36 instance.SetFieldData(XQt1531InBlock.BlockName, XQt1531InBlock.F.tmcode, 0, tmcode); // char 4 if (instance.Request() < 0) { return(null); } var outBlock = instance.GetBlocks(); return(outBlock); } }