コード例 #1
0
        private static LookUp3Col MapLookUp3Col(IDataReader reader)
        {
            LookUp3Col lookUp = new LookUp3Col();
            int        idx    = 0;

            lookUp.Id   = reader.GetSafeInt32(idx++);
            lookUp.Code = reader.GetSafeString(idx++);
            lookUp.Name = reader.GetSafeString(idx++);

            return(lookUp);
        }
コード例 #2
0
        public List <LookUp3Col> GetLookUp3Col(string tableName)
        {
            List <LookUp3Col> list     = null;
            string            procName = $"[dbo].[{tableName}_SelectAll]";

            _data.ExecuteCmd(procName, inputParamMapper : null, singleRecordMapper : delegate(IDataReader reader, short set)
            {
                LookUp3Col lookUp = MapLookUp3Col(reader);

                if (list == null)
                {
                    list = new List <LookUp3Col>();
                }

                list.Add(lookUp);
            });
            return(list);
        }