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