public bool Add(User model) { StringBuilder sql = new StringBuilder(@" INSERT INTO dbo.[User] ( Id , UserName , Email , Phone , Lng , Lat , Location , Remark ) VALUES ( @Id , @UserName , @Email , @Phone , @Lng , @Lat , @Location , @Remark ) "); using (IDbConnection conn = DapperContext.GetSqlConnection()) { return(conn.Execute(sql.ToString(), model) > 0); } }
public int SearchListCount(UserSearchCondition condition) { StringBuilder sql = new StringBuilder(@" SELECT COUNT(0) Total FROM dbo.[User] "); using (IDbConnection conn = DapperContext.GetSqlConnection()) { return(conn.Query <User>(sql.ToString(), null).ToList().Count()); } }
public bool Delete(Guid Id) { StringBuilder sql = new StringBuilder(@" DELETE FROM [dbo].[User] WHERE Id = @Id "); using (IDbConnection conn = DapperContext.GetSqlConnection()) { return(conn.Execute(sql.ToString(), new { Id }) > 0); } }
public List <User> SearchList(UserSearchCondition condition) { StringBuilder sql = new StringBuilder(@" SELECT * FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY CreateTime DESC ) AS RowNum,* FROM dbo.[User] ) tb WHERE RowNum BETWEEN STR(@PageIndex - 1) * @PageSize + 1 AND STR(@PageIndex * @PageSize) "); var list = new List <User>(); using (IDbConnection conn = DapperContext.GetSqlConnection()) { return(conn.Query <User>(sql.ToString(), condition).ToList()); } }
public bool Edit(User model) { StringBuilder sql = new StringBuilder(@" UPDATE [dbo].[User] SET [UserName] = @UserName , [Email] = @Email , [Phone] = @Phone , [Lng] = @Lng , [Lat] = @Lat , [Location] = @Location , [Remark] = @Remark WHERE Id = @Id "); using (IDbConnection conn = DapperContext.GetSqlConnection()) { return(conn.Execute(sql.ToString(), model) > 0); } }