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); } }