public OceanFile GetFileById(int fileId)
{
using (var db = new OsConn())
{
var file = db.Find <OceanFile>(fileId);
return(file);
}
}
public OceanFile GetFileById(string fileName, string version)
{
using (var db = new OsConn())
{
var file = db.Top <OceanFile>(t => t.OriginName == fileName && t.Version == version, t => t.AddTime, true);
return(file);
}
}
public int AddFile(OceanFile file)
{
using (var db = new OsConn())
{
var result = db.Insert(file);
return(result);
}
}
public List <OceanFile> List(string fileName, int page, int limit)
{
using (var db = new OsConn())
{
var files = !string.IsNullOrWhiteSpace(fileName)
? db.FindPage <OceanFile>(t => t.OriginName.Contains(fileName), t => t.AddTime, page, limit, true)
: db.FindPage <OceanFile>(t => t.OriginName != "", t => t.AddTime, page, limit, true);
return(files.Item1);
}
}
public SatasticData GetSatastic()
{
using (var db = new OsConn())
{
var allCnt = db.ExecuteSql("select count(1) from OceanFile (nolock)");
var staticCnt = db.ExecuteSql("select count(1) from OceanFile (nolock) where Ext in ('.js','.css','.html')");
return(new SatasticData {
AllCnt = Convert.ToInt64(allCnt), StaticCnt = Convert.ToInt64(staticCnt)
});
}
}
