public DataSet FindGroupByGroupName(string groupname)
{
SysGroupDao GroupDao = new SysGroupDao();
string strsql = "select * from sys_GroupList where groupname='" + groupname + "'";
return(GroupDao.GetData(strsql));
}
public DataSet GetGroupList()
{
string strsql = @"SELECT * FROM V_SYS_GROUPLIST";
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.GetData(strsql));
}
public void UpdateGroupByGroupName(string groupname, string memo)
{
SysGroupDao GroupDao = new SysGroupDao();
string strsql = "UPDATE sys_GroupList set memo='" + memo + "' where groupname='" + groupname + "'";
GroupDao.SetData(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));
}
public void AddNewGroup(string groupname, string memo)
{
SysGroupDao GroupDao = new SysGroupDao();
string strsql = "insert sys_GroupList (groupname,memo,state) values ('" + groupname + "','" + memo + "',1)";
GroupDao.SetData(strsql);
}
public DataSet GetGroupList(int pageIndex, int pageSize, string filter, string OrderByFields)
{
using (THOK.Util.PersistentManager pm = new THOK.Util.PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.QueryGroup(strTableView, strPrimaryKey, strQueryFields, pageIndex, pageSize, OrderByFields, filter, strTableView));
}
}
public DataSet GetSystemSubModules()
{
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao groupDao = new SysGroupDao();
return(groupDao.FindSystemSubModules());
}
}
public int GetGroupMemberCount(int groupID)
{
using (PersistentManager pm = new PersistentManager())
{
SysGroupDao groupDao = new SysGroupDao();
return(groupDao.FindGroupMemberCount(groupID));
}
}
public int GetCount(string filter)
{
using (PersistentManager pm = new PersistentManager())
{
SysGroupDao groupDao = new SysGroupDao();
return(groupDao.FindCount(filter));
}
}
public DataTable GetAll()
{
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao groupDao = new SysGroupDao();
return(groupDao.FindAll());
}
}
public string GetNavigation(string menuCode)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao groupDao = new SysGroupDao();
return(groupDao.FindNavigation(menuCode));
}
}
public DataSet GetGroupRole(int groupID)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao groupDao = new SysGroupDao();
return(groupDao.FindRole(groupID));
}
}
public void InsertGroupOperation(int groupID, string moduleID)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao groupDao = new SysGroupDao();
groupDao.InsertGroupOperation(groupID, moduleID);
}
}
public void DeleteGroupOperation(int groupID)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao groupDao = new SysGroupDao();
groupDao.DeleteGroupOperation(groupID);
}
}
public DataSet GetAll(int pageIndex, int pageSize, string filter)
{
using (PersistentManager pm = new PersistentManager())
{
SysGroupDao groupDao = new SysGroupDao();
return(groupDao.FindAll((pageIndex - 1) * pageSize, pageSize, filter));
}
}
public DataSet GetSystemOperations()
{
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao groupDal = new SysGroupDao();
return(groupDal.FindSystemOperation());
}
}
public int GetGroupMemberCount(int GroupID)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.GetGroupMemberCount(GroupID));
}
}
public int GetRemindRowCount(string TableName, string filter)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
return(GroupDao.GetRowCount(TableName, filter));
}
}
public void DeleteGroupByGroupID(string groupid)
{
SysGroupDao GroupDao = new SysGroupDao();
string strsql = "DELETE FROM sys_GroupList where groupid =" + groupid;
GroupDao.SetData(strsql);
strsql = "DELETE FROM sys_UserList where groupid =" + groupid;
GroupDao.SetData(strsql);
}
/// <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));
}
}
/// <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 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));
}
}
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));
}
}
/// <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 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));
}
}
public bool SetGroupOperation(string sql)
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
GroupDao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Delete(DataSet dataSet)
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
SysGroupDao GroupDao = new SysGroupDao();
GroupDao.DeleteEntity(dataSet);
flag = true;
}
return(flag);
}
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));
}
}
