/// <summary>
/// 获取列表
/// </summary>
/// <param name="where">条件</param>
/// <param name="page">分页</param>
/// <returns></returns>
public CriticalMass.TagNode.Model.Paging GetList(string where, CriticalMass.TagNode.Model.Paging page)
{
IDbConnection conn = base.GetConnection();
page.TotalCount = conn.Query <int>("select count(0) from tsku where " + where).First();
string sql = @"SELECT `id`,`code`,`desc`,`createBy`,`createTime`,`modifyBy`,`modifyTime`,`status` FROM tsku WHERE {0} {1} limit {2},{3}";
var list = conn.Query <CriticalMass.TagNode.Model.tsku>(string.Format(sql, where, page.Sort, page.StartItemIndex, page.PageSize)).ToList();
page.List = list;
return(page);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="where">条件</param>
/// <param name="page">分页</param>
/// <returns></returns>
public CriticalMass.TagNode.Model.Paging GetList(string where, CriticalMass.TagNode.Model.Paging page)
{
IDbConnection conn = base.GetConnection();
page.TotalCount = conn.Query <int>("select count(0) from tapi_tagnode_developers where " + where).First();
string sql = @"SELECT `id`,`username`,`password`,`createBy`,`createTime`,`modifyBy`,`modifyTime` FROM tapi_tagnode_developers WHERE {0} {1} limit {2},{3}";
var list = conn.Query <CriticalMass.TagNode.Model.tapi_tagnode_developers>(string.Format(sql, where, page.Sort, page.StartItemIndex, page.PageSize)).ToList();
page.List = list;
return(page);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="where">条件</param>
/// <param name="page">分页</param>
/// <returns></returns>
public CriticalMass.TagNode.Model.Paging GetList(string where, CriticalMass.TagNode.Model.Paging page)
{
IDbConnection conn = base.GetConnection();
page.TotalCount = conn.Query <int>("select count(0) from tapi_tagnode_app where " + where).First();
string sql = @"SELECT `id`,`did`,`app_name`,`app_desc`,`createTime`,`createBy`,`appkey`,`appsecret`,`status`,`audit` FROM tapi_tagnode_app WHERE {0} {1} limit {2},{3}";
var list = conn.Query <CriticalMass.TagNode.Model.tapi_tagnode_app>(string.Format(sql, where, page.Sort, page.StartItemIndex, page.PageSize)).ToList();
page.List = list;
return(page);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="where">条件</param>
/// <param name="page">分页</param>
/// <returns></returns>
public CriticalMass.TagNode.Model.Paging GetList(string where, CriticalMass.TagNode.Model.Paging page)
{
IDbConnection conn = base.GetConnection();
page.TotalCount = conn.Query <int>("select count(0) from tattribute_name where " + where).First();
string sql = @"SELECT `id`,`name`,`code`,`createBy`,`createTime`,`status`,`is_custom`,`modifyBy`,`modifyTime`,`canMultiSelect`,`canNull`,`canCustom`,`ctype` FROM tattribute_name WHERE {0} {1} limit {2},{3}";
var list = conn.Query <CriticalMass.TagNode.Model.tattribute_name>(string.Format(sql, where, page.Sort, page.StartItemIndex, page.PageSize)).ToList();
page.List = list;
return(page);
}
