/// <summary>
/// 获取用户基础信息
/// </summary>
/// <param name="condtion">用户ID与组织ID，传入组织ID会对用户所属部门产生影响</param>
public void GetMemberBaseInfo(GetMembersInfoRequestModel condtion)
{
try
{
MembersBaseInfoModel Info = BaseSysTemDataBaseManager.MemberGetMemberBaseInfo(condtion);
Info.numOfDep = GetMemberNumofDep(Info);
this.MemberBaseInfo = Info;
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString(), condtion);
}
}
/// <summary>
/// 查询推送历史
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
internal static SearchSentPushListReplayModel RunSearchHistoryPushList(SearchSentPushListRequestModel condtion)
{
using (SysTemDataBaseDataContext context = new SysTemDataBaseDataContext(SqlConnection)) {
SearchSentPushListReplayModel result = new SearchSentPushListReplayModel();
result.total = (from c in context.Us_RunSentPush
where (1 == 1) &&
(condtion.beginDate == null ? true : c.createdOn >= condtion.beginDate) &&
(condtion.endDate == null ? true : c.createdOn <= condtion.endDate) &&
(string.IsNullOrEmpty(condtion.keyWords) ? true : (SqlMethods.Like(c.title, string.Format("%{0}%", condtion.keyWords)) || SqlMethods.Like(c.msg, string.Format("%{0}%", condtion.keyWords))))
select c.Us_RunSentPushId).Count();
if (result.total > 0)
{
result.rows = (from c in context.Us_RunSentPush
where (1 == 1) &&
(condtion.beginDate == null ? true : c.createdOn >= condtion.beginDate) &&
(condtion.endDate == null ? true : c.createdOn <= condtion.endDate) &&
(string.IsNullOrEmpty(condtion.keyWords) ? true : (SqlMethods.Like(c.title, string.Format("%{0}%", condtion.keyWords)) || SqlMethods.Like(c.msg, string.Format("%{0}%", condtion.keyWords))))
orderby c.createdOn descending
select new SentPushInfoModel
{
id = c.Us_RunSentPushId,
createdBy = BaseSysTemDataBaseManager.SysGetSysUserById(c.createdBy),
createdOn = c.createdOn,
customInfo = c.customInfo,
messageType = (EnumPushMessagesType)c.messageType,
msg = c.msg,
sentResultAndroid = c.sentResultAndroid,
sentResultIos = c.sentResultIos,
sentStats = c.sentStats,
sentUserNum = c.Us_RunSentPushDetail.Count,
title = c.title,
sentUserList = (from x in c.Us_RunSentPushDetail
select new SentPushInfoDetailInfoModel
{
sentDeviceInfo = new GeTuiSetModel()
{
clientId = x.clientId,
deviceType = (EnumUserDeviceType)x.deviceType,
userId = x.sentUserId
},
sentUserInfo = (x.sentUserId == null || x.sentUserId == "") ? null :
BaseSysTemDataBaseManager.SysGetSysUserById(x.sentUserId)
}
).ToList()
}).Skip((condtion.Page - 1) * condtion.PageSize).Take(condtion.PageSize).ToList();
}
else
{
result.rows = new List <SentPushInfoModel>();
}
return(result);
}
}
/// <summary>
/// 获取已有的输入类型集合
/// </summary>
/// <returns></returns>
internal static List <Combobox> GetUserInputRuleTypes()
{
try
{
List <Combobox> result = BaseSysTemDataBaseManager.RsGetUserInputRuleTypes();
return(result);
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString());
return(new List <Combobox>());
}
}
/// <summary>
/// 获取系统菜单列表
/// </summary>
/// <returns></returns>
public static List <SysMenuModel> GetSysMenuList()
{
try
{
List <SysMenuModel> result = BaseSysTemDataBaseManager.SysGetSysMenuList();
return(result);
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString());
return(new List <SysMenuModel>());
}
}
/// <summary>
/// 查询系统用户日志
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
internal static ReplaySearchSysUserLog SearchSysUserLog(RequestSearchSysUserLog condtion)
{
try
{
ReplaySearchSysUserLog result = BaseSysTemDataBaseManager.SysSearchSysUserLog(condtion);
return(result);
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString(), condtion);
return(new ReplaySearchSysUserLog());
}
}
/// <summary>
/// 获取后台全部角色信息
/// </summary>
/// <returns></returns>
internal static List <SysUserRoleListModel> GetSysRoleAllRowsList()
{
try
{
List <SysUserRoleListModel> result = BaseSysTemDataBaseManager.SysGetSysRoleAllRowsList();
return(result);
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString());
return(new List <SysUserRoleListModel>());
}
}
/// <summary>
/// 获取省份信息列表
/// </summary>
/// <returns></returns>
internal static List <Combobox> GetProvniceList()
{
List <Combobox> result = new List <Combobox>();
try
{
result = BaseSysTemDataBaseManager.RsGetProvniceList();
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString());
}
return(result);
}
/// <summary>
/// 获取所有已存在的分组
/// </summary>
/// <returns></returns>
internal static List <Combobox> GetAllDocumentsGroupInfo()
{
List <Combobox> result = new List <Combobox>();
try
{
result = BaseSysTemDataBaseManager.RsGetAllDocumentsResourceGroupInfoList();
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString());
}
return(result);
}
/// <summary>
/// 获取全国热门城市列表，按省排列，每个省去前3个城市
/// </summary>
/// <returns></returns>
internal static List <GeoCityInfoModel> GetHotCityList()
{
List <GeoCityInfoModel> result = new List <GeoCityInfoModel>();
try
{
result = BaseSysTemDataBaseManager.RsGetHotCityList();
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString());
}
return(result);
}
/// <summary>
/// 编辑用户基础信息
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
internal ReplayBase EditMemberBaseInfo(MembersBaseInfoModel condtion)
{
ReplayBase result = new ReplayBase();
try
{
result = BaseSysTemDataBaseManager.MemberEditMemberBaseInfo(condtion);
}
catch (Exception e) {
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = "服务器错误 500";
SysManagerService.SysSaveErrorLogMsg(e.ToString(), condtion);
}
return(result);
}
/// <summary>
/// 设置用户的部门
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
internal static ReplayBase SetMemberDepartments(SetMemberDepartmentsRequestModel condtion)
{
ReplayBase result = new ReplayBase();
try
{
result = BaseSysTemDataBaseManager.DepSetMemberDepartments(condtion);
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString(), condtion);
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = "服务器错误 500";
}
return(result);
}
/// <summary>
/// 检索根组织(可翻页，后台列表与企业名片数据展示)
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
internal SearchMemberRootDepartMentReplay SearchRootDepartments(SearchMemberRootDepartmentRequest condtion)
{
try
{
SearchMemberRootDepartMentReplay result = BaseSysTemDataBaseManager.DepSearchRootDepartments(condtion);
return(result);
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString(), condtion);
return(new SearchMemberRootDepartMentReplay()
{
rows = new List <MemberDepartmentInfoModel>()
});
}
}
/// <summary>
/// 创建系统用户日志
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
internal static ReplayBase CreateSysUserLog(SysUserLogModel condtion)
{
ReplayBase result = new ReplayBase();
try
{
result = BaseSysTemDataBaseManager.SysCreateSysUserLog(condtion);
}
catch (Exception e) {
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = "服务器错误 500";
SysSaveErrorLogMsg(e.ToString(), condtion);
}
return(result);
}
/// <summary>
/// 保存系统更新日志
/// </summary>
/// <returns></returns>
internal ReplayBase SaveSysUpdateLog()
{
ReplayBase result = new ReplayBase();
try
{
result = BaseSysTemDataBaseManager.SysSaveSysUpdateLog(this.SysUpdateLog);
}
catch (Exception e)
{
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = e.ToString();
}
return(result);
}
/// <summary>
/// 删除系统更新日志
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
internal static ReplayBase DelSysUpdateLogById(long Id)
{
ReplayBase result = new ReplayBase();
try
{
result = BaseSysTemDataBaseManager.SysDelSysUpdateLogById(Id);
}
catch (Exception e)
{
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = e.ToString();
}
return(result);
}
/// <summary>
/// 新增或保存资源文档
/// </summary>
/// <returns></returns>
internal ReplayBase Save()
{
ReplayBase result = new ReplayBase();
try
{
result = BaseSysTemDataBaseManager.RsSaveDocumentResource(this.Document);
}
catch (Exception e) {
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = "服务器错误 500";
SysManagerService.SysSaveErrorLogMsg(e.ToString(), this.Document);
}
return(result);
}
/// <summary>
/// 保存角色信息
/// </summary>
/// <returns></returns>
public ReplayBase SaveRole()
{
ReplayBase result = new ReplayBase();
try
{
result = BaseSysTemDataBaseManager.SysSaveSysRole(this.UserRole);
}
catch (Exception e) {
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = "服务器错误 500";
SysSaveErrorLogMsg(e.ToString(), this.UserRole);
}
return(result);
}
/// <summary>
/// 检索城市by关键字
/// </summary>
/// <param name="q">关键字，汉子或拼音</param>
/// <returns></returns>
internal static List <GeoCityInfoModel> SearchCityByKeyWords(string q)
{
List <GeoCityInfoModel> result = new List <GeoCityInfoModel>();
try
{
if (!string.IsNullOrEmpty(q))
{
result = BaseSysTemDataBaseManager.RsSearchCityByKeyWords(q);
}
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString(), q);
}
return(result);
}
/// <summary>
/// 根据市ID检索区域信息
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
internal static SearchAreaInfoListReplayModel GetAreaInfoListByCityCode(SearchAreaInfoListRequestModel condtion)
{
SearchAreaInfoListReplayModel result = new SearchAreaInfoListReplayModel();
try
{
if (!string.IsNullOrEmpty(condtion.CityCode))
{
result = BaseSysTemDataBaseManager.RsGetAreaInfoListByCityCode(condtion);
}
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString(), condtion);
}
return(result);
}
/// <summary>
/// 文档批量排序
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
internal static ReplayBase SortDocuments(SortDocumentsRequest condtion)
{
ReplayBase result = new ReplayBase();
try
{
result = BaseSysTemDataBaseManager.RsSortDocumentsResource(condtion);
}
catch (Exception e)
{
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = "服务器错误 500";
SysManagerService.SysSaveErrorLogMsg(e.ToString(), condtion);
}
return(result);
}
/// <summary>
/// 标记删除用户扩展信息
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
internal static ReplayBase DelExInfo(EditInfoExInfoRequestModel condtion)
{
ReplayBase result = new ReplayBase();
try
{
result = BaseSysTemDataBaseManager.RsDelExInfo(condtion);
}
catch (Exception e)
{
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = "服务器错误 500";
SysManagerService.SysSaveErrorLogMsg(e.ToString(), condtion);
}
return(result);
}
/// <summary>
/// 重置用户密码
/// </summary>
/// <returns></returns>
internal ReplayBase ReSetUserPwd()
{
ReplayBase result = new ReplayBase();
try
{
result = BaseSysTemDataBaseManager.SysReSetUserPwd(SysUserInfo);
}
catch (Exception e)
{
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = "服务器错误 500";
SysSaveErrorLogMsg(e.ToString(), SysUserInfo);
}
return(result);
}
/// <summary>
/// 编辑组织基础信息
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
internal ReplayBase EditOrgBaseInfo(EditOrgInfoRequestModel condtion)
{
ReplayBase result = new ReplayBase();
try
{
int num = 0;
//检查是否有重名
num = CheckDepartmentCationNumInRootList(condtion.caption, condtion.depmentid);
if (num == 0)
{
GetOrgBaseInfo(condtion.depmentid);
result = BaseSysTemDataBaseManager.DepEditOrgBaseInfo(condtion);//保存信息
if (result.ReturnCode == EnumErrorCode.Success)
{
if (this.orgInfo.baseInfo.caption != condtion.caption)
{
SearchMemberDepartmentReplay dr = SearchDepartments(new SearchMemberDepartmentRequst()
{
departmentId = condtion.depmentid,
getchild = true,
showdisabled = true,
showontheui = false
});
List <string> depmentids = new List <string>();
foreach (MemberDepartmentBaseInfoModel d in dr.rows)
{
depmentids.Add(d.depmentid);
}
BaseSysTemDataBaseManager.DepEditUserDepmentPath(depmentids);
}
}
}
else
{
result.ReturnCode = EnumErrorCode.EmptyDate;
result.ReturnMessage = "该组织名称已存在，不能重复创建";
}
}
catch (Exception e)
{
SysManagerService.SysSaveErrorLogMsg(e.ToString(), condtion);
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = "服务器错误 500";
}
return(result);
}
/// <summary>
/// 将信息记录到错误日志
/// </summary>
/// <param name="errormsg">错误描述</param>
/// <param name="condtion">当前方法的请求参数对象</param>
public static void SysSaveErrorLogMsg(string errormsg, object condtion = null)
{
string condtions = null;
if (condtion != null)
{
condtions = JsonConvert.SerializeObject(condtion);
}
Us_SysLog dblog = new Us_SysLog()
{
Us_SysLogId = Helps.GetTimeId(),
condtion = condtions,
CreatedOn = DateTime.Now,
errormsg = errormsg,
type = 0
};
BaseSysTemDataBaseManager.SysSaveErrorLogMsg(dblog);
}
/// <summary>
/// 获取用户详情
/// </summary>
/// <param name="condtion"></param>
public void GetMemberInfo(GetMembersInfoRequestModel condtion)
{
GetMemberBaseInfo(condtion);
try
{
//用户扩展信息
if (this.MemberBaseInfo != null)
{
this.memberInfo = new MembersInfoModel()
{
baseInfo = this.MemberBaseInfo,
exList = BaseSysTemDataBaseManager.RsGetExInfoList(condtion.userId)
};
}
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString(), condtion);
}
}
/// <summary>
/// 递归获取部门子集
/// </summary>
/// <param name="d"></param>
private void getchlidDepartments(MemberDepartmentBaseInfoModel d)
{
departmentslist.Add(d);
List <MemberDepartmentBaseInfoModel> childlist = BaseSysTemDataBaseManager.DepSearchDepartments(new SearchMemberDepartmentRequst()
{
_parentId = d.depmentid,
ordertype = EnumSortOrderType.标题升序,
showdisabled = searchdepartmentscondtion.showdisabled,
showontheui = searchdepartmentscondtion.showontheui
});
if (childlist.Count > 0)
{
foreach (MemberDepartmentBaseInfoModel c in childlist)
{
getchlidDepartments(c);
}
}
}
/// <summary>
/// 获取后台系统角色列表
/// </summary>
/// <returns></returns>
internal static ReplaySysUserRoleListModel GetSysRoleList(RequestBase condtion)
{
ReplaySysUserRoleListModel result = new ReplaySysUserRoleListModel();
try
{
result = BaseSysTemDataBaseManager.SysGetSysRoleList(condtion);
if (result.ReturnCode == EnumErrorCode.EmptyDate)
{
result.RowList = new List <SysUserRoleModel>();
}
}
catch (Exception e) {
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = "服务器错误 500";
SysSaveErrorLogMsg(e.ToString(), condtion);
}
return(result);
}
/// <summary>
/// 会员检索
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
internal static SearchMembersreplayModel SearchMembersList(SearchMembersRequestModel condtion)
{
SearchMembersreplayModel result = new SearchMembersreplayModel();
try
{
result = BaseSysTemDataBaseManager.MemberSearchMembersList(condtion);
if (result.total > 0)
{
foreach (MembersBaseInfoModel user in result.rows)
{
user.numOfDep = GetMemberNumofDep(user);
}
}
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString(), condtion);
result.rows = new List <MembersBaseInfoModel>();
}
return(result);
}
/// <summary>
/// 编辑部门基础信息
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
internal ReplayBase EditDepBaseInfo(EditDepInfoRequestModel condtion)
{
ReplayBase result = new ReplayBase();
try
{
GetDepBaseInfo(new GetDepInfoRequestModel()
{
depmentid = condtion.depmentid
});
result = BaseSysTemDataBaseManager.DepEditDepBaseInfo(condtion);//保存信息
if (result.ReturnCode == EnumErrorCode.Success)
{
if (this.depInfo.baseinfo.caption != condtion.caption)
{
SearchMemberDepartmentReplay dr = SearchDepartments(new SearchMemberDepartmentRequst()
{
_parentId = condtion.depmentid,
getchild = true,
showdisabled = true,
showontheui = false
});
List <string> depmentids = new List <string>();
depmentids.Add(condtion.depmentid);
foreach (MemberDepartmentBaseInfoModel d in dr.rows)
{
depmentids.Add(d.depmentid);
}
BaseSysTemDataBaseManager.DepEditUserDepmentPath(depmentids);
}
}
}
catch (Exception e)
{
SysManagerService.SysSaveErrorLogMsg(e.ToString(), condtion);
result.ReturnCode = EnumErrorCode.ServiceError;
result.ReturnMessage = "服务器错误 500";
}
return(result);
}
/// <summary>
/// 获取用户输入规范项列表
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
internal static SearchResourceUserInputRuleReplayModel SearchUserInputRuleList(SearchResourceUserInputRuleRequestModel condtion)
{
SearchResourceUserInputRuleReplayModel result = new SearchResourceUserInputRuleReplayModel();
try
{
result = BaseSysTemDataBaseManager.RsSearchUserInputRuleList(condtion);
if (result.rows.Count > 0)
{
foreach (ResourceUserInputRuleModel row in result.rows)
{
if (!string.IsNullOrEmpty(row.OptionsString))
{
row.OptionsList = row.OptionsString.Split(',').ToList();
}
}
}
}
catch (Exception e) {
SysManagerService.SysSaveErrorLogMsg(e.ToString(), condtion);
}
return(result);
}
