public List<T_SYS_USERACTLOG> GetSysUseractLogWithPaging(int pageIndex, int pageSize, string sort, string filterString, IList<object> paras, ref int pageCount, LoginUserInfo loginUserInfo)
{
IQueryable<T_SYS_USERACTLOG> usList;
//string keyString = "GetSysUseractLogWithPaging" + loginUserInfo.userID + loginUserInfo.companyID; //缓存KEY
//if (WCFCache.Current[keyString] == null)
//{
usList = Useract.GetSysUseractLogWithPaging(pageIndex,pageSize,sort,filterString,paras,ref pageCount,loginUserInfo.userID);
// WCFCache.Current.Insert(keyString, usList);
//}
//else
//{
// usList = (IQueryable<T_SYS_USERACTLOG>)WCFCache.Current[keyString];
//}
return usList.Count() > 0 ? usList.ToList() : null;
}
public List<T_SYS_ENTITYMENU> GetSysMenuByTypePaging(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, LoginUserInfo loginUserInfo)
{
using (SysEntityMenuBLL bll = new SysEntityMenuBLL())
{
T_SYS_USER Userinfo = this.GetUserByEmployeeID(loginUserInfo.userID);
T_SYS_FBADMIN UserFb = null;
bool IsFbAdmin = false;//是否预算管理员
if (Userinfo != null)
{
UserFb = this.getFbAdmin(Userinfo.SYSUSERID);
}
if (UserFb != null)
{
IsFbAdmin = true;
}
IQueryable<T_SYS_ENTITYMENU> menuList = bll.GetSysMenuByTypeWithPaging(pageIndex, pageSize, sort, filterString, paras, ref pageCount, loginUserInfo.userID, IsFbAdmin);
return menuList !=null ? menuList.ToList() : null;
}
}
public List<T_SYS_ROLE> GetRoleInfosByUser(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, string flagState, LoginUserInfo loginUserInfo)//0待审核 1已审核
{
SysRoleBLL roleBll = new SysRoleBLL();
//using (ApprovalManagementBll approvalBll = new ApprovalManagementBll())
//{
if (flagState != "4")//草稿,审核完成(已过,未过) 建立人操作
{
IQueryable<T_SYS_ROLE> approvalList = roleBll.GetUserRoleByUser(pageIndex, pageSize, sort, filterString, paras, ref pageCount, loginUserInfo.userID, null, flagState);
if (approvalList == null)
{
return null;
}
else
{
return approvalList.ToList();
}
}
else//审批人
{
//SMT.SaaS.BLLCommonServices.BllCommonUserPermissionWS.BllCommonPermissionServicesClient ServiceClient = new BLLCommonServices.BllCommonUserPermissionWS.BllCommonPermissionServicesClient();
//ServiceClient workFlowWS = new ServiceClient();
string isView = "1";
if (flagState == "4")
{
isView = "0";
}
//FLOW_FLOWRECORDDETAIL_T[] flowList = workFlowWS.GetFlowInfo("", "", "", isView, "T_SYS_ROLEAPP", loginUserInfo.companyID, loginUserInfo.userID);
//if (flowList == null)
//{
// return null;
//}
List<string> guidStringList = new List<string>();
//foreach (FLOW_FLOWRECORDDETAIL_T f in flowList)
//{
// guidStringList.Add(f.FLOW_FLOWRECORDMASTER_T.FORMID);
//}
//if (guidStringList.Count < 1)
//{
// return null;
//}
IQueryable<T_SYS_ROLE> approList = roleBll.GetUserRoleByUser(pageIndex, pageSize, sort, filterString, paras, ref pageCount, loginUserInfo.userID, guidStringList, flagState);
if (approList == null)
{
return null;
}
else
{
return approList.ToList();
}
}
}
//所有用户登录信息 2010-6-10
public List<V_UserLoginRecordHistory> GetSysUserLoginHistoryRecordAllInfosPaging(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, LoginUserInfo loginUserInfo)
{
using (SysUserLoginRecordHistoryBll UserLoginHistoryBll = new SysUserLoginRecordHistoryBll())
{
IQueryable<V_UserLoginRecordHistory> recordList = UserLoginHistoryBll.GetAllUserLoginHistoryRecordInfosWithPaging(pageIndex, pageSize, sort, filterString, paras, ref pageCount, loginUserInfo.userID);
return recordList == null ? null : recordList.ToList();
}
}
//所有用户登录信息 2010-6-10
public List<V_UserLoginRecord> GetSysUserLoginRecordInfosPaging(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, LoginUserInfo loginUserInfo)
{
using (SysUserLoginRecordBll UserLoginBll = new SysUserLoginRecordBll())
{
IQueryable<V_UserLoginRecord> recordList = UserLoginBll.GetAllUserLoginRecordInfosWithPaging(pageIndex, pageSize, sort, filterString, paras, ref pageCount, loginUserInfo.userID);
SysUserBLL bll = new SysUserBLL();
//string OwnerCompanyIDs = "";
//string OwnerDepartmentIDs = "";
//string OwnerPositionIDs = "";
//IQueryable<V_BllCommonUserPermission> plist;
//plist = bll.GetUserMenuPermsByUserPermisionBllCommon("T_HR_SALARYSOLUTION", "2e41f129-cab4-4864-832e-6a2d6fba2750", ref OwnerCompanyIDs, ref OwnerDepartmentIDs, ref OwnerPositionIDs);
//plist = bll.GetUserMenuPermsByUserPermisionBllCommonAddPermissionValue("T_FB_DEPTBUDGETAPPLYMASTER", "286ab878-be35-4cb9-83d4-51e4f0344637", ref OwnerCompanyIDs, ref OwnerDepartmentIDs, ref OwnerPositionIDs, "0");
//plist = bll.GetUserMenuPermsByUserPermisionBllCommon("T_HR_COMPANY", "2e67b94c-888f-4488-8663-d356740efcc6", ref OwnerCompanyIDs, ref OwnerDepartmentIDs, ref OwnerPositionIDs);
//plist = bll.GetUserMenuPermsByUserPermisionBllCommon("T_OA_WORKRECORD", "5dabd014-e418-4d0e-a88e-440ec012857e", ref OwnerCompanyIDs, ref OwnerDepartmentIDs, ref OwnerPositionIDs);
if (recordList == null)
{
return null;
}
else
{
return recordList.ToList();
}
}
}
//所有用户信息 根据用户所属公司获取 2010-8-24
public List<T_SYS_USER> GetSysUserAllInfosPagingByCompanyIDs(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, LoginUserInfo loginUserInfo, string[] CompanyIDs)
{
using (SysUserBLL UserBll = new SysUserBLL())
{
IQueryable<T_SYS_USER> recordList = UserBll.GetAllSysUserInfosWithPagingByCompanyIDs(pageIndex, pageSize, sort, filterString, paras, ref pageCount, loginUserInfo.userID, CompanyIDs);
return recordList == null ? null : recordList.ToList();
}
}
//获取系统角色-视图
public List<T_SYS_ROLE_V> GetRoleView(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, LoginUserInfo loginUserInfo, string[] CompanyIDs)
{
using (SysRoleBLL RoleBll = new SysRoleBLL())
{
//SysUserBLL userbll = new SysUserBLL();
//SysUserBLL userbll = new SysUserBLL();
//string companyids = "";
//string departids = "";
//string postids = "";
//userbll.GetUserMenuPermsByUserPermisionBllCommon("T_OA_APPROVALINFO", "2ec631ed-0fc0-4b7f-a86c-28581eeab068", ref companyids, ref departids, ref postids);
IQueryable<T_SYS_ROLE_V> SysRoleInfosList = RoleBll.GetRoleView(pageIndex, pageSize, sort, filterString, paras, ref pageCount, loginUserInfo.userID, CompanyIDs);
//GetSysLeftMenuFilterPermissionToNewFrame("543e0360-6e27-4f8a-82cb-6df1f9ea6a8d");//85b414ab-87b3-4740-aef4-1d89f3f380cc
//GetSysLeftMenuFilterPermissionToNewFrame("85b414ab-87b3-4740-aef4-1d89f3f380cc");
//GetUserByEmployeeID("940d667e-4c04-425a-b347-b82719f39c71");
if (SysRoleInfosList == null)
{
return null;
}
else
{
return SysRoleInfosList.ToList();
}
}
}
//所有系统角色信息
public List<T_SYS_ROLE> GetSysRoleInfosPaging(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, LoginUserInfo loginUserInfo)
{
using (SysRoleBLL RoleBll = new SysRoleBLL())
{
IQueryable<T_SYS_ROLE> SysRoleInfosList = RoleBll.GetAllSysRoleInfosWithPaging(pageIndex, pageSize, sort, filterString, paras, ref pageCount, loginUserInfo.userID);
if (SysRoleInfosList == null)
{
return null;
}
else
{
return SysRoleInfosList.ToList();
}
}
}
//所有用户信息 2010-6-10
public List<T_SYS_PERMISSION> GetSysPermissionAllPaging(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, LoginUserInfo loginUserInfo)
{
using (SysPermissionBLL bll = new SysPermissionBLL())
{
#region
List<T_SYS_PERMISSION> perList;
string keyString = "PermissionAllPagingCache";
if (WCFCache.Current[keyString] == null)
{
perList = bll.GetSysPermissionAll().ToList();
WCFCache.Current.Insert(keyString, perList, DateTime.Now.AddMinutes(15));
}
else
{
perList = (List<T_SYS_PERMISSION>)WCFCache.Current[keyString];
}
#endregion
return perList != null ? perList : null;
}
}
public List <T_SYS_USERACTLOG> GetSysUseractLogWithPaging(int pageIndex, int pageSize, string sort, string filterString, IList <object> paras, ref int pageCount, LoginUserInfo loginUserInfo)
{
IQueryable <T_SYS_USERACTLOG> usList;
//string keyString = "GetSysUseractLogWithPaging" + loginUserInfo.userID + loginUserInfo.companyID; //缓存KEY
//if (WCFCache.Current[keyString] == null)
//{
usList = Useract.GetSysUseractLogWithPaging(pageIndex, pageSize, sort, filterString, paras, ref pageCount, loginUserInfo.userID);
// WCFCache.Current.Insert(keyString, usList);
//}
//else
//{
// usList = (IQueryable<T_SYS_USERACTLOG>)WCFCache.Current[keyString];
//}
return(usList.Count() > 0 ? usList.ToList() : null);
}
