/// <summary>
/// 目录 状态 更新
/// </summary>
/// <param name="id">id</param>
/// <returns></returns>
public bool WeedDirStatusUpdate(int id, bool status)
{
return(Try(nameof(WeedDirStatusUpdate), () =>
{
var sql = @"update WeedDir set Status=@status where id=@id;";
var cmd = SqlBuilder.Raw(sql, new { id, status }).ToCommand();
return WeedConn.Execute(cmd) > 0;
}));
}
///<summary>
/// 目录 获取
///</summary>
///<param name="id">id</param>
///<returns></returns>
public WeedDir WeedDirGet(int id)
{
return(Try(nameof(WeedDirGet), () =>
{
var sql = @"select * from WeedDir where id=@id";
var cmd = SqlBuilder.Raw(sql, new { id }).ToCommand();
return WeedConn.QueryFirstOrDefault <WeedDir>(cmd);
}));
}
///<summary>
/// 目录 是否存在
///</summary>
///<param name="uid">用户id</param>
///<returns></returns>
public int WeedDirExist(int uid)
{
return(Try(nameof(WeedDirExist), () =>
{
var sql = @"select top 1 id from WeedDir where pid=0 and status=1 and depth=1 and uid=@uid";
var cmd = SqlBuilder.Raw(sql, new { uid }).ToCommand();
return WeedConn.ExecuteScalar <int>(cmd);
}));
}
/// <summary>
/// 文件 删除
/// </summary>
/// <param name="id">id</param>
/// <returns></returns>
public bool WeedFileDelete(string id)
{
return(Try(nameof(WeedFileDelete), () =>
{
var sql = @"delete from WeedFile where id=@id;";
var cmd = SqlBuilder.Raw(sql, new { id }).ToCommand();
return WeedConn.Execute(cmd) > 0;
}));
}
public IList <Magic <int, int, string> > WeedDirList(int userId)
{
return(Try(nameof(WeedDirGet), () =>
{
var sql = @"select id as First,pid as Second,name as Third from WeedDir where UserId=@userId";
var cmd = SqlBuilder.Raw(sql, new { userId }).ToCommand();
return WeedConn.Query <Magic <int, int, string> >(cmd).ToList();
}));
}
///<summary>
/// 文件 更新
///</summary>
///<param name="o">WeedFile</param>
///<returns></returns>
public bool WeedFileUpdate(WeedFile o)
{
return(Try(nameof(WeedFileUpdate), () =>
{
var cmd = SqlBuilder.Update("WeedFile")
.Column("Name", o.Name)
.Column("Badge", o.Badge ?? string.Empty)
.Column("Extra", o.Extra ?? string.Empty)
//.Column("UserId", o.UserId)
.Column("Status", o.Status)
//.Column("CreatedBy", o.CreatedBy)
//.Column("CreatedOn", o.CreatedOn)
.Column("ModifiedBy", o.ModifiedBy)
.Column("ModifiedOn", o.ModifiedOn)
.Where("Id=@id", new { o.Id })
.ToCommand();
return WeedConn.Execute(cmd) > 0;
}));
}
///<summary>
/// 目录 创建
///</summary>
///<param name="o">WeedDir</param>
///<returns></returns>
public int WeedDirCreate(WeedDir o)
{
return(Try(nameof(WeedDirCreate), () =>
{
var cmd = SqlBuilder.Insert("WeedDir")
.Column("Pid", o.Pid)
.Column("Name", o.Name)
.Column("Depth", o.Depth)
.Column("Badge", o.Badge ?? string.Empty)
.Column("Extra", o.Extra ?? string.Empty)
.Column("UserId", o.UserId)
.Column("Status", o.Status)
.Column("CreatedBy", o.CreatedBy ?? string.Empty)
.Column("CreatedOn", o.CreatedOn)
.Column("ModifiedBy", o.ModifiedBy ?? string.Empty)
.Column("ModifiedOn", o.ModifiedOn)
.ToCommand(true);
return WeedConn.ExecuteScalar <int>(cmd);
}));
}
/// <summary>
/// 文件 分页
/// </summary>
/// <param name="uid">用户id</param>
/// <param name="did">目录id</param>
/// <param name="page">页码</param>
/// <param name="size">分页大小</param>
/// <param name="keyword">关键字</param>
/// <param name="status">状态</param>
/// <returns></returns>
public IPagedList <WeedFile> WeedFilePagedList(int uid, int did, int page = 1, int size = 20, string keyword = null, bool?status = null)
{
if (size < 0)
{
size = 20;
}
if (size > 200)
{
size = 200;
}
return(Try(nameof(WeedFilePagedList), () =>
{
var cmd = SqlBuilder
.Select("*").From("WeedFile")
.Where(!string.IsNullOrEmpty(keyword), "Name=@keyword", new { keyword })
.Where(status.HasValue, "Status=@status", new { status })
.Where(uid > 0, "Uid=@uid", new { uid })
.Where(did > 0, "Did=@did", new { did })
.ToCommand(page, size);
return WeedConn.PagedList <WeedFile>(page, size, cmd);
}));
}
///<summary>
/// 文件 创建
///</summary>
///<param name="o">WeedFile</param>
///<returns></returns>
public int WeedFileCreate(WeedFile o)
{
return(Try(nameof(WeedFileCreate), () =>
{
var cmd = SqlBuilder.Insert("WeedFile")
.Column("Id", o.Id)
.Column("Uid", o.Uid)
.Column("Did", o.Did)
.Column("Ext", o.Ext)
.Column("Url", o.Url)
.Column("Size", o.Size)
.Column("Name", o.Name)
.Column("Badge", o.Badge ?? string.Empty)
.Column("Extra", o.Extra ?? string.Empty)
.Column("Status", o.Status)
.Column("CreatedBy", o.CreatedBy ?? string.Empty)
.Column("CreatedOn", o.CreatedOn)
.Column("ModifiedBy", o.ModifiedBy ?? string.Empty)
.Column("ModifiedOn", o.ModifiedOn)
.ToCommand(true);
return WeedConn.ExecuteScalar <int>(cmd);
}));
}
