/// <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); }