public ActionResult ArtClsUpdate(int?ID, string artClsTitle)
{
string account = Server.HtmlEncode(Request.Cookies["Accout"].Value);
ArticleClass ac = db.ArticleClass.Find(ID);
string wzfl = "默认日志";
bool flag = (wzfl == ac.artClsTitle);
if (!flag)
{
ac.artClsTitle = artClsTitle;
}
else
{
ac.artClsTitle = wzfl;
}
ac.uAccount = account;
db.SaveChanges();
var obj = new
{
ok = "true"
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 产品详情
/// </summary>
/// <returns></returns>
public ActionResult Details()
{
int id = GetRouteInt("id");
if (id == 0)
{
id = WebHelper.GetQueryInt("id");
}
ProductInfo info = Product.GetModelByProductID(id);
if (info == null)
{
return(PromptView("/", "您访问的页面不存在"));
}
ProductModel model = new ProductModel
{
ProductInfo = info,
ArticleClassInfo = ArticleClass.GetModelById(info.ProductClassID),
ClassPath = ArticleClass.GetArticleClassPath(info.ProductClassID)
};
if (model.ArticleClassInfo.ContentView.Length > 0)
{
return(View("details." + model.ArticleClassInfo.ContentView, model));
}
else
{
return(View(model));
}
}
/// <summary>
/// 初始化，载入下拉菜单等
/// </summary>
public void Load()
{
List <SelectListItem> list = new List <SelectListItem>();
list.Add(new SelectListItem()
{
Text = "郑州八中校本部", Value = "0"
});
//分校区 列表添加
list.Add(new SelectListItem()
{
Text = "郑州市经纬中学", Value = "-1"
});
list.Add(new SelectListItem()
{
Text = "高新区实验学校", Value = "-2"
});
foreach (ArticleClassInfo info in ArticleClass.AdminGetArticleClassTreeList())
{
list.Add(new SelectListItem()
{
Text = info.ClassName, Value = info.ArticleClassID.ToString()
});
}
ViewData["articleClassList"] = list;
}
public void BindArticleClass()
{
using (ArticleClass a = new ArticleClass())
{
a.Select("order by orderNum asc").Bind(View);
}
}
public ActionResult Index(int?id)
{
int id1 = id == null ? 0 : (int)id;
ArticleInfo info = Article.GetModelByArticleID(id1);
if (info == null)
{
return(PromptView("/Null/Index", "链接失效!"));
}
ArticleModel model = new ArticleModel();
model.ArticleInfo = info;
model.ArticleClassInfo = ArticleClass.GetModelById(info.ArticleClassID);
model.ClssPath = ArticleClass.GetArticleClassPath(info.ArticleClassID);
//访问量加一
ArticleInfo info2 = Article.GetModelByArticleID(id1);
int Hits = Convert.ToInt32(info2.Hits) + 1;
info2.Hits = Hits;
Article.Update(info2);
return(View(model));
}
private void BindNewsClass()
{
IList <NewsClass> list = NewsClass.AllClass;
ArticleClass.DataSource = list;
ArticleClass.TextField = "ClassName";
ArticleClass.ValueField = "ID";
ArticleClass.DataBind();
}
public ActionResult IndexPc(int type = 0)
{
List <SpecialInfo> a = BonSite.Services.Special.GetList();
SpecialInfo info = BonSite.Services.Special.GetModelById(a[0].SpecialID);
WorkContext.Type = type;
WorkContext.NavList = ArticleClass.GetNavList(type);
return(View());
}
//预览
public ActionResult Preview(int id = -1)
{
ArticleInfo articleInfo = Article.GetModelByArticleID(id);
ArticleClassInfo articleClassInfo = ArticleClass.GetModelById(articleInfo.ArticleClassID);
ArticleModel model = new ArticleModel()
{
ArticleClassID = articleInfo.ArticleClassID,
Title = articleInfo.Title,
SpecialID = articleInfo.SpecialID,
DisplayType = articleInfo.DisplayType,
Url = articleInfo.Url,
Digest = articleInfo.Digest,
ImgUrl = articleInfo.ImgUrl,
Body = articleInfo.Body,
Author = articleInfo.Author,
ComeForm = articleInfo.ComeForm,
IsShow = articleInfo.IsShow,
IsHome = articleInfo.IsHome,
IsBest = articleInfo.IsBest,
IsTop = articleInfo.IsTop,
AddTime = articleInfo.AddTime,
Keyword = articleInfo.Keyword,
Description = articleInfo.Description,
InformType = articleInfo.InformType,
EndTime = articleInfo.EndTime,
InformGroup = articleInfo.InformGroup,
MicroVideo = articleInfo.MicroVideo
};
if (articleInfo != null)
{
if (articleInfo.DisplayType.Equals(4))
{
ViewData["actlcle"] = "display:none";
ViewData["video"] = "";
ViewData["ArticleImg"] = "display:none";
}
else
{
ViewData["actlcle"] = "";
ViewData["video"] = "display:none";
ViewData["ArticleImg"] = "display:none";
}
if (articleClassInfo.ClassType.Equals(3))
{
ViewData["actlcle"] = "";
ViewData["video"] = "display:none";
ViewData["ArticleImg"] = "";
}
//外部链接转向
if (articleInfo.DisplayType.Equals(1))
{
return(Redirect(articleInfo.Url));
}
}
return(View(model));
}
public ActionResult AddArtCls(ArticleClass artCls)
{
string account = Server.HtmlEncode(Request.Cookies["Accout"].Value);
artCls.uAccount = account;
db.ArticleClass.Add(artCls);
db.SaveChanges();
return(RedirectToAction("index", "myarticle"));
}
public ActionResult List(string articleTitle, string Keyword, string sortColumn, string sortDirection, int?articleClassId1, int pageSize = 10, int pageNumber = 1)
{
pageSize = WorkContext.SiteConfig.pageSize;
int articleClassId = 0;
if (articleClassId1 == null)
{
articleClassId = 233;
}
else
{
articleClassId = (int)articleClassId1;
}
ArticleClassInfo classInfo = ArticleClass.AdminGetModelById(articleClassId);
//if (classInfo == null)
// return PromptView("文章分类不存在");
////管理菜单
//if ((classInfo.ClassType.Equals(-1)) || (classInfo.ClassType.Equals(0)))
// Response.Redirect(classInfo.AdminUrl);
////单页
//if (classInfo.ClassType.Equals(1))
// return RedirectToAction("Page", new { articleClassId = articleClassId });
string condition = Article.AdminGetArticleListCondition(articleClassId, articleTitle);
//string condition = " [Keyword] = 1 ";
string condition1 = condition + @" or [Keyword] = 1 ";
string sort = Article.AdminGetArticleListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, Article.AdminGetArticleCount(condition1));
//
ArticleListModel model = new ArticleListModel()
{
DataList = Article.AdminGetArticleList(pageModel.PageSize, pageModel.PageNumber, condition1, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
ArticleClassID = articleClassId,
ArticleTitle = articleTitle,
ClassInfo = classInfo
};
List <ArticleClassInfo> classPath = ArticleClass.GetArticleClassPath(articleClassId);
ViewData["classPath"] = classPath;
SiteUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&articleClassId={5}&newsTitle={6}",
Url.Action("List"),
pageModel.PageNumber,
pageModel.PageSize,
sortColumn,
sortDirection,
articleClassId,
articleTitle));
return(View(model));
}
public void BindTopArticle()
{
ArticleClass ac = DBFast.Find <ArticleClass>("Name='行业资讯' or Name='最新资讯'");
if (ac != null)
{
View.Set("lnkMore", SetType.Href, "/articlelist?id=" + ac.ID);
using (Article a = new Article())
{
View.OnForeach += View_OnForeach;
a.Select(3, "CateID=" + ac.ID + " order by id desc").Bind(View);
}
}
}
public ActionResult Add(int productClassId)
{
ProductModel model = new ProductModel()
{
AddTime = DateTime.Now, UpdateTime = DateTime.Now, IsShow = 1
};
List <ArticleClassInfo> classPath = ArticleClass.GetArticleClassPath(productClassId);
ViewData["classPath"] = classPath;
Load();
return(View(model));
}
public ActionResult List(string articleTitle, string Keyword, string sortColumn, string sortDirection, int?articleClassId1, int pageSize = 15, int pageNumber = 1)
{
pageSize = WorkContext.SiteConfig.pageSize;
int articleClassId = 0;
if (articleClassId1 == null)
{
articleClassId = 243;
}
else
{
articleClassId = (int)articleClassId1;
}
ArticleClassInfo classInfo = ArticleClass.AdminGetModelById(articleClassId);
int userID = WorkContext.Uid;
string condition = Article.AdminGetArticleListCondition(articleClassId, articleTitle);
string condition1 = @" ( " + condition + @" or [Keyword] = 4 ) " + " and [AdminID] = " + userID;
string sort = Article.AdminGetArticleListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, Article.AdminGetArticleCount(condition1));
ArticleListModel model = new ArticleListModel()
{
DataList = Article.AdminGetArticleList(pageModel.PageSize, pageModel.PageNumber, condition1, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
ArticleClassID = articleClassId,
ArticleTitle = articleTitle,
ClassInfo = classInfo
};
SiteUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&articleClassId={5}&newsTitle={6}",
Url.Action("List"),
pageModel.PageNumber,
pageModel.PageSize,
sortColumn,
sortDirection,
articleClassId,
articleTitle));
List <ArticleClassInfo> classPath = ArticleClass.GetArticleClassPath(articleClassId);
ViewData["classPath"] = classPath;
return(View(model));
}
/// <summary>
/// 产品列表
/// </summary>
/// <returns></returns>
public ActionResult List()
{
int classid = GetRouteInt("classid");
if (classid == 0)
{
classid = WebHelper.GetQueryInt("classid");
}
int page = GetRouteInt("page");
if (page == 0)
{
page = WebHelper.GetQueryInt("page");
}
ArticleClassInfo info = ArticleClass.GetModelById(classid);
if (info == null)
{
return(PromptView("/", "您访问的页面不存在"));
}
string condition = Product.GetProductListCondition(classid, "");
string sort = Product.GetProductListSort("", "");
PageModel pageModel = new PageModel(20, page, Product.GetProductCount(condition));
ProductListModel model = new ProductListModel
{
ArticleClassID = classid,
ArticleClassInfo = info,
ClassPath = ProductClass.GetProductClassPath(classid),
ProductList = Product.GetProductList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel
};
if (info.ListView.Length > 0)
{
return(View("List." + info.ListView, model));
}
else
{
return(View(model));
}
}
/// <summary>
/// 列表
/// </summary>
/// <param name="articleTitle"></param>
/// <param name="sortColumn"></param>
/// <param name="sortDirection"></param>
/// <param name="articleClassId"></param>
/// <param name="pageSize"></param>
/// <param name="pageNumber"></param>
/// <returns></returns>
public ActionResult List(string productTitle, string sortColumn, string sortDirection, int productClassId, int pageSize = 15, int pageNumber = 1)
{
pageSize = WorkContext.SiteConfig.pageSize;
ArticleClassInfo classInfo = ArticleClass.AdminGetModelById(productClassId);
if (classInfo == null)
{
return(PromptView("文章分类不存在"));
}
string condition = Product.AdminGetProductListCondition(productClassId, productTitle);
string sort = Product.AdminGetProductListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, Product.AdminGetProductCount(condition));
ProductListModel model = new ProductListModel()
{
DataList = Product.AdminGetProductList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
ProductClassID = productClassId,
ProductTitle = productTitle,
ClassInfo = classInfo
};
SiteUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&productClassId={5}&productTitle={6}",
Url.Action("List"),
pageModel.PageNumber,
pageModel.PageSize,
sortColumn,
sortDirection,
productClassId,
productTitle));
//List<SelectListItem> list = new List<SelectListItem>();
//list.Add(new SelectListItem() { Text = "全部类型", Value = "0" });
//foreach (NewsTypeInfo newsTypeInfo in AdminNews.GetNewsTypeList())
//{
// list.Add(new SelectListItem() { Text = newsTypeInfo.Name, Value = newsTypeInfo.NewsTypeId.ToString() });
//}
//ViewData["newsTypeList"] = list;
List <ArticleClassInfo> classPath = ArticleClass.GetArticleClassPath(productClassId);
ViewData["classPath"] = classPath;
return(View(model));
}
public ActionResult ArtClsDel(int id)
{
ArticleClass ac = db.ArticleClass.Find(id);
string wzfl = "默认日志";
bool flag = (wzfl == ac.artClsTitle);
if (!flag)
{
db.ArticleClass.Remove(ac);
db.SaveChanges();
return(RedirectToAction("index", "PersonalBlog"));
}
else
{
return(Content("<script>alert('系统默认日志，不能删除！');history.go(-1);</script>"));
}
}
protected void delete(object sender, RepeaterCommandEventArgs e)
{
string id = e.CommandName.ToString();
if (id == "delete")
{
int DeletedID = Convert.ToInt32(e.CommandArgument);
int result = 0;
try
{
using (var db = new hackerEntities())
{
var Dc = new ArticleClass();
Dc = db.ArticleClass.SingleOrDefault(a => a.ID == DeletedID);
db.ArticleClass.Remove(Dc);
db.SaveChanges();
}
result = 1;
}
catch { }
if (result == 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除成功');</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除失败');</script>");
}
using (var db = new hackerEntities())
{
arclass1.DataSource = (from it in db.ArticleClass
where it.Class == 1
select it).ToList();
arclass1.DataBind();
arclass2.DataSource = (from it in db.ArticleClass
where it.Class == 2
select it).ToList();
arclass2.DataBind();
arclass3.DataSource = (from it in db.ArticleClass
where it.Class == 3
select it).ToList();
arclass3.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int ID = int.Parse(Request.QueryString["ID"]);
if (!this.IsPostBack)
{
Article = new ArticleDB().ViewArticle(ID);
decodedContent = HttpUtility.HtmlDecode(Article.ArticleContent);
Page.Title = Article.ArticleTitle;
if (Request.UrlReferrer != null && !new ArticleDB().isAuthor(ID, User.Identity.Name))
{
if (!(Request.UrlReferrer.Query.Contains(HttpContext.Current.Request.Url.PathAndQuery)
|| Request.UrlReferrer.AbsoluteUri == Request.Url.AbsoluteUri))
new ArticleDB().IncreaseView(ID);
}
}
this.DataBind();
}
public ActionResult Edit(int productid = -1)
{
ProductInfo productInfo = Product.GetModelByProductID(productid);
if (productInfo == null)
{
return(PromptView("产品不存在"));
}
ProductModel model = new ProductModel()
{
ProductClassID = productInfo.ProductClassID,
Title = productInfo.Title,
Code = productInfo.Code,
Type = productInfo.Type,
Provider = productInfo.Provider,
Digest = productInfo.Digest,
ImgUrl = productInfo.ImgUrl,
Body = productInfo.Body,
IsShow = productInfo.IsShow,
IsBest = productInfo.IsBest,
IsTop = productInfo.IsTop,
AddTime = productInfo.AddTime,
AdminID = productInfo.AdminID,
BigImgUrl = productInfo.BigImgUrl,
DisplayOrder = productInfo.DisplayOrder,
Hits = productInfo.Hits,
Keys = productInfo.Keys,
UpdateTime = productInfo.UpdateTime,
Keyword = productInfo.Keyword,
Description = productInfo.Description
};
List <ArticleClassInfo> classPath = ArticleClass.GetArticleClassPath(productInfo.ProductClassID);
ViewData["classPath"] = classPath;
Load();
ViewData["referer"] = SiteUtils.GetAdminRefererCookie();
return(View(model));
}
/// <summary>
/// 删除栏目
/// </summary>
public ActionResult Del(int id = -1)
{
ArticleClassInfo info = ArticleClass.AdminGetModelById(id);
if (!ArticleClass.HaveChild(id))
{
ArticleClass.Delete(id);
if (info != null)
{
AddLog(info, "栏目删除成功");
}
//AddAdminOperateLog("删除广告位置", "删除广告位置,广告位置ID为:" + adPosId);
return(PromptView("栏目删除成功"));
}
else
{
return(PromptView("本分类下还有子分类，请先删除小分类后再删除大分类"));
}
}
//班牌内容
public ActionResult View(int?id)
{
//select TOP 1 [ArticleId] from [bs_Article] where (ArticleClassId=243) order by UpdateTime desc
int id1 = 0;
int articleClassId = 0;
articleClassId = Article.GetArticleClassIdByIsClassBrand();
if (id == null)
{
//获取班牌专栏最新新闻
id1 = Article.GetTopArticleIdByArticleClassId(articleClassId);
}
else
{
id1 = (int)id;
}
ArticleInfo info = Article.GetModelByArticleID(id1);
if (info == null)
{
return(PromptView("/Null/Index", "链接失效!"));
}
//if (info.IsShow == 0)
// return PromptView("/", "您访问的页面不存在");
ArticleModel model = new ArticleModel();
if (info.IsClassBrand == 1)
{
model.ArticleInfo = info;
model.ArticleClassInfo = ArticleClass.GetModelById(info.ArticleClassID);
model.ClssPath = ArticleClass.GetArticleClassPath(info.ArticleClassID);
return(View(model));
}
else
{
return(PromptView("/Null/Index", "链接失效!"));
}
}
public ActionResult Index(UserInfo userinfo, string NickName, string Account, string PassWord, string PassWord1, string name)
{
//判断验证码
if (name != Session["ValidateNum"].ToString())
{
return(Content("<script>alert('验证码错误请注意大小写，请重新输入！');history.go(-1);</script>"));
}
else
{
userinfo.NickName = NickName;
userinfo.Account = Account;
userinfo.PassWord = PassWord;
userinfo.Gender = "保密";
userinfo.Describe = "这个人很懒，什么都没有...";
userinfo.Introduce = "这个人很懒，什么都没有...";
userinfo.CreateTime = DateTime.Now;
db.UserInfo.Add(userinfo);
//创建默认的日志
ArticleClass ac = new ArticleClass();
ac.artClsTitle = "默认日志";
ac.uAccount = Account;
db.ArticleClass.Add(ac);
//创建默认的相册
PictureClass pc = new PictureClass();
//pc.CoverFile = "/UploadPicture/ImagesFile/20170921061035749421.jpg";
pc.picClsTitle = "默认相册";
pc.uAccount = Account;
pc.picClsAuthority = 0;
pc.picClsDescribe = "这是系统创建默认的相册。";
pc.picClsPicCnt = 0;
pc.picClsCreateTime = DateTime.Now;
db.PictureClass.Add(pc);
db.SaveChanges();
return(RedirectToAction("Index", "login"));
}
}
public ActionResult Edit(int id)
{
ArticleClassInfo classinfo = ArticleClass.AdminGetModelById(id);
if (classinfo == null)
{
return(PromptView("分类不存在"));
}
ArticleClassModel model = new ArticleClassModel();
model.ArticleClassID = classinfo.ArticleClassID;
model.ClassName = classinfo.ClassName;
model.ClassType = classinfo.ClassType;
model.ParentArticleClassID = classinfo.ParentArticleClassID;
model.Target = classinfo.Target;
model.IsNav = classinfo.IsNav;
model.IsWeb = classinfo.IsWeb;
model.WebUrl = classinfo.WebUrl;
model.IsAdmin = classinfo.IsAdmin;
model.AdminUrl = classinfo.AdminUrl;
model.DisplayOrder = classinfo.DisplayOrder;
model.IsOpen = classinfo.IsOpen;
model.ListView = classinfo.ListView;
model.ContentView = classinfo.ContentView;
model.Code = classinfo.Code;
model.ImgUrl = classinfo.ImgUrl;
model.Keyword = classinfo.Keyword;
model.Description = classinfo.Description;
model.IsClassBrand = classinfo.IsClassBrand;
model.Subhead = classinfo.Subhead;
model.IsShowNews = classinfo.IsShowNews;
Load();
Loads();
ViewData["referer"] = SiteUtils.GetAdminRefererCookie();
return(View(model));
}
public ActionResult Add(ArticleClassModel model)
{
ArticleClassInfo info = new ArticleClassInfo();
//获取当前登录用户信息
string ck = WebHelper.GetCookie("bs", "uname");
PartUserInfo partUserInfo = Users.GetPartUserByName(ck);
if (ModelState.IsValid)
{
info.ClassName = model.ClassName;
info.ParentArticleClassID = model.ParentArticleClassID;
info.ClassType = model.ClassType;
info.Target = model.Target;
info.IsWeb = model.IsWeb;
info.IsNav = model.IsNav;
info.WebUrl = model.WebUrl == null ? "" : model.WebUrl;
info.IsAdmin = model.IsAdmin;
info.AdminUrl = model.AdminUrl == null ? "" : model.AdminUrl;
info.DisplayOrder = model.DisplayOrder;
info.IsOpen = model.IsOpen;
info.ListView = model.ListView;
info.ContentView = model.ContentView;
info.Code = model.Code;
info.ImgUrl = model.ImgUrl;
info.Keyword = model.Keyword == null ? "" : model.Keyword;
info.Description = model.Description == null ? "" : model.Description;
info.IsClassBrand = model.IsClassBrand;
info.Subhead = model.Subhead;
info.Auditor = ck;
info.IsShowNews = model.IsShowNews;
ArticleClass.Create(info);
AddLog(info, "分类新加成功");
//AddAdminOperateLog
return(PromptView("分类新加成功"));
}
Loads();
return(View(model));
}
protected void AddClass_Click(object sender, EventArgs e)
{
if (CName.Text.Trim() == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('类名不能为空');</script>");
}
else if (AClass.SelectedItem.Text == "请选择一个专题")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请选择一个专题');</script>");
}
else
{
using (var db = new hackerEntities())
{
var ac = new ArticleClass();
ac.Name = CName.Text;
ac.Class = Convert.ToInt32(AClass.SelectedItem.Value);
db.ArticleClass.Add(ac);
db.SaveChanges();
}
using (var db = new hackerEntities())
{
arclass1.DataSource = (from it in db.ArticleClass
where it.Class == 1
select it).ToList();
arclass1.DataBind();
arclass2.DataSource = (from it in db.ArticleClass
where it.Class == 2
select it).ToList();
arclass2.DataBind();
arclass3.DataSource = (from it in db.ArticleClass
where it.Class == 3
select it).ToList();
arclass3.DataBind();
}
Response.Write("<script>alert('添加成功')</script>");
}
}
/// <summary>
/// 提交表单
/// </summary>
protected override object OnSubmit(Article saveTo)
{
if (saveTo.Author == null)
{
var sessionManager = Application.Ioc.Resolve <SessionManager>();
var session = sessionManager.GetSession();
var userManager = Application.Ioc.Resolve <UserManager>();
saveTo.Author = userManager.Get(session.ReleatedId.Value);
}
saveTo.Title = Title;
saveTo.Summary = Summary;
var classManager = Application.Ioc.Resolve <GenericClassManager>();
var tagManager = Application.Ioc.Resolve <GenericTagManager>();
saveTo.Classes = new HashSet <GenericClass>(
classManager.GetMany(c => ArticleClass.Contains(c.Id)));
saveTo.Tags = new HashSet <GenericTag>(
tagManager.GetMany(t => ArticleTag.Contains(t.Id)));
saveTo.DisplayOrder = DisplayOrder;
saveTo.Contents = Contents;
saveTo.Remark = Remark;
return(this.SaveSuccessAndCloseModal());
}
/// <summary>
/// 门店列表
/// </summary>
/// <returns></returns>
public ActionResult List()
{
int classid = GetRouteInt("classid");
if (classid == 0)
{
classid = WebHelper.GetQueryInt("classid");
}
string city = GetRouteString("city");
if (city == "")
{
city = WebHelper.GetQueryString("city");
}
if (city == "")
{
city = "全部";
}
int page = GetRouteInt("page");
if (page == 0)
{
page = WebHelper.GetQueryInt("page");
}
ArticleClassInfo info = ArticleClass.GetModelById(classid);
if (info == null)
{
return(PromptView("/", "您访问的页面不存在"));
}
string condition = Job.GetJobListCondition(city, "");
string sort = Job.GetJobListSort("", "asc");
PageModel pageModel = new PageModel(20, page, Job.GetJobCount(condition));
JobListModel model = new JobListModel
{
ArticleClassID = classid,
ArticleClassInfo = info,
ClassPath = ArticleClass.GetArticleClassPath(classid),
City = city,
JobList = Job.GetJobList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel
};
//if (info.ListView.Length > 0)
// return View("List." + info.ListView, model);
//else
// return View(model);
List <SelectListItem> jobcityList = new List <SelectListItem>();
jobcityList.Add(new SelectListItem()
{
Text = "全部",
Value = ""
});
foreach (DataRow drRow in Job.GetJobCityList().Rows)
{
jobcityList.Add(new SelectListItem()
{
Text = drRow["city"].ToString(),
Value = drRow["city"].ToString()
});
}
ViewData["jobcityList"] = jobcityList;
return(View(model));
}
/// <summary>
/// 提交表单
/// </summary>
protected override object OnSubmit(IDatabaseContext context, Database.Article saveTo)
{
if (saveTo.Id <= 0)
{
var sessionManager = Application.Ioc.Resolve <SessionManager>();
var session = sessionManager.GetSession();
var userRepository = RepositoryResolver.Resolve <User>(context);
saveTo.Author = userRepository.GetById(session.ReleatedId);
saveTo.CreateTime = DateTime.UtcNow;
}
saveTo.Title = Title;
saveTo.Summary = Summary;
var classRepository = RepositoryResolver.Resolve <GenericClass>(context);
var tagRepository = RepositoryResolver.Resolve <GenericTag>(context);
saveTo.Classes = new HashSet <GenericClass>(classRepository.GetMany(c => ArticleClass.Contains(c.Id)));
saveTo.Tags = new HashSet <GenericTag>(tagRepository.GetMany(t => ArticleTag.Contains(t.Id)));
saveTo.DisplayOrder = DisplayOrder;
saveTo.Contents = Contents;
saveTo.Remark = Remark;
saveTo.LastUpdated = DateTime.UtcNow;
return(new {
message = new T("Saved Successfully"),
script = ScriptStrings.AjaxtableUpdatedAndCloseModal
});
}
public ArticleClass ViewArticle(int articleID)
{
SqlCommand ViewArticleCommand;
if (Membership.GetUser() != null)
{
if (Roles.IsUserInRole(Membership.GetUser().UserName, "Admin") || isAuthor(articleID, Membership.GetUser().UserName))
ViewArticleCommand = new SqlCommand("ViewArticleAdmin", DefaultConnection);
else
ViewArticleCommand = new SqlCommand("ViewArticle", DefaultConnection);
}
else
ViewArticleCommand = new SqlCommand("ViewArticle", DefaultConnection);
ViewArticleCommand.CommandType = System.Data.CommandType.StoredProcedure;
ViewArticleCommand.Parameters.Add("@articleID", SqlDbType.Int);
ViewArticleCommand.Parameters["@articleID"].Value = articleID;
try
{
DefaultConnection.Open();
SqlDataReader ViewArticleReader = ViewArticleCommand.ExecuteReader(CommandBehavior.SingleRow);
ViewArticleReader.Read();
ArticleClass Readarticle = new ArticleClass();
Readarticle.ArticleID = articleID;
Readarticle.ArticleTitle = ViewArticleReader["ArticleTitle"].ToString();
Readarticle.ArticleAuthor = ViewArticleReader["ArticleAuthor"].ToString();
Readarticle.ArticleContent = ViewArticleReader["ArticleContent"].ToString();
Readarticle.PostedTime = (DateTime)ViewArticleReader["PostedTime"];
ViewArticleReader.Close();
return Readarticle;
}
catch (Exception e)
{
throw;
}
finally
{
DefaultConnection.Close();
}
}
/// <summary>
/// 门店列表
/// </summary>
/// <returns></returns>
public ActionResult List()
{
int classid = GetRouteInt("classid");
if (classid == 0)
{
classid = WebHelper.GetQueryInt("classid");
}
string area = GetRouteString("area");
if (area == "")
{
area = WebHelper.GetQueryString("area");
}
if (area == "")
{
area = "全部";
}
int page = GetRouteInt("page");
if (page == 0)
{
page = WebHelper.GetQueryInt("page");
}
ArticleClassInfo info = ArticleClass.GetModelById(classid);
if (info == null)
{
return(PromptView("/", "您访问的页面不存在"));
}
string condition = Shop.GetShopListCondition(area, "全部", "");
string sort = Shop.GetShopListSort("", "asc");
PageModel pageModel = new PageModel(20, page, Shop.GetShopCount(condition));
ShopListModel model = new ShopListModel
{
ArticleClassID = classid,
ArticleClassInfo = info,
ClassPath = ArticleClass.GetArticleClassPath(classid),
Area = area,
ShopList = Shop.GetShopList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel
};
//if (info.ListView.Length > 0)
// return View("List." + info.ListView, model);
//else
// return View(model);
List <SelectListItem> shopareaList = new List <SelectListItem>();
shopareaList.Add(new SelectListItem()
{
Text = "全部",
Value = ""
});
foreach (DataRow drRow in Shop.GetShopAreaList().Rows)
{
shopareaList.Add(new SelectListItem()
{
Text = drRow["area"].ToString(),
Value = drRow["area"].ToString()
});
}
ViewData["shopareaList"] = shopareaList;
return(View(model));
}
public ActionResult List(ArticleClass articleClass=ArticleClass.News,int pageSize=10,int page=0)
{
var model = new ListPage<Article>(db.Articles.Where(a => a.Class == articleClass), page, pageSize);
return View(model);
}
public void UploadArticle(ArticleClass article)
{
SqlCommand UploadArticleCommand = new SqlCommand("UploadArticle", DefaultConnection);
UploadArticleCommand.CommandType = System.Data.CommandType.StoredProcedure;
UploadArticleCommand.Parameters.Add("@Author", SqlDbType.NVarChar, 50);
UploadArticleCommand.Parameters.Add("@Title", SqlDbType.NVarChar);
UploadArticleCommand.Parameters.Add("@Content", SqlDbType.Text);
UploadArticleCommand.Parameters.Add("@Time", SqlDbType.DateTime);
UploadArticleCommand.Parameters["@Author"].Value = article.ArticleAuthor;
UploadArticleCommand.Parameters["@Title"].Value = article.ArticleTitle;
UploadArticleCommand.Parameters["@Content"].Value = article.ArticleContent;
UploadArticleCommand.Parameters["@Time"].Value = article.PostedTime;
try
{
DefaultConnection.Open();
UploadArticleCommand.ExecuteNonQuery();
}
catch (Exception e)
{
throw;
}
finally
{
DefaultConnection.Close();
}
}
//
// GET: /Home/
public ActionResult Index(int type = 0)
{
WorkContext.Type = type;
WorkContext.NavList = ArticleClass.GetNavList(type);
return(View());
}
public ActionResult List(string articleTitle, string Keywords, string sortColumn, string sortDirection, string dayTime, string status, string setArticleClassId, int?articleClassId1, int pageSize = 10, int pageNumber = 1)
{
if (setArticleClassId == null)
{
setArticleClassId = "";
}
//查询条件
string condition = " [DisplayType] in (0,2,4) ";
//审核状态 选中状态
string[] statusArray = new string[3];
if (!string.IsNullOrEmpty(status) && !status.Equals("4"))
{
statusArray[Convert.ToInt32(status)] = "selected";
condition = condition + " and ApprovalStatus=" + status;
}
ViewData["statusArray"] = statusArray;
if (!string.IsNullOrEmpty(setArticleClassId) && Convert.ToInt32(setArticleClassId) > 0)
{
DataTable articleClassDt = Article.GetArtClaIdByParentArticleClassIDs(Convert.ToInt32(setArticleClassId));
if (articleClassDt != null && articleClassDt.Rows.Count > 0)
{
string articleClasss = "";
for (int i = 0; i < articleClassDt.Rows.Count; i++)
{
DataTable articleClassDt2 = Article.GetArtClaIdByParentArticleClassIDs(Convert.ToInt32(articleClassDt.Rows[i]["ArticleClassID"].ToString()));
if (articleClassDt2 != null && articleClassDt2.Rows.Count > 0)
{
for (int j = 0; j < articleClassDt2.Rows.Count; j++)
{
articleClasss += Convert.ToInt32(articleClassDt2.Rows[j]["ArticleClassID"].ToString()) + ",";
}
}
else
{
articleClasss += Convert.ToInt32(articleClassDt.Rows[i]["ArticleClassID"].ToString()) + ",";
}
}
articleClasss = articleClasss.Substring(0, articleClasss.Length - 1);
condition = condition + " and ArticleClassID in " + "(" + articleClasss + ")";
}
else
{
//没有下级菜单
condition = condition + " and ArticleClassID=" + Convert.ToInt32(setArticleClassId);
}
}
ViewData["setArticleClassId"] = setArticleClassId;
MenuModel menuModel = new MenuModel();
menuModel.MenuList = BonSite.Services.ArticleClass.AdminGetArticleClassTreeList();
ViewData["MenuList"] = menuModel.MenuList;
//时间选择状态
if (!string.IsNullOrEmpty(dayTime))
{
DateTime dtStart = TypeHelper.StringToDateTime(dayTime);
DateTime dtEnd = dtStart.AddDays(1);
condition = condition + " and AddTime > '" + dtStart + "' and AddTime < '" + dtEnd + "'";
}
ViewData["dayTime"] = dayTime;
//标题关键字
if (Keywords != null && !string.IsNullOrEmpty(Keywords))
{
ViewData["Keywords"] = Keywords;
condition = condition + " and Title like '%" + Keywords + "%'";
}
pageSize = WorkContext.SiteConfig.pageSize;
int articleClassId = 0;
if (articleClassId1 == null)
{
articleClassId = 299;
}
else
{
articleClassId = (int)articleClassId1;
}
ArticleClassInfo classInfo = ArticleClass.AdminGetModelById(articleClassId);
//string condition = Article.AdminGetArticleListCondition(articleClassId, articleTitle);
//string condition1 = condition + @" or [Keyword] = 1 ";
string sort = Article.AdminGetArticleListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, Article.AdminGetArticleCount(condition));
//
ArticleListModel model = new ArticleListModel()
{
DataList = Article.AdminGetArticleList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
ArticleClassID = articleClassId,
ArticleTitle = articleTitle,
ClassInfo = classInfo
};
//foreach (DataRow item in model.DataList.Rows)
//{
// //获取一级分类
// int ParentArticleClassID = 0;
// int ArticleClassID = Convert.ToInt32(item["ArticleClassID"].ToString());
// ParentArticleClassID = Article.GetNameByArticleClassID2(ArticleClassID);
// if (ParentArticleClassID > 0)
// {
// ArticleClassID = Article.GetNameByArticleClassID2(ParentArticleClassID);
// if (ArticleClassID > 0)
// {
// ParentArticleClassID = Article.GetNameByArticleClassID2(ArticleClassID);
// if (ParentArticleClassID > 0)
// {
// ArticleClassID = Article.GetNameByArticleClassID2(ParentArticleClassID);
// if (ArticleClassID > 0)
// {
// ParentArticleClassID = Article.GetNameByArticleClassID2(ArticleClassID);
// if (ParentArticleClassID > 0)
// {
// }
// else
// {
// //如果没有上级菜单，则取当前栏目
// ParentArticleClassID = ArticleClassID;
// }
// }
// }
// else
// {
// //如果没有上级菜单，则取当前栏目
// ParentArticleClassID = ArticleClassID;
// }
// }
// }
// else
// {
// //如果没有上级菜单，则取当前栏目
// ParentArticleClassID = ArticleClassID;
// }
// item["ArticleClassID"] = ParentArticleClassID;
//}
List <ArticleClassInfo> classPath = ArticleClass.GetArticleClassPath(articleClassId);
ViewData["classPath"] = classPath;
SiteUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&articleClassId={5}&newsTitle={6}",
Url.Action("List"),
pageModel.PageNumber,
pageModel.PageSize,
sortColumn,
sortDirection,
articleClassId,
articleTitle));
return(View(model));
}
