/// <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);
}
