public static string SendMessge(int form,int to,string title,string message,string ip) { Status status = Status.error; string hitStr = "操作失败,请重试!"; using (ClubEntities club = new ClubEntities()) { var toUser = club.Users.Where(u => u.Id == to).FirstOrDefault(); if (toUser != null) { Message msg = new Message() { FromId=form, ToId=to, Title=title, Message1=message, Ip=ip, Vardate=DateTime.Now }; club.Messages.Add(msg); if (club.SaveChanges() >0) { status = Status.success; hitStr = "发送成功!"; } } else { hitStr = "对方账号不存在!"; } } return JsonConvert.SerializeObject(new {status=status,context=hitStr }); }
public ActionResult Create(string title,int city,string address,string pic,string start,string end,string contact,string phone,string sponsor,string context,string cost,string limited) { activity = new Activity() { Title=HtmlCommon.ClearHtml(title), CityId=city, Address=address, StartDate=DateTime.Parse(start), EndDate=DateTime.Parse(end), Contact=contact, Phone=phone, Sponsor=sponsor, Context=context, Cover=pic, Cost=cost, Limited=limited, VarDate=DateTime.Now }; using (club = new ClubEntities()) { club.Activities.Add(activity); if (club.SaveChanges() >= 0) { status = Status.success; hitStr = "活动添加成功!"; } else { hitStr = "添加失败,请稍后重试!"; } } ViewBag.StatusStr = HtmlCommon.GetHitStr(status,hitStr); return View("~/areas/bwum/views/activity/edit.cshtml",activity); }
public JsonResult MultiDel(string[] chk) { if (chk.Length == 0) { hitStr = "未选中行,请选中行后再进行操作!"; } else { using (club = new ClubEntities()) { foreach (string ck in chk) { tId = Convert.ToInt32(ck); var question = club.Questions.Where(b => b.Id == tId).FirstOrDefault(); club.Questions.Remove(question); } if (club.SaveChanges() >= 0) { hitStr = "信息删除成功!"; status = Status.success; } else { hitStr = "系统异常删除失败,请稍后重试!"; } } } return Json(new { state = status.ToString(), context = hitStr.ToString(), url = "/bwum/activity/" }); }
public JsonResult Del(int id) { hitStr="删除失败,请稍后重试!"; using (club = new ClubEntities()) { var topic = club.TopicIndexes.Where(t => t.Id == id).FirstOrDefault(); if (topic.Type == (int)TopicType.Topic) { var _topic=club.Topics.Where(t => t.Id == id).FirstOrDefault(); club.Topics.Remove(_topic); } else { if (topic.Type == (int)TopicType.Activity) { var _topic=club.TopicActivities.Where(t => t.Id == id).FirstOrDefault(); club.TopicActivities.Remove(_topic); } else { var _topic = club.TopicTasks.Where(t => t.Id == id).FirstOrDefault(); club.TopicTasks.Remove(_topic); } } club.TopicIndexes.Remove(topic); if (club.SaveChanges() >= 0) { status = Status.success;hitStr="删除成功!"; } } return Json(new { status = status.ToString(), context = HtmlCommon.GetHitStr(status, hitStr) }); }
public JsonResult AccountCreate(string username, string password, string confirmpassword, string phone, string email, string realname, string address, string cover) { if (string.IsNullOrEmpty(username)) { hitStr = "用户名不能为空!"; } else if (string.IsNullOrEmpty(password)) { hitStr = "请输入姓名!"; } else if (string.IsNullOrEmpty(confirmpassword)) { hitStr = "请输入确认密码!"; } else if (password != confirmpassword) { hitStr = "两次密码输入不一致!"; }else{ AdminAccount account = new AdminAccount() { UserName=username, PassWord=System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(password,"MD5"), Phone=phone, RealName=realname, Address=address, Cover=cover, Email=email }; using (club = new ClubEntities()) { club.AdminAccounts.Add(account); if (club.SaveChanges() > 0) { status = Status.success; hitStr = "账号创建成功!"; } } } return Json(new { status = status.ToString() ,context=hitStr}); }
public ActionResult Show(int? id,string sort) { ViewQuestion vq=new ViewQuestion(); int qid = id ?? 0; ViewBag.CurrentUser = GetUser(); using (club = new ClubEntities()) { vq = club.ViewQuestions.Where(q => q.Id == qid).FirstOrDefault(); var question = club.Questions.Where(q => q.Id == qid).FirstOrDefault(); if (question != null) { question.Views += 1; } club.SaveChanges(); ViewBag.AnswerCount = club.Answers.Where(a => a.QId == qid).Count(); ViewBag.AnswerVote = club.AnswerVotes.Where(a => a.QId == qid).ToList<AnswerVote>(); switch(sort){ case "time": ViewBag.ViewAnswers = GetAnswerList(club, q => q.QId == qid,q=>q.Id,0); break; case "vote": ViewBag.ViewAnswers = GetAnswerList(club, q => q.QId == qid, q => q.Agree, 0); break; default: ViewBag.ViewAnswers = GetAnswerList(club, q => q.QId == qid,q=>q.Id,0); break; } if (vq == null) return Redirect("/error/notfound"); ViewBag.Title = vq.Title; ViewBag.OtherQuestions = club.Questions.Where(q => q.UserId == vq.UserId&&q.Id!=vq.Id).Take(6).ToList<Question>(); } return View(vq); }
public JsonResult reviews(int id, string commentStr) { BaWuClub.Web.Dal.User user = GetUser(); string url="/account/login"; string context = string.Empty; if (user != null) { VideoReview reviews = new VideoReview(); reviews.UserId=user.Id; reviews.VideoId=id; reviews.Review=HtmlCommon.ClearJavascript(commentStr); reviews.VarDate=DateTime.Now; reviews.IP = Request.UserHostAddress; using (club = new ClubEntities()) { club.VideoReviews.Add(reviews); if (club.SaveChanges() >= 0){ status = Status.success; StringBuilder str = new StringBuilder(); str.Append("<div class=\"comment-item\">"); str.Append("<div class=\"comment-item-info\">"); str.Append("<a href=\"/member/u-" + user.Id + "/show/\" class=\"comment-item-info-name\">" + user.NickName + "</a>"); str.Append("<a href=\"/member/u-" + user.Id + "/show/\" class=\"comment-item-info-avatar\"><img src=\"" + (string.IsNullOrEmpty(user.Cover) ? "/content/images/no-img.jpg" : "~/uploads/avatar/small/" + user.Cover) + "\"/>"); str.Append("</a>"); str.Append("</div>"); str.Append("<div class=\"comment-item-content\">" + HtmlCommon.ClearJavascript(reviews.Review) + "</div>"); str.Append("<div class=\"comment-item-meta\"><span>评论与" + HtmlCommon.GetAnswerTimeSpan((DateTime)reviews.VarDate) + "</span></div>"); str.Append("</div>"); context = str.ToString(); } else{ status = Status.warning; context = "系统异常,操作失败,请稍后重试!"; } } } return Json(new { status = status.ToString(), context = context, url = url }); }
public ActionResult Login(string username, string password, string returnurl) { if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password)) { ViewBag.Status = "<span style=\"color:red\">用户名或密码不能为空!</span>"; } BaWuClub.Web.Dal.User user = new User() { NickName=HtmlCommon.ClearHtml(username),Password= System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(password, "md5")}; using (club = new ClubEntities()) { var _user = club.Users.Where(u =>u.NickName ==user.NickName && u.Password ==user.Password).FirstOrDefault(); if (_user!=null){ if (_user.LastLoginDate < DateTime.Now) { _user.Points += 2; } _user.LastLoginDate = DateTime.Now; _user.LastLoginIP = Request.UserHostAddress; club.SaveChanges(); //System.Web.Security.FormsAuthentication.SetAuthCookie(user.NickName, true); //HttpCookie cookie = new HttpCookie("bwusers"); //cookie.Values["id"] = _user.Id.ToString(); //cookie.Values["user"] = HttpUtility.UrlEncode(_user.NickName.ToString()); //cookie.Values["avatar"] = _user.Cover; Response.Cookies.Add(SetCookies(_user)); return RedirectUrl(returnurl); } else { ViewBag.Status = "<span style=\"color:red\">用户名或密码不正确!</span>";} } return View(); }
public ActionResult Save(string title,string keywords,string description,string phone,string fax,string email,string qq,string copyright,string address) { Models.SettingModel s = new Models.SettingModel() { Title=title, Keywords=keywords, Description=description, Phone=phone, Fax=fax, Email=email, QQ=qq, CopyRight=copyright, Address=address }; Status status=Status.error; string hitStr=String.Empty; Type t=s.GetType(); using (club = new ClubEntities()) { var Properties = t.GetProperties(); foreach (var p in Properties) { var settting=club.Settings.Where(st => st.SettingName == p.Name).FirstOrDefault(); if (settting != null) settting.SettingValue = p.GetValue(s, null).ToString(); } if (club.SaveChanges() >= 0) { status = Status.success; hitStr = "网站信息保存成功!"; } else{ hitStr = "网站信息保存失败,请稍后重试!"; } ViewBag.StatusStr = HtmlCommon.GetHitStr(hitStr, status); } return View("~/areas/bwum/views/setting/index.cshtml",GetSettingDic()); }
public JsonResult Del(int id) { document = new Document(); using (club = new ClubEntities()) { RemoveDocument(club,id); if (club.SaveChanges() >= 0) { status = Status.success; hitStr = "操作成功!"; } } return Json(new { state = status.ToString(), context = hitStr }); }
public ActionResult Modify(int id, string tagName) { Tag tag = new Tag(); using (club = new ClubEntities()) { tag = club.Tags.Single(t => t.Id == id); tag.TagName = tagName; if (club.SaveChanges() > 0) ViewBag.StatusStr = HtmlCommon.GetHitStr("标签更新成功!",Status.success); else ViewBag.StatusStr = HtmlCommon.GetHitStr("标签未修改!", Status.error); return View("~/areas/bwum/views/tag/edit.cshtml",tag); } }
public ActionResult Sub(string name,string context) { if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(context)) { ViewBag.HitStr = "<span style=\"color:red\">姓名、内容均不能为空!</span>"; }else{ using (ClubEntities club = new ClubEntities()) { Feedback feedback = new Feedback {Name=Common.HtmlCommon.ClearHtml(name),Context=Common.HtmlCommon.ClearHtml(context) }; club.Feedbacks.Add(feedback); if (club.SaveChanges() >= 0) { ViewBag.ResponseStr = "<span>你提交的意见反馈,我们已经收到。我们会尽快的处理!感谢您的支持!!</span>"; } } } return View("~/views/feedback/index.cshtml"); }
public JsonResult Del(int id) { video = new Video(); using (club = new ClubEntities()) { video = club.Videos.Where(v => v.Id == id).FirstOrDefault(); if (video != null) { club.Videos.Remove(video); if (club.SaveChanges() >= 0) { status = Status.success; hitStr = "操作成功!"; } } } return Json(new { state = status.ToString(), context = hitStr }); }
public JsonResult Del(int? id) { vId = id ?? 0; hitStr = "系统异常,操作失败!"; using (club = new ClubEntities()) { article = club.Articles.Where(v=> v.Id == vId).FirstOrDefault(); if (article != null){ club.Articles.Remove(article); if (club.SaveChanges() >= 0){ hitStr = "删除成功!"; status = Status.success; } } } return Json(new { status = status.ToString(), content = HtmlCommon.GetHitStr(hitStr, status) }); }
public ActionResult Item(int id) { ViewDocument viewDoc = new ViewDocument(); using (club = new ClubEntities()) { viewDoc = club.ViewDocuments.Where(v => v.Id == id).FirstOrDefault(); var doc=club.Documents.Where(v => v.Id == id).FirstOrDefault(); if(doc!=null){ doc.Views += 1; club.SaveChanges(); ViewBag.DownsTop = GetViewDocumentsOrderByDown(club); } } if (viewDoc == null) return RedirectToAction("notfound","error"); return View("~/views/download/show.cshtml",viewDoc); }
public ActionResult Course(int id) { Video video = new Video(); using (club = new ClubEntities()) { video = club.Videos.Where(v => v.Id == id).FirstOrDefault(); ViewBag.reviews = club.ViewVideoReviews.Where(v => v.VideoId == id).ToList<ViewVideoReview>(); if (video != null) { video.Views += 1; club.SaveChanges(); } else { return RedirectToAction("notfound","error"); } } return View("~/views/online/course.cshtml",video); }
public JsonResult Del(int? id) { tId = id ?? 0; using (club = new ClubEntities()) { var feedback = club.Feedbacks.Where(a => a.Id == tId).FirstOrDefault(); if (feedback != null) { club.Feedbacks.Remove(feedback); if (club.SaveChanges() >= 0) { hitStr = "删除成功!"; status = Status.success; } }else{ hitStr="要删除的数据不存在!"; } } return Json(new { status=status.ToString(),context=HtmlCommon.GetHitStr(status,hitStr)}); }
/// <summary> /// 统计每日、总浏览的PV /// </summary> private void Statistics() { using (club = new ClubEntities()){ var _v = (from v in club.Views orderby v.Id descending select v).FirstOrDefault<View>(); if (IsToday(club)) { _v.Today = _v.Today + 1; _v.Count = _v.Count + 1; } else{ if(_v!=null) club.Views.Add(new View() { Today = 1, Count = _v.Count + 1, Date = DateTime.Now }); else club.Views.Add(new View() { Today = 1, Count = 1,Date=DateTime.Now }); } club.SaveChanges(); } }
public ActionResult Create(string name,int node) { area = new Area() { Name=name,Node=(Byte)node}; if (!string.IsNullOrEmpty(name)) { using (club = new ClubEntities()) { GetProvince(club); club.Areas.Add(area); if (club.SaveChanges() >= 0) { hitStr = "区域创建成功!"; status = Status.success; } } }else{ hitStr= "区域名称不能空!"; } ViewBag.StatusStr = Common.HtmlCommon.GetHitStr(hitStr, status); return View("~/areas/bwum/Views/area/edit.cshtml",area); }
public JsonResult MultiDel(string[] chk) { if (chk.Length == 0){ hitStr = "未选中行,请选中行后再进行操作!"; } else{ int vId = 0; using (club = new ClubEntities()){ foreach (string ck in chk){ vId = Convert.ToInt32(ck); RemoveDocument(club,vId); } if (club.SaveChanges() >= 0){ hitStr = "删除成功!"; status = Status.success; } } } return Json(new { state = status.ToString(), context = hitStr }); }
public ActionResult SetCheck(int id) { ViewDocument viewDocument = new ViewDocument(); Document document = new Document(); using (club = new ClubEntities()) { document = club.Documents.Where(v => v.Id == id).FirstOrDefault(); viewDocument = club.ViewDocuments.Where(v => v.Id == id).FirstOrDefault(); if (document != null) { document.Status = (byte)(((int)viewDocument.Status == 0) ? 1 : 0); document.TagsId = App_Start.CommonMethod.SetTags(club, document.Tags); if (club.SaveChanges() >= 0) { status = Status.success; hitStr = "修改成功!"; viewDocument.Status = document.Status; } } } ViewBag.StatusStr = HtmlCommon.GetHitStr(hitStr,status); return View("~/areas/bwum/views/down/show.cshtml", viewDocument); }
public ActionResult Edit(string tagName) { Tag tag = new Tag(); if (string.IsNullOrEmpty(tagName)){ ViewBag.statusStr = HtmlCommon.GetHitStr("标签不能空!",Status.error); return View(tag); } if (CheckController.IsRepeate(CheckController.CheckType.TagName,tagName)) { ViewBag.statusStr = HtmlCommon.GetHitStr("该标签已重复!", Status.error); return View(tag); } using (club = new ClubEntities()) { tag.TagName= tagName; club.Tags.Add(tag); if (club.SaveChanges() > 0) ViewBag.statusStr = HtmlCommon.GetHitStr("保存成功!", Status.error); else ViewBag.statusStr = HtmlCommon.GetHitStr("系统异常,请稍后重试!", Status.error); } return View(tag); }
public JsonResult MultiDel(string[] chk,int id) { if (chk.Length == 0){ hitStr = "未选中行,请选中行后再进行操作!"; } else{ int vId = 0; using (club = new ClubEntities()){ foreach (string ck in chk){ vId = Convert.ToInt32(ck); video = club.Videos.Where(v => v.Id == vId).FirstOrDefault(); if (video != null){ club.Videos.Remove(video); } } if (club.SaveChanges() >= 0){ hitStr = "删除成功!"; status = Status.success; } } } return Json(new { state = status.ToString(), context = hitStr }); }
public ActionResult Create(string name, string role) { if (string.IsNullOrEmpty(name)) { hitStr = "名称不能为空!"; } else { AdminType adminType = new AdminType { Name=name,Role=role,VarDate=DateTime.Now}; using (club = new ClubEntities()) { club.AdminTypes.Add(adminType); if (club.SaveChanges() > 0) { hitStr = "创建成功!"; status = Status.success; } else { hitStr = "系统异常,请稍后重试!"; } } } ViewBag.StatusStr = Common.HtmlCommon.GetHitStr(hitStr, status); return View(GetRole()); }
public JsonResult MassSend(string ids, string context) { user=GetUser(); ids=HtmlCommon.ClearHtml(ids); context=HtmlCommon.ClearHtml(context); if (string.IsNullOrEmpty(ids)){ hintStr = "信息发送失败,没有选择用户!"; } else { if (string.IsNullOrEmpty(context)){ hintStr = "信息发送失败,发送的信息不能空!"; } else { string[] idArray = ids.Split(','); int[] idIntArray = new int[idArray.Length]; int value = 0; for (int i = 0; i < idArray.Length; i++){ Int32.TryParse(idArray[i],out value); idIntArray[i] = value; } using (club = new ClubEntities()) { List<Message> Messages=new List<Message>(); foreach (int item in idIntArray) { var msg = new Message() {FromId=user.Id,ToId=item,Message1=context,Status=(byte)State.Disable, Ip=Request.UserHostAddress,Vardate=DateTime.Now,Title="个人消息" }; club.Messages.Add(msg); } if (club.SaveChanges() >= 0) { status = Status.success; hintStr = "发送成功!"; }else{ hintStr = "系统异常!!"; } } } } return Json(new {status=status.ToString(),context=hintStr }); }
public ActionResult Create(string name, string description, string pic,string icon, string variable) { topicCategory = new TopicCategory() { Name = name, Description = description, Cover = pic, Icon=icon,Variable = variable, VarDate = DateTime.Now,Type=1 }; if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(variable)) { hitStr = "分类的名称、变量缺一不可"; } else { using (club = new ClubEntities()) { club.TopicCategories.Add(topicCategory); if (club.SaveChanges() >= 0) { status = Status.success; hitStr = "分类名称创建成功!"; } else { hitStr = "系统异常,请稍后重试!"; } } } ViewBag.StatusStr = Common.HtmlCommon.GetHitStr(hitStr, status); return View("~/areas/bwum/views/discuss/create.cshtml",topicCategory); }
public ActionResult Create(string name, string variable, string description) { topicCategory = new TopicCategory() {Name=name,Variable=variable,VarDate=DateTime.Now,Description=description,Type=0 }; if (string.IsNullOrEmpty(topicCategory.Name) || string.IsNullOrEmpty(topicCategory.Variable)) { hitStr = "论坛模块添加失败,论坛名称或模块变量不能为空!"; } else { using (club = new ClubEntities()) { club.TopicCategories.Add(topicCategory); if (club.SaveChanges() > 0) { status = Status.success; hitStr = "论坛模块添加成功!"; } else { hitStr = "系统异常,论坛模块添加失败!"; } } } ViewBag.StatusStr = HtmlCommon.GetHitStr(hitStr,status); return View("~/areas/bwum/views/forum/create.cshtml", topicCategory); }
public JsonResult MultiDel(string[] chk) { if (chk.Length == 0) { hitStr = "未选中行,请选中行后再进行操作!"; }else{ using (club = new ClubEntities()) { foreach (string ck in chk) { vId = Convert.ToInt32(ck); article = club.Articles.Where(v => v.Id == vId).FirstOrDefault(); if (article != null) { club.Articles.Remove(article); } } if (club.SaveChanges() >= 0) { hitStr = "删除成功!"; status = Status.success; }else{ hitStr = "系统异常删除失败,请稍后重试!"; } } } return Json(new { state=status.ToString(),context=hitStr.ToString(),url="/bwum/Contribute/"}); }
public static string SetTags(ClubEntities club,string tags){ StringBuilder str = new StringBuilder(); Tag tag; if (tags != null) { string[] tagArray = tags.Split(','); foreach (string t in tagArray) { if (!string.IsNullOrEmpty(t)){ tag = club.Tags.Where(ta => ta.TagName == t).FirstOrDefault(); if (tag != null){ str.Append(tag.Id + ","); } else{ tag = new Tag() { TagName = t }; club.Tags.Add(tag); club.SaveChanges(); str.Append(tag.Id + ","); } } } } str = str.Length > 0 ? str.Remove(str.Length - 1, 1) : str; return str.ToString(); }
public JsonResult JoinTo(int joinid,string name,string company,string post,string phone,string email,string site,string qq,string info) { Status status = Status.error; string hit = "系统异常,报名失败,请稍后重试!"; using (club = new ClubEntities()) { ActivityOrder activityOrder = new ActivityOrder() { Name=HtmlCommon.ClearHtml(name), Company=HtmlCommon.ClearHtml(company), Post=HtmlCommon.ClearHtml(post), Phone=HtmlCommon.ClearHtml(phone), Email=HtmlCommon.ClearHtml(email), Site=HtmlCommon.ClearHtml(site), QQ=HtmlCommon.ClearHtml(qq), Info=HtmlCommon.ClearHtml(info), ActivityId=joinid, }; club.ActivityOrders.Add(activityOrder); if (club.SaveChanges() > 0) { status = Status.success; hit = "报名成功!我们会尽快的联系您哦!"; } } return Json(new { status = status.ToString(), context = hit }); }