예제 #1
0
        public IList<Core.Business.ActionList> GetAllActionList()
        {
            IList<Core.Business.ActionList> actionListlist = new List<Core.Business.ActionList>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllActionList);

            if(reader != null)
            {
                while(reader.Read())
                {
                    Core.Business.ActionList actionList = new Core.Business.ActionList();

                    if (!reader.IsDBNull(0)) actionList.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) actionList.ActionName = reader.GetString(1);

                    actionList.MarkOld();
                    actionListlist.Add(actionList);
                }
                reader.Close();
            }
            return actionListlist;
        }