public DataSet GetAllUser()
{
string sql = "select UserName ,GroupName ,UserID from sys_UserList u left join sys_GroupList g on u.GroupID=g.GroupID ";
using (PersistentManager persistentManager = new PersistentManager())
{
SysUserDao UserDao = new SysUserDao();
return(UserDao.GetUser(sql));
}
}
public DataSet GetUserInfo(string UserName)
{
string sql = string.Format("select a.*," +
" d.sys_PageCount,d.grid_ColumnTitleFont,d.grid_ContentFont," +
" d.grid_ColumnTextAlign,d.grid_ContentTextAlign,d.grid_NumberColumnAlign," +
" d.grid_MoneyColumnAlign,d.grid_SelectMode,d.grid_OddRowColor," +
" d.grid_EvenRowColor,d.grid_IsRefreshBeforeAdd,d.grid_IsRefreshBeforeUpdate," +
" d.grid_IsRefreshBeforeDelete,d.sys_PrintForm,d.pager_ShowPageIndex," +
" e.ParameterValue as SessionTimeOut" +
" from sys_UserList a" +
" left join sys_UserConfigPlan b on a.UserID=b.UserID " +
" left join sys_ConfigPlan c on b.ConfigPlanID=c.ConfigPlanID " +
" left join sys_UserSysInfo d on a.UserID=d.UserID " +
" left join sys_SystemParameter e on e.ParameterName='sys_SessionTimeOut' " +
"where UserName='******'", UserName);
using (PersistentManager persistentManager = new PersistentManager())
{
SysUserDao UserDao = new SysUserDao();
return(UserDao.GetUser(sql));
}
}