public List <Role> GetRolesByRoleIdAndDelFlag(int role_id, int delFlag = 0)
        {
            string sql = "SELECT [Id] ,[Name],[System_manage],[Speciality_manage],[Class_manage],[Course_manage],[Score_manage],[Student_manage],[Remark],[Submitter_id],[DelFlag] FROM [dbo].[RoleInfo] where [DelFlag]=" + delFlag + " and Id like '%" + role_id + "%'";

            using (SqlDataReader reader = SqlserverHelper.ExecuteReader(sql))
            {
                List <Role> list = new List <Role>();
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        list.Add(ReaderToRole(reader));
                    }
                }
                return(list);
            }
        }
        public List <Role> GetAllRoleInfoByDelFlag(int delflag)
        {
            //"select * from RoleInfo";
            string sql = "SELECT [Id] ,[Name],[System_manage],[Speciality_manage],[Class_manage],[Course_manage],[Score_manage],[Student_manage],[Remark],[Submitter_id],[DelFlag] FROM [dbo].[RoleInfo] where [DelFlag]=" + delflag;

            using (SqlDataReader reader = SqlserverHelper.ExecuteReader(sql))
            {
                List <Role> list = new List <Role>();
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        list.Add(ReaderToRole(reader));
                    }
                }
                return(list);
            }
        }