/// <summary>
/// 获取角色权限详细列表(增删改查导出打印详细分开)
/// </summary>
/// <param name="strsql"></param>
/// <returns></returns>
public static DataTable GetRolesJurisdictionDetailList(string strRole)
{
try
{
string strSql = "select a.ID,Role,b.Explain, left(PowerString,1) as 'Add', right(left(PowerString,2),1) as 'Delete', right(left(PowerString,3),1) as 'Edit', right(left(PowerString,4),1) as 'select', right(left(PowerString,5),1) as 'Export', right(left(PowerString,6),1) as 'Print', Activate from RolesJurisdiction a inner join PaperInfo b on a.PaperInfoID=b.ID where Role like '%" + strRole + "%'";
return(DBHandle.Getdt(strSql));
}
catch (Exception exc)
{
//异常处理
return(null);
}
}
/// <summary>
/// 获取角色权限列表
/// </summary>
/// <param name="strsql"></param>
/// <returns></returns>
public static DataTable GetRolesJurisdictionList(string strRole)
{
try
{
string strSql = "select a.ID,Role,b.Explain,left(PowerString,6) as PowerString,Activate from RolesJurisdiction a inner join PaperInfo b on a.PaperInfoID=b.ID where Role like '%" + strRole + "%'";
return(DBHandle.Getdt(strSql));
}
catch (Exception exc)
{
//异常处理
return(null);
}
}