/// <summary>
/// 用户对象分页条件查询
/// </summary>
/// <param name="userFilter">用户对象</param>
/// <param name="limit">一页显示的数量</param>
/// <param name="page">当前第几页</param>
/// <returns>Pagination</returns>
public static dynamic Find(CMS_User userFilter, int limit, int page)
{
try
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
Pagination pagination = new Pagination();
var list = from data in cms.CMS_User
select data;
if (!string.IsNullOrEmpty(userFilter.uname))
{
list = list.Where(data => data.uname.Contains(userFilter.uname)).Select(data => data);
}
if (userFilter.uid > 0)
{
list = list.Where(data => data.uid == userFilter.uid).Select(data => data);
}
pagination.total = list.Count();
list = list.OrderByDescending(data => data.uid);
list = list.Skip(limit * (page - 1)).Take(limit);
pagination.rows = list.ToList();
return(pagination);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查找用户
/// </summary>
/// <param name="userFilter">用户对象</param>
/// <returns>list</returns>
public static dynamic Find(CMS_User userFilter)
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
try
{
return(CMS_User_DAL.Find(userFilter));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="cateFilter">对象</param>
/// <returns>int</returns>
public static dynamic Edit(CMS_Category cateFilter)
{
try
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
cms.Entry(cateFilter).State = System.Data.Entity.EntityState.Modified;
var count = cms.SaveChanges();
return(count);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="aid">编号</param>
/// <returns>int</returns>
public static dynamic Del(int aid)
{
try
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
cms.CMS_Article.Remove(cms.CMS_Article.Find(aid));
var count = cms.SaveChanges();
return(count);
}
}
catch (Exception error)
{
throw error;
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="key">对象</param>
/// <returns>int</returns>
public static dynamic Add(CMS_Keyword key)
{
try
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
cms.CMS_Keyword.Add(key);
var count = cms.SaveChanges();
return(count);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 添加评论
/// </summary>
/// <param name="com">对象</param>
/// <returns>int</returns>
public static dynamic Add(CMS_Comment com)
{
try
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
cms.CMS_Comment.Add(com);
var count = cms.SaveChanges();
return(count);
}
}
catch (Exception error)
{
throw error;
}
}
/// <summary>
/// 查询是否存在该用户名
/// </summary>
/// <param name="userFilter">实体类对象</param>
/// <returns>int;0为不存在,1为存在</returns>
public static int FindUname(CMS_User userFilter)
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
var list = from data in cms.CMS_User
select data;
foreach (var item in list.ToList())
{
if (item.uname == userFilter.uname)
{
return(1);
}
}
return(0);
}
}
/// <summary>
/// 注册方法
/// </summary>
/// <param name="user">用户</param>
/// <returns>int</returns>
public static dynamic Register(CMS_User user)
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
try
{
cms.CMS_User.Add(user);
var count = cms.SaveChanges();
return(count);
}
catch (Exception error)
{
throw error;
}
}
}
/// <summary>
/// 查找栏目
/// </summary>
/// <returns>list</returns>
public static dynamic Find()
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
try
{
var list = from data in cms.CMS_Category
//where data.nav == true
select data;
return(list.ToList());
}
catch (Exception error)
{
throw error;
}
}
}
/// <summary>
/// 查找前五条数据
/// </summary>
/// <returns>list</returns>
public static dynamic Find()
{
try
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
var list = from data in cms.CMS_Comment
select data;
list = list.OrderByDescending(data => data.cmtime);
list = list.Take(5);
return(list.ToList());
}
}
catch (Exception error)
{
throw error;
}
}
/// <summary>
/// 查询最近被置顶的一篇文章
/// </summary>
/// <returns>list</returns>
public static dynamic FindIsTop()
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
try
{
var list = from data in cms.ArticleMain_View
select data;
list = list.Where(data => data.istop == true).Select(data => data);
list = list.OrderByDescending(data => data.ptime);
list = list.Take(1);
return(list.ToList());
}
catch (Exception error)
{
throw error;
}
}
}
/// <summary>
/// 查找关键字,有条件
/// </summary>
/// <param name="keyFilter">对象</param>
/// <returns>list</returns>
public static dynamic Find(CMS_Keyword keyFilter)
{
try
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
var list = from data in cms.CMS_Keyword
select data;
if (!string.IsNullOrEmpty(keyFilter.keyword))
{
list = list.Where(data => data.keyword.Contains(keyFilter.keyword)).Select(data => data);
}
return(list.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 得到关键字
/// </summary>
/// <returns>list</returns>
public static dynamic Find()
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
try
{
var list = from data in cms.CMS_Keyword
select data;
list = list.OrderByDescending(data => data.stimes);//.OrderByDescending(data => data.ltimes);
list = list.Where(data => data.show == 1).Select(data => data);
list = list.Take(5);
return(list.ToList());
}
catch (Exception error)
{
throw error;
}
}
}
/// <summary>
/// 查询一个用户的回复次数
/// </summary>
/// <param name="userFilter">对象</param>
/// <returns>int</returns>
public static dynamic FindComSum(CMS_User userFilter)
{
try
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
var list = from data in cms.CMS_Comment
select data;
if (userFilter.uid > 0)
{
list = list.Where(data => data.uid == userFilter.uid).Select(data => data);
}
var count = list.Count();
return(count);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查询文章评论
/// </summary>
/// <param name="comFilter">对象</param>
/// <returns>pagination</returns>
public static dynamic Find(CommentMain_View comFilter)
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
try
{
var list = from data in cms.CommentMain_View
select data;
if (comFilter.aid == 0)
{
throw new System.Exception("需要知道是哪一篇文章的评论");
}
else
{
list = list.Where(data => data.aid == comFilter.aid).Select(data => data);
}
return(list.ToList());
}
catch (Exception error)
{
throw error;
}
}
}
/// <summary>
/// 查找文章
/// </summary>
/// <param name="artFilter">条件</param>
/// <returns>list</returns>
public static dynamic Find(CMS_Article artFilter)
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
try
{
var list = from data in cms.CMS_Article
select data;
if (artFilter.cid > 0)
{
list = list.Where(data => data.cid == artFilter.cid).Select(data => data);
}
if (artFilter.aid > 0)
{
list = list.Where(data => data.aid == artFilter.aid).Select(data => data);
}
return(list.ToList());
}
catch (Exception error)
{
throw error;
}
}
}
/// <summary>
/// 查找用户
/// </summary>
/// <param name="userFilter">用户对象</param>
/// <returns>list</returns>
public static dynamic Find(CMS_User userFilter)
{
using (CMSDatabase_Model cms = new CMSDatabase_Model())
{
try
{
var list = from data in cms.CMS_User
select data;
if (userFilter.uid > 0)
{
list = list.Where(data => data.uid == userFilter.uid).Select(data => data);
}
if (!string.IsNullOrEmpty(userFilter.upwd))
{
list = list.Where(data => data.upwd == (userFilter.upwd)).Select(data => data);
}
return(list.ToList());
}
catch (Exception ex)
{
throw ex;
}
}
}
