/// <summary> /// 获取用户所具有角色列表 /// </summary> /// <param name="user"></param> /// <returns></returns> public DataTable GetRoleTable(string userid) { Database db1 = DatabaseFactory.Create("LZBgAuthorityConn"); StringBuilder str = new StringBuilder(); str.Append(" select distinct ARole.* from roleuser RUser "); str.Append(" left join role ARole on ARole.Rl_id = RUser.Rl_id "); str.Append(" where RUser.Ur_id = '" + userid + "' "); str.Append(" and Rl_state = 0 and Rl_del = 0 "); SqlDao ddc = db1.CreateSqlDao(str.ToString()); return(ddc.ExecTable()); }
/// <summary> /// 根据用户ID获取用户所具有的平台数据 /// </summary> /// <param name="user"></param> /// <returns></returns> public DataTable GetPlatformTableByUserid(string userid) { Database db1 = DatabaseFactory.Create("LZBgAuthorityConn"); StringBuilder str = new StringBuilder(); str.Append(" select distinct APlatform.Pf_id,APlatform.Pf_name, APlatform.Pf_imgUrl, APlatform.Pf_imgWaterUrl, APlatform.Pf_addUser, APlatform.Pf_addTime, APlatform.Pf_state, APlatform.Pf_del, APlatform.Pf_isRepair, APlatform.Pf_newFunction, APlatform.Pf_newEndTime, APlatform.Pf_isNewShow, APlatform.Pf_sort, APlatform.Pf_text1, APlatform.Pf_text2 from roleuser RUser ");//, ARole.Rl_id,RUser.Rl_id str.Append(" left join role ARole on ARole.Rl_id = RUser.Rl_id "); str.Append(" left join platform APlatform on APlatform.Pf_id = ARole.Pf_id "); str.Append(" where RUser.Ur_id = '" + userid + "' and APlatform.Pf_del = 0 and APlatform.Pf_state = 0 order by APlatform.Pf_sort asc"); SqlDao ddc = db1.CreateSqlDao(str.ToString()); return(ddc.ExecTable()); }
/// <summary> /// 根据角色ID 查询用户所具有的的游戏列表 /// </summary> /// <param name="user"></param> /// <returns></returns> public DataTable GetGameListByRoleId(string roleid) { Database db1 = DatabaseFactory.Create("LZBgAuthorityConn"); StringBuilder str = new StringBuilder(); str.Append(" select distinct gm.Gm_name,gm.Gm_gameId,cn.Cn_channelId,cn.Cn_name from Game gm "); str.Append(" inner join rolegame rg on "); str.Append(" rg.Gm_id = gm.Gm_id "); str.Append(" inner join channel cn "); str.Append(" on gm.Cn_channelId = cn.Cn_id "); str.Append(" where " + roleid + " "); str.Append(" order by gm.Gm_name "); SqlDao ddc = db1.CreateSqlDao(str.ToString()); return(ddc.ExecTable()); }
public DataTable GetModuleTableByUseridForMenu(string userid, string platformid) { Database db1 = DatabaseFactory.Create("LZBgAuthorityConn"); StringBuilder str = new StringBuilder(); str.Append(" select distinct AModule.* from roleuser RUser "); str.Append(" left join role ARole on ARole.Rl_id = RUser.Rl_id "); str.Append(" left join rolemodule RModule on RModule.Rl_id = ARole.Rl_id "); str.Append(" left join module AModule on AModule.Md_id = RModule.Md_id "); str.Append(" where RUser.Ur_id = '" + userid + "' "); if (platformid != "") { str.Append(" and AModule.Pf_id = '" + platformid + "' "); } str.Append(" and Md_deleteFlag = 0 and Md_useFlag = 0 and AModule.Md_existsTreeView = 0 "); SqlDao ddc = db1.CreateSqlDao(str.ToString()); return(ddc.ExecTable()); }
/// <summary> /// 根据用户ID 和模块ID 查询模块具有的功能 /// </summary> /// <param name="user"></param> /// <returns></returns> public DataTable GetPermissionsNameByUseridModouleid(string userid, string moduleid) { Database db1 = DatabaseFactory.Create("LZBgAuthorityConn"); StringBuilder str = new StringBuilder(); str.Append(" select APermiss.Pm_name from roleuser ARoleUser "); str.Append(" inner join users AUser on "); str.Append(" AUser.Ur_id = ARoleUser.Ur_id "); str.Append(" inner join rolemodule ARoleMod on "); str.Append(" ARoleMod.Rl_id = ARoleUser.Rl_id "); str.Append(" inner join permissionstatal APermissTat on "); str.Append(" APermissTat.Pt_id = ARoleMod.Pt_id "); str.Append(" inner join permissionstatalp APermissTatP on "); str.Append(" APermissTatP.Pt_id = APermissTat.Pt_id "); str.Append(" inner join permissions APermiss on "); str.Append(" APermiss.Pm_Id = APermissTatP.Pm_id "); str.Append(" where AUser.Ur_id ='" + userid + "' "); str.Append(" and ARoleMod.Md_id = '" + moduleid + "' "); SqlDao ddc = db1.CreateSqlDao(str.ToString()); return(ddc.ExecTable()); }