Ejemplo n.º 1
0
        public ActionResultVM WriteEditSave(UserWriting mo, int UwId, string TagIds)
        {
            var vm = new ActionResultVM();

            var lisTagId = new List <int>();

            TagIds.Split(',').ToList().ForEach(x => lisTagId.Add(Convert.ToInt32(x)));

            var lisTagName = Func.Common.TagsQuery().Where(x => lisTagId.Contains(x.TagId)).ToList();

            int uid = new UserAuthAid(HttpContext).Get().UserId;

            using (var db = new ContextBase())
            {
                var oldmo = db.UserWriting.Where(x => x.Uid == uid && x.UwId == UwId).FirstOrDefault();

                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 <UserWritingTags>();
                    foreach (var tag in lisTagId)
                    {
                        var wtmo = new 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);
                }
            }

            return(vm);
        }
Ejemplo n.º 2
0
        public ActionResultVM WriteSave(UserWriting mo, string TagIds)
        {
            var vm = new ActionResultVM();

            var uinfo = new Func.UserAuthAid(HttpContext).Get();

            using (var db = new ContextBase())
            {
                var lisTagId = new List <int>();
                TagIds.Split(',').ToList().ForEach(x => lisTagId.Add(Convert.ToInt32(x)));

                var lisTagName = Func.Common.TagsQuery().Where(x => lisTagId.Contains(x.TagId)).ToList();

                mo.Uid          = uinfo.UserId;
                mo.UwCreateTime = DateTime.Now;
                mo.UwUpdateTime = mo.UwCreateTime;
                mo.UwLastUid    = mo.Uid;
                mo.UwLastDate   = mo.UwCreateTime;
                mo.UwReplyNum   = 0;
                mo.UwReadNum    = 0;
                mo.UwOpen       = 1;
                mo.UwLaud       = 0;
                mo.UwMark       = 0;
                mo.UwStatus     = 1;

                db.UserWriting.Add(mo);
                db.SaveChanges();

                var listwt = new List <UserWritingTags>();
                foreach (var tag in lisTagId)
                {
                    var wtmo = new UserWritingTags
                    {
                        UwId    = mo.UwId,
                        TagId   = tag,
                        TagName = lisTagName.Where(x => x.TagId == tag).FirstOrDefault().TagName
                    };

                    listwt.Add(wtmo);
                }
                db.UserWritingTags.AddRange(listwt);

                //标签热点+1
                var listTagId = listwt.Select(x => x.TagId.Value);
                var listTags  = db.Tags.Where(x => listTagId.Contains(x.TagId)).ToList();
                listTags.ForEach(x => x.TagHot += 1);
                db.Tags.UpdateRange(listTags);

                int num = db.SaveChanges();

                vm.Set(num > 0);
            }

            return(vm);
        }
Ejemplo n.º 3
0
        public SharedResultVM WriteSave(UserWriting mo, string TagIds)
        {
            var vm = new SharedResultVM();

            try
            {
                vm = Apps.LoginService.CompleteInfoValid(HttpContext);
                if (vm.Code == 200)
                {
                    var uinfo = Apps.LoginService.Get(HttpContext);

                    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();

                    mo.Uid          = uinfo.UserId;
                    mo.UwCreateTime = DateTime.Now;
                    mo.UwUpdateTime = mo.UwCreateTime;
                    mo.UwLastUid    = mo.Uid;
                    mo.UwLastDate   = mo.UwCreateTime;
                    mo.UwReplyNum   = 0;
                    mo.UwReadNum    = 0;
                    mo.UwOpen       = 1;
                    mo.UwLaud       = 0;
                    mo.UwMark       = 0;
                    mo.UwStatus     = 1;

                    db.UserWriting.Add(mo);
                    db.SaveChanges();

                    var listwt = new List <UserWritingTags>();
                    foreach (var tag in lisTagId)
                    {
                        var wtmo = new UserWritingTags
                        {
                            UwId    = mo.UwId,
                            TagId   = tag,
                            TagName = lisTagName.FirstOrDefault(x => x.TagId == tag).TagName
                        };

                        listwt.Add(wtmo);
                    }
                    db.UserWritingTags.AddRange(listwt);

                    //标签热点+1
                    var listTagId = listwt.Select(x => x.TagId.Value);
                    var listTags  = db.Tags.Where(x => listTagId.Contains(x.TagId)).ToList();
                    listTags.ForEach(x => x.TagHot += 1);
                    db.Tags.UpdateRange(listTags);

                    int num = db.SaveChanges();

                    vm.Data = mo.UwId;
                    vm.Set(num > 0);
                }
            }
            catch (Exception ex)
            {
                ConsoleTo.Log(ex);
                vm.Set(ex);
            }

            return(vm);
        }
Ejemplo n.º 4
0
        public ActionResultVM WriteSave(UserWriting mo, string TagIds)
        {
            var vm = new ActionResultVM();

            var uinfo = new Application.UserAuthService(HttpContext).Get();

            using (var db = new ContextBase())
            {
                //已验证邮箱
                uinfo = db.UserInfo.Find(uinfo.UserId);
                if (uinfo.UserId != 1 && uinfo.UserMailValid != 1)
                {
                    vm.Set(ARTag.unauthorized);
                    vm.Msg = "请验证邮箱后再操作";

                    return(vm);
                }

                //有昵称
                if (string.IsNullOrWhiteSpace(uinfo.Nickname))
                {
                    vm.Set(ARTag.refuse);
                    vm.Msg = "请填写昵称后再操作";

                    return(vm);
                }

                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();

                mo.Uid          = uinfo.UserId;
                mo.UwCreateTime = DateTime.Now;
                mo.UwUpdateTime = mo.UwCreateTime;
                mo.UwLastUid    = mo.Uid;
                mo.UwLastDate   = mo.UwCreateTime;
                mo.UwReplyNum   = 0;
                mo.UwReadNum    = 0;
                mo.UwOpen       = 1;
                mo.UwLaud       = 0;
                mo.UwMark       = 0;
                mo.UwStatus     = 1;

                db.UserWriting.Add(mo);
                db.SaveChanges();

                var listwt = new List <UserWritingTags>();
                foreach (var tag in lisTagId)
                {
                    var wtmo = new UserWritingTags
                    {
                        UwId    = mo.UwId,
                        TagId   = tag,
                        TagName = lisTagName.Where(x => x.TagId == tag).FirstOrDefault().TagName
                    };

                    listwt.Add(wtmo);
                }
                db.UserWritingTags.AddRange(listwt);

                //标签热点+1
                var listTagId = listwt.Select(x => x.TagId.Value);
                var listTags  = db.Tags.Where(x => listTagId.Contains(x.TagId)).ToList();
                listTags.ForEach(x => x.TagHot += 1);
                db.Tags.UpdateRange(listTags);

                int num = db.SaveChanges();

                vm.Data = mo.UwId;
                vm.Set(num > 0);
            }

            return(vm);
        }