/// <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));
}
}
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));
}
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 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>
/// <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 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));
}
//班牌内容
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", "链接失效!"));
}
}
/// <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>
/// <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(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));
}