예제 #1
0
        public IEnumerable <DalTag> GetAll(string filter = "")
        {
            var result = new List <DalTag>();

            var data = _adapterHelper.GetAll(filter);

            for (var i = 0; i < data.Tables[0].Rows.Count; ++i)
            {
                var dataRow = data.Tables[0].Rows[i].ItemArray;
                result.Add(new DalTag(int.Parse(dataRow[0].ToString()), dataRow[1].ToString(), int.Parse(dataRow[2].ToString())));
            }

            return(result);
        }
예제 #2
0
        public IEnumerable <DalDashboardFilterRelation> GetAll(string filter = "")
        {
            var result = new List <DalDashboardFilterRelation>();

            var data = _adapterHelper.GetAll(filter);

            for (var i = 0; i < data.Tables[0].Rows.Count; ++i)
            {
                var dataRow = data.Tables[0].Rows[i].ItemArray;
                result.Add(new DalDashboardFilterRelation(int.Parse(dataRow[0].ToString()), int.Parse(dataRow[1].ToString()), dataRow[2] != DBNull.Value ? int.Parse(dataRow[2].ToString()) : (int?)null, dataRow[3] != DBNull.Value ? int.Parse(dataRow[3].ToString()) : (int?)null, (bool)dataRow[4], int.Parse(dataRow[5].ToString())));
            }

            return(result);
        }
예제 #3
0
        public IEnumerable <DalOperation> GetAll(string filter = "")
        {
            var result = new List <DalOperation>();

            var data = _adapterHelper.GetAll(filter);

            for (var i = 0; i < data.Tables[0].Rows.Count; ++i)
            {
                var dataRow  = data.Tables[0].Rows[i].ItemArray;
                var parentId = int.TryParse(dataRow[1].ToString(), out var tempVal) ? tempVal : (int?)null;

                result.Add(new DalOperation(int.Parse(dataRow[0].ToString()), parentId, int.Parse(dataRow[2].ToString()), dataRow[3].ToString(), decimal.Parse(dataRow[4].ToString()), int.Parse(dataRow[6].ToString()), int.Parse(dataRow[5].ToString()), int.Parse(dataRow[7].ToString()), int.Parse(dataRow[8].ToString()), dataRow[9].ToString(), dataRow[10].ToString()));
            }

            return(result);
        }