public static IEnumerable <User> GetAllWeblog()
{
var db = DbBase.CreateDBContext();
var list = db.GetCollection <User>("users");
return(list.FindAll());
}
public static User GetWeblogById(int id)
{
var db = DbBase.CreateDBContext();
var list = db.GetCollection <User>("users");
return(list.FindById(id));
}
public static bool Update(Weblog model)
{
var db = DbBase.CreateDBContext();
var list = db.GetCollection <Weblog>("weblogs");
return(list.Update(model));
}
public static int GetAllCount()
{
var db = DbBase.CreateDBContext();
var list = db.GetCollection <Weblog>("weblogs");
return(list.Count());
}
public static void Delete(int id)
{
var db = DbBase.CreateDBContext();
var list = db.GetCollection <Weblog>("weblogs");
list.Delete(id);
}
public static Weblog GetWeblogById(int id)
{
var db = DbBase.CreateDBContext();
var list = db.GetCollection <Weblog>("weblogs");
return(list.FindById(id));
}
/// <summary>
/// 获取全部内容
/// </summary>
/// <returns></returns>
public static IEnumerable <Weblog> GetAllWeblog()
{
var db = DbBase.CreateDBContext();
var list = db.GetCollection <Weblog>("weblogs");
return(list.Find(Query.All("CreateTime", Query.Descending)));
}
public static void AddWeblog(User model)
{
using (var db = DbBase.CreateDBContext())
{
var list = db.GetCollection <User>("users");
list.Insert(model);
}
}
/// <summary>
/// 获取分页内容
/// </summary>
/// <param name="pageindex">当前页</param>
/// <param name="pagesize">每页几条</param>
/// <returns></returns>
public static IEnumerable <Weblog> GetPageWeblog(int pageindex, int pagesize)
{
var db = DbBase.CreateDBContext();
var list = db.GetCollection <Weblog>("weblogs");
int skip = (pageindex - 1) * pagesize;
return(list.Find(Query.All("CreateTime", Query.Descending), skip, pagesize));
}