public async Task <int> GetLogoTemplatesCount(string accountId = "", LogoTemplateEntity delta = null)
{
try
{
using (var context = new DjLiveCpContext())
{
var paraObjects = new object[] { };
var sql = $@"SELECT Count(0) FROM sys_logotemplate ";
if (!string.IsNullOrEmpty(accountId))
{
sql = $@"SELECT Count(0) FROM sys_logotemplate where
AccountId = {"{0}"} ";
paraObjects = new object[] { accountId };
}
var objs = context.Database.SqlQuery <int>(sql, paraObjects);
return(await objs.FirstOrDefaultAsync());
}
}
catch (Exception e)
{
LogHelper.Error(e.Message, e);
return(0);
}
}
public async Task <List <LogoTemplateEntity> > GetLogoTemplates(int page, int countPerPage, string accountId = "", LogoTemplateEntity delta = null)
{
try
{
using (var context = new DjLiveCpContext())
{
var sql = $@"SELECT * FROM sys_logotemplate
limit {(page - 1) * countPerPage},{countPerPage}";
var paraObjects = new object[] { };
if (!string.IsNullOrEmpty(accountId))
{
sql = $@"SELECT * FROM sys_logotemplate where
AccountId = {"{0}"} limit {(page - 1) * countPerPage},{countPerPage}";
paraObjects = new object[] { accountId };
}
var objs = context.Database.SqlQuery <LogoTemplateEntity>(sql, paraObjects);
return(await objs.ToListAsync());
}
}
catch (Exception e)
{
LogHelper.Error(e.Message, e);
return(null);
}
}
