/// <summary> /// 上传医生个人信息证明图片 /// </summary> /// <param name="httpRequest">请求</param> /// <returns></returns> public ReturnValueModel UploadPicture(WorkUser workUser, HttpRequest httpRequest) { ReturnValueModel rvm = new ReturnValueModel(); var root = HostingEnvironment.MapPath("~/"); var unionId = workUser?.WxUser?.UnionId; //httpRequest["UnionId"]; var user = _rep.FirstOrDefault <WxUserModel>(s => s.IsDeleted != 1 && s.UnionId == unionId); if (user == null) { rvm.Success = false; rvm.Msg = "Invalid union Id"; return(rvm); } try { #region 保存文件 HttpFileCollection files = httpRequest.Files; if (files == null || files.Count == 0) { rvm.Success = false; rvm.Msg = "Files not found."; return(rvm); } var dir = @"DoctorPictures"; var path = root + dir; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } foreach (var f in files) { var ext = Path.GetExtension(files[0].FileName); var fileName = Guid.NewGuid().ToString() + ext; var downloadPath = "/" + dir + "/" + fileName; files[0].SaveAs(path + "\\" + fileName); user.Pictures = (user.Pictures ?? "") + downloadPath + "|"; } #endregion user.UpdateTime = DateTime.Now; _rep.Update(user); _rep.SaveChanges(); rvm.Success = true; rvm.Msg = "success"; rvm.Result = new { path = user.Pictures }; } catch (Exception ex) { rvm.Success = false; rvm.Msg = ex.Message; LoggerHelper.WriteLogInfo("[UploadPicture]Exception ex:" + ex.Message); } return(rvm); }
/// <summary> /// 保存系统配置 /// </summary> /// <param name="key">配置名称</param> /// <param name="value">配置值</param> /// <param name="workUser">当前登录用户</param> public void SetConfig(string key, string value, WorkUser workUser) { var item = _rep.FirstOrDefault <Configuration>(s => s.ConfigureName == key); if (item == null) { item = new Configuration { Id = Guid.NewGuid().ToString(), ConfigureName = key, ConfigureValue = value, CreateTime = DateTime.Now, UpdateUser = workUser.User.Id }; _rep.Insert(item); } else { item.ConfigureValue = value; item.UpdateTime = DateTime.Now; item.UpdateUser = workUser.User.Id; _rep.Update(item); } _rep.SaveChanges(); }
/// <summary> /// 小程序会议订阅-添加 /// </summary> /// <param name="dto"></param> /// <returns></returns> public ReturnValueModel AddMeetSubscribe(MeetSubscribeInputDto dto, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); if (dto == null && workUser == null) { rvm.Msg = "错误"; rvm.Success = false; rvm.Result = ""; return(rvm); } var model = new MeetSubscribe { Id = Guid.NewGuid().ToString(), UserId = workUser?.WxSaleUser?.Id, UnionId = dto.UnionId, MeetId = dto.MeetId, OpenId = dto.OpenId, HasReminded = 0, RemindOffsetMinutes = -30, CreateTime = DateTime.UtcNow.AddHours(8), TemplateId = string.Join(",", dto.TemplateId), }; _rep.Insert(model); _rep.SaveChanges(); rvm.Msg = "success"; rvm.Success = true; rvm.Result = ""; return(rvm); }
public ReturnValueModel DeleteMeetQA(QuestionModel meetQA, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); var question = _rep.FirstOrDefault <QuestionModel>(s => s.Id == meetQA.Id); if (question != null) { using (var tran = _rep.Database.BeginTransaction()) { try { var list = _rep.Where <AnswerModel>(s => s.QuestionId == question.Id); _rep.Delete(question); _rep.DeleteList(list); _rep.SaveChanges(); tran.Commit(); rvm.Msg = "sucess"; rvm.Success = true; } catch (Exception ex) { rvm.Msg = "fail"; rvm.Success = false; tran.Rollback(); } } } return(rvm); }
/// <summary> /// 根据当前用户获取到相关的会议和学术知识 /// </summary> /// /// <param name="workUser"></param> /// <returns></returns> public ReturnValueModel GetDiscoveryHome(WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); var model = new DiscoveryViewModel(); var user = _rep.FirstOrDefault <WxUserModel>(s => s.IsDeleted != 1 && s.UnionId == workUser.WxUser.UnionId); if (user.IsCompleteRegister == 1) { model.IsRegister = 1; model.MeetInfos = _rep.Where <MeetInfo>(s => s.MeetDep.Contains(user.DepartmentName)).ToList().OrderByDescending(s => s.CreateTime).Take(2); model.Academic = _rep.Where <ProductTypeInfo>(s => s.ContentDepType.Contains(user.DepartmentName) && s.TypeId == 2).ToList().OrderByDescending(s => s.CreateTime).Take(2); rvm.Msg = "success"; rvm.Success = true; rvm.Result = new { model = model }; } else { rvm.Msg = "fail"; rvm.Success = false; } return(rvm); }
/// <summary> /// 绑定用户角色 /// </summary> /// <param name="roleInfo">权限信息,是需要传入角色Id</param> /// <param name="workUser"></param> /// <returns></returns> public ReturnValueModel BindUserRole(RoleInfo roleInfo, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); var isAdmin = _commonService.IsAdmin(workUser); //获取角色ID对应的角色列表 var roleInCom = _rep.FirstOrDefault <RoleInfo>(s => s.Id == roleInfo.Id); var userHasRole = (from a in _rep.All <UserModel>() join b in _rep.All <UserRole>() on a.Code equals b.SapCode where (a.CompanyCode == b.CompanyCode && b.CompanyCode == roleInCom.CompanyCode || isAdmin) && a.IsDeleted != 1 && b.IsDeleted != 1 && b.RoleId == roleInfo.Id select a).ToList().Select(s => new { key = s.Code, label = s.ChineseName + '-' + s.Code }); var userNoRole = _rep.SqlQuery <UserRoleView>($@"select a.Code as 'key',a.ChineseName+'-'+a.Code as 'label' from UserInfo a left join UserRole b on a.EmployeeNo = b.SapCode left join RoleInfo c on b.RoleId = c.id where ISNULL(b.RoleId, '') != '{roleInfo.Id}' and ISNULL(c.RoleName, '') != '系统管理员' and a.IsDeleted!=1 ").ToList(); //只能有一个权限 var hasRole = _rep.Where <UserRole>(x => true).Select(x => x.SapCode).ToList(); userNoRole = userNoRole.Where(x => !hasRole.Contains(x.key)).ToList(); rvm.Success = true; rvm.Msg = ""; rvm.Result = new { userHasRole = userHasRole, userNoRole = userNoRole }; return(rvm); }
/// <summary> /// 新增或删除角色 /// </summary> /// <param name="roleInfo">角色基本信息</param> /// <param name="workUser">当前操作人</param> /// <returns></returns> public ReturnValueModel InsertOrUpdateRole(RoleInfo roleInfo, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); var role = _rep.FirstOrDefault <RoleInfo>(s => s.Id == roleInfo.Id); if (role == null) { roleInfo.Id = Guid.NewGuid().ToString(); roleInfo.CreateTime = DateTime.Now; roleInfo.CreateUser = workUser.User.Id; _rep.Insert(roleInfo); } else { role.RoleName = roleInfo.RoleName; role.RoleDesc = roleInfo.RoleName; role.CompanyCode = roleInfo.CompanyCode; role.UpdateTime = DateTime.Now; role.UpdateUser = workUser.User.Id; _rep.Update(role); } _rep.SaveChanges(); rvm.Success = true; rvm.Msg = ""; rvm.Result = new { role = role }; return(rvm); }
/// <summary> /// /// </summary> /// <param name="actionContext"></param> public override void OnAuthorization(HttpActionContext actionContext) { var cache = ContainerManager.Resolve <ICacheManager>(); var adName = actionContext?.RequestContext?.Principal?.Identity?.Name; if (!string.IsNullOrEmpty(adName)) { var workUser = cache.Get <WorkUser>(adName); if (workUser == null) { var rep = ContainerManager.Resolve <IEfRepository>(); var user = rep.FirstOrDefault <UserModel>(s => s.UserAccount == adName); if (user != null) { var userViewModel = new UserViewModel { UserCode = user.UserCode, CompanyCode = user.CompanyCode, CreateTime = user.CreateTime, CreateUser = user.CreateUser, Id = user.Id, UserAccount = user.UserAccount, UserAddress = user.UserAddress, UserDept = user.UserDept, UserMail = user.UserMail, UserName = user.UserName, UserTel = user.UserTel, CompanyName = rep.FirstOrDefault <CompanyInfo>(s => s.CompanyCode == user.CompanyCode)?.CompanyName, UserCompany = user.UserCompany }; var userRole = rep.Where <UserRole>(s => s.UserCode == user.UserCode); var isSuperAdmin = userRole.Any(s => s.RoleId == "EF153464-0340-494F-AB72-A734733CF996") ? 1 : 0; var isAreaAdmin = userRole.Any(s => s.RoleId == "D07599DC-0D53-4C73-9ADB-33F0D9AE9426" || s.RoleId == "7DB07F89-4475-4CA1-AB39-A563DE901D4C" || s.RoleId == "61359D91-52F2-42D7-B2AE-A70ACFD39653") ? 1 : 0; workUser = new WorkUser { UserInfo = userViewModel, UserRoles = userRole, IsSuperAdmin = isSuperAdmin, IsAreaAdmin = isAreaAdmin }; ContainerManager.Resolve <ICacheManager>().Set(user.UserCode, workUser); base.OnAuthorization(actionContext); } else { actionContext.Response = actionContext.ControllerContext.Request.CreateErrorResponse(HttpStatusCode.Unauthorized, "无权限"); } } } else { actionContext.Response = actionContext.ControllerContext.Request.CreateErrorResponse(HttpStatusCode.Unauthorized, "无权限"); } }
/// <summary> /// 删除关键词 /// </summary> /// <param name="meetInfo"></param> /// <param name="workUser"></param> /// <returns></returns> public ReturnValueModel DeleteWords(WordBlackList viewModel, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); var model = _rep.FirstOrDefault <WordBlackList>(s => s.Id == viewModel.Id); if (model == null) { rvm.Success = false; rvm.Msg = "Invalid Id"; return(rvm); } if (model.IsDeleted == 1) { rvm.Msg = "It has been deleted already."; rvm.Success = true; return(rvm); } model.IsDeleted = 1; _rep.Update(model); _rep.SaveChanges(); rvm.Msg = "success"; rvm.Success = true; return(rvm); }
/// <summary> /// 临床指南列表 /// </summary> /// <param name="dataInfo">分页、搜索</param> /// <param name="workUser"></param> /// <returns></returns> public ReturnValueModel GetGuideList(RowNumModel <DataInfo> dataInfo, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); var list = from a in _rep.Where <DataInfo>(s => s.IsDeleted != 1) //join b in _rep.Table<BuProDeptRel>() on a.Id equals b.DataInfoId where a.MediaType == 2 && a.IsDeleted != 1 select a; if (!string.IsNullOrEmpty(dataInfo.SearchParams.Title)) { list = list.Where(s => s.Title.Contains(dataInfo.SearchParams.Title)); } if (workUser != null) { var UserDept = workUser.WxUser.DepartmentName; list = list.Where(s => s.Dept == UserDept); } var total = list.Count(); var rows = list.OrderByDescending(o => o.CreateTime) .ToPaginationList(dataInfo.PageIndex, dataInfo.PageSize); rvm.Success = true; rvm.Msg = ""; rvm.Result = new { total = total, rows = rows }; return(rvm); }
/// <summary> /// 删除短信模板 /// </summary> /// <param name="manage">需要删除的短信模板</param> /// <param name="workUser">操作用户</param> /// <returns></returns> public ReturnValueModel DeleteManagement(Management manage, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); ///查询需要删除的数据 var manageInfo = _rep.FirstOrDefault <Management>(s => s.ManagementId == manage.ManagementId); if (manageInfo == null) { rvm.Success = false; rvm.Msg = "Invalid Id"; return(rvm); } if (manageInfo.IsDeleted == 1) { rvm.Msg = "This management info has been deleted."; rvm.Success = true; return(rvm); } var approvalEnabled = _systemService.AdminApprovalEnabled; //是否启用审核 if (approvalEnabled) { switch (manageInfo.IsCompleted ?? EnumComplete.AddedUnapproved) { case EnumComplete.Approved: manageInfo.IsCompleted = EnumComplete.WillDelete; //将要删除(等待审核) _rep.Update(manageInfo); _rep.SaveChanges(); break; case EnumComplete.Reject: manageInfo.IsCompleted = EnumComplete.Approved; _rep.Update(manageInfo); _rep.SaveChanges(); break; case EnumComplete.AddedUnapproved: DoManagementInfoDeletion(manageInfo, workUser); break; case EnumComplete.UpdatedUnapproved: DoManagementInfoDeletion(manageInfo, workUser); //删除数据 break; default: rvm.Msg = "This meeting info can not be deleted at this time."; rvm.Success = false; return(rvm); } } else { DoManagementInfoDeletion(manageInfo, workUser); } rvm.Msg = "success"; rvm.Success = true; return(rvm); }
/// <summary> /// 内容: /// </summary> /// <param name="workUser"></param> /// <returns></returns> public async Task <ReturnValueModel> CreateContent(ContentCreateDto dto, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); try { var token = _cache.Get <KBSTokenOutDto>(workUser.User.Id + "KBS"); string _host = ConfigurationManager.AppSettings["KBSUrl"]; var result = await new WebClient <Result>() .Post($"{_host}Content") .BearerToken(token.Auth_token) .JsonData(dto) .ResultFromJsonAsync(); if (result?.Code == 0) { rvm.Msg = "fail"; rvm.Success = false; rvm.Result = result?.Message; return(rvm); } rvm.Msg = "success"; rvm.Success = true; rvm.Result = result.Data; } catch (Exception e) { rvm.Msg = "fail"; rvm.Success = false; rvm.Result = e.Message; } return(rvm); }
/// <summary> /// 获取KBS bot信息 /// </summary> /// <returns></returns> public async Task <ReturnValueModel> BotInfo(WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); try { var token = _cache.Get <KBSTokenOutDto>(workUser.User.Id + "KBS"); string _host = ConfigurationManager.AppSettings["KBSUrl"]; var result = await new WebClient <Result>() .Get($"{_host}BotManage/Select") .Header("Authorization", $"Bearer { token.Auth_token}") .ResultFromJsonAsync(); if (result?.Code == 0) { rvm.Msg = "fail"; rvm.Success = false; rvm.Result = result?.Message; return(rvm); } rvm.Msg = "success"; rvm.Success = true; rvm.Result = result.Data; } catch (Exception e) { rvm.Msg = "fail"; rvm.Success = false; rvm.Result = e.Message; } return(rvm); }
/// <summary> /// 验证验证码是否正确 /// </summary> /// <param name="workUser"></param> /// <param name="code">验证码</param> /// <returns></returns> public ReturnValueModel VerifyCode(WorkUser workUser, string code) { ReturnValueModel rvm = new ReturnValueModel(); string unionId = workUser?.WxUser?.UnionId; var wxUser = _rep.FirstOrDefault <WxUserModel>(s => s.IsDeleted != 1 && s.UnionId == unionId && s.Code == code /*&& s.CodeTime > DateTime.Now*/); if (wxUser != null) { rvm.Msg = "success"; rvm.Success = true; rvm.Result = new { wxUser = wxUser }; } else { rvm.Msg = "fail"; rvm.Success = false; } return(rvm); }
/// <summary> /// 融云-删除-聊天室保活服务 /// </summary> /// <returns></returns> public ReturnValueModel ChatroomKeepaliveRemove(ChatroomInputDto inputDto, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); string body = $"chatroomId={HttpUtility.UrlEncode(inputDto.Id, Encoding.UTF8)}"; string appKey = ConfigurationManager.AppSettings["RongCloudAppKey"]; string appSecret = ConfigurationManager.AppSettings["RongCloudAppSecret"]; string _host = ConfigurationManager.AppSettings["RongCloudUrl"]; string url = $"{_host}/chatroom/keepalive/remove.json"; String result = RongHttpClient.ExecutePost(appKey, appSecret, body, url, "application/x-www-form-urlencoded"); var res = (ResponseResult)RongJsonUtil.JsonStringToObj <ResponseResult>(result); if (res.Code == 200) { rvm.Msg = "success"; rvm.Success = true; rvm.Result = res; return(rvm); } else { rvm.Msg = "删除聊天室保活失败"; rvm.Success = false; rvm.Result = result; return(rvm); } }
/// <summary> /// 根据权限获取菜单 /// </summary> /// <param name="workUser">当前操作人</param> /// <returns></returns> public ReturnValueModel GetMenus(WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); var canRoleIds = workUser.Roles.Select(s => s.Id).ToList(); var norMenus = _rep.Where <MenuInfo>(s => s.IsDeleted != 1 && s.IsNormal == true).Select(s => s.Id).ToList(); var roleMenus = _rep.Where <RoleMenu>(s => canRoleIds.Contains(s.RoleId)).Select(s => s.MenuId).Union(norMenus).Distinct().ToList(); var allMenus = _rep.Where <MenuInfo>(s => s.IsDeleted != 1).OrderBy(s => s.Sort).ToList(); string rootId = Guid.Empty.ToString(); var roots = allMenus.Where(s => s.ParentId == rootId && roleMenus.Contains(s.Id)); List <MenuViewModel> menus = new List <MenuViewModel>(); foreach (var root in roots) { MenuViewModel menu = new MenuViewModel { Name = root.MenuName ?? "", Component = root.Component ?? "", IconCls = root.MenuIcons ?? "", Path = root.MenuPath ?? "", Leaf = root.Leaf ?? false, Hidden = root.Hidden ?? false, LinkPath = root.LinkPath ?? "", Children = new List <MenuViewModel>() }; GetChildrenMenus(allMenus, root, menu, roleMenus); menus.Add(menu); } rvm.Success = true; rvm.Msg = "success"; rvm.Result = menus; return(rvm); }
public LoginCine() { InitializeComponent(); workLogin = new WorkLogin(); workUser = new WorkUser(); user = new User(); }
/// <summary> /// 收藏功能 /// </summary> /// <param name="collectionInfo">收藏信息</param> /// <param name="workUser">当前操作用户</param> /// <returns></returns> public ReturnValueModel CollectionMeet(MyCollectionInfo collectionInfo, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); var myCollections = _rep.FirstOrDefault <MyCollectionInfo>(s => s.UnionId == workUser.WxUser.UnionId && s.CollectionDataId == collectionInfo.CollectionDataId && s.CollectionType == collectionInfo.CollectionType); if (myCollections == null) { collectionInfo.Id = Guid.NewGuid().ToString(); collectionInfo.UnionId = workUser.WxUser.UnionId; collectionInfo.CreateTime = DateTime.Now; _rep.Insert(collectionInfo); } else { _rep.Delete <MyCollectionInfo>(myCollections); } _rep.SaveChanges(); rvm.Success = true; rvm.Msg = ""; rvm.Result = new { collectionInfo }; return(rvm); }
/// <summary> /// 获取菜单 /// </summary> /// <param name="roleInfo">当前角色,传入Id</param> /// <param name="workUser">当前操作人</param> /// <returns></returns> public ReturnValueModel GetRoleMenus(RoleInfo roleInfo, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); //var canRoleIds = workUser.Roles.Select(s => s.Id).ToList(); var eEmpty = Guid.Empty.ToString(); var hasRole = _rep.Where <RoleMenu>(s => s.RoleId == roleInfo.Id).Select(s => s.MenuId).Distinct().ToList(); var hasRoleMenus = _rep.Where <MenuInfo>(s => hasRole.Contains(s.Id) && (s.ParentId != eEmpty || s.Leaf == true)).Select(s => s.Id); var allMenus = _rep.Where <MenuInfo>(s => s.IsDeleted != 1).OrderBy(s => s.Sort).ToList(); var rootId = Guid.Empty.ToString(); var roots = allMenus.Where(s => s.ParentId == rootId); List <MenuViewModel> menus = new List <MenuViewModel>(); foreach (var root in roots) { MenuViewModel menu = new MenuViewModel { Id = root.Id, Children = new List <MenuViewModel>(), Label = root.MenuName }; GetChildrenMenus(allMenus, root, menu); menus.Add(menu); } rvm.Success = true; rvm.Msg = "success"; rvm.Result = new { menus = menus, hasRoleMenus = hasRoleMenus }; return(rvm); }
/// <summary> /// 删除推广二维码信息 /// </summary> /// <param name="viewModel"></param> /// <param name="workUser"></param> /// <returns></returns> public ReturnValueModel DeleteAdQRCode(AdQRCode viewModel, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); if (string.IsNullOrEmpty(viewModel?.Id)) { rvm.Success = false; rvm.Msg = "The parameter 'Id' is required."; return(rvm); } AdQRCode model = _rep.FirstOrDefault <AdQRCode>(s => s.IsDeleted != 1 && s.Id == viewModel.Id); if (model == null) { rvm.Success = false; rvm.Msg = "Invalid Id."; return(rvm); } model.IsDeleted = 1; _rep.Update(model); _rep.SaveChanges(); rvm.Success = true; rvm.Msg = "success"; return(rvm); }
/// <summary> /// 横幅管理- 业务标签获取明细 /// </summary> /// <returns></returns> public ReturnValueModel GetByBusinessTag(string input, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); if (string.IsNullOrEmpty(input)) { rvm.Success = false; rvm.Msg = "The parameter 'Scene' is required."; return(rvm); } var bannerInfo = _rep.FirstOrDefault <BannerInfo>(o => o.Scene == input && o.IsDeleted == 0); List <BannerInfoItem> bannerInfoItem = new List <BannerInfoItem>(); if (bannerInfo != null) { bannerInfoItem = _rep.Where <BannerInfoItem>(o => o.BannerInfoId == bannerInfo.Id && o.IsDeleted == 0).OrderBy(o => o.Sort).ToList(); } rvm.Success = true; rvm.Msg = "success"; rvm.Result = new { bannerInfo, bannerInfoItem, }; return(rvm); }
/// <summary> /// 增改 /// </summary> /// <param name="data"></param> /// <param name="workUser"></param> /// <returns></returns> public ReturnValueModel AddOrUpdateItem(SpreadQRCode data, WorkUser workUser) { var item = _rep.FirstOrDefault <SpreadQRCode>(x => x.IsDeleted != 1 && x.Id == data.Id); if (item == null) { data.Id = Guid.NewGuid().ToString(); data.CreateTime = DateTime.Now; data.CreateUser = workUser?.User?.Id ?? ""; _rep.Insert(data); } else { item.SpreadAppId = data.SpreadAppId; item.SpreadName = data.SpreadName; item.SpreadQRCodeUrl = data.SpreadQRCodeUrl; item.UpdateTime = DateTime.Now; item.CreateUser = workUser?.User?.Id ?? ""; _rep.Update(item); } var val = _rep.SaveChanges() > 0 ? true : false; var result = new ReturnValueModel() { Msg = "Success", Success = val, Result = data }; return(result); }
public ReturnValueModel GetMeetQA(QuestionModel question, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); var meetQA = new MeetQAContentViewModel(); meetQA.Question = _rep.FirstOrDefault <QuestionModel>(s => s.Id == question.Id); meetQA.Answers = _rep.Where <AnswerModel>(s => s.IsDeleted != 1 && s.QuestionId == meetQA.Question.Id).OrderBy(s => s.Sort); if (meetQA.Question != null) { meetQA = FillFromQA(meetQA); rvm.Msg = "success"; rvm.Success = true; rvm.Result = new { meetQA = meetQA }; } else { rvm.Msg = "fail"; rvm.Success = false; } return(rvm); }
/// <summary> /// 伪删除 /// </summary> /// <param name="data"></param> /// <param name="workUser"></param> /// <returns></returns> public ReturnValueModel DeleteItem(SpreadQRCode data, WorkUser workUser) { var result = new ReturnValueModel() { }; var item = _rep.FirstOrDefault <SpreadQRCode>(x => x.IsDeleted != 1 && x.Id == data.Id); if (item != null) { item.IsDeleted = 1; item.UpdateUser = workUser?.User?.Id ?? ""; item.UpdateTime = DateTime.Now; _rep.Update(item); _rep.SaveChanges(); result.Success = true; result.Msg = "Success"; result.Result = new { item }; } else { result.Success = false; result.Msg = "Invalid Id."; } return(result); }
/// <summary> /// BOT配置- 删除 /// </summary> /// <param name="viewModel"></param> /// <param name="workUser"></param> /// <returns></returns> public ReturnValueModel DeleteMenusSaleConfigure(BotSaleConfigure dto, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); if (string.IsNullOrEmpty(dto?.Id)) { rvm.Success = false; rvm.Msg = "The parameter 'Id' is required."; return(rvm); } BotSaleConfigure model = _rep.FirstOrDefault <BotSaleConfigure>(s => s.IsDeleted != 1 && s.Id == dto.Id); if (model == null) { rvm.Success = false; rvm.Msg = "Invalid Id."; return(rvm); } model.IsDeleted = 1; model.UpdateTime = DateTime.Now; model.UpdateUser = workUser.User.Id; _rep.Update(model); _rep.SaveChanges(); rvm.Success = true; rvm.Msg = "success"; return(rvm); }
/// <summary> /// 删除产品 /// </summary> /// <param name="proList">传入模型数组,只需要Id</param> /// <param name="workUser"></param> /// <returns></returns> public ReturnValueModel DelProduct(List <ProductInfo> proList, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); if (proList == null) { rvm.Success = false; return(rvm); } var ids = proList.Where(s => s != null).Select(s => s.Id).ToList(); var list = _rep.Where <ProductInfo>(s => ids.Contains(s.Id)).ToList(); foreach (var item in list) { item.IsDeleted = 1; } _rep.UpdateList(list); _rep.SaveChanges(); rvm.Success = true; rvm.Msg = ""; return(rvm); }
/// <summary> /// 查询目录列表 /// </summary> /// <param name="row"></param> /// <param name="workUser"></param> /// <returns></returns> public ReturnValueModel GetHcpCatalogueList(string buName, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); var data = _rep.Where <HcpCatalogueManage>(s => s.BuName == buName && s.IsDeleted == 0).ToList(); //如果目录列表为空 生成默认目录 if (data == null || data.Count <= 0) { var defaultCatalogue = new HcpCatalogueManage(); defaultCatalogue.Id = Guid.NewGuid().ToString(); defaultCatalogue.BuName = buName; defaultCatalogue.CatalogueName = "默认目录"; defaultCatalogue.CreateTime = DateTime.Now; defaultCatalogue.CreateUser = workUser.User.Id; _rep.Insert(defaultCatalogue); data.Add(defaultCatalogue); _rep.SaveChanges(); } var res = data.OrderByDescending(o => o.CreateTime).Select(o => new { o.Id, o.BuName, o.CatalogueName, o.CreateTime, IsDefault = o.CatalogueName == "默认目录" ? true : false }).ToList(); rvm.Success = true; rvm.Msg = ""; rvm.Result = res; return(rvm); }
/// <summary> /// buprodept关系 /// </summary> /// <param name="workUser"></param> /// <returns></returns> public ReturnValueModel BuProDeptRelMap(WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); var pros = _rep.Table <ProductInfo>(); var depts = _rep.Table <DepartmentInfo>(); var list = from a in _rep.Table <BuProDeptRel>() group a by a.BuName into g1 select new { BuName = g1.Key, DeptPro = from b in g1 join c in pros on b.ProId equals c.Id where b.BuName == g1.Key group b by c into g2 select new { ProId = g2.Key.Id, ProName = g2.Key.ProductName, ProUrl = g2.Key.ProductUrl, Depts = from d in g2 join e in depts on d.DeptId equals e.Id select e } }; rvm.Success = true; rvm.Msg = ""; rvm.Result = new { list }; return(rvm); }
/// <summary> /// 删除公众号推广信息 /// </summary> /// <param name="publicaccount"></param> /// <param name="workUser"></param> /// <returns></returns> public ReturnValueModel DeletePublicAccount(PublicAccount publicAccount, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); //查询要删除的对象 var deletePublic = _rep.FirstOrDefault <PublicAccount>(s => s.Id == publicAccount.Id && s.IsDeleted != 1 /*"select * from PublicAccount where Id='"+publicaccount.Id+"' and IsDeleted=0"*/); //判断需要删除的数据是否存在 if (deletePublic != null) { try { deletePublic.IsDeleted = 1; deletePublic.UpdateTime = DateTime.Now; deletePublic.UpdateUser = workUser.User.Id; _rep.Delete(deletePublic); var send = _rep.SaveChanges(); } catch (Exception ex) { rvm.Success = false; rvm.Msg = "'" + ex + "'"; throw; } rvm.Success = true; rvm.Msg = "success"; rvm.Result = deletePublic ?? deletePublic; } else { rvm.Success = true; rvm.Msg = "No such data was found."; } return(rvm); }
public ReturnValueModel AddOrUpdateDepartmentInfo(DepartmentInfo department, WorkUser workUser) { ReturnValueModel rvm = new ReturnValueModel(); var item = _rep.FirstOrDefault <DepartmentInfo>(s => s.Id == department.Id); if (item != null) { department.Id = item.Id; item = department; item.UpdateTime = DateTime.Now; item.UpdateUser = workUser.User.Id; _rep.Update(item); _rep.SaveChanges(); } else { department.Id = Guid.NewGuid().ToString(); department.CreateTime = DateTime.Now; department.CreateUser = workUser.User.Id; _rep.Insert(department); _rep.SaveChanges(); } rvm.Msg = "success"; rvm.Success = true; rvm.Result = new { department = department }; return(rvm); }