public DataSet GetGroupList()
{
string strsql = @"SELECT * FROM V_SYS_GROUPLIST";
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.GetData(strsql));
}
public DataSet FindGroupByGroupName(string groupname)
{
SysGroupDao GroupDao = new SysGroupDao();
string strsql = "select * from sys_GroupList where groupname='" + groupname + "'";
return(GroupDao.GetData(strsql));
}
/////////////////
public DataSet GetWESModules()
{
string sql = "select distinct(ModuleCode) ,MenuTitle from sys_ModuleList m left join sys_Menu n on m.ModuleCode=n.MenuCode where n.SystemName='WES' order by ModuleCode";
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.GetData(sql));
}
/// <summary>
/// 获取组操作模块的ID
/// </summary>
/// <param name="GroupID"></param>
/// <returns></returns>
public DataSet GetGroupOperation(int GroupID)
{
string sql = "select ModuleID from sys_GroupOperationList where GroupID=" + GroupID;
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.GetData(sql));
}
}
public DataSet GetWESSubModules()
{
string sql = "select distinct(N.ID),MenuTitle,m.SubModuleCode,MenuParent,ModuleCode from sys_ModuleList m left join sys_Menu n on m.SubModuleCode=n.MenuCode where n.SystemName='WES' order by m.SubModuleCode";
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.GetData(sql));
}
}
/// <summary>
/// 获取系统操作项
/// </summary>
/// <returns></returns>
public DataSet GetSystemOperations()
{
string sql = "select SubModuleName,SubModuleCode,OperatorDescription,ModuleID from sys_ModuleList order by SubModuleCode";
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.GetData(sql));
}
}
public DataSet GetSystemSubModules(string SystemName)
{
string sql = string.Format("select distinct(N.ID),MenuTitle,m.SubModuleCode,MenuParent,ModuleCode,n.OrderIndex from sys_ModuleList m left join sys_Menu n on m.SubModuleCode=n.MenuCode where SystemName='{0}' order by n.OrderIndex, m.SubModuleCode", SystemName);
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.GetData(sql));
}
}
public DataSet GetSystemModules(string SystemName)
{
string sql = string.Format("select distinct(ModuleCode) ,MenuTitle from sys_ModuleList m left join sys_Menu n on m.ModuleCode=n.MenuCode where n.SystemName='{0}' order by ModuleCode", SystemName);
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.GetData(sql));
}
}
/// <summary>
/// 获取系统一级模块
/// </summary>
/// <returns></returns>
public DataSet GetSystemModules()
{
string sql = "select distinct(ModuleCode) ,MenuTitle from sys_ModuleList m left join sys_Menu n on m.ModuleCode=n.MenuCode order by ModuleCode";
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.GetData(sql));
}
}
public DataSet GetWESOperations()
{
string sql = @"select SubModuleName,SubModuleCode,OperatorDescription,ModuleID
from sys_ModuleList
where ModuleCode in
(select MenuCode from sys_Menu where SystemName='WES')
order by SubModuleCode";
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.GetData(sql));
}
}
public DataSet GetGroupOperationWithWES(int GroupID)
{
string sql = @"select * from sys_GroupOperationList
where GroupID=" + GroupID + @" and ModuleID in
(select ModuleID from sys_ModuleList
where ModuleCode in
(select MenuCode as ModuleCode
from sys_Menu where SystemName='WES'))";
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.GetData(sql));
}
}
/// <summary>
/// 组操作菜单
/// </summary>
/// <param name="GroupID"></param>
/// <returns></returns>
public DataSet GetGroupRole(int GroupID, string SystemName)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
string sql = "select distinct(SubModuleCode),n.SystemName,m.ModuleID,OperatorCode,n.MenuCode,n.MenuTitle,n.MenuParent,n.MenuUrl,n.MenuImage,n2.MenuImage as ParentImage,n.OrderIndex" +
" from sys_GroupOperationList o " +
" left join sys_ModuleList m on m.ModuleID=o.ModuleID " +
" left join sys_GroupList g on g.GroupID=o.GroupID " +
" left join sys_UserLIst u on u.GroupID=g.GroupID " +
" left join sys_Menu n on n.MenuCode=m.SubModuleCode" +
" left join sys_Menu n2 on n2.MenuCode=substring(n.MenuCode,1,8)" +
" where g.GroupID=" + GroupID + "and n.SystemName='" + SystemName + "'" +
" order by n.OrderIndex, SubModuleCode ";
return(GroupDao.GetData(sql));
}
}