public IActionResult Create(RoleCreateViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
if (model.RoleName.Trim().Length <= 0)
{
response.SetFailed("请输入角色名称");
return(Ok(response));
}
using (_dbContext)
{
if (_dbContext.SystemRole.Count(x => x.RoleName == model.RoleName) > 0)
{
response.SetFailed("角色已存在");
return(Ok(response));
}
var entity = new SystemRole();
entity.SystemRoleUuid = Guid.NewGuid();
entity.RoleName = model.RoleName;
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
entity.AddPeople = AuthContextService.CurrentUser.DisplayName;
entity.IsDeleted = 0;
_dbContext.SystemRole.Add(entity);
int res = _dbContext.SaveChanges();
if (res > 0)
{
ToLog.AddLog("添加", "成功:添加:系统角色管理列表数据", _dbContext);
}
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(Entities.RestsData model)
{
using (_dbContext)
{
var response = ResponseModelFactory.CreateResultInstance;
var query = _dbContext.RestsData.FirstOrDefault(x => x.Name == model.Name && x.Type == model.Type);
if (query != null)
{
response.SetFailed("该类别名称已存在");
return(Ok(response));
}
var entity = new Entities.RestsData
{
RestsDataUuid = Guid.NewGuid(),
Name = model.Name,
Accessory = model.Accessory,
Type = model.Type,
UpdatePeople = AuthContextService.CurrentUser.LoginName,
UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
AddPeople = AuthContextService.CurrentUser.LoginName,
AddTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
};
_dbContext.RestsData.Add(entity);
var res = _dbContext.SaveChanges();
if (res > 0)
{
ToLog.AddLog("添加", "成功:添加:其他数据信息一条数据", _dbContext);
}
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(ProclamationViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var entity = new Proclamation();
entity.ProclamationTitle = model.ProclamationTitle;
entity.ProclamationContent = model.ProclamationContent;
entity.Remark = model.Remark;
entity.SortId = model.SortId;
entity.IsStick = model.IsStick;
entity.ProclamationUuid = Guid.NewGuid();
entity.IsDeleted = 0;
entity.AddPeople = AuthContextService.CurrentUser.LoginName;
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
_dbContext.Proclamation.Add(entity);
int res = _dbContext.SaveChanges();
if (res > 0)
{
ToLog.AddLog("添加", "成功:添加:通知公告列表信息一条数据", _dbContext);
}
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(ColumnViewModel vmodel)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
if (_dbContext.Content.Any(x => x.ColumnTitle == vmodel.ColumnTitle && x.IsDeleted == 0))
{
response.SetFailed("已存在该名称的栏目");
return(Ok(response));
}
var query = _dbContext.Column.FirstOrDefault(x => x.ColumnUuid == vmodel.SuperiorUuid);
if (query == null)
{
response.SetFailed("请填写上级栏目");
return(Ok(response));
}
if (vmodel.IssueTime == "")
{
response.SetFailed("请选择发布时间");
return(Ok(response));
}
var entity = new Content();
entity.ColumnUuid = Guid.NewGuid();
entity.IsDeleted = 0;
entity.ColumnTitle = vmodel.ColumnTitle;
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
entity.AddPeople = AuthContextService.CurrentUser.LoginName;
entity.SuperiorUuid = vmodel.SuperiorUuid;
entity.SuperiorMenu = query.SuperiorMenu + 1;
entity.ColumnTitleText = query.ColumnTitle;
entity.ColumnModel = "列表栏目";
entity.ColumnContent = vmodel.ColumnContent;
entity.Staue = vmodel.Staue;
entity.SortId = vmodel.SortId;
entity.IsStick = vmodel.IsStick;
if (!string.IsNullOrEmpty(vmodel.IssueTime))
{
entity.IssueTime = Convert.ToDateTime(vmodel.IssueTime).ToString("yyyy-MM-dd");
}
_dbContext.Content.Add(entity);
int res = _dbContext.SaveChanges();
if (res > 0)
{
ToLog.AddLog("添加", "成功:添加:内容管理信息一条数据", _dbContext);
}
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(ColumnViewModel vmodel)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
if (_dbContext.Column.Any(x => x.ColumnTitle == vmodel.ColumnTitle && x.IsDeleted == 0 && x.SuperiorUuid == vmodel.SuperiorUuid))
{
response.SetFailed("已存在该名称的栏目");
return(Ok(response));
}
var entity = new Column();
entity.ColumnUuid = Guid.NewGuid();
entity.IsDeleted = 0;
entity.ColumnTitle = vmodel.ColumnTitle;
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
entity.AddPeople = AuthContextService.CurrentUser.LoginName;
//if (vmodel.SuperiorUuid == null || vmodel.SuperiorUuid == Guid.Empty)
//{
// entity.SuperiorUuid = Guid.Empty;
// entity.SuperiorMenu = 0;
//}
//else
//{
// Guid? newuuid = vmodel.SuperiorUuid;
// var supentity = _dbContext.Column.FirstOrDefault(x => x.ColumnUuid == newuuid);
// entity.SuperiorMenu = supentity.SuperiorMenu + 1;
// entity.SuperiorUuid = newuuid;
//}
entity.SuperiorUuid = vmodel.SuperiorUuid;
entity.SuperiorMenu = vmodel.SuperiorUuid == null ? 0 : 1;
entity.ColumnModel = vmodel.ColumnModel;
entity.IsStick = vmodel.IsStick;
entity.ColumnContent = vmodel.ColumnContent;
entity.SortId = vmodel.SortId;
_dbContext.Column.Add(entity);
int res = _dbContext.SaveChanges();
if (res > 0)
{
ToLog.AddLog("添加", "成功:添加:栏目列表信息一条数据", _dbContext);
}
response.SetSuccess("操作成功");
return(Ok(response));
}
}
public IActionResult Create(NewsViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
if (_dbContext.News.Count(x => x.NewsTitle == model.NewsTitle) > 0)
{
response.SetFailed("标题已存在");
return(Ok(response));
}
var entity = new News();
entity.NewsTitle = model.NewsTitle;
entity.NewSubhead = model.NewSubhead;
entity.NewsTypeUuid = model.NewsTypeUuid;
entity.NewsContent = model.NewsContent;
entity.NewsPic = model.NewsPic;
if (!string.IsNullOrEmpty(model.NewsUrl))
{
entity.NewsUrl = Convert.ToDateTime(model.NewsUrl).ToString("yyyy-MM-dd HH:mm:ss");
}
entity.Video = model.Video;
entity.File = model.File;
entity.Staue = model.Staue;
entity.SortId = model.SortId;
entity.IsStick = model.IsStick;
entity.NewsUuid = Guid.NewGuid();
entity.IsDeleted = 0;
entity.AddPeople = AuthContextService.CurrentUser.LoginName;
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
_dbContext.News.Add(entity);
int res = _dbContext.SaveChanges();
if (res > 0)
{
ToLog.AddLog("添加", "成功:添加:新闻列表信息一条数据", _dbContext);
}
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(MenuCreateViewModel model)
{
using (_dbContext)
{
var entity = _mapper.Map <MenuCreateViewModel, SystemMenu>(model);
entity.CreatedOn = DateTime.Now.ToString("yyyy-MM-dd");
entity.SystemMenuUuid = Guid.NewGuid();
entity.CreatedByUserGuid = AuthContextService.CurrentUser.Guid;
entity.CreatedByUserName = AuthContextService.CurrentUser.DisplayName;
entity.IsDeleted = 0;
entity.Icon = string.IsNullOrEmpty(entity.Icon) ? "md-menu" : entity.Icon;
_dbContext.SystemMenu.Add(entity);
int res = _dbContext.SaveChanges();
if (res > 0)
{
ToLog.AddLog("添加", "成功:添加:系统菜单管理列表数据", _dbContext);
}
var response = ResponseModelFactory.CreateInstance;
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(NewsTypeViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var entity = new NewsType();
entity.NewsTypeName = model.NewsTypeName;
entity.NewsTypeUuid = Guid.NewGuid();
entity.Remark = model.Remark;
entity.IsDeleted = 0;
entity.AddPeople = AuthContextService.CurrentUser.LoginName;
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
_dbContext.NewsType.Add(entity);
int res = _dbContext.SaveChanges();
if (res > 0)
{
ToLog.AddLog("添加", "成功:添加:新闻类型列表信息一条数据", _dbContext);
}
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(PermissionCreateViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
if (model.Name.Trim().Length <= 0)
{
response.SetFailed("请输入权限名称");
return(Ok(response));
}
using (_dbContext)
{
if (_dbContext.SystemPermission.Count(x => x.ActionCode == model.ActionCode && x.SystemMenuUuid == model.SystemMenuUuid) > 0)
{
response.SetFailed("权限操作码已存在");
return(Ok(response));
}
if (_dbContext.SystemPermission.Count(x => x.Name == model.Name && x.SystemMenuUuid == model.SystemMenuUuid) > 0)
{
response.SetFailed("权限名称已存在");
return(Ok(response));
}
var entity = _mapper.Map <PermissionCreateViewModel, SystemPermission>(model);
entity.CreatedOn = DateTime.Now.ToString("yyyy-MM-dd");
entity.SystemPermissionUuid = Guid.NewGuid();
entity.CreatedByUserGuid = AuthContextService.CurrentUser.Guid;
entity.CreatedByUserName = AuthContextService.CurrentUser.DisplayName;
_dbContext.SystemPermission.Add(entity);
int res = _dbContext.SaveChanges();
if (res > 0)
{
ToLog.AddLog("添加", "成功:添加:系统权限管理列表数据", _dbContext);
}
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Edit(GlobalViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var query = _dbContext.SystemSetting.FirstOrDefault(x => x.ClobalUuid == model.ClobalUuid);
query.ClobalName = model.ClobalName;
query.GlobalLogo = model.GlobalLogo;
query.Globalurl = model.Globalurl;
query.CountTime = Convert.ToDateTime(model.CountTime).ToString("yyyy-MM-dd");
query.AddTime = DateTime.Now;
_dbContext.SaveChanges();
response.SetSuccess();
return Ok(response);
}
}
public static string AddLog(string Typem, string Content, haiKanChemistryContext _dbContext)
{
string messange = "";
var entity = new HaikanCMS.Api.Entities.SystemLog();
entity.SystemLogUuid = Guid.NewGuid();
entity.UserId = AuthContextService.CurrentUser.Guid.ToString();
entity.UserName = AuthContextService.CurrentUser.LoginName;
entity.Type = Typem;
entity.OperationContent = Content;
entity.OperationTime = DateTime.Now;
entity.AddTime = DateTime.Now;
entity.AddPeople = "系统日志";
entity.IsDelete = 0;
_dbContext.SystemLog.Add(entity);
_dbContext.SaveChanges();
return(messange);
}
/// <summary>
/// 获取访问量
/// </summary>
/// <returns></returns>
public IActionResult SetVisit()
{
using (_dbContext)
{
var response = ResponseModelFactory.CreateResultInstance;
Visit model = new Visit();
model.VisitUuid = Guid.NewGuid();
model.AddTime = DateTime.Now;
_dbContext.Visit.Add(model);
_dbContext.SaveChanges();
var sysset = _dbContext.SystemSetting.First();
var ctime = Convert.ToDateTime(sysset.CountTime);
var date = ctime.ToString("yyyy年MM月dd日");
var datalist = _dbContext.Visit.Count();
if (datalist > 0)
{
datalist = _dbContext.Visit.Where(x => x.AddTime >= ctime).Count();
}
response.SetData(new { date, datalist });
return(Ok(response));
}
}
public IActionResult Create(UserCreateViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
if (model.LoginName.Trim().Length <= 0)
{
response.SetFailed("请输入登录名称");
return(Ok(response));
}
using (_dbContext)
{
if (_dbContext.SystemUser.Count(x => x.LoginName == model.LoginName) > 0)
{
response.SetFailed("登录名已存在");
return(Ok(response));
}
//if ((!string.IsNullOrEmpty(model.UserIdCard))&& _dbContext.SystemUser.Count(x => x.UserIdCard == model.UserIdCard) > 0)
//{
// response.SetFailed("身份证号已存在");
// return Ok(response);
//}
if (string.IsNullOrEmpty(model.SystemRoleUuid))
{
response.SetFailed("请选择角色");
return(Ok(response));
}
var entity = _mapper.Map <UserCreateViewModel, SystemUser>(model);
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
entity.SystemUserUuid = Guid.NewGuid();
var rolename = _dbContext.SystemRole.FirstOrDefault(x => x.RoleName == "超级管理员");
if (model.SystemRoleUuid.Contains(rolename.SystemRoleUuid.ToString()))
{
entity.UserType = 0;
}
else
{
entity.UserType = 2;
}
entity.SystemRoleUuid = "";
entity.PassWord = Haikan3.Utils.DesEncrypt.Encrypt(model.PassWord.Trim(), MdDesEncrypt.SecretKey);
//for (int i = 0; i < model.SystemRoleUuid.Count; i++)
//{
// entity.SystemRoleUuid += model.SystemRoleUuid[i] + ",";
//}
entity.SystemRoleUuid = model.SystemRoleUuid;
entity.SystemRoleUuid = entity.SystemRoleUuid.TrimEnd(',');
//entity.OldCard = model.OldCard;
entity.Phone = model.Phone;
entity.Sex = model.Sex;
entity.Placeofresidence = model.Placeofresidence;
entity.Age = model.Age;
entity.Nickname = model.Nickname;
_dbContext.SystemUser.Add(entity);
int res = _dbContext.SaveChanges();
if (res > 0)
{
ToLog.AddLog("添加", "成功:添加:系统用户管理列表数据", _dbContext);
}
_dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUserRoleMapping WHERE SystemUserUUID={0}", entity.SystemUserUuid);
var success = true;
//循环加权限
//for (int i = 0; i < model.SystemRoleUuid.Count; i++)
//{
// if (model.SystemRoleUuid[i] != "")
// {
// var roles = new SystemUserRoleMapping();
// roles.SystemUserUuid = entity.SystemUserUuid;
// roles.SystemRoleUuid = Guid.Parse(model.SystemRoleUuid[i]);
// roles.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
// roles.AddPeople = AuthContextService.CurrentUser.DisplayName;
// _dbContext.SystemUserRoleMapping.Add(roles);
// }
//}
//非循环加权
var roles = new SystemUserRoleMapping();
roles.SystemUserUuid = entity.SystemUserUuid;
roles.SystemRoleUuid = Guid.Parse(model.SystemRoleUuid);
roles.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
roles.AddPeople = AuthContextService.CurrentUser.DisplayName;
_dbContext.SystemUserRoleMapping.Add(roles);
success = _dbContext.SaveChanges() > 0;
if (success)
{
response.SetSuccess();
}
else
{
_dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUser WHERE SystemUserUUID={0}", entity.SystemUserUuid);
response.SetFailed("保存用户角色数据失败");
}
return(Ok(response));
}
}
public IActionResult WXAuth(WXUserInfo info)
{
var response = ResponseModelFactory.CreateInstance;
SystemUser user = new SystemUser();
using (_dbContext)
{
var entity = _dbContext.SystemUser.FirstOrDefault(x => x.Wechat == info.Openid);
string nowdate = DateTime.Now.ToString("yyyy-MM-dd");
if (entity == null)
{
user.SystemUserUuid = Guid.NewGuid();
user.LoginName = info.NickName;
user.Nickname = info.NickName;
user.RealName = "";
user.Wechat = info.Openid;
//授权登录的普通用户
user.UserType = 5;
user.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
if (info.Sex == 0)
{
user.Sex = "未知";
}
if (info.Sex == 1)
{
user.Sex = "男";
}
if (info.Sex == 2)
{
user.Sex = "女";
}
//user.Phone = info.Phone;
user.IsDeleted = 0;
user.SystemRoleUuid = _dbContext.SystemRole.FirstOrDefault(x => x.RoleName == "微信用户").SystemRoleUuid.ToString();
_dbContext.SystemUser.Add(user);
//判断当天用户增加次数
//var ac = _dbContext.ActiveQuantity.FirstOrDefault(x => x.Type == 1 && x.AddTime== nowdate);
//if (ac == null)
//{
// ac = new ActiveQuantity();
// ac.ActiveQuantityUuid = Guid.NewGuid();
// ac.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
// ac.Num = 1;
// ac.Type = 1;
// _dbContext.ActiveQuantity.Add(ac);
//}
//else
//{
// ac.Num = ac.Num + 1;
//}
}
else
{
entity.LoginName = info.NickName;
entity.IsDeleted = 0;
//判断当天用户登录次数
//var ac = _dbContext.ActiveQuantity.FirstOrDefault(x => x.Type == 2 && x.AddTime == nowdate);
//if(ac==null)
//{
// ac = new ActiveQuantity();
// ac.ActiveQuantityUuid = Guid.NewGuid();
// ac.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
// ac.Num = 1;
// ac.Type = 2;
// _dbContext.ActiveQuantity.Add(ac);
//}
//else
//{
// ac.Num = ac.Num + 1;
//}
}
_dbContext.SaveChanges();
response.SetSuccess("授权成功");
return(Ok(response));
}
}