/// <summary>
/// 保存一条回复（管理）
/// </summary>
/// <param name="mo"></param>
/// <returns></returns>
public ActionResultVM ReplyAdminSave(Domain.UserReply mo)
{
var vm = new ActionResultVM();
var uinfo = new Application.UserAuthService(HttpContext).Get();
var oldmo = db.UserReply.FirstOrDefault(x => x.UrId == mo.UrId);
if (oldmo != null)
{
oldmo.UrAnonymousName = mo.UrAnonymousName;
oldmo.UrAnonymousMail = mo.UrAnonymousMail;
oldmo.UrAnonymousLink = mo.UrAnonymousLink;
oldmo.UrStatus = mo.UrStatus;
db.UserReply.Update(oldmo);
int num = db.SaveChanges();
vm.Set(num > 0);
}
return(vm);
}
public ActionResultVM DelCatalog(string code, string id)
{
var vm = new ActionResultVM();
var uinfo = new Application.UserAuthService(HttpContext).Get();
using var db = new ContextBase();
var ds = db.DocSet.Find(code);
if (ds?.Uid != uinfo.UserId)
{
vm.Set(ARTag.unauthorized);
return(vm);
}
var listdsd = db.DocSetDetail.Where(x => x.DsCode == code && string.IsNullOrEmpty(x.DsdContentMd)).ToList();
var removelist = Core.TreeTo.FindToTree(listdsd, "DsdPid", "DsdId", new List <string> {
id
});
removelist.Add(listdsd.Where(x => x.DsdId == id).FirstOrDefault());
db.DocSetDetail.RemoveRange(removelist);
int num = db.SaveChanges();
vm.Set(num > 0);
return(vm);
}
/// <summary>
/// 用户
/// </summary>
/// <param name="q"></param>
/// <param name="page"></param>
/// <returns></returns>
public IActionResult Index(string q, int page = 1)
{
string id = RouteData.Values["id"]?.ToString();
if (string.IsNullOrWhiteSpace(id))
{
return(Redirect("/doc"));
}
int uid = Convert.ToInt32(id);
using (var db = new Data.ContextBase())
{
var mu = db.UserInfo.Find(uid);
if (mu == null)
{
return(Content("Account is empty"));
}
ViewData["Nickname"] = mu.Nickname;
}
var uinfo = new Application.UserAuthService(HttpContext).Get();
var ps = Application.CommonService.DocQuery(q, uid, uinfo.UserId, page);
ps.Route = Request.Path;
ViewData["q"] = q;
return(View("_PartialDocList", ps));
}
public ActionResultVM UpdatePassword(string oldpwd, string newpwd)
{
var vm = new ActionResultVM();
int uid = new Application.UserAuthService(HttpContext).Get().UserId;
using (var db = new Data.ContextBase())
{
var userinfo = db.UserInfo.Find(uid);
if (userinfo.UserPwd == Core.CalcTo.MD5(oldpwd))
{
userinfo.UserPwd = Core.CalcTo.MD5(newpwd);
db.UserInfo.Update(userinfo);
var num = db.SaveChanges();
vm.Set(num > 0);
}
else
{
vm.Set(ARTag.unauthorized);
}
};
return(vm);
}
public ActionResultVM ListUserConn(int a)
{
var vm = new ActionResultVM();
int wid = Convert.ToInt32(RouteData.Values["id"]?.ToString());
var uinfo = new Application.UserAuthService(HttpContext).Get();
using (var db = new ContextBase())
{
var uw = db.UserWriting.Find(wid);
var uc = db.UserConnection.Where(x => x.Uid == uinfo.UserId && x.UconnTargetId == wid.ToString() && x.UconnAction == a).FirstOrDefault();
if (uc == null)
{
uc = new UserConnection()
{
UconnId = Core.UniqueTo.LongId().ToString(),
UconnAction = a,
UconnCreateTime = DateTime.Now,
UconnTargetId = wid.ToString(),
UconnTargetType = Application.EnumService.ConnectionType.UserWriting.ToString(),
Uid = uinfo.UserId
};
db.UserConnection.Add(uc);
if (a == 1)
{
uw.UwLaud += 1;
}
if (a == 2)
{
uw.UwMark += 1;
}
db.UserWriting.Update(uw);
vm.Data = "1";
}
else
{
db.UserConnection.Remove(uc);
if (a == 1)
{
uw.UwLaud -= 1;
}
if (a == 2)
{
uw.UwMark -= 1;
}
db.UserWriting.Update(uw);
vm.Data = "0";
}
int num = db.SaveChanges();
vm.Set(num > 0);
}
return(vm);
}
/// <summary>
/// 保存一篇文章（管理）
/// </summary>
/// <param name="mo"></param>
/// <returns></returns>
public ActionResultVM WriteAdminSave(Domain.UserWriting mo)
{
var vm = new ActionResultVM();
var uinfo = new Application.UserAuthService(HttpContext).Get();
var oldmo = db.UserWriting.FirstOrDefault(x => x.UwId == mo.UwId);
if (oldmo != null)
{
oldmo.UwStatus = mo.UwStatus;
oldmo.UwReplyNum = mo.UwReplyNum;
oldmo.UwReadNum = mo.UwReadNum;
oldmo.UwLaud = mo.UwLaud;
oldmo.UwMark = mo.UwMark;
oldmo.UwOpen = mo.UwOpen;
db.UserWriting.Update(oldmo);
int num = db.SaveChanges();
vm.Set(num > 0);
}
return(vm);
}
public ActionResultVM WriteDel(int id)
{
var vm = new ActionResultVM();
int uid = new Application.UserAuthService(HttpContext).Get().UserId;
var mo1 = db.UserWriting.FirstOrDefault(x => x.Uid == uid && x.UwId == id);
if (mo1.UwStatus == -1)
{
vm.Set(ARTag.unauthorized);
}
else
{
db.UserWriting.Remove(mo1);
var mo2 = db.UserWritingTags.Where(x => x.UwId == id).ToList();
db.UserWritingTags.RemoveRange(mo2);
var mo3 = db.UserReply.Where(x => x.UrTargetId == id.ToString()).ToList();
db.UserReply.RemoveRange(mo3);
vm.Set(db.SaveChanges() > 0);
}
return(vm);
}
public ActionResultVM UserInfo()
{
var vm = new ActionResultVM();
try
{
var uinfo = new Application.UserAuthService(HttpContext).Get();
if (uinfo.UserId != 0)
{
vm.Data = uinfo;
vm.Set(ARTag.success);
}
else
{
vm.Set(ARTag.unauthorized);
}
}
catch (Exception ex)
{
vm.Set(ex);
Filters.FilterConfigs.WriteLog(HttpContext, ex);
}
return(vm);
}
public IActionResult Edit(string dsdid)
{
var code = RouteData.Values["id"]?.ToString();
var uinfo = new Application.UserAuthService(HttpContext).Get();
using (var db = new ContextBase())
{
var ds = db.DocSet.Find(code);
if (ds?.Uid != uinfo.UserId)
{
return(Content("unauthorized"));
}
}
var mo = new DocSetDetail
{
DsCode = code
};
if (!string.IsNullOrWhiteSpace(dsdid))
{
using var db = new ContextBase();
mo = db.DocSetDetail.Where(x => x.DsdId == dsdid).FirstOrDefault();
}
return(View(mo));
}
public ActionResultVM QueryNoteOne(int id)
{
var vm = new ActionResultVM();
var uinfo = new Application.UserAuthService(HttpContext).Get();
using (var db = new Data.ContextBase())
{
var mo = db.Notepad.Find(id);
if (mo == null)
{
vm.Set(ARTag.invalid);
}
else if (mo.Uid == uinfo.UserId)
{
vm.Set(ARTag.success);
vm.Data = mo;
}
else
{
vm.Set(ARTag.unauthorized);
}
}
return(vm);
}
public QueryDataOutputVM QueryNoteList(QueryDataInputVM ivm)
{
var ovm = new QueryDataOutputVM();
var uinfo = new Application.UserAuthService(HttpContext).Get();
var query = from a in db.Notepad
join b in db.UserInfo on a.Uid equals b.UserId
orderby a.NoteCreateTime descending
where a.Uid == uinfo.UserId
select new Domain.Notepad
{
NoteId = a.NoteId,
NoteTitle = a.NoteTitle,
NoteCreateTime = a.NoteCreateTime,
NoteUpdateTime = a.NoteUpdateTime,
Uid = a.Uid,
Spare3 = b.Nickname
};
if (!string.IsNullOrWhiteSpace(ivm.Pe1))
{
query = query.Where(x => x.NoteTitle.Contains(ivm.Pe1));
}
Application.CommonService.QueryJoin(query, ivm, ref ovm);
return(ovm);
}
public ActionResultVM WriteEditSave(Domain.UserWriting mo, int UwId, string TagIds)
{
var vm = new ActionResultVM();
try
{
var lisTagId = new List <int>();
TagIds.Split(',').ToList().ForEach(x => lisTagId.Add(Convert.ToInt32(x)));
var lisTagName = Application.CommonService.TagsQuery().Where(x => lisTagId.Contains(x.TagId)).ToList();
int uid = new Application.UserAuthService(HttpContext).Get().UserId;
var oldmo = db.UserWriting.FirstOrDefault(x => x.Uid == uid && x.UwId == UwId);
if (oldmo.UwStatus == -1)
{
vm.Set(ARTag.unauthorized);
}
else if (oldmo != null)
{
oldmo.UwTitle = mo.UwTitle;
oldmo.UwCategory = mo.UwCategory;
oldmo.UwContentMd = mo.UwContentMd;
oldmo.UwContent = mo.UwContent;
oldmo.UwUpdateTime = DateTime.Now;
db.UserWriting.Update(oldmo);
var wt = db.UserWritingTags.Where(x => x.UwId == UwId).ToList();
db.UserWritingTags.RemoveRange(wt);
var listwt = new List <Domain.UserWritingTags>();
foreach (var tag in lisTagId)
{
var wtmo = new Domain.UserWritingTags
{
UwId = mo.UwId,
TagId = tag,
TagName = lisTagName.Where(x => x.TagId == tag).FirstOrDefault().TagName
};
listwt.Add(wtmo);
}
db.UserWritingTags.AddRange(listwt);
int num = db.SaveChanges();
vm.Set(num > 0);
}
}
catch (Exception ex)
{
Core.ConsoleTo.Log(ex);
vm.Set(ex);
}
return(vm);
}
public IActionResult Index(string q, int page = 1)
{
var uinfo = new Application.UserAuthService(HttpContext).Get();
var ps = Application.CommonService.DocQuery(q, 0, uinfo.UserId, page);
ps.Route = Request.Path;
ViewData["q"] = q;
return(View("_PartialDocList", ps));
}
public IActionResult Setting()
{
var uinfo = new Application.UserAuthService(HttpContext).Get();
using (var db = new Data.ContextBase())
{
var mo = db.UserInfo.Find(uinfo.UserId);
return(View(mo));
};
}
public ActionResultVM Delete(string id)
{
var vm = new ActionResultVM();
try
{
if (string.IsNullOrWhiteSpace(id))
{
vm.Set(ARTag.invalid);
}
else
{
var uinfo = new Application.UserAuthService(HttpContext).Get();
if (uinfo.UserId != 0)
{
using var db = new Data.ContextBase();
var mo = db.GuffRecord.Find(id);
if (mo == null)
{
vm.Set(ARTag.invalid);
}
else
{
if (mo.Uid != uinfo.UserId)
{
vm.Set(ARTag.unauthorized);
}
else if (mo.GrStatus == -1)
{
vm.Set(ARTag.refuse);
}
else
{
db.Remove(mo);
int num = db.SaveChanges();
vm.Set(num > 0);
}
}
}
else
{
vm.Set(ARTag.unauthorized);
}
}
}
catch (Exception ex)
{
vm.Set(ex);
Filters.FilterConfigs.WriteLog(HttpContext, ex);
}
return(vm);
}
public ActionResultVM List(string category, string q, int uid, string nv, string tag, string obj, int page = 1)
{
var vm = new ActionResultVM();
try
{
//所属用户
var OwnerId = 0;
if (uid != 0)
{
OwnerId = uid;
}
var uinfo = new Application.UserAuthService(HttpContext).Get();
if (new List <string> {
"me", "melaud", "mereply"
}.Contains(category))
{
if (uinfo.UserId == 0)
{
vm.Set(ARTag.unauthorized);
}
else
{
if (category == "me")
{
OwnerId = uinfo.UserId;
}
var pvm = Application.CommonService.GuffQuery(category, q, nv, tag, obj, OwnerId, uinfo.UserId, page);
vm.Data = pvm;
vm.Set(ARTag.success);
}
}
else
{
var pvm = Application.CommonService.GuffQuery(category, q, nv, tag, obj, OwnerId, uinfo.UserId, page);
vm.Data = pvm;
vm.Set(ARTag.success);
}
}
catch (Exception ex)
{
vm.Set(ex);
Filters.FilterConfigs.WriteLog(HttpContext, ex);
}
return(vm);
}
public ActionResultVM Save(DocSetDetail mo)
{
var vm = new ActionResultVM();
var uinfo = new Application.UserAuthService(HttpContext).Get();
using (var db = new ContextBase())
{
var ds = db.DocSet.Find(mo.DsCode);
if (ds?.Uid != uinfo.UserId)
{
vm.Set(ARTag.unauthorized);
}
else
{
mo.DsdUpdateTime = DateTime.Now;
mo.Uid = uinfo.UserId;
if (string.IsNullOrWhiteSpace(mo.DsdPid))
{
mo.DsdPid = Guid.Empty.ToString();
}
if (!mo.DsdOrder.HasValue)
{
mo.DsdOrder = 99;
}
if (string.IsNullOrWhiteSpace(mo.DsdId))
{
mo.DsdId = Core.UniqueTo.LongId().ToString();
mo.DsdCreateTime = mo.DsdUpdateTime;
db.DocSetDetail.Add(mo);
}
else
{
//查询原创建时间
var currmo = db.DocSetDetail.AsNoTracking().FirstOrDefault(x => x.DsdId == mo.DsdId);
mo.DsdCreateTime = currmo.DsdCreateTime;
db.DocSetDetail.Update(mo);
}
int num = db.SaveChanges();
vm.Set(num > 0);
vm.Data = mo.DsdId;
}
}
return(vm);
}
public void OnActionExecuting(ActionExecutingContext context)
{
var mo = new Application.UserAuthService(context.HttpContext).Get();
if (mo.UserId == 0)
{
context.Result = new ContentResult()
{
Content = "unauthorized",
StatusCode = 401
};
}
}
public ActionResultVM SaveNote(Domain.Notepad mo)
{
var vm = new ActionResultVM();
if (string.IsNullOrWhiteSpace(mo.NoteTitle) || string.IsNullOrWhiteSpace(mo.NoteContent))
{
vm.Set(ARTag.lack);
}
else
{
var uinfo = new Application.UserAuthService(HttpContext).Get();
using var db = new Data.ContextBase();
var now = DateTime.Now;
if (mo.NoteId == 0)
{
mo.NoteCreateTime = now;
mo.NoteUpdateTime = now;
mo.Uid = uinfo.UserId;
db.Notepad.Add(mo);
int num = db.SaveChanges();
vm.Set(num > 0);
vm.Data = mo.NoteId;
}
else
{
var currmo = db.Notepad.Find(mo.NoteId);
if (currmo.Uid == uinfo.UserId)
{
currmo.NoteTitle = mo.NoteTitle;
currmo.NoteContent = mo.NoteContent;
currmo.NoteUpdateTime = now;
db.Notepad.Update(currmo);
int num = db.SaveChanges();
vm.Set(num > 0);
}
else
{
vm.Set(ARTag.unauthorized);
}
}
}
return(vm);
}
public void OnAuthorization(AuthorizationFilterContext context)
{
//验证登录标记是最新，不是则注销登录（即同一用户不允许同时在线，按缓存时间生效）
if (context.HttpContext.User.Identity.IsAuthenticated && GlobalTo.GetValue <bool>("SingleSignOn"))
{
var uinfo = new Application.UserAuthService(context.HttpContext).Get();
string ServerSign = HelpFuncTo.GetLogonSign(uinfo.UserId);
if (uinfo.UserSign != ServerSign)
{
context.HttpContext.SignOutAsync(CookieAuthenticationDefaults.AuthenticationScheme);
}
}
}
public IActionResult Catalog()
{
var code = RouteData.Values["id"]?.ToString();
var uinfo = new Application.UserAuthService(HttpContext).Get();
var ds = db.DocSet.Find(code);
if (ds?.Uid != uinfo.UserId)
{
return(Content("unauthorized"));
}
return(View());
}
public string WriteList(string sort, string order, int page = 1, int rows = 30, string pe1 = null)
{
string result = string.Empty;
var pag = new PaginationVM
{
PageNumber = page,
PageSize = rows
};
int uid = new Application.UserAuthService(HttpContext).Get().UserId;
using var db = new Data.ContextBase();
var query = from a in db.UserWriting
where a.Uid == uid
select new
{
a.UwId,
a.UwTitle,
a.UwCreateTime,
a.UwUpdateTime,
a.UwReadNum,
a.UwReplyNum,
a.UwOpen,
a.UwStatus,
a.UwLaud,
a.UwMark,
a.UwCategory
};
if (!string.IsNullOrWhiteSpace(pe1))
{
query = query.Where(x => x.UwTitle.Contains(pe1));
}
query = Fast.QueryableTo.OrderBy(query, sort, order);
pag.Total = query.Count();
var list = query.Skip((pag.PageNumber - 1) * pag.PageSize).Take(pag.PageSize).ToList();
result = new
{
data = list,
total = pag.Total
}.ToJson();
return(result);
}
public IActionResult Setting()
{
var uinfo = new Application.UserAuthService(HttpContext).Get();
var mo = db.UserInfo.Find(uinfo.UserId);
ViewData["listQuickLogin"] = new List <Application.ViewModel.QuickLoginVM>
{
new Application.ViewModel.QuickLoginVM
{
Key = "qq",
Name = "QQ",
Bind = mo.OpenId1?.Length > 1
},
new Application.ViewModel.QuickLoginVM
{
Key = "weibo",
Name = "微博",
Bind = mo.OpenId2?.Length > 1
},
new Application.ViewModel.QuickLoginVM
{
Key = "github",
Name = "GitHub",
Bind = mo.OpenId3?.Length > 1
},
new Application.ViewModel.QuickLoginVM
{
Key = "taobao",
Name = "淘宝",
Bind = mo.OpenId4?.Length > 1
},
new Application.ViewModel.QuickLoginVM
{
Key = "microsoft",
Name = "Microsoft",
Bind = mo.OpenId5?.Length > 1
},
new Application.ViewModel.QuickLoginVM
{
Key = "dingtalk",
Name = "钉钉",
Bind = mo.OpenId6?.Length > 1
}
};
return(View(mo));
}
public ActionResultVM SaveCatalog(DocSetDetail mo)
{
var vm = new ActionResultVM();
var uinfo = new Application.UserAuthService(HttpContext).Get();
using var db = new ContextBase();
var ds = db.DocSet.Find(mo.DsCode);
if (ds?.Uid != uinfo.UserId)
{
vm.Set(ARTag.unauthorized);
return(vm);
}
mo.DsdOrder ??= 99;
mo.DsdUpdateTime = DateTime.Now;
if (string.IsNullOrWhiteSpace(mo.DsdPid))
{
mo.DsdPid = Guid.Empty.ToString();
}
if (string.IsNullOrWhiteSpace(mo.DsdId))
{
mo.DsdId = Guid.NewGuid().ToString();
mo.DsdCreateTime = mo.DsdUpdateTime;
mo.Uid = uinfo.UserId;
db.DocSetDetail.Add(mo);
}
else
{
var currmo = db.DocSetDetail.Where(x => x.DsdId == mo.DsdId).FirstOrDefault();
currmo.DsdTitle = mo.DsdTitle;
currmo.DsdOrder = mo.DsdOrder;
currmo.DsdPid = mo.DsdPid;
db.DocSetDetail.Update(currmo);
}
int num = db.SaveChanges();
vm.Set(num > 0);
return(vm);
}
public IActionResult Setting()
{
string code = RouteData.Values["id"]?.ToString();
var uinfo = new Application.UserAuthService(HttpContext).Get();
var mo = db.DocSet.Find(code);
if (mo.Uid == uinfo.UserId)
{
return(View("_PartialItemForm", mo));
}
else
{
return(Content("unauthorized"));
}
}
public ActionResultVM UpdateUserSay(Domain.UserInfo mo)
{
var vm = new ActionResultVM();
var uinfo = new Application.UserAuthService(HttpContext).Get();
var currmo = db.UserInfo.Find(uinfo.UserId);
currmo.UserSay = mo.UserSay;
db.UserInfo.Update(currmo);
int num = db.SaveChanges();
vm.Set(num > 0);
return(vm);
}
public ActionResultVM WriteOne(int id)
{
var vm = new ActionResultVM();
int uid = new Application.UserAuthService(HttpContext).Get().UserId;
var mo = db.UserWriting.FirstOrDefault(x => x.Uid == uid && x.UwId == id);
var listTags = db.UserWritingTags.Where(x => x.UwId == id).ToList();
vm.Data = new
{
item = mo,
tags = listTags
};
vm.Set(ARTag.success);
return(vm);
}
public void OnActionExecuting(ActionExecutingContext context)
{
bool isv = false;
if (context.HttpContext.User.Identity.IsAuthenticated)
{
var uinfo = new Application.UserAuthService(context.HttpContext).Get();
isv = uinfo.UserId == GlobalTo.GetValue <int>("AdminId");
}
if (!isv)
{
context.Result = new ContentResult()
{
Content = "unauthorized",
StatusCode = 401
};
}
}
public IActionResult List(int page = 1)
{
if (int.TryParse(RouteData.Values["Id"]?.ToString(), out int wid))
{
var uwo = Application.CommonService.UserWritingOneQuery(wid);
if (uwo == null)
{
return(Redirect("/"));
}
var pag = new PaginationVM
{
PageNumber = Math.Max(page, 1),
PageSize = 10
};
var vm = new PageVM()
{
Rows = Application.CommonService.ReplyOneQuery(Application.EnumService.ReplyType.UserWriting, wid.ToString(), pag),
Pag = pag,
Temp = uwo,
Route = "/home/list/" + wid.ToString()
};
if (User.Identity.IsAuthenticated)
{
var uinfo = new Application.UserAuthService(HttpContext).Get();
using var db = new ContextBase();
var listuc = db.UserConnection.Where(x => x.Uid == uinfo.UserId && x.UconnTargetType == Application.EnumService.ConnectionType.UserWriting.ToString() && x.UconnTargetId == wid.ToString()).ToList();
ViewData["uca1"] = listuc.Any(x => x.UconnAction == 1) ? "yes" : "";
ViewData["uca2"] = listuc.Any(x => x.UconnAction == 2) ? "yes" : "";
}
return(View(vm));
}
else
{
return(Redirect("/"));
}
}
public IActionResult Del()
{
string code = RouteData.Values["id"]?.ToString();
var uinfo = new Application.UserAuthService(HttpContext).Get();
var mo = db.DocSet.Find(code);
if (mo.Uid == uinfo.UserId)
{
db.DocSet.Remove(mo);
var moDetail = db.DocSetDetail.Where(x => x.DsCode == code).ToList();
db.DocSetDetail.RemoveRange(moDetail);
db.SaveChanges();
return(Redirect("/doc/user/" + uinfo.UserId));
}
return(Content("Bad"));
}
