public Boolean ResetPassword(String account, String password) { string sql = @"UPDATE [user] SET [password] = '" + password + "' WHERE [account]='" + account + "'"; ContentProvider provider = ContentProvider.getInstance(); int rowAffected = provider.update(sql); return(rowAffected > 0); }
public static int resolve(WarnningDataSource.ErrorInfo info) { ContentProvider provider = ContentProvider.getInstance(); String sqlQuery = String.Format(@"SELECT [_id],[whenresolved]FROM [warnning] where level={0} ORDER BY [whenhappened] desc", info.level); DataTable dt = provider.query(sqlQuery); int rowAffected = 0; foreach (DataRow row in dt.Rows) { string whenresolved = row["whenresolved"].ToString(); if (String.IsNullOrEmpty(whenresolved)) { string id = row["_id"].ToString(); string sql = String.Format(@"UPDATE [warnning] SET [whenresolved]='{0}' where [_id]={1} ", DateTime.Now.ToString(), id); rowAffected = provider.update(sql); break; } } return(rowAffected); }