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