//获得某个分组下的好友列表
public IList <Friend> getFriendByGroup(int uId, int groupId)
{
DataTable result = friendDal.getFriendByGroup(uId, groupId);
IList <Friend> list = ModelConvertUtil <Friend> .ConvertToModel(result);
return(list);
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="psw">密码</param>
public UserInfoDto Login(string userName, string psw)
{
string md5Psw = MD5.Encrypt(psw);
var user = _repository.GetUserInfo(userName, md5Psw);
return(ModelConvertUtil <UserInfo, UserInfoDto> .ModelCopy(user));
}
public VRequestInfo SaveNavigationImgPlays(ImgPlayDto input)
{
if (input.NavigationID != -1)
{
var navModel = navigationRepositrory.Query(input.NavigationID);
if (navModel == null || navModel.Id == 0)
{
return(VRequestInfo.ErrorResult("导航不存在"));
}
}
bool res = false;
if (input.Id == 0)
{
input.IsDisable = Models.Enum.EYesOrNo.No;
input.CreateTime = DateTime.Now;
res = playInfoRepository.Insert(ModelConvertUtil <ImgPlayDto, ImgPlayInfo> .ModelCopy(input)) > 0;
}
else
{
var model = ModelConvertUtil <ImgPlayDto, ImgPlayInfo> .ModelCopy(input);
res = playInfoRepository.Update(model);
}
if (res)
{
return(VRequestInfo.SuccessResult());
}
else
{
return(VRequestInfo.ErrorResult("保存失败"));
}
}
public List <AdminUserDto> GetUserList(VUserListConditionInput input, out int pageCount)
{
var user = adminRepository.GetUserInfoByQueryCondition(input, "CreateTime", false);
pageCount = user.pageCount;
return(ModelConvertUtil <AdminUserInfo, AdminUserDto> .ModelCopy(user.data));
}
public IList <Chatroom> getChatRoomDetail(int uId)//获得每个群组列表信息
{
DataTable result = chatRoomMemberDal.getChatRoomDetail(uId);
IList <Chatroom> list = ModelConvertUtil <Chatroom> .ConvertToModel(result);
return(list);
}
//获得某个特定好友的信息
public Friend getOneFriend(int uId, int friendId)
{
DataTable result = friendDal.getOneFriend(uId, friendId);
IList <Friend> list = ModelConvertUtil <Friend> .ConvertToModel(result);
return(list[0]);
}
public User getUser(int uId)
{
DataTable result = userDal.getUserById(uId);
IList <User> list = ModelConvertUtil <User> .ConvertToModel(result);
return(list[0]);
}
//查找群主信息
public User searchLeader(int uId)
{
DataTable result = chatRoomMemberDal.searchLeader(uId);
IList <User> list = ModelConvertUtil <User> .ConvertToModel(result);
return(list[0]);
}
//获得好友分组列表
public IList <Model.Group> getGroupList(int uId)
{
DataTable result = groupDal.getGroupList(uId);
IList <Model.Group> list = ModelConvertUtil <Model.Group> .ConvertToModel(result);
return(list);
}
public User getUser(string email)
{
DataTable result = userDal.getUserByEmail(email);
IList <User> list = ModelConvertUtil <User> .ConvertToModel(result);
return(list[0]);
}
public string EditUser(AdminUserDto user)
{
string res = "";
var oldUser = GetUserInfo(user.Id);
if (oldUser.Id == 0)
{
res = "用户不存在";
}
else
{
var userModel = ModelConvertUtil <AdminUserDto, AdminUserInfo> .ModelCopy(user);
if (string.IsNullOrEmpty(user.Password))
{
//未修改密码
userModel.Password = oldUser.Password;
}
else
{
//修改密码，加密
userModel.Password = MD5.Encrypt(user.Password);
}
res = adminRepository.Update(userModel) ? "" : "修改失败";
}
return(res);
}
public List <VUserListModel> GetUserList(VUserListConditionInput input, out int pageCount)
{
List <string> sqlwhere = new List <string>();
string whereStr = "";
if (!string.IsNullOrEmpty(input.name))
{
sqlwhere.Add(" name like @name");
}
if (!string.IsNullOrEmpty(input.phone))
{
sqlwhere.Add(" phone = @phone");
}
if (input.sex > -1)
{
sqlwhere.Add(" sex = @sex");
}
if (sqlwhere.Count > 0)
{
whereStr = string.Join("and", sqlwhere);
}
var user = Repository.QueryList(input.pageNum, input.pageSize, whereString: whereStr, param: new { name = "%" + input.name + "%", phone = input.phone, sex = input.sex }, order: "createTime");
pageCount = user.pageCount;
var res = ModelConvertUtil <UserInfo, VUserListModel> .ModelCopy(user.data);
return(res);
}
//获得所有好友的信息
public IList <Friend> getAllFriend(int uId)
{
DataTable result = friendDal.getAllFriend(uId);
IList <Friend> list = ModelConvertUtil <Friend> .ConvertToModel(result);
return(list);
}
public VNewDetailPage GetNewDetailPage(int id)
{
var res = new VNewDetailPage();
var info = newsRepository.Query(id);
res.Content = ModelConvertUtil <NewsInfo, NewsDto> .ModelCopy(info);
return(res);
}
public int AddUser(AdminUserDto user)
{
var userModel = ModelConvertUtil <AdminUserDto, AdminUserInfo> .ModelCopy(user);
userModel.CreateTime = DateTime.Now;
userModel.IsDisable = Models.Enum.EYesOrNo.No;
userModel.Password = MD5.Encrypt(user.Password);
return((int)adminRepository.Insert(userModel));
}
public async Task <NavigationDto> GetNavigationsAsync(int navId)
{
var naviagation = await Task.Run(() => navigationRepositrory.Query(navId));
if (naviagation == null)
{
naviagation = new NavigationInfo();
}
return(ModelConvertUtil <NavigationInfo, NavigationDto> .ModelCopy(naviagation));
}
private void getTree(List <NavigationDto> alllist, List <VNavigation> showlist, int parentId)
{
foreach (var parent in alllist.FindAll(c => c.ParentId == parentId))
{
VNavigation tree = ModelConvertUtil <NavigationDto, VNavigation> .ModelCopy(parent);
getTree(alllist, tree.Childs, tree.Id);
showlist.Add(tree);
}
}
public AdminUserDto Login(string userName, string passWord)
{
AdminUserDto res = new AdminUserDto();
var model = adminRepository.GetUserInfo(userName, MD5.Encrypt(passWord));
if (model != null)
{
res = ModelConvertUtil <AdminUserInfo, AdminUserDto> .ModelCopy(model);
}
return(res);
}
/// <summary>
/// 获取最近6个注册用户
/// </summary>
public List <VUserListModel> GetIndexUsers(int count = 8)
{
var res = new List <VUserListModel>();
var list = Repository.QueryList("CreateTime>=@time ORDER BY CreateTime desc", new { time = "2018-11-01" }).Take(count).ToList();
list.ForEach(u =>
{
VUserListModel model = ModelConvertUtil <UserInfo, VUserListModel> .ModelCopy(u);
res.Add(model);
});
return(res);
}
public async Task Write(AdminLogDto log)
{
try
{
var logModel = ModelConvertUtil <AdminLogDto, AdminLogInfo> .ModelCopy(log);
await Task.Run(() => logRepository.InsertAsync(logModel));
}
catch (Exception ex)
{
logger.Error(typeof(ActionLog), "AOP记录", ex);
}
}
private List <VNavigation> GetVNavigations(List <NavigationDto> alllist)
{
List <VNavigation> result = new List <VNavigation>();
var rootList = alllist.FindAll(c => c.ParentId == 0);
foreach (var root in rootList)
{
VNavigation tree = ModelConvertUtil <NavigationDto, VNavigation> .ModelCopy(root);
getTree(alllist, tree.Childs, root.Id);
result.Add(tree);
}
return(result);
}
public VRequestInfo GetNavigationDetail(int id)
{
VRequestInfo res = new VRequestInfo();
var info = navigationRepositrory.Query(id);
if (info == null)
{
return(VRequestInfo.ErrorResult("导航不存在"));
}
res.Data = ModelConvertUtil <NavigationInfo, NavigationDto> .ModelCopy(info);
res.Code = VRequestInfo.Success;
return(res);
}
public VActionLogs GetLogs(DateTime starDate, DateTime endDate)
{
var res = new VActionLogs();
var logs = logRepository.QueryByTime(starDate, endDate).Result;
logs.ForEach(l => {
var yyyyMMdd = l.CreateTime.ToString("yyyy-MM-dd");
if (!res.Logs.ContainsKey(yyyyMMdd))
{
res.Logs[yyyyMMdd] = new List <AdminLogDto>();
}
res.Logs[yyyyMMdd].Add(ModelConvertUtil <AdminLogInfo, AdminLogDto> .ModelCopy(l));
});
return(res);
}
/// <summary>
/// 保存用户信息
/// </summary>
/// <param name="inputUserInfo">用户信息</param>
/// <returns></returns>
public bool Save(UserInfoDto inputUserInfo)
{
var user = ModelConvertUtil <UserInfoDto, UserInfo> .ModelCopy(inputUserInfo);
user.CreateTime = DateTime.Now;
user.Enable = EUserState.Enabled;
user.HeaderImg = user.HeaderImg.Substring(inputUserInfo.HeaderImg.IndexOf("/upload"));
user.Password = MD5.Encrypt(user.Password);
if (user.Id == 0)
{
return(_repository.Insert(user) > 0);
}
else
{
return(_repository.Update(user));
}
}
public VPageImgPlay GetNavigationImgPlays(string host)
{
VPageImgPlay res = new VPageImgPlay();
var navs = navigationRepositrory.QueryList("ParentId=@ParentId", new { ParentId = 0 }, "Id", true);
foreach (var nav in navs)
{
VNavigationImgPlays plays = ModelConvertUtil <NavigationInfo, VNavigationImgPlays> .ModelCopy(nav);
var imgplayHeader = playInfoRepository.GetAllImgPlaysAsync(nav.Id, Models.Enum.EImageType.Header);
foreach (var img in imgplayHeader.Result)
{
var modelDto = ModelConvertUtil <ImgPlayInfo, ImgPlayDto> .ModelCopy(img);
if (!string.IsNullOrEmpty(img.ImgUrl))
{
modelDto.ImgUrl = GeneralCMS.Common.Extend.UrlCommon.CreateUrlPath(host, img.ImgUrl);
}
plays.HeaderImgPlays.Add(modelDto);
}
res.NavigationsImgPlay.Add(plays);
}
var imgplayFooter = playInfoRepository.GetImgPlayByTypeAsync(Models.Enum.EImageType.Footer);
var footerImg = ModelConvertUtil <ImgPlayInfo, ImgPlayDto> .ModelCopy(imgplayFooter.Result.FirstOrDefault() ?? new ImgPlayInfo());
if (!string.IsNullOrEmpty(footerImg.ImgUrl))
{
footerImg.ImgUrl = GeneralCMS.Common.Extend.UrlCommon.CreateUrlPath(host, footerImg.ImgUrl);
}
//因为页脚不存在导航中
VNavigationImgPlays footer = new VNavigationImgPlays();
footer.Id = -1;
footer.Name = "页脚";
footer.HeaderImgPlays.Add(footerImg);
res.NavigationsImgPlay.Add(footer);
return(res);
}
public async Task <VNewPage> GetNewPageList(int pageNum, int pageSize)
{
if (pageNum <= 0)
{
pageNum = 1;
}
if (pageSize <= 0 || pageSize > 10)
{
pageSize = 5;
}
var aa = newsRepository.QueryList();
var page = await Task.Run(() => newsRepository.GetNewPageList(pageNum, pageSize));
VNewPage newPage = new VNewPage();
newPage.pageCount = page.pageCount;
newPage.pageNo = page.pageNo;
newPage.pageSize = page.pageSize;
newPage.dataCount = page.dataCount;
newPage.data = ModelConvertUtil <NewsInfo, NewsDto> .ModelCopy(page.data);
return(newPage);
}
public async Task <List <ImgPlayDto> > GetImgPlaysAsync(int navId, EImageType imageType)
{
var imgList = await Task.Run(() => imgPlayInfoRepository.GetImgPlaysAsync(navId, imageType));
return(ModelConvertUtil <ImgPlayInfo, ImgPlayDto> .ModelCopy(imgList));
}
/// <summary>
/// 获取企业信息
/// </summary>
/// <returns></returns>
public async Task <OwnerDto> GetCompanyInfoAsync()
{
var companyInfo = await ownerInfoRepository.QueryListAsync();
return(ModelConvertUtil <OwnerInfo, OwnerDto> .ModelCopy(companyInfo.ToList().FirstOrDefault()));
}
private async Task <List <RecruitmentDto> > GetRecruitmentDtos()
{
var res = await recruitmentRepository.QueryListAsync(order : "Sort", asc : false);
return(ModelConvertUtil <RecruitmentInfo, RecruitmentDto> .ModelCopy(res.ToList()));
}
public async Task <SystemConfigDto> GetSystemConfig(string code)
{
var res = await Task.Run(() => systemConfigRepository.GetValueByCode(code));
return(ModelConvertUtil <SystemConfigInfo, SystemConfigDto> .ModelCopy(res));
}
